Issue 20680 - Inserted fields from spreadsheet database don´t preserve number formatting
Summary: Inserted fields from spreadsheet database don´t preserve number formatting
Alias: None
Product: Writer
Classification: Application
Component: code (show other issues)
Version: OOo 1.1
Hardware: PC All
: P3 Trivial with 1 vote (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: oooqa
: 75459 102149 (view as issue list)
Depends on:
Reported: 2003-10-04 01:15 UTC by Unknown
Modified: 2017-05-20 11:19 UTC (History)
3 users (show)

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

Database for reproducing the problem (5.16 KB, application/octet-stream)
2003-10-19 14:19 UTC, guido.pinkernell
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description Unknown 2003-10-04 01:15:43 UTC
When you insert a field, there is a Format box where you can choose "From 
Database" or "User Defined."  If you choose "From Database" and you have 
formatted fields, the merged file will have unformatted fields.  For example, 
if you have numbers like "3,100" and "280,000" formatted with "##0,#" in your 
spreadsheet and you import them into a mail merge, they come out looking 
like "3100" and "280000".  This can be a real problem, especially when you 
want to do a merge with dollar values ($280000 looks pretty silly).

To reproduce:
1) Create a test spreadsheet with 4 numbers, formatted as: general, comma 
separated, comma separated with decimals, and dollar with deciamals
2) Import the test spreadsheet
3) Create a document with the field
4) Do a mail merge to the printer
5) The fields will not be formatted

Note: I was only able to do this by printing them, I wasn't able to create the 
files because that feature also doesn't work.

Workarounds: The user can set the format to be something specific.  In my 
case, I had to change all of the number fields to text fields and add the 
commas myself.
Comment 1 utomo99 2003-10-04 03:05:57 UTC
Please try using the latest OpenOffice 1.1 Final , you can download it
many bug fixes and enhancements since your version and 1.1 Final . If
the problem still happend in 1.1 please report back 
Comment 2 Unknown 2003-10-04 19:05:44 UTC
Sorry -- I put in the wrong version.  This was tested on OOo1.1, the 
standard download from the site.
Comment 3 guido.pinkernell 2003-10-19 14:17:27 UTC
This problem can be reproduced also by using mail merge. I´ve modified
the summary accordingly. The problem is visible already after having
imported the spreadsheet database into Writer. The table there doesn´t
make a difference between differently formatted numbers.

Confirmed on OOo1.1.0, Win98.

For reproduction I´ve created a small spreadsheet file. Will attach.
Comment 4 guido.pinkernell 2003-10-19 14:19:00 UTC
Created attachment 10442 [details]
Database for reproducing the problem
Comment 5 h.ilter 2003-10-20 10:11:23 UTC
HI->FS: After you defined the bugdoc as a new Data Source, open the
Database with F4 and you will see the number formats are not imported 1:1.
Comment 6 Frank Schönheit 2003-10-20 12:47:13 UTC
this is a know limitation of the spreadsheet SDBC driver: it doesn't
import the number formats.
fs->nn: If the driver could provide the formatting as column property,
then the higher layers (SDB) could probably use this. However, there's
no infrastructure for this, yet.
If we decide that this will be solved, then:
- your driver needs to expose the spreadsheet format as column properties
- our SDB layer needs to respect column formattings provided from the
SDBC(X) layer
Comment 7 marc.neumann 2007-03-16 15:39:43 UTC
*** Issue 75459 has been marked as a duplicate of this issue. ***
Comment 8 marc.neumann 2009-08-14 09:01:39 UTC
*** Issue 102149 has been marked as a duplicate of this issue. ***
Comment 9 marc.neumann 2009-11-30 07:22:21 UTC
*** Issue 107279 has been marked as a duplicate of this issue. ***
Comment 10 Marcus 2017-05-20 11:19:48 UTC
Reset assigne to the default "".