Bug 74442 - FILEOPEN XLSX confusion on cell content
Summary: FILEOPEN XLSX confusion on cell content
Status: RESOLVED DUPLICATE of bug 74535
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.2.0.4 release
Hardware: Other Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: regression
Depends on:
Blocks: 76254
  Show dependency treegraph
 
Reported: 2014-02-03 15:02 UTC by Nicolas Mailhot
Modified: 2014-03-17 08:55 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
Testcase (12.13 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2014-02-03 15:02 UTC, Nicolas Mailhot
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Nicolas Mailhot 2014-02-03 15:02:11 UTC
Created attachment 93287 [details]
Testcase

In the attached testcase, calc appends content of cell A22 to cell B8
Comment 1 Nicolas Mailhot 2014-02-07 13:33:24 UTC
This is a regression and indeed aoo 4.0.1 does not exhibit the problem
Comment 2 Kevin Suo 2014-03-15 01:55:59 UTC
Will you please see if this issue is the same as:
Bug 74535 - VIEWING: Column contents appended in subsequent rows

If not, would you please attached a screenshot to show what is expected, and what you get, and the version? and could you try with the latest 4.2.2.1 version?

I can not reproduce in LibreOffice 4.2.2.1 Fedora 20.
It shows "http://immopass.edf.fr" in B8,
and shows "
Pour en savoir plus sur le service d'accès aux sites Internet pour les utilisateurs, et
obtenir la dernière version de ce formulaire, consulter :
http://sissi.edf.fr/guides/preconisation-technique/aeq_access_internet " in A22.
Comment 3 Nicolas Mailhot 2014-03-17 07:51:06 UTC
It seems partly fixed in 4.2.2.1 (windows)

However cell A22 is till incorrect : all the text is on a single line without linebreaks, and the whole text has been converted to a giant link
Comment 4 Kevin Suo 2014-03-17 08:08:00 UTC
(In reply to comment #3)
> It seems partly fixed in 4.2.2.1 (windows)
> 
> However cell A22 is till incorrect : all the text is on a single line
> without linebreaks, and the whole text has been converted to a giant link

I reproduce the following in LibreOffice 4.2.3.1, windows XP:
 * All the text in A22 is in the single line, althrough the cell format is set "Wrap text automatically".

But I beleive this is a different issue, so we should mark this bug as a duplicate of Bug 74535, and open a new bug about the text-wrap issue.
Comment 5 Kevin Suo 2014-03-17 08:32:30 UTC
I openned a new bug regarding hyperlink auto-wrap, see Bug 76253.

Marking this one as Duplicate of Bug 74535.

*** This bug has been marked as a duplicate of bug 74535 ***
Comment 6 Kevin Suo 2014-03-17 08:55:02 UTC
*** Bug 76254 has been marked as a duplicate of this bug. ***