Apache OpenOffice (AOO) Bugzilla – Issue 108521
Numbers pasted incorrectly into table with special number format - lost on save
Last modified: 2017-05-20 10:30:42 UTC
Numbers pasted in the attached Writer document are lost on save: reopening the document, you find them set to 0,00 (on Italian locale; possibly 0.00 on another locale). To reproduce: 1. Right click on the table in the attached Writer document, disable "Number Recognition". 2. Copy this number: 1234 3. Paste it in the first three rows of the table, using "Paste special" as unformatted text every time. Numbers should display fine. 4. Save, close, reopen. 5. Only the first occurrence is still there. The others are set to "0,00". [Found by Aldo Colamartino during Italian QA tests]
Created attachment 67327 [details] Document exhibiting the bug
Created attachment 67328 [details] Document exhibiting the bug
Add me to cc.
Hi Andrea, I can reproduce the bug with FR version of OOo 3.2 rc3 (OOO320m10) under Ubuntu 8.04 and *your* file. But *not* with a new document. What is the particularity of your file ? I saw that there is a table in another table and I tested in the same configuration. Set keyword data_loss anyway. Kind regards. JBF
I have reproduced the described defect in OOo 2.0 (English version) under Windows I first look into the ODF reveals that the table cells from the second row on have a certain number format set. To reproduce from scratch (even in OOo 2.0) perform the following steps: - create new text document - type characters "1234" - insert table with 1 column and 2 rows - selected 2nd table row - open context menu for selected table row and choose menu entry "Number Format" - choose number format category: Number, format: -1.234,12 - confirm the dialog - copy typed characters "1234" and paste them as unformatted text into the table cells of the first row and then into the table cell of the 2nd row. - save - reload --> show content in table cell of 2nd row is "0,00"
MRU->OS: when having a cell with number format assigned as described, a content like "1234" pasted as "unformatted text" will give a curious result "1#2#3#4" which will turn to 0 when saved and reopened. Maybe this is related to issue 46075, issue 63127 or issue 46076.
Add me to CC
SBA -> OS: As discussed, set target to OOo 3.4
Fixed in cws os151 in http://hg.services.openoffice.org/cws/os151/rev/2f08930a1292 ->od: Please review
reassigned to mru for verification
The problem regarding valid numbers turn to 0.000 is fixed in CWS os151. The problem regarding wrong numbers 1#2#3#4# when pasting into table selection is handled in issue 60447.