https://bugs.freedesktop.org/show_bug.cgi?id=62221

          Priority: medium
            Bug ID: 62221
          Assignee: [email protected]
           Summary: FORMATTING: using format with color on cell with
                    formula, color is lost when spreadsheet
                    saved/re-opened until cell content changes
          Severity: normal
    Classification: Unclassified
                OS: Windows (All)
          Reporter: [email protected]
          Hardware: Other
        Whiteboard: BSA
            Status: UNCONFIRMED
           Version: 4.0.1.2 release
         Component: Spreadsheet
           Product: LibreOffice

Created attachment 76390
  --> https://bugs.freedesktop.org/attachment.cgi?id=76390&action=edit
test spreadsheet as described above

Problem description: 
If a cell contains a formula and a format is applied which includes color. The
save  the spreadsehet & reopen & there is no color. color reappears when cell
content is changed.

Steps to reproduce:
1. Create new sheet. Enter 2 in A1, 1 in A2 and =A2-A1 in B2
2. Format cell B2 with e.g. #,##0.00 ;[RED](#,##0.00)  
3. close sheet & reopen. 
4) edit A1 to 3 & color reppears

Current behavior: color lost on save & reopen

Expected behavior: color restored on reopen


Operating System: Windows 7
Version: 4.0.1.2 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

Reply via email to