Launchpad has imported 6 comments from the remote bug at https://bugs.documentfoundation.org/show_bug.cgi?id=133163.
If you reply to an imported comment from within Launchpad, your comment will be sent to the remote bug automatically. Read more about Launchpad's inter-bugtracker facilities at https://help.launchpad.net/InterBugTracking. ------------------------------------------------------------------------ On 2020-05-19T10:36:46+00:00 Norbert 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 Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1879479/comments/0 ------------------------------------------------------------------------ On 2020-05-19T10:37:32+00:00 Norbert wrote: Created attachment 160997 Simple table with formula to be saved as DOC/DOCX to demonstrate formula lose Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1879479/comments/1 ------------------------------------------------------------------------ On 2020-05-19T11:02:08+00:00 Mikekaganski wrote: Created attachment 160999 A DOCX with a formula in table The document is created in Word 2016. The table has SUM(ABOVE) formula in the bottommost (A3) cell. So the issue is interoperability with Word formats, which are also able to have simple formulas. Both reading is imperfect, and writing. This is by no means HIGHEST/CRITICAL, of course. Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1879479/comments/4 ------------------------------------------------------------------------ On 2020-05-19T11:16:53+00:00 Norbert wrote: This is critical because of data loss. Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1879479/comments/5 ------------------------------------------------------------------------ On 2020-05-19T11:18:57+00:00 Mikekaganski wrote: (In reply to Norbert X from comment #3) > This is critical because of data loss. No bug related to external file types is critical. Please don't start edit wars. Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1879479/comments/6 ------------------------------------------------------------------------ On 2020-05-19T11:22:47+00:00 Norbert wrote: Ok, no problem. Just edited a bunch of documents, opened them and lost formulas in them. Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1879479/comments/7 ** Changed in: df-libreoffice Status: Unknown => Confirmed ** Changed in: df-libreoffice Importance: Unknown => Medium -- You received this bug notification because you are a member of Desktop Packages, which is subscribed to libreoffice in Ubuntu. https://bugs.launchpad.net/bugs/1879479 Title: Saving doc/docx document with formula in table removes this formula Status in LibreOffice: Confirmed Status in libreoffice package in Ubuntu: New 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-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) To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/1879479/+subscriptions -- Mailing list: https://launchpad.net/~desktop-packages Post to : [email protected] Unsubscribe : https://launchpad.net/~desktop-packages More help : https://help.launchpad.net/ListHelp
