https://bugs.documentfoundation.org/show_bug.cgi?id=171568

            Bug ID: 171568
           Summary: FILESAVE: html `data-sheets-formula` field is omitted
                    when saving a cell with a formula that returns a
                    string
           Product: LibreOffice
           Version: 26.2.2.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: [email protected]
          Reporter: [email protected]

Description:
I am using the html export functionality to implement an automatic grader.
While testing this system I have noticed that the field `data-sheets-formula`
is not properly populated for formulas that return strings.

Being able to access formula information is an important feature to my grader
and I have not been able to find an easy workaround.

Implementation for reference:
https://github.com/lucaFiorini/py_calc_tester


Steps to Reproduce:
1.Create a new calc document
2.Insert the following formula anywhere in the document E.G. `CONCAT("A";"B")`
3.Save the file as an html document (or run --convert-to xhtml)
4.Check if the cell correctly contains the `data-sheets-formula` field

Actual Results:
The exported document is missing formula information

Expected Results:
The exported document should contain formula information


Reproducible: Always


User Profile Reset: No

Additional Info:
Version: 26.2.2.2 (X86_64)
Build ID: 1f77d10d6938fd34972958f64b2bcfa54f8b1ba5
CPU threads: 8; OS: Windows 11 X86_64 (build 26200); UI render: Skia/Raster;
VCL: win
Locale: it-IT (it_IT); UI: it-IT
Calc: CL threaded

-- 
You are receiving this mail because:
You are the assignee for the bug.

Reply via email to