https://issues.apache.org/ooo/show_bug.cgi?id=125941
Issue ID: 125941
Issue Type: DEFECT
Summary: In Pivot Table time format not retained on refresh if
over 24 hours
Product: Calc
Version: 4.1.1
Hardware: PC
OS: Windows Vista
Status: UNCONFIRMED
Severity: critical
Priority: P3
Component: formatting
Assignee: [email protected]
Reporter: [email protected]
Created attachment 84291
--> https://issues.apache.org/ooo/attachment.cgi?id=84291&action=edit
Screen print of correct format
The spreadsheet is used to record time in form HH:MM
The format for the total result field should be [HH]:MM;"("[HH]:MM")"
Once the total field exceeds 24 hours this cell reverts to format HH:MM on
refresh of the pivot table. Requiring the cell format to be reset each time.
The cell data is correct for use elsewhere in the spreadsheet therefore this a
presentation issue only, but very annoying.
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.
