https://bugs.freedesktop.org/show_bug.cgi?id=63120
Priority: medium
Bug ID: 63120
Assignee: [email protected]
Summary: FORMATTING: Red for Negative values failing on opening
Severity: normal
Classification: Unclassified
OS: Linux (All)
Reporter: [email protected]
Hardware: Other
Whiteboard: BSA
Status: UNCONFIRMED
Version: 4.0.2.1 rc
Component: Spreadsheet
Product: LibreOffice
Created attachment 77422
--> https://bugs.freedesktop.org/attachment.cgi?id=77422&action=edit
A simple spreadsheet with the first cell as a -1 and then every other cell
below it multiplying the one two cells above by a -1
The spreadsheet I keep to handle my finances has some columns with
[$$-409]#,##0.00;[RED]-[$$-409]#,##0.00
So that negative values always show in red.
I last saved this spreadsheet in 4.0.2.1 and upon reopening, the formatting has
been ignored. The cells which should show red for a negative value do NOT.
They are the normal color, black.
However, if I changed the first cell in a chain of cells that each rely on the
previous one, by placing a negative symbol in front of the formula or number
and save it, nothing happens. Upon removing that negative symbol (the minus
sign right after the equal sign) the cell turns red and every cell in the chain
that is negative also turns red.
Steps to reproduce:
1.Create a cell with a -1 and format as stated above (sample attached)
2.Create a chain of cells each referencing the one before
3.Save the file
4.Reopen the file. All cells will have default formatting, not red on negative
formatting.
5.Change the top cell that all the others indirectly rely on by removing the
negative sign or putting a positive number in.
6.All following cells in the chain will now respect the RED directive.
7.Change the top cell again, putting the negative sign back in, or changing the
number to a negative number
8.All following cells still respect the RED directive.
9.Save the file.
10.Reopen the file, the RED directive is not respected until the top of the
chain is changed again.
Current behavior:
Expected behavior:
Operating System: Ubuntu
Version: 4.0.2.1 rc
--
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
