Issue 44775 - Copy/Paste from Calc to Writer doesn't use the styles' number format
Summary: Copy/Paste from Calc to Writer doesn't use the styles' number format
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: OOo 1.1.4
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: oooqa
Depends on:
Reported: 2005-03-11 08:59 UTC by acoffee
Modified: 2013-08-07 15:12 UTC (History)
2 users (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description acoffee 2005-03-11 08:59:37 UTC
To reproduce:
* Create a new spreadsheet, write a number in the first cell
* Using format|cell (or even the toolbar buttons) assign to that number a new
number format (for instance, a percentage value with just one decimal) (this
format will appear under "user defined" number formats for that file)
* Using the stylist, create a new style (let's call it 'new') based on that cell
* Save the file, and reload it
* Copy the cell to a new Writer file

Expected result: a new OLE object with the cell's formating in Calc

Result: the number format for the cell is wrong. (but just the number format;
all the other formatting defined for the cell's style -border, font, color...-
are correct). This only seems to happen with user-defined number formats.

I've checked this on Windows, too, and I remember seeing this behavior in the
last couple of versions of OOo.

(The bug might seem obscure, but is actually very common to create styles based
on user-defined numeric formats)
Comment 1 haxwell 2005-03-16 20:20:25 UTC
Using OOo 1.9.84 on Win 2000 SP4, I didn't see exactly this bug, because the
issue of the number format being wrong happens before being pasted in the Writer
document. This is what I did:

1. Create new spreadsheet. 
2. Enter 23234.98765 in the first field.
3. Click Format > Cells..
4. In the Format Code field, enter #####.#######0%
5. Click the green check mark button to the right of the field. Click OK.
6. If the Styles and Formatting window does not appear, hit F11.
7. Click the New Style From Selection button.
8. Enter New as the style name.
9. Save the file, exit Calc.
10. Reopen the file you just saved.

A1 will contain 2323498.765% rather than 2323498.76500000% as the format you
originally entered would have displayed it. The format in Format > Cells.. is
different as well.

Pasting into Writer yields a field with the 2323498.765% value in it. A correct
copy, but containing the wrong value.
Comment 2 acoffee 2005-03-17 11:10:55 UTC
I'm not sure we're talking about the same bug. When I open the spreadsheet file,
the formats (the styles, and the number format for each one) are fine. When I
try pasting as OLE into Writer, the new (user-defined) number format is not
applied to the cells as part of their style.

In other words, mine is not a "calc doesn't respect my number formats", but
"writer doesn't apply my style's number format to calc objects"
Comment 3 haxwell 2005-03-17 15:16:19 UTC
acoffee, if you follow the steps I outlined above, do you get the same results?
Comment 4 frank 2005-03-29 10:56:30 UTC
not a bug but an enhancement. Set the flags and re-assigned
Comment 5 ace_dent 2008-05-16 00:53:36 UTC Issue Tracker - Feedback Request.

The Issue you raised is currently assigned to 'Requirements' pending review, but
has not been updated within the last 3 years. Please consider re-testing with
one of the latest versions of OOo, as the problem(s) may have already been
addressed. Either use the recent stable version:
or consider trying the new OOo 3 BETA (still in testing):
Please report back the outcome so this Issue may be Closed or Progressed as
necessary - otherwise it may be Resolved as Invalid in the future. You may also
wish to search for (and note) any duplicates of this Issue that may have
advanced further by checking the Issue Tracker:
Many thanks,
Cleaning-up and Closing old Issues as part of:
~ The Grand Bug Squash, pre v3 ~