https://bugs.documentfoundation.org/show_bug.cgi?id=97935
Bug ID: 97935
Summary: FILESAVE, FORMATTING. Format of cells containing text
with several formats is corrupted when saving as xls,
xlsx
Product: LibreOffice
Version: 5.1.1.1 rc
Hardware: x86 (IA32)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 122725
--> https://bugs.documentfoundation.org/attachment.cgi?id=122725&action=edit
test ods file
The attached ods file contains simple a couple of "Lorem ipsum" sentences in
each cell, with different formatting. All the cells Calibri 14 and 'Wrap text'
on:
* A1: without any additional formatting to the chars.
* A2: last sentence has a smaller text size.
* A3: word "ipsum" bold.
* A4: cell with bold text.
* A5: word "ipsum" red color.
* A6: word "Lorem" underlined.
* A7: cell with red text.
When saving this file as xlsx or xls, cell formatting is corrupted and, when
opening the xlsx file with Excel Viewer 2007, there are no spaces before and
after words with different format. The xls file in Excel Viewer 2007 shows all
the spaces but formatting is not respected.
=== Steps to reproduce ===
1. Save the attached ods file as xlsx.
2. Reopen the xlsx or xls file with LibreOffice.
Current Results (please compare with the above for expected results):
In all the cells of the sheet: Text alignment vertical changes from 'Default'
to 'Align bottom'; Reference Edge in Text Orientation changes from 'Text
Extension from Lower Cell Border' to 'Text Extension Inside Cell'.
* A1: Looks good.
* A2: Text not wrapped; original font (Calibri) changed to Arial; original text
size (14) changes to 10.
* A3: Same as A2.
* A4: Can't see the first four words of the text.
* A5: Same as A2.
* A6: Same as A2.
* A7: Looks good.
3. Reopen the xlsx file with MS Excel Viewer 2007.
Current Results:
You will see the same bug behaviour as shown in step 2, PLUS the spaces before
and after the formatted words in cells A2:A7 are missing and there is an empty
first line in cells A1 and A7. Cell A4 looks good.
4. 3. Reopen the xls file with MS Excel Viewer 2007.
Current Results:
You will see the same bug behaviour as shown in step 2, PLUS there is an empty
first line in cells A1 and A7. Cell A4 looks good.
Reproduced in
Version: 5.1.1.1
Build ID: c43cb650e9c145b181321ea547d38296db70f36e
CPU Threads: 4; OS Version: Windows 6.1; UI Render: default;
Locale: es-ES (es_ES)
I set Severity as major because affects interoperabilty with MS Office.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
