Bug 121009 - Spreadsheet read in als ods file, exported as ksp file now has strange time in cells
Summary: Spreadsheet read in als ods file, exported as ksp file now has strange time i...
Status: CONFIRMED
Alias: None
Product: calligrasheets
Classification: Applications
Component: opendocument (show other bugs)
Version: 1.4.2
Platform: unspecified Linux
: NOR normal
Target Milestone: ---
Assignee: Calligra Sheets (KSpread) Bugs
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2006-01-29 22:38 UTC by Ernest ter Kuile
Modified: 2021-03-19 16:48 UTC (History)
1 user (show)

See Also:
Latest Commit:
Version Fixed In:


Attachments
original opendocument spreadsheet file (99.12 KB, application/vnd.oasis.opendocument.spreadsheet)
2006-01-29 22:42 UTC, Ernest ter Kuile
Details
resulting kspread file after saving in native file format (45.09 KB, application/x-kspread)
2006-01-29 22:45 UTC, Ernest ter Kuile
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Ernest ter Kuile 2006-01-29 22:38:52 UTC
Version:           1.4.2 (using KDE 3.5.0, Debian Package 4:3.5.0-3 (testing/unstable))
Compiler:          Target: x86_64-linux-gnu
OS:                Linux (x86_64) release 2.6.15.1

After converting an ods file make with openoffice

To see problem, read provided ods file with kspread, saving it as a native kspread file. Stopping and restarting kspread (just to clear all) and reloading just saved file.

in file now all the cells that contained a time only _seem_ to contain a time, however all calculations are 0 and when clicking on any cell with a time shows that they all contain the date 30/12/1899
Comment 1 Ernest ter Kuile 2006-01-29 22:42:57 UTC
Created attachment 14447 [details]
original opendocument spreadsheet file

This is the spreadsheet i used. it was produced with 32bit open office 2.0
Comment 2 Ernest ter Kuile 2006-01-29 22:45:37 UTC
Created attachment 14448 [details]
resulting kspread file after saving in native file format

here is the native file that was produced on my system from previous opendoc
file (just in case the bug doesn't show on other peoples system).
Comment 3 Elián Hanisch 2008-11-02 01:37:17 UTC
I couldn't really test this, kspread in trunk was awfully slow in opening and saving the file, and I had to kill the process as it was eating my ram.

bug this seems related to bug #173736
Comment 4 Jeremy Whiting 2010-10-05 17:43:59 UTC
I'm seeing the same thing here. I opened a ods file, and saved back as ods, and the time cells are all wrong when opening in openoffice.
Comment 5 Justin Zobel 2021-03-09 22:43:36 UTC
Thank you for the bug report.

As this report hasn't seen any changes in 5 years or more, we ask if you can please confirm that the issue still persists.

If this bug is no longer persisting or relevant please change the status to resolved.
Comment 6 Ernest ter Kuile 2021-03-19 16:48:43 UTC
This bug may have been resolved or not. I would not know. I have not been using KOffice since a long time. I suspect it is no longer relevant since there have been quite a few KDE releases since. 
As far as I am concerned the bug may be closed. 

Cheers,
Ernest. 

> On 9 Mar 2021, at 23:43, Justin Zobel <bugzilla_noreply@kde.org> wrote:
> 
> https://bugs.kde.org/show_bug.cgi?id=121009
> 
> --- Comment #5 from Justin Zobel <justin.zobel@gmail.com> ---
> Thank you for the bug report.
> 
> As this report hasn't seen any changes in 5 years or more, we ask if you can
> please confirm that the issue still persists.
> 
> If this bug is no longer persisting or relevant please change the status to
> resolved.
> 
> -- 
> You are receiving this mail because:
> You reported the bug.