https://bugs.documentfoundation.org/show_bug.cgi?id=93878
Bug ID: 93878
Summary: save formulas in xls
Product: LibreOffice
Version: 5.0.1.1 rc
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 118375
--> https://bugs.documentfoundation.org/attachment.cgi?id=118375&action=edit
Test.ods
Hello,
I think, that is bug in save to xls format.
Formulas in odt format works for many saves
SUMIFS(C:C;A:A;$E$1;B:B;$E$2)
first save to xls
SUMIFS(C$1:C$983040;A$1:A$983040;$E$1;B$1:B$983040;$E$2)
second save xls to xls
SUMIFS(#REF!$#REF!:#REF!$#REF!;#REF!$#REF!:#REF!$#REF!;$E$1;#REF!$#REF!:#REF!$#REF!;$E$2)
Files in attachment (Test.ods, Test-1.xls, Test-2.xls)
I think that problem:
A:A =>
save to xls convert formula => A$1:A$983040
=> save to xls convert formula => #REF!$#REF!:#REF!$#REF!
David
--
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
