Bug 247709 - kspreadsheet:msoffice2007: date formatting is not retained in Kspread
Summary: kspreadsheet:msoffice2007: date formatting is not retained in Kspread
Status: RESOLVED WORKSFORME
Alias: None
Product: calligracommon
Classification: Applications
Component: filters (other bugs)
Version First Reported In: Git
Platform: Unlisted Binaries All
: NOR normal
Target Milestone: ---
Assignee: Calligra Bugs
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2009-10-29 08:15 UTC by Lassi Nieminen
Modified: 2023-01-20 05:08 UTC (History)
0 users

See Also:
Latest Commit:
Version Fixed/Implemented In:
Sentry Crash Report:


Attachments
Screen shot when viewed in Kspread (185.15 KB, image/pjpeg)
2009-10-29 08:15 UTC, Lassi Nieminen
Details
Test data created in MS excel 2007 (8.47 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2009-10-29 08:16 UTC, Lassi Nieminen
Details
Screen shot when viewed in kspread-1076388 (179.16 KB, image/pjpeg)
2010-01-22 05:23 UTC, Lassi Nieminen
Details
Screen shot when viewed in msoffice 2007 (117.74 KB, image/pjpeg)
2010-01-22 05:25 UTC, Lassi Nieminen
Details
pyodconverter converted testdata (7.51 KB, application/x-zip-compressed)
2010-03-04 08:09 UTC, Lassi Nieminen
Details
koconverter converted testdata (169 bytes, application/x-zip-compressed)
2010-03-04 08:13 UTC, Lassi Nieminen
Details
koconverter converted testdata opened in openoffice (87.51 KB, image/x-png)
2010-03-04 08:19 UTC, Lassi Nieminen
Details
pyodconverter converted testdata opened in koffice (93.66 KB, image/x-png)
2010-03-04 08:20 UTC, Lassi Nieminen
Details

Note You need to log in before you can comment on or make changes to this bug.
Description David Faure 2010-08-13 20:36:54 UTC


---- Reported by lassi.ta.nieminen@nokia.com 2009-10-29 09:15:43 +0200 ----

Created an attachment
Screen shot when viewed in Kspread

SOFTWARE VERSION:
  Kubuntu 9.04
  Koffice (svn version 1037805)
  Test document (MS excel 2007): me07_date_formatting.xlsx

STEPS LEADING TO PROBLEM: 
  1. Open the attached document in MS excel 2007.
  2. Open the same document in Kspread.
  3. Observe that date formatting is not retained.

EXPECTED OUTCOME:
Date should be displayed in the cells with date formattiing
ACTUAL OUTCOME:
Cells with date formatting are not displayed properly
FREQUENCY OF OCCURRENCE: 
always



---- Additional Comments From lassi.ta.nieminen@nokia.com 2009-10-29 09:16:20 +0200 ----

Created an attachment
Test data created in MS excel 2007



---- Additional Comments From lassi.ta.nieminen@nokia.com 2010-01-18 22:54:08 +0200 ----

1074249



---- Additional Comments From lassi.ta.nieminen@nokia.com 2010-01-22 06:21:37 +0200 ----

Retested in koffice version 1076388.

Only date format MM/DD/YYYY is displayed correctly. All the remaining formats are displayed with numbers.

Please find the attachment.



---- Additional Comments From lassi.ta.nieminen@nokia.com 2010-01-22 06:23:06 +0200 ----

Created an attachment
Screen shot when viewed in kspread-1076388



---- Additional Comments From lassi.ta.nieminen@nokia.com 2010-01-22 06:25:12 +0200 ----

Created an attachment
Screen shot when viewed in msoffice 2007



---- Additional Comments From lassi.ta.nieminen@nokia.com 2010-03-04 09:09:37 +0200 ----

Created an attachment
pyodconverter converted testdata



---- Additional Comments From lassi.ta.nieminen@nokia.com 2010-03-04 09:13:16 +0200 ----

Created an attachment
koconverter converted testdata



---- Additional Comments From lassi.ta.nieminen@nokia.com 2010-03-04 09:19:20 +0200 ----

Created an attachment
koconverter converted testdata opened in openoffice



---- Additional Comments From lassi.ta.nieminen@nokia.com 2010-03-04 09:20:19 +0200 ----

Created an attachment
pyodconverter converted testdata opened in koffice

Observation (1096327) : File got corrupted when converted using koconverter and when loaded in open office error message is displayed.

KOffice loaded the OOo-converted document properly, but the data displayed is incorrect.



--- Bug imported by faure@kde.org 2010-08-13 20:36  ---

This bug was previously known as _bug_ 144666.

Imported an attachment (id=50262)
Imported an attachment (id=50263)
Imported an attachment (id=50264)
Imported an attachment (id=50265)
Imported an attachment (id=50266)
Imported an attachment (id=50267)
Imported an attachment (id=50268)
Imported an attachment (id=50269)

Bug Status was REOPENED but everconfirmed was false
   Setting status to UNCONFIRMED

Comment 1 Andrew Crouthamel 2018-11-09 01:01:14 UTC
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!
Comment 2 Andrew Crouthamel 2018-11-18 03:31:30 UTC
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!
Comment 3 Justin Zobel 2022-12-21 23:58:29 UTC
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!
Comment 4 Bug Janitor Service 2023-01-05 05:25:05 UTC
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
mark the bug 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!
Comment 5 Bug Janitor Service 2023-01-20 05:08:27 UTC
This bug has been in NEEDSINFO status with no change for at least
30 days. The bug is now 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

Thank you for helping us make KDE software even better for everyone!