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

          Priority: medium
            Bug ID: 59061
          Assignee: [email protected]
           Summary: FORMULA (prolly imported from Excel) that should
                    result in   -   now shows   -"#\"
          Severity: normal
    Classification: Unclassified
                OS: All
          Reporter: [email protected]
          Hardware: Other
            Status: NEW
           Version: 4.0.0.0.beta2
         Component: Spreadsheet
           Product: LibreOffice

Created attachment 72551
  --> https://bugs.freedesktop.org/attachment.cgi?id=72551&action=edit
xls file showing the error

Spreadsheet with formula
  =C4+E4+G4+I4+K4-SUM(M4:S4)

that sould evaluate to   -  if the result in 0
or to a number, if not.
Worked fine for years, now evaluates in  -"#\"


I'll attach a sample spreadsheet.
Opening that in 3.6.4 gives the expected result.

Saving as ODS (I did it in 4.0 beta2) and then opening that ods file in 3.6.4,
gives the wrong result too.

-- 
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