Comment 2 for bug 1879479

Revision history for this message
In , Norbert (nrbrtx) wrote :

Description:
Formula handling inside tables is broken in Microsoft Office DOC or DOCX file formats.

Steps to Reproduce:
Steps to reproduce:
1. Open LibreOffice Writer
2. Insert table of any size - for example 4x4
3. Enter some numbers in the table cells
4. Go to the last (right bottom) cell, hit "=", enter "=sum(<A1:D3>)"
5. Save the document as Microsoft Office DOC or DOCX and close document
6. Open just saved DOC/DOCX document and change some numbers in table (try pressing F9 for sure)

Actual Results:
Actual results:
* the formula in the table is not saved, the user is unable to calculate with it after saving file as DOC / DOCX

Expected Results:
Expected results:
* the formula in the table is saved, the user is able to calculate with it after saving file as DOC / DOCX

Reproducible: Always

User Profile Reset: No

Additional Info:
Notes: the same happens if original document is DOC / DOCX. Saving table with formula removes the formula on next open. Test ODT document is in attachment.

The almost latest LO 6.4.3.2 as in Ubuntu 20.04 LTS is also affected by this bug:

Version: 6.4.3.2
Build ID: 1:6.4.3-0ubuntu0.20.04.1
CPU threads: 1; OS: Linux 5.4; UI render: default; VCL: gtk3;
Locale: en-US (en_US.UTF-8); UI-Language: en-US
Calc: threaded