Issue 81933 - RPT 1.0.1: strange behaviour by using formated fields
Summary: RPT 1.0.1: strange behaviour by using formated fields
Status: CONFIRMED
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 2.3
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2007-09-25 13:19 UTC by thomaskrumbein
Modified: 2013-02-07 21:55 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments
Picture1 - RPT error (89.44 KB, image/png)
2007-09-25 13:20 UTC, thomaskrumbein
no flags Details
picture2 - RPT-error (162.58 KB, image/png)
2007-09-25 13:21 UTC, thomaskrumbein
no flags Details
picture3 - RPT-error (17.12 KB, image/png)
2007-09-25 13:22 UTC, thomaskrumbein
no flags Details
picture4 - RPT-error (30.55 KB, image/png)
2007-09-25 13:22 UTC, thomaskrumbein
no flags Details
picture5 - RPT-error (29.23 KB, image/png)
2007-09-25 13:23 UTC, thomaskrumbein
no flags Details
picture6 - RPT-error (76.25 KB, image/png)
2007-09-25 13:23 UTC, thomaskrumbein
no flags Details
picture7 - RPT-error (8.19 KB, image/png)
2007-09-25 13:23 UTC, thomaskrumbein
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
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