https://bugs.freedesktop.org/show_bug.cgi?id=60495
Priority: medium
Bug ID: 60495
Assignee: [email protected]
Summary: Formatting: Appears to have no effect on numbers
Severity: normal
Classification: Unclassified
OS: Linux (All)
Reporter: [email protected]
Hardware: x86-64 (AMD64)
Status: UNCONFIRMED
Version: 4.0.0.3 release
Component: Spreadsheet
Product: LibreOffice
Created attachment 74431
--> https://bugs.freedesktop.org/attachment.cgi?id=74431&action=edit
Table of sunspot data. Columns D and E are formatted to have negative numbers
in red.
In a book created by a previous version of Calc, I noticed that a column of
numbers were all in black, whether or not they were negative. The formatting
said they should be red if negative. I changed the formatting several times,
lastly to scientific notation, but it appeared to have no effect. I then saved
and closed the book.
On opening the saved version with LO 3.6.3, I found the formatting had taken
effect, complete with scientific notation, although 4.0.0 hadn't displayed the
change. Opening again with 4.0.0, the changed formatting still wasn't visible.
This problem doesn't occur with all numbers; it seems limited to calculated
numbers and not directly entered ones. I will do more testing to try to see a
pattern.
--
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
