Apache OpenOffice (AOO) Bugzilla – Issue 55923
Alignment of numbers not saved in reports
Last modified: 2013-08-07 15:45:09 UTC
I encountered a problem in the Base module of the OOo2.0RC2 (WinXP) release but am quite sure it also affects other OS's: 1. I create a report using report wizard, some of the data fields contain numbers (e.g. integer or date/time fields) 2. The corresponding table cells in the report are automatically aligned bottom-right 3. I change their alignment to top-left in the design-mode of the report, everything looks o.k. now 4. I create the report and all number fields are aligned *bottom-right* again! => My report looks horrible and I am a bit pissed now...;-) I am attaching two screenshot, one is the "should be" (design mode), the other one the "way it is" in the resulting report.
Created attachment 30402 [details] The final report, with number-field aligned bottom-right
Created attachment 30403 [details] The design view of the report - number field aligned top-left
CONFIRMED Win XP Pro SP2 OOo 2.0.0 final
Reassigned to component owner
could you also attach the document in which this defect occurs?
Hi Lars! As the original document contains confidential data, I have prepared a new one for you (this time on OOo2.0 final on Suse10.0). I am sure you can reproduce it, too, if you follow the steps in my original description. As for the attachment, please check out the report "Zahlungen" that contains two number fields showing the issue.
Created attachment 31992 [details] Test .odb-file with an report demonstrating the problem.
this issue is still present in OOo 2.0.1 RC1 explaining step 3 a little more detailed: (use the attached db) in the last step of the report generation choose "modify report layout". Increase the hight of the second row to make the alignment attributes more visible. Align the data in A2 top left. Save. Close and Open the report: the data is aligned bottom right.
Hi, I can reproduce this, reassign it to the right developer and set target. Bye Marc
. *** This issue has been marked as a duplicate of 56325 ***
bc: Still could reproduce the issue
.
bc: I discussed the issue with fme: It looks like the Numberformatter always changes the alignment of a style as soon as it recognizes it as a number, when Number recognition is enabled. After consulting cj we came to the conclusion, that this behaviour should be changed following this direction: When the alignment attribute of a style is set by the user (PropertyState = com.sun.star.beans.PropertyState.DIRECT_VALUE) the Numberformatter must not change this attribute. Only if it inherits the attribute value (PropertyState = com.sun.star.beans.PropertyState.DEFAULT_VALUE) or if the attribute value is ambigous ((PropertyState = com.sun.star.beans.PropertyState.AMBIGUOUS) it may change the value of the alignment. bc->fme: As discussed I send the bug to you to implement this change. After that you have to send the issue to va so that he can reset the alignment attributes in all user defined paragraph styles of the document templates cnt-012.ott, cnt-022.ott, cnt-032.ott, cnt-042.ott, cnt-052.ott, cnt-062.ott in the share directory /template/lang/wizard/report
bc: Adding cj as cc
Adding va as cc
*** Issue 56325 has been marked as a duplicate of this issue. ***
Cannot be fixed until code freeze. Adjust target to 3.x.