| Summary: | kspread:openoffice: Dollar symbol displayed twice in the cell | ||
|---|---|---|---|
| Product: | [Applications] calligrasheets | Reporter: | Lassi Nieminen <lassi.ta.nieminen> |
| Component: | opendocument | Assignee: | Calligra Sheets (KSpread) Bugs <calligra-sheets-bugs-null> |
| Status: | CONFIRMED --- | ||
| Severity: | normal | CC: | j.r.hudson, mecirt, utcl95 |
| Priority: | NOR | ||
| Version First Reported In: | unspecified | ||
| Target Milestone: | --- | ||
| Platform: | unspecified | ||
| OS: | All | ||
| Latest Commit: | Version Fixed/Implemented In: | ||
| Sentry Crash Report: | |||
| Attachments: |
testdata to be opened in kspread
screenshot of the document in kspread screenshot of the document in oocalc patch Snapshot showing the problem |
||
|
Description
David Faure
2010-05-28 03:30:46 UTC
*** 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! |