Saving doc/docx document with formula in table removes this formula
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
LibreOffice |
Fix Released
|
Medium
|
|||
libreoffice (Ubuntu) |
New
|
Undecided
|
Unassigned |
Bug Description
Description:
Formula handling inside tables is broken in Microsoft Office DOC or DOCX file formats.
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:
* the formula in the table is not saved, the user is unable to calculate with it after saving file as DOC / DOCX
Expected Results:
* the formula in the table is saved, the user is able to calculate with it after saving file as DOC / DOCX
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-
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
ProblemType: Bug
DistroRelease: Ubuntu 20.04
Package: libreoffice-writer 1:6.4.3-
ProcVersionSign
Uname: Linux 5.4.0-26-generic x86_64
ApportVersion: 2.20.11-0ubuntu27
Architecture: amd64
CasperMD5CheckR
CurrentDesktop: MATE
Date: Tue May 19 13:37:57 2020
InstallationDate: Installed on 2020-04-23 (25 days ago)
InstallationMedia: Ubuntu-MATE 20.04 LTS "Focal Fossa" - Release amd64 (20200423)
SourcePackage: libreoffice
UpgradeStatus: No upgrade log present (probably fresh install)
Changed in df-libreoffice: | |
importance: | Unknown → Medium |
status: | Unknown → Confirmed |
Changed in df-libreoffice: | |
status: | Confirmed → In Progress |
Changed in df-libreoffice: | |
status: | In Progress → Fix Released |
Changed in libreoffice (Ubuntu): | |
status: | New → Fix Released |
status: | Fix Released → New |
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 0ubuntu0. 20.04.1
Build ID: 1:6.4.3-
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