Apache OpenOffice (AOO) Bugzilla – Issue 94186
datapilot number format is defect
Last modified: 2013-07-30 02:36:43 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.
Created attachment 56734 [details] datapilot's strange number format
confirming it. Yeah the number format appears to be ignored when pulling data from external sources.
I'm taking this.
started.
@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.
okay - I try it (see attachment). Calc gets data from base via datapilot. Thank you for investing your time.
Created attachment 56871 [details] calc with reference to base
Created attachment 56872 [details] base
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.
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?
Reset assignee on issues not touched by assignee in more than 1000 days.