[Bug 664816] New: oowriter kill table content in odt document when sum() is used
https://bugzilla.novell.com/show_bug.cgi?id=664816 https://bugzilla.novell.com/show_bug.cgi?id=664816#c0 Summary: oowriter kill table content in odt document when sum() is used Classification: openSUSE Product: openSUSE 11.4 Version: Factory Platform: x86-64 OS/Version: Other Status: NEW Severity: Critical Priority: P5 - None Component: OpenOffice.org AssignedTo: bnc-team-ooo@forge.provo.novell.com ReportedBy: bruno@ioda-net.ch QAContact: cwei@novell.com Found By: --- Blocker: --- Created an attachment (id=408540) --> (http://bugzilla.novell.com/attachment.cgi?id=408540) This is the original document, you can't modify User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:2.0b9) Gecko/20110110 Firefox/4.0b9 On factory 11.4 with those LibreOffice component installed S | Name | Type | Version | Arch | Repository --+------------------------------------------+---------+-------------+--------+------------------ i | libreoffice | package | 3.3.0.2-2.1 | x86_64 | factory-oss i | libreoffice-base | package | 3.3.0.2-2.1 | x86_64 | factory-oss i | libreoffice-base-debuginfo | package | 3.3.0.2-2.1 | x86_64 | 11.4-Debug i | libreoffice-base-drivers-mysql | package | 3.3.0.2-2.1 | x86_64 | factory-oss i | libreoffice-base-drivers-mysql-debuginfo | package | 3.3.0.2-2.1 | x86_64 | 11.4-Debug i | libreoffice-base-drivers-postgresql | package | 3.3.0.2-2.1 | x86_64 | factory-oss i | libreoffice-base-extensions | package | 3.3.0.2-2.1 | x86_64 | factory-oss i | libreoffice-branding-upstream | package | 3.3.0.2-2.1 | noarch | factory-oss i | libreoffice-calc | package | 3.3.0.2-2.1 | x86_64 | factory-oss i | libreoffice-calc-debuginfo | package | 3.3.0.2-2.1 | x86_64 | 11.4-Debug i | libreoffice-calc-extensions | package | 3.3.0.2-2.1 | x86_64 | factory-oss i | libreoffice-components | package | 3.3.0.2-2.1 | x86_64 | factory-oss i | libreoffice-components-debuginfo | package | 3.3.0.2-2.1 | x86_64 | 11.4-Debug i | libreoffice-draw | package | 3.3.0.2-2.1 | x86_64 | factory-oss i | libreoffice-draw-extensions | package | 3.3.0.2-2.1 | x86_64 | factory-oss i | libreoffice-filters | package | 3.3.0.2-2.1 | x86_64 | factory-oss i | libreoffice-filters-debuginfo | package | 3.3.0.2-2.1 | x86_64 | 11.4-Debug i | libreoffice-filters-optional | package | 3.3.0.2-2.1 | x86_64 | factory-oss i | libreoffice-filters-optional-debuginfo | package | 3.3.0.2-2.1 | x86_64 | 11.4-Debug i | libreoffice-help-en-GB | package | 3.3.0.2-2.1 | noarch | factory-oss i | libreoffice-help-en-US | package | 3.3.0.2-2.1 | noarch | factory-oss i | libreoffice-help-fr | package | 3.3.0.2-2.1 | noarch | factory-oss i | libreoffice-icon-theme-crystal | package | 3.3.0.2-2.1 | noarch | (System Packages) i | libreoffice-icon-theme-galaxy | package | 3.3.0.2-2.1 | noarch | (System Packages) i | libreoffice-icon-theme-hicontrast | package | 3.3.0.2-2.1 | noarch | (System Packages) i | libreoffice-icon-theme-oxygen | package | 3.3.0.2-2.1 | noarch | (System Packages) i | libreoffice-icon-theme-tango | package | 3.3.0.2-2.1 | noarch | factory-oss i | libreoffice-impress | package | 3.3.0.2-2.1 | x86_64 | factory-oss i | libreoffice-impress-debuginfo | package | 3.3.0.2-2.1 | x86_64 | 11.4-Debug i | libreoffice-impress-extensions | package | 3.3.0.2-2.1 | x86_64 | factory-oss i | libreoffice-kde4 | package | 3.3.0.2-2.1 | x86_64 | factory-oss i | libreoffice-kde4-debuginfo | package | 3.3.0.2-2.1 | x86_64 | 11.4-Debug i | libreoffice-l10n-en-GB | package | 3.3.0.2-2.1 | noarch | factory-oss i | libreoffice-l10n-extras | package | 3.3.0.2-2.1 | noarch | factory-oss i | libreoffice-l10n-fr | package | 3.3.0.2-2.1 | noarch | factory-oss i | libreoffice-libs-core | package | 3.3.0.2-2.1 | x86_64 | factory-oss i | libreoffice-libs-core-debuginfo | package | 3.3.0.2-2.1 | x86_64 | 11.4-Debug i | libreoffice-libs-extern | package | 3.3.0.2-2.1 | x86_64 | factory-oss i | libreoffice-libs-extern-debuginfo | package | 3.3.0.2-2.1 | x86_64 | 11.4-Debug i | libreoffice-libs-gui | package | 3.3.0.2-2.1 | x86_64 | factory-oss i | libreoffice-libs-gui-debuginfo | package | 3.3.0.2-2.1 | x86_64 | 11.4-Debug i | libreoffice-mailmerge | package | 3.3.0.2-2.1 | x86_64 | factory-oss i | libreoffice-math | package | 3.3.0.2-2.1 | x86_64 | factory-oss i | libreoffice-math-debuginfo | package | 3.3.0.2-2.1 | x86_64 | 11.4-Debug i | libreoffice-officebean | package | 3.3.0.2-2.1 | x86_64 | factory-oss i | libreoffice-officebean-debuginfo | package | 3.3.0.2-2.1 | x86_64 | 11.4-Debug i | libreoffice-pyuno | package | 3.3.0.2-2.1 | x86_64 | factory-oss i | libreoffice-pyuno-debuginfo | package | 3.3.0.2-2.1 | x86_64 | 11.4-Debug i | libreoffice-ure | package | 3.3.0.2-2.1 | x86_64 | factory-oss i | libreoffice-ure-debuginfo | package | 3.3.0.2-2.1 | x86_64 | 11.4-Debug i | libreoffice-writer | package | 3.3.0.2-2.1 | x86_64 | factory-oss i | libreoffice-writer-debuginfo | package | 3.3.0.2-2.1 | x86_64 | 11.4-Debug i | libreoffice-writer-extensions | package | 3.3.0.2-2.1 | x86_64 | factory-oss There's a BIG problem ( loosing data ) when you try to modify or edit a document which has a table and the sum() formula somewhere is the content. Reproducible: Always Steps to Reproduce: 1. Start a new odt document 2. write one title 3. insert a table 2 cols, 7 rows 3. First row Label, Time past 4. add row by row, Label N° , 1.25 . on the seventh line, second col use sum(<b2>:<b6>) 5 : Check Preview, do a pdf export, save the document everything is right 6: close all LibreOffice 7: reopen the document 8: insert a paragraph at the end 9: clic on the table 10 : get the "**Expression is faulty**" everywhere in the table Actual Results: if the document is saved with the "Expression is faulty" this replace and destroy any data that was present inside the table. I didn't try to reproduce it without the styling applied to the second columns, I should be able to use that style, as I've doing it in go-ooo 3.2.1 Expected Results: Be able to modify what I want inside the document and the table. I'll will add two document which explain how it doesn't work and kill your data, so you can diff them -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.
https://bugzilla.novell.com/show_bug.cgi?id=664816 https://bugzilla.novell.com/show_bug.cgi?id=664816#c1 --- Comment #1 from Bruno Friedmann <bruno@ioda-net.ch> 2011-01-16 15:28:48 UTC --- Created an attachment (id=408541) --> (http://bugzilla.novell.com/attachment.cgi?id=408541) This is the pdf made during the initial phase of building the document Exported as pdf, before any initial saves. At that time you are able to modify the table -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.
https://bugzilla.novell.com/show_bug.cgi?id=664816 https://bugzilla.novell.com/show_bug.cgi?id=664816#c2 --- Comment #2 from Bruno Friedmann <bruno@ioda-net.ch> 2011-01-16 15:30:16 UTC --- Created an attachment (id=408542) --> (http://bugzilla.novell.com/attachment.cgi?id=408542) Content of table as been destroyed, just clicking the content Now this document is a save as of the first attach. When you have clic the content of the table. You have loose your content. -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.
https://bugzilla.novell.com/show_bug.cgi?id=664816 https://bugzilla.novell.com/show_bug.cgi?id=664816#c3 Lubos Lunak <llunak@novell.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |llunak@novell.com AssignedTo|bnc-team-ooo@forge.provo.no |cbosdonnat@novell.com |vell.com | --- Comment #3 from Lubos Lunak <llunak@novell.com> 2011-01-17 16:30:07 UTC --- Confirmed with current master. -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.
https://bugzilla.novell.com/show_bug.cgi?id=664816 https://bugzilla.novell.com/show_bug.cgi?id=664816#c4 --- Comment #4 from Bruno Friedmann <bruno@ioda-net.ch> 2011-01-18 08:08:10 UTC --- Created an attachment (id=408728) --> (http://bugzilla.novell.com/attachment.cgi?id=408728) Test document, where table and sum() have been created by go-oo 3.2.1 I join here a document in which the table and sum formula (total line) was created with go-ooo 3.2.1 In that case you can edit the table, change content, delete line, and refresh the sum formula. So only new document and new table created with Libre-Office present the default. -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.
https://bugzilla.novell.com/show_bug.cgi?id=664816 https://bugzilla.novell.com/show_bug.cgi?id=664816#c5 Cédric Bosdonnat <cbosdonnat@novell.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED Resolution| |DUPLICATE --- Comment #5 from Cédric Bosdonnat <cbosdonnat@novell.com> 2011-03-01 13:07:31 UTC --- (In reply to comment #0)
on the seventh line, second col use sum(<b2>:<b6>)
This is probably a meaningless mistake: the correct formula is sum(<b2:b6>) in writer tables.
Actual Results: if the document is saved with the "Expression is faulty" this replace and destroy any data that was present inside the table.
I didn't try to reproduce it without the styling applied to the second columns, I should be able to use that style, as I've doing it in go-ooo 3.2.1
Expected Results: Be able to modify what I want inside the document and the table.
This is a duplicate of bug 664516. Sorry for the delay to spot that one. *** This bug has been marked as a duplicate of bug 664516 *** http://bugzilla.novell.com/show_bug.cgi?id=664516 -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.
participants (1)
-
bugzilla_noreply@novell.com