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