Issue 108521 - Numbers pasted incorrectly into table with special number format - lost on save
Summary: Numbers pasted incorrectly into table with special number format - lost on save
Status: CLOSED FIXED
Alias: None
Product: Writer
Classification: Application
Component: save-export (show other issues)
Version: OOO320m9
Hardware: All All
: P2 Trivial (vote)
Target Milestone: 3.4.0
Assignee: michael.ruess
QA Contact: issues@sw
URL:
Keywords: data_loss
Depends on:
Blocks:
 
Reported: 2010-01-20 23:01 UTC by Andrea Pescetti
Modified: 2017-05-20 10:30 UTC (History)
5 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Document exhibiting the bug (9.45 KB, application/vnd.oasis.opendocument.text)
2010-01-20 23:07 UTC, Andrea Pescetti 		no flags Details
Document exhibiting the bug (9.45 KB, application/vnd.oasis.opendocument.text)
2010-01-20 23:07 UTC, Andrea Pescetti 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description Andrea Pescetti 2010-01-20 23:01:52 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]
Comment 1 Andrea Pescetti 2010-01-20 23:07:22 UTC 
Created attachment 67327 [details]
Document exhibiting the bug
Comment 2 Andrea Pescetti 2010-01-20 23:07:27 UTC 
Created attachment 67328 [details]
Document exhibiting the bug
Comment 3 jbf.faure 2010-01-21 04:56:59 UTC 
Add me to cc.
Comment 4 jbf.faure 2010-01-21 07:49:58 UTC 
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
Comment 5 Oliver-Rainer Wittmann 2010-01-21 09:09:57 UTC 
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"
Comment 6 michael.ruess 2010-01-21 13:13:46 UTC 
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.
Comment 7 vitriol 2010-02-05 19:45:07 UTC 
Add me to CC
Comment 8 stefan.baltzer 2011-01-14 11:13:08 UTC 
SBA -> OS: As discussed, set target to OOo 3.4
Comment 9 Oliver Specht 2011-03-23 11:50:20 UTC 
Fixed in cws os151 in 
http://hg.services.openoffice.org/cws/os151/rev/2f08930a1292

->od: Please review
Comment 10 Oliver Specht 2011-03-28 12:25:57 UTC 
reassigned to mru for verification
Comment 11 michael.ruess 2011-03-30 11:00:02 UTC 
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.