Issue 94186

Summary: datapilot number format is defect
Product: Calc Reporter: murof <dieter.reiser>
Component: formattingAssignee: AOO issues mailing list <issues>
Status: ACCEPTED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: cmoulin, issues, kyoshida
Version: OOo 3.0 RC1   
Target Milestone: ---   
Hardware: Sun   
OS: Linux, all   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
datapilot's strange number format
none
calc with reference to base
none
base none

Description murof 2008-09-22 19:14:24 UTC 
I use to make a draft on the datapilot. But now - in the version 3.0 RC1 - the
number formats are inconsistent. E.g. the number 24,500 (in base) is displayed
as 24.000 (with dot) or like this: 24500 (!). Sometimes such numbers are
displayed as datum. I have discussed this problem with members of the german
forum: http://de.openoffice.info/viewtopic.php?f=2&t=19632 but we didn't come to
a satisfyingly result.
Comment 1 murof 2008-09-22 19:16:20 UTC 
Created attachment 56734 [details]
datapilot's strange number format
Comment 2 kyoshida 2008-09-27 04:08:56 UTC 
confirming it.  Yeah the number format appears to be ignored when pulling data
from external sources.
Comment 3 kyoshida 2008-09-27 07:01:11 UTC 
I'm taking this.
Comment 4 kyoshida 2008-09-27 07:01:26 UTC 
started.
Comment 5 kyoshida 2008-09-27 17:45:39 UTC 
@murof: hmm... actually I have hard time reproducing this.  Can you attach a
test document that can reproduce this problem?  Otherwise I won't be able to
debug....   Thanks.
Comment 6 murof 2008-09-27 19:28:15 UTC 
okay - I try it (see attachment). Calc gets data from base via datapilot.
Thank you for investing your time.
Comment 7 murof 2008-09-27 19:37:17 UTC 
Created attachment 56871 [details]
calc with reference to base
Comment 8 murof 2008-09-27 19:39:14 UTC 
Created attachment 56872 [details]
base
Comment 9 kyoshida 2008-09-29 18:02:25 UTC 
Ah, the number formats do not get carried over from an external source since the
data transfer is done via UNO's com.sun.star.sdbc.* APIs.  We do get the data
type information (i.e. Date, Time, String, etc.) but the more detailed number
format information is lost in the transfer.

So, for Calc to honor the number format set in Base, we need a way to retrieve
the original number format from the Base file.

BTW this is not a regression since 2.4.1 exhibits the same limitation.
Comment 10 murof 2008-10-16 04:53:30 UTC 
kohei: what's up now? OpenOffice was released, but this bug exists. The
datapilot isn't practicable and therefore I can't use the whole suite. Or do you
know a way to bypass datapilots wrong formatting?
Comment 11 Rob Weir 2013-07-30 02:36:43 UTC 
Reset assignee on issues not touched by assignee in more than 1000 days.