Apache OpenOffice (AOO) Bugzilla – Issue 44775
Copy/Paste from Calc to Writer doesn't use the styles' number format
Last modified: 2013-08-07 15:12:27 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)
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.
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"
acoffee, if you follow the steps I outlined above, do you get the same results?
not a bug but an enhancement. Set the flags and re-assigned
OpenOffice.org 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: http://download.openoffice.org/index.html or consider trying the new OOo 3 BETA (still in testing): http://download.openoffice.org/3.0beta/ 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: http://www.openoffice.org/issues/query.cgi Many thanks, Andrew Cleaning-up and Closing old Issues as part of: ~ The Grand Bug Squash, pre v3 ~ http://marketing.openoffice.org/3.0/announcementbeta.html