Issue 4122 - importing spreadsheet as data source resets the cell format
Summary: importing spreadsheet as data source resets the cell format
Status: ACCEPTED
Alias: None
Product: Writer
Classification: Application
Component: open-import (show other issues)
Version: 641
Hardware: Other All
: P3 Trivial with 1 vote (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: rfe_eval_ok, usability
: 4123 (view as issue list)
Depends on:
Blocks:
 
Reported: 2002-04-18 16:58 UTC by helmerj
Modified: 2017-05-20 11:19 UTC (History)
3 users (show)

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

Attachments
sample pix that shows the single quote (14.77 KB, image/jpeg)
2002-12-03 15:12 UTC, helmerj 		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 helmerj 2002-04-18 16:58:12 UTC 
When importing a scalc spreadsheet using OpenOffice 641.d under Mandrake 8.2 
as a data source the cell format that was set in the spreadsheet to either 
german DM or Euro (german) is reset to $ US. The rese is visible in the data 
source panel and is inserted as such into the Documents.  
 
so 1.200,00 DM becomes $1.200,00.
Comment 1 stefan.baltzer 2002-05-21 09:37:51 UTC 
Reassigned to Michael.
Comment 2 marc.neumann 2002-05-31 11:40:48 UTC 
assigned to msc
Comment 3 michael.ruess 2002-05-31 12:27:15 UTC 
*** Issue 4123 has been marked as a duplicate of this issue. ***
Comment 4 marc.neumann 2002-10-16 13:30:39 UTC 
reassigned to nn@openoffice.org, because he is the developer of this
database driver.

As a workaround you have to set the column format in the database view
to your right currency format.
Comment 5 marc.neumann 2002-10-16 13:38:34 UTC 
reassigned to nn@openoffice.org, because he is the developer of this
database driver.

As a workaround you have to set the column format in the database view
to your right currency format.
Comment 6 Frank Schönheit 2002-10-16 13:44:32 UTC 
I set this to enhancement.
From the technical point of view, the spreadsheet driver has to
translate into the "database world", and there is no such concept as a
format of a column. In databases, numbers are stored, not money
values. It's always a matter how you interpret these numbers.
Comment 7 Frank Schönheit 2002-10-16 13:46:15 UTC 
fs->nn: If we want to have this (I am not sure about it, there is an
easy workaround), then the spreadsheet driver would need to add a
Format property to the columnds. Please ask Ocke for details (I am not
sure how complete the infrastructure for this is implemented in
SDB(C(X)))).
Comment 8 helmerj 2002-12-03 15:12:00 UTC 
Created attachment 3875 [details]
sample pix that shows the single quote
Comment 9 helmerj 2002-12-10 19:03:20 UTC 
I'm fine if you guys close it, the one thing I'd like to know though is, 
how do I get rid of the single quote and where is it actually stored, as 
it is not exported when exporting to plain text. The find and replace 
function also doesn't find it.
Comment 10 niklas.nebel 2002-12-12 14:01:30 UTC 
Falko, any opinion on whether we need this? (Ignore the last comment
and the attachment, they belong to a different issue)
Comment 11 falko.tesch 2003-10-01 14:55:39 UTC 
I'd say this is a nice to have. I re-target it to Office Later
Comment 12 niklas.nebel 2003-10-02 17:26:24 UTC 
accepting for later.
Comment 13 leilich 2004-07-14 09:24:53 UTC 
Suggestion in handling spreadsheets as new data sources:
for each column do {
1. check format of the first n cells in column (table head not included)
2. if it is the same in all n cells use it as format for the new field of the 
data source
}
Problem is the selection of n. Maybe constant 10. Or the max. row# of filled 
cells of the column. Or the min of both.
Comment 14 sgautier.ooo 2004-09-07 15:42:40 UTC 
adding keywords according to new RFE process - Sophie
Comment 15 Marcus 2017-05-20 11:19:28 UTC 
Reset assigne to the default "issues@openoffice.apache.org".