Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
Summary: | Inserted fields from spreadsheet database don´t preserve number formatting | ||||||
---|---|---|---|---|---|---|---|
Product: | Writer | Reporter: | Unknown <non-migrated> | ||||
Component: | code | Assignee: | AOO issues mailing list <issues> | ||||
Status: | CONFIRMED --- | QA Contact: | |||||
Severity: | Trivial | ||||||
Priority: | P3 | CC: | guido.pinkernell, issues, pagalmes.lists | ||||
Version: | OOo 1.1 | Keywords: | oooqa | ||||
Target Milestone: | --- | ||||||
Hardware: | PC | ||||||
OS: | All | ||||||
Issue Type: | ENHANCEMENT | Latest Confirmation in: | --- | ||||
Developer Difficulty: | --- | ||||||
Attachments: |
|
Description
Unknown
2003-10-04 01:15:43 UTC
Please try using the latest OpenOffice 1.1 Final , you can download it from www.openoffice.org many bug fixes and enhancements since your version and 1.1 Final . If the problem still happend in 1.1 please report back Sorry -- I put in the wrong version. This was tested on OOo1.1, the standard download from the site. 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. Created attachment 10442 [details]
Database for reproducing the problem
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. 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 *** Issue 75459 has been marked as a duplicate of this issue. *** *** Issue 102149 has been marked as a duplicate of this issue. *** *** Issue 107279 has been marked as a duplicate of this issue. *** Reset assigne to the default "issues@openoffice.apache.org". |