Apache OpenOffice (AOO) Bugzilla – Issue 81933
RPT 1.0.1: strange behaviour by using formated fields
Last modified: 2013-02-07 21:55:44 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".
Created attachment 48473 [details] Picture1 - RPT error
Created attachment 48474 [details] picture2 - RPT-error
Created attachment 48475 [details] picture3 - RPT-error
Created attachment 48476 [details] picture4 - RPT-error
Created attachment 48477 [details] picture5 - RPT-error
Created attachment 48478 [details] picture6 - RPT-error
Created attachment 48479 [details] picture7 - RPT-error
The date- and time problem only occur when inserting the fields in the pagehead- or pagefooter-section.
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.
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.
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.
the mistake from "bild3" is fixed in 2.4.0 To the second part there is a discussion on dev@dba.openoffice.org http://dba.openoffice.org/servlets/ReadMsg?list=dev&msgNo=3304