https://bugs.freedesktop.org/show_bug.cgi?id=61271
Priority: medium
Bug ID: 61271
Assignee: [email protected]
Summary: FORMATTING: Negative numbers red does not work on file
load for calculated cells
Severity: normal
Classification: Unclassified
OS: All
Reporter: [email protected]
Hardware: Other
Status: UNCONFIRMED
Version: 4.0.0.3 release
Component: Spreadsheet
Product: LibreOffice
Created attachment 75302
--> https://bugs.freedesktop.org/attachment.cgi?id=75302&action=edit
Spreadsheet with negative calculated cells not correctly displayed on load.
Steps to reproduce:
1. Create a spreadsheet.
2. Place a negative number in cell A1.
3. Set cell B2 to "=A1".
4. Select both cells, open Format Cells and enable "Negative numbers red".
5. Save and close the spreadsheet.
6. Reopen the spreadsheet.
7. Change the value of cell A1 to another negative number.
Expected:
>From step 4 on, the symbols in cells A1 and B2 are always red.
Actual:
In step 6 cell B2 is displayed with black text.
Note 1: If the format specifies parenthesis for negative numbers, that format
is displayed correctly on load.
Note 2: In the attached spreadsheet, cells B3 and B4 have the same format but
they are display differently until cell A1 is changed. I'm not sure whether
that is the same issue or a different issue.
--
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
