Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing
|Summary:||datapilot number format is defect|
|Component:||formatting||Assignee:||AOO issues mailing list <issues>|
|Status:||ACCEPTED ---||QA Contact:|
|Priority:||P3||CC:||cmoulin, issues, kyoshida|
|Version:||OOo 3.0 RC1|
|Issue Type:||DEFECT||Latest Confirmation in:||---|
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
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 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.