https://bugs.documentfoundation.org/show_bug.cgi?id=125466
Bug ID: 125466
Summary: FILESAVE XLS loses formula type metadata
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
See https://github.com/SheetJS/js-xlsx/issues/1514
Some formulae results are written with 0 value even though LO knows the actual
result is a string.
Steps to Reproduce:
set A1=a, B1=b, C1=CONCAT(A1,",",B1)
Now copy cell C1 down to C2 then save as XLS, then set A2=d and B2=c
Actual Results:
Formula cells C1 and C2 are written with FormulaValue 0
Expected Results:
Formula cells should be written with the string results
Reproducible: Always
User Profile Reset: Yes
Additional Info:
Something about copying the cell triggers the error. If you just do the first
part (A1,B1,C1, then save) LO writes the FormulaValue as a string.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
