https://bugs.freedesktop.org/show_bug.cgi?id=68282
Priority: medium
Bug ID: 68282
Assignee: [email protected]
Summary: FORMATTING: Paste formatting to blank cells not
preserved in .xlsx
Severity: normal
Classification: Unclassified
OS: Linux (All)
Reporter: [email protected]
Hardware: Other
Whiteboard: BSA
Status: UNCONFIRMED
Version: 4.1.0.4 release
Component: Spreadsheet
Product: LibreOffice
Created attachment 84249
--> https://bugs.freedesktop.org/attachment.cgi?id=84249&action=edit
File showing the problem. Try typing a number into the currency column.
Problem description: Using Formatting of empty rows using the Paste Special
command is not preserved across saves in .xlsx documents
Steps to reproduce:
1. Create a new calc document.
2. Create a row of data in 2 or 3 columns
3. Apply formatting to each column (alignment, number format, whatever)
4. Highlight and copy the row of data
5. Paste the formatting only into all the blank cells below your data, through
row 25. (Use CTRL+Shift+v and uncheck everything except "formats").
6. Save as .xlsx
7. Type something into one of the newly formatted rows to confirm that the
formatting was applied. DO NOT SAVE.
8. Close the document and reopen it
9. Type something into a formatted row. Notice that the formatting is no longer
there. See attached example (test.xlsx)
Current behavior: Formatting of blank rows is lost after save
Expected behavior: Formatting should be preserved.
WORKAROUND: I've noticed that if any content is present in one of the rows that
is formatted (even if it is outside the columns that are formatted), then the
pasted formatting will be retained UP TO THAT ROW. In the attached example
(workaround.xlsx), I have inserted text in cell D21. I pasted formatting into
columns A,B, and C through row 25. The formatting is preserved across saves for
columns A,B, and C only through row 21.
Operating System: Linux (Other)
Version: 4.1.0.4 release
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
