Public bug reported:
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-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
ProblemType: Bug
DistroRelease: Ubuntu 20.04
Package: libreoffice-writer 1:6.4.3-0ubuntu0.20.04.1
ProcVersionSignature: Ubuntu 5.4.0-26.30-generic 5.4.30
Uname: Linux 5.4.0-26-generic x86_64
ApportVersion: 2.20.11-0ubuntu27
Architecture: amd64
CasperMD5CheckResult: skip
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)
** Affects: df-libreoffice
Importance: Unknown
Status: Unknown
** Affects: libreoffice (Ubuntu)
Importance: Undecided
Status: New
** Tags: amd64 apport-bug focal
** Attachment added: "Simple table with formula to be saved as DOC/DOCX to
demonstrate formula lose"
https://bugs.launchpad.net/bugs/1879479/+attachment/5374024/+files/table.odt
** Bug watch added: Document Foundation Bugzilla #133163
https://bugs.documentfoundation.org/show_bug.cgi?id=133163
** Also affects: df-libreoffice via
https://bugs.documentfoundation.org/show_bug.cgi?id=133163
Importance: Unknown
Status: Unknown
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1879479
Title:
Saving doc/docx document with formula in table removes this formula
To manage notifications about this bug go to:
https://bugs.launchpad.net/df-libreoffice/+bug/1879479/+subscriptions
--
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
