Issue 81933

Summary: RPT 1.0.1: strange behaviour by using formated fields
Product: Base Reporter: thomaskrumbein <tk>
Component: codeAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues, mechtilde
Version: OOo 2.3   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
Picture1 - RPT error
none
picture2 - RPT-error
none
picture3 - RPT-error
none
picture4 - RPT-error
none
picture5 - RPT-error
none
picture6 - RPT-error
none
picture7 - RPT-error none

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 dev@dba.openoffice.org
http://dba.openoffice.org/servlets/ReadMsg?list=dev&msgNo=3304