Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing
|Summary:||RPT 1.0.1: strange behaviour by using formated fields|
|Component:||code||Assignee:||AOO issues mailing list <issues>|
|Status:||CONFIRMED ---||QA Contact:|
|Issue Type:||DEFECT||Latest Confirmation in:||---|
Description thomaskrumbein 2007-09-25 13:19:58 UTC
Playing around with the report-designer 1.0.1 I found some real strange behaviour. So it is not really usable. 1. I create a report and want to summerize some currency-fields. So I create a new function with will do this - well, works fine. In report details there are two fields with represents currency-values. I formated them using the proberty "Format" in report-designer (see "_Bild1"). Trying the Report at this stage, the fields will be shown as "x.xxx,xx", so two digits after decimal-point, but without the currency-sign. OK, that may be OK. Then I create the function (see "_Bild4") and add a formated textfielt to the report. I assign the same "Format" (see "_Bild2"), but the result is very strange... see "_Bild3". 2. Playing around with datefields you will found even strange behaviours. Insert a Datefield using "Insert - Date" - the Format is correct in desgn-view, but without any format in report-view (the internal number is shown correct ;-) ). OK, you can reformat the field in Writer itself - this is a workaround. Creating own function with datevalues I will get no values or even the internal numbers (see pictures "_Bild5", "_Bild6", "_bild7".
Comment 1 thomaskrumbein 2007-09-25 13:20:53 UTC
Created attachment 48473 [details] Picture1 - RPT error
Comment 2 thomaskrumbein 2007-09-25 13:21:40 UTC
Created attachment 48474 [details] picture2 - RPT-error
Comment 3 thomaskrumbein 2007-09-25 13:22:17 UTC
Created attachment 48475 [details] picture3 - RPT-error
Comment 4 thomaskrumbein 2007-09-25 13:22:40 UTC
Created attachment 48476 [details] picture4 - RPT-error
Comment 5 thomaskrumbein 2007-09-25 13:23:03 UTC
Created attachment 48477 [details] picture5 - RPT-error
Comment 6 thomaskrumbein 2007-09-25 13:23:27 UTC
Created attachment 48478 [details] picture6 - RPT-error
Comment 7 thomaskrumbein 2007-09-25 13:23:50 UTC
Created attachment 48479 [details] picture7 - RPT-error
Comment 8 thomaskrumbein 2007-09-26 11:28:25 UTC
The date- and time problem only occur when inserting the fields in the pagehead- or pagefooter-section.
Comment 9 Mechtilde 2008-02-03 12:13:20 UTC
I can confirm it also under GNU/Linux so I set OS to all. I see also that all curency values are negative. which isn't right.
Comment 10 Mechtilde 2008-02-03 12:22:05 UTC
I found a Workaround If there are no negative numbers you can delete the formatting of it in the number formatting. Then it works :-( So you can organize the calculation to have no negative numer.
Comment 11 Frank Schönheit 2008-02-04 14:01:11 UTC
Part 1 seems to be a duplicate of 80479 - actually, currency values don't work reliably at the moment :( Part 2 seems to be a duplicate of another issue whose number I don't recall ATM, but it should be fixed in OOo 2.4.
Comment 12 Mechtilde 2008-03-19 12:38:10 UTC
the mistake from "bild3" is fixed in 2.4.0 To the second part there is a discussion on email@example.com http://dba.openoffice.org/servlets/ReadMsg?list=dev&msgNo=3304