Bug 69746 - FILEOPEN: empty cell content is overwritten by a multiline cell content
Summary: FILEOPEN: empty cell content is overwritten by a multiline cell content
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.1.1.2 release
Hardware: Other All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard: BSA
Keywords: regression
Depends on:
Blocks:
 
Reported: 2013-09-24 07:17 UTC by Brigitte.Roschewski
Modified: 2013-10-13 03:49 UTC (History)
0 users

See Also:
Crash report or crash signature:


Attachments
Sample-file (8.95 KB, application/vnd.oasis.opendocument.spreadsheet)
2013-09-24 07:17 UTC, Brigitte.Roschewski
Details
Screenshot (105.93 KB, image/png)
2013-09-24 21:15 UTC, m_a_riosv
Details
attachment-26917-0.html (8.27 KB, text/html)
2013-09-25 06:30 UTC, Brigitte.Roschewski
Details
attachment-26917-1.dat (1 bytes, multipart/alternative)
2013-09-25 06:30 UTC, Brigitte.Roschewski
Details
bug 69746.png (92.41 KB, image/png)
2013-09-25 06:30 UTC, Brigitte.Roschewski
Details
opened sample-file as screenshot (LibreOffice 4.1.1.2) (91.27 KB, image/png)
2013-09-26 06:26 UTC, Brigitte.Roschewski
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Brigitte.Roschewski 2013-09-24 07:17:51 UTC
Created attachment 86432 [details]
Sample-file

Problem description: 
We use the OpenDocument-Format for exporting data from our programs
if the content.xml includes multiline-cells, empty table cells are filled with this content

Steps to reproduce:
1. write a multiline cell (content.xml)
2. write empty cells with the content <text:p/>
3. the content of the multiline cell is shown in the empty cell

Current behavior:
empty cells get the content of a multiline cell

Expected behavior:
empty cells should be empty

              
Operating System: All
Version: 4.1.1.2 release
Last worked in: 4.1.0.4 release
Comment 1 m_a_riosv 2013-09-24 21:15:45 UTC
Created attachment 86484 [details]
Screenshot

Hi Brigitte, thanks for reporting.

I can not see the issue with:
Win7x64Ultimate
Version: 4.1.3.0.0+ Build ID: 952c5fe20d5975c8a2c9f5093d05472ca0fc78f
Comment 2 Brigitte.Roschewski 2013-09-25 06:30:10 UTC
Created attachment 86506 [details]
attachment-26917-0.html

Hi,

I send you a screenshot

Windows 7 Professional
Service Pack 1
Build # 7601
Language German


Brigitte Roschewski

Von: bugzilla-daemon@freedesktop.org [mailto:bugzilla-daemon@freedesktop.org]
Gesendet: Dienstag, 24. September 2013 23:16
An: Brigitte Roschewski
Betreff: [Bug 69746] FILEOPEN: empty cell content is overwritten by a multiline cell content

Comment # 1<https://bugs.freedesktop.org/show_bug.cgi?id=69746#c1> on bug 69746<https://bugs.freedesktop.org/show_bug.cgi?id=69746> from mariosv<mailto:mariosv@miguelangel.mobi>

Created attachment 86484 [details]<attachment.cgi?id=86484> [details]<attachment.cgi?id=86484&action=edit>

Screenshot



Hi Brigitte, thanks for reporting.



I can not see the issue with:

Win7x64Ultimate

Version: 4.1.3.0.0+ Build ID: 952c5fe20d5975c8a2c9f5093d05472ca0fc78f

________________________________
You are receiving this mail because:

  *   You reported the bug.
Comment 3 Brigitte.Roschewski 2013-09-25 06:30:10 UTC
Created attachment 86507 [details]
attachment-26917-1.dat
Comment 4 Brigitte.Roschewski 2013-09-25 06:30:10 UTC
Created attachment 86508 [details]
bug 69746.png
Comment 5 Markus Mohrhard 2013-09-25 15:30:59 UTC
Brigitte, I still see no issue after looking at the content.xml. Can you please write exactly what you expect to see.

Please also don't answer to the mail if you use html mode in your mail editor and instead either use pure text mode or go to freedesktop bugzilla.
Comment 6 Brigitte.Roschewski 2013-09-26 06:26:30 UTC
Created attachment 86615 [details]
opened sample-file as screenshot (LibreOffice 4.1.1.2)

The red marked cells should be empty (see content.xml)
Comment 7 Markus Mohrhard 2013-09-26 07:19:30 UTC
(In reply to comment #6)
> Created attachment 86615 [details]
> opened sample-file as screenshot (LibreOffice 4.1.1.2)
> 
> The red marked cells should be empty (see content.xml)

They are empty in my master build. I'll need to check with a 4-1 build next week.
Comment 8 Julien Nabet 2013-10-03 20:00:28 UTC
On pc Debian x86-64 with master sources updated today, I don't reproduce this.

With 4.1.1.2 Debian package, I reproduced this.
But, with 4.1 sources updated about 15 days ago (commit 594a9cc9278c8ca3ff9b78bad917233f207be194), I don't reproduce this.

Brigitte:
for the test, could you give a try to prerelease 4.1.2? (see http://www.libreoffice.org/download/pre-releases/)

BTW, please, don't use your emailer to answer to the emails sent by bugzilla. You may just use:
- https://bugs.freedesktop.org/show_bug.cgi?id=69746# to put a comment
- https://bugs.freedesktop.org/attachment.cgi?bugid=69746&action=enter to attach a file + let a comment
Thank you in advance.
Comment 9 Brigitte.Roschewski 2013-10-04 06:34:13 UTC
I tested Version: 4.1.2.2
Build ID: 281b75f427729060b6446ddb3777b32f957a8fb

The bug is resolved