[Libreoffice-bugs] [Bug 125466] New: FILESAVE XLS loses formula type metadata

[bugzilla-daemon at bugs.documentfoundation.org]

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: libreoffice-bugs at lists.freedesktop.org
          Reporter: dev at sheetjs.com

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190523/e32d6afd/attachment.html>