Issue 125941 - In Pivot Table time format not retained on refresh if over 24 hours
Summary: In Pivot Table time format not retained on refresh if over 24 hours
Status: UNCONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: 4.1.1
Hardware: PC Windows Vista
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2014-12-12 19:24 UTC by Mervyn Beach
Modified: 2017-05-20 11:55 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Screen print of correct format (605.94 KB, application/vnd.oasis.opendocument.text)
2014-12-12 19:24 UTC, Mervyn Beach 		no flags Details
Time recording and summary spreadsheet (117.94 KB, application/vnd.oasis.opendocument.spreadsheet)
2014-12-24 12:33 UTC, Mervyn Beach 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description Mervyn Beach 2014-12-12 19:24:15 UTC 
Created attachment 84291 [details]
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.
Comment 1 oooforum (fr) 2014-12-15 08:27:17 UTC 
Well, why did you provide a screenshot embedded in an ODT instead of your real spreadsheet? Understand that this is not easy to reproduce.
Thanks to save time for developper team and attach an ODS file.
Comment 2 Mervyn Beach 2014-12-24 12:33:23 UTC 
Created attachment 84313 [details]
Time recording and summary spreadsheet
Comment 3 Mervyn Beach 2014-12-24 12:35:38 UTC 
The attachment is the working spreadsheet and the pivot table which produces the error on refresh.

Does this help to recreate the problem?
Comment 4 oooforum (fr) 2014-12-29 09:47:30 UTC 
(In reply to Mervyn Beach from comment #3)
> Does this help to recreate the problem?
No, provide a step-by-step procedure to reproduce (the simpler will be the better).
Comment 5 Mervyn Beach 2014-12-29 11:59:54 UTC 
(In reply to oooforum from comment #4)
> (In reply to Mervyn Beach from comment #3)
> > Does this help to recreate the problem?
> No, provide a step-by-step procedure to reproduce (the simpler will be the
> better).

Well you put the cursor somewhere in the pivot table, right click and choose refresh.

When you do that the total time in cell P14 will not show the total hours if they exceed 24.  

Navigate to cell p14 and choose Format-Cells.  It will be set to time but at the top of the list 13:37 which is wrong.  Change this and select 876613:37.  Press OK and the correct format is then used to show the total hours.

However as soon as you refresh the pivot table again, the format setting again will be lost and will revert to 13:37.  WHY?

This reversion to the basic time setting where any of the total fields in the pivot table exceed 24 hours.  Or, in other words the pivot table cannot cope with time exceeding 24 hours anywhere whether in the totals or any field.  It does not recognize any time format other than HH:MM