---- Reported by lassi.ta.nieminen@nokia.com 2010-04-13 14:44:32 +0300 ---- Created an attachment testdata to be opened in kspread SOFTWARE VERSION: Kubuntu 9.10 Koffice (svn version 1113826) Test document (OpenOffice): oos_HowMuchMortgage.ods STEPS LEADING TO THE PROBLEM: 1. Open the attached document in OpenOffice. 2. Open the same document in KOffice. 3. Check the D column in second sheet of the document. EXPECTED OUTCOME: Kspread should display dollar symbol only once in each cell. oos_dollar_symbol_oocalc.png ACTUAL OUTCOME: Kspread displays dollar symbol twice in each cell. oos_dollar_symbol_kspread.png FREQUENCY: Always ---- Additional Comments From lassi.ta.nieminen@nokia.com 2010-04-13 14:45:19 +0300 ---- Created an attachment screenshot of the document in kspread ---- Additional Comments From lassi.ta.nieminen@nokia.com 2010-04-13 14:46:34 +0300 ---- Created an attachment screenshot of the document in oocalc --- Bug imported by faure@kde.org 2010-05-28 03:30 --- This bug was previously known as _bug_ 164084. Imported an attachment (id=47124) Imported an attachment (id=47125) Imported an attachment (id=47126) Unknown bug field "example" encountered while moving bug <example>2010-04-13 14:46:34</example>
*** Bug 240760 has been marked as a duplicate of this bug. ***
Created attachment 53648 [details] patch The line: e.text format + = (); generates a custom format, which is then used in KSpread: ValueFormatter:: formatText, formatString =($ 0.00) by adding the $ symbol. Tested and with doc and passed...
Created attachment 54355 [details] Snapshot showing the problem Hi Juan, great patch! After a bit of testing I don't think that it's correct or at least it's not complete. First if you load the document into KSpread vs OO.org and then look at the secon d sheet at the format of D4 then it's Generic in KSpread and Currency in OO.org. Second I am not sure if this isn't the wrong $ that got removed with the patch. In the edit-field the $-sign is visible (see attached screenshot) in KSpread but not in OO.org. You can just remove that sign there in KSpread now. There is a theird problem. If I select in KSpread those cell D4 from the second sheet and then in the menu select Format=>Cell Format and explicit select a Money-format and change the currency to e.g. "Dollar" and press ok, then the cell doesn't display a $-sign. If I do the same in OO.org then the Dollar-sign is displayed. It looks for me as there are multiple things that are wrong here and I am absolute unsure that the patch really does improve the situation. In any case I guess we need to fix at least the proper displaying. Displaying two $$ is as wrong as displaying no $.
Ok, patch incorrect, I give a second try later...
Dear Bug Submitter, This bug has been stagnant for a long time. Could you help us out and re-test if the bug is valid in the latest version? I am setting the status to NEEDSINFO pending your response, please change the Status back to REPORTED when you respond. Thank you for helping us make KDE software even better for everyone!
Dear Bug Submitter, This is a reminder that this bug has been stagnant for a long time. Could you help us out and re-test if the bug is valid in the latest version? This bug will be moved back to REPORTED Status for manual review later, which may take a while. If you are able to, please lend us a hand. Thank you for helping us make KDE software even better for everyone!
Thank you for reporting this issue in KDE software. As it has been a while since this issue was reported, can we please ask you to see if you can reproduce the issue with a recent software version? If you can reproduce the issue, please change the status to "REPORTED" when replying. Thank you!