Version: 1.6.2 (using KDE KDE 3.5.6) Installed from: Gentoo Packages Compiler: GCC 4.1.2 OS: Linux I think that KSpread has some massive misunderstanding of the difference between cell content (ie what you actually type into a cell and what is visible in the edit bar) and formatted display (ie what is visible in the spreadsheet). I'd like to present two examples. Example I --------- 1. enter the text (no quotes) "12-12-2007" into a cell. 2. save and close the document 3. open the document 4. select the cell Result: what you see in the edit field is (in my case it's in Polish) "środa 12 grudnia 2007". This is NOT what I've entered. The edit field should display verbatim what was entered. It does not. What if I needed to change "12-12-2007" to "11-12-2007"? I'd need to enter the whole thing again... 5. copy the cell's content, eg by ctrl+c 6. paste it into some text editor Result: the original value ("12-12-2007") is pasted. This is actually the expected behavior, but then why did KSpread display something completely different in the edit field? 7. in the edit field, edit the text and make a typo in month's name (eg "grudnia" -> "grdnia" in my case) 8. select the cell again Result: the cell contains the text "środa 12 grdnia 2007". The question is: how is it possible that removing a single character from the original value ("12-12-2007") produces "środa 12 grdnia 2007"? Example II ---------- 1. start with a blank spreadsheet 2. type "12" (no quotes) in cell A1 3. change A1 cell's format to "percent" 4. change A2 cell's format to "percent" 5. type "12" (no quotes) into cell A2 Result: for A1, the edit field displays it correctly ("12"); the cell itself displays "1 200 %", but this is another bug. For A2, both the edit field and the cell display "12 %", which is a) wrong (edit field should be "12"), b) inconsistent with cell A1 (where the edit field correctly contains the actual value "12"). 6. save and close the document 7. open the document 8. select cell A2 Result: the edit field now says "0,12 %". This is wrong. I'll supply a few more examples if needed. The expected behavior, in my opinion, would be to make the edit field always display verbatim what was entered (otherwise it might be impossible to edit your data!). All (if any) formatting rules should *only* affect what is finally displayed in the cell. I might be wrong with my judgement of this, but I find it a serious showstopper for KOffice. I'll be glad to help with resolving this issue.
In Example 1, saving and opening the document shows 12-12-07 to me (but im using EN_US, not polish) In Example 2, saving and opening the document shows 12%, not 0.12%.
I've tried to reproduce this bug with 1.6.3 @ KDE 3.5.10. The results were the same as in my original report. @Comment #1 Ananth: Example 1: you wrote "saving and opening the document shows 12-12-07", so you also have the bug (it should show 12-12-2007). You probably have different default date formatting in your locale ("%dd-%mm-%yy", as opposed to the textual formatting in Polish), that's all. Example 2: weird, the bug is still there for me. Note that it's incorrect only in the edit field (the formula bar, or whatever it's called) - the cell in the sheet itself displays "12 %" correctly, but the edit field says "0,12 %". I realize that 2.0 is on the way and probably nobody has time to look at 1.x bugs. When I get hold of 2.0, I'll update this bug report.
Example 1: I think it is a locale specific bug. not too sure. Example 2: It shows 12% in the edit field/tool options using v2.0 beta 4 (compiled from svn using kde 4.1.3) for me. So i guess this has been fixed in the later versions. :) Regards, Ananth
This seems to be about some very old version, is this still valid with Calligra Sheets 2.5?
Dear Bug Submitter, This bug has been in NEEDSINFO status with no change for at least 15 days. Please provide the requested information as soon as possible and set the bug status as REPORTED. Due to regular bug tracker maintenance, if the bug is still in NEEDSINFO status with no change in 30 days, the bug will be closed as RESOLVED > WORKSFORME due to lack of needed information. For more information about our bug triaging procedures please read the wiki located here: https://community.kde.org/Guidelines_and_HOWTOs/Bug_triaging If you have already provided the requested information, please set the bug status as REPORTED so that the KDE team knows that the bug is ready to be confirmed. Thank you for helping us make KDE software even better for everyone!
I've just installed Calligra Sheets 2.9.7 and tested it. The bug is partially fixed, but it's still behaving incorrectly, and in very weird ways. Example II from this bug report works fine now. Example I is still not correct. Let me describe it again as Example III: Example III ----------- 1. open a blank spreadsheet 2. enter the following into cells A1-A3: 12/12/2007 12-12-2007 12.12.2007 3. Change the format of those 3 cells to Date, with format string set to the long system date format (see screenshot #1) BUG #1: the system date format shown is an English one, although my system settings (also in KDE's System Settings) are set to pl-PL with a completely different date format than what Calligra shows. BUG #2: only cell A1 gets formatted as date ("Wednesday 12 of December 2007"), although it's A3 which follows my system short date format. 4. Save, close and reopen the spreadsheet BUG #3: all 3 cells have format changed to Date, with format string set to the *short* system date format (it was the *long* format before) 5. Cell A1 is corrupt: BUG #4: A1's display value is now actually formatted in Polish (presumably following my system settings of pl-PL) and shows "środa 12 grudnia2007", but: - it is missing a space before the year - it still doesn't follow either the short or long date format I have set in KDE's settings (see screenshot #2) BUG #5: A1's edit field contains the text "Wednesday 12 of December 2007" instead of "12/12/2007", so it's impossible to edit the original entered value 6. Change A1's format to the system *long* date format again 7. Save, close and reopen the spreadsheet 8. Select A1 BUG #6: both the edit field and display value show "środa 12 grudnia2007" now 9. Enter "1" (no quotes) into cell B1 10. Save, close and reopen the spreadsheet 11. Select A1 BUG #7: the cell displays "12/12/2007" and it's edit field shows "środa 12 grudnia2007" - it is *the opposite* of what it should be I'm sorry to say this, but after 11+ years, this is still unusable.
Created attachment 115236 [details] cell format options
Created attachment 115237 [details] system regional settings