Bug 331967

Summary:	Cell time format (time duration) is lost/shows wrong values after saving file (ods)
Product:	[Applications] calligrasheets	Reporter:	Oliver Goethel <mail>
Component:	functions	Assignee:	Calligra Sheets (KSpread) Bugs <calligra-sheets-bugs-null>
Status:	CONFIRMED ---
Severity:	normal	CC:	mail, mecirt
Priority:	NOR
Version First Reported In:	2.8.0
Target Milestone:	---
Platform:	Arch Linux
OS:	Linux
Latest Commit:		Version Fixed/Implemented In:
Sentry Crash Report:

Description Oliver Goethel 2014-03-10 14:14:03 UTC

Setting the time duration format ( 57960445:24(=[hh]:mm)) in a cell and closing and reopening the file, the cell shows a value with 24h time format although the format is set to time duration.
The preview in right click -> cell format shows the correct value.

Reproducible: Always

Steps to Reproduce:
1. set cell format 57960445:24(=[hh]:mm)
2. input values (e.g. 45:00, 45:00 and SUM(...) -> result 90:00)
3. sum up values (=SUM(...))
4. save as .ods
5. close and reload
6. values are wrong
Actual Results:  
cell values are
21:00 (45:00 - 24:00)
21:00
18:00 (90:00 - 3 * 24:00)

Expected Results:  
cell values should have been the same as before saving
45:00
45:00
90:00

Comment 1 Andrew Crouthamel 2018-11-11 04:22:36 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 Oliver Goethel 2018-11-12 22:47:25 UTC

This bug is still valid (calligra sheets 3.1.0)

Comment 3 Andrew Crouthamel 2018-11-21 04:26:51 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 4 Justin Zobel 2023-01-04 07:05:16 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 5 Oliver Goethel 2023-01-04 11:13:15 UTC

(In reply to Justin Zobel from comment #4)
> 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?

The issue still persists (Calligra sheets 3.2.1, KDE 5.101.0, QT 5.15.7)