Apache OpenOffice (AOO) Bugzilla – Issue 102149
% values not shown in serial letter
Last modified: 2009-09-22 20:46:09 UTC
I am using a OOCalc file that displays % values (for example 34.6%). Then I create a serial letter and one of the imported values is a percent value. In OOWriter I see 0.346 which is the correct value but the wrong format. I think that Writer should use the same format when importing values.
I checked with "Ooo 3.1.0 WIN XP multilingual version German UI activated [OOO310m11 (Build 9399)]" and my standard address-database / letter template; I can NOT confirm the reported effect. @cniehaus: Pls. contribute a test kit and a step by step instruction
The file from bug 102147 is the result (you see the wrong value there). The spreadsheet itself contains confidential data, I will try to reproduce with uncritical data. Or is the file already enough?
Created attachment 62451 [details] This is the "database" to reproduce the bug
Created attachment 62452 [details] the origin odt-file from which I produced the "result" file
Created attachment 62453 [details] This is the result with the bug
@rainerbielefeld I am able to reproduce this with the attached ods-file. Open a new odt-file, start the serial letter assitent (Serienbrief-Assistent). Of course the data doesn't make much sense, I simply pretended as if the adress would be the three fields in the ods-file (I took Bundesland, Stadt, Vorname, Name, Adresszeile 2). Then you can already see the issue in the preview. There you can read: 0.130.13 Bar Foo 0.13 which means that the percentvalues are already misformated (I hope that is an english word, I mean "falsch formatiert"). Then just click on "Continue" a couple of times and you will get a document with misformated fields. Are you able to reproduce this?
I don't think we have here a Writer problem but a Calc/database import problem. Import and register the ods as new database and all the values are 0,XX and not XX%. Having a deeper look at it, the % column in Calc only contents numbers *formatted* as % but the internal numbers are below 0 or near decimal. So I don't think it's even a defect but an INVALID. The internal values only can be imported. The formats are irrelevant. @MSC: Please have a look.
Yes, the problem is that the spreadsheet driver only read the values and not the format. This is a duplicate to a stoneold defect in the spreadsheet driver. *** This issue has been marked as a duplicate of 20680 ***
duplicate -> closed