[Libreoffice-bugs] [Bug 104174] Loss of formatting on Pivot Tables after refreshing data

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=104174

ssackett at adaxa.com changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 OS|All                         |Linux (All)
           Hardware|All                         |x86-64 (AMD64)

--- Comment #5 from ssackett at adaxa.com ---
tested in 6.2.5.2
create spreadsheet with a date column
create pivot table with date in left column... displays as 2 char year
format the date column in pivot to 4 char year
refresh pivot data - date display is reset to 2 char year. 

I note this comment from earlier:
"Setting as:
Minor: I understand this is a real PITA (it affects me too) but it doesn't
*prevent* high quality work, just slows it down in an annoying way
Low: Default for minor bugs"

May seem minor to some but it is a major issue to this user (pivot table user
since excel 95). Similar formatting issues arise when pulling data from
postgres. ... refresh data from postgres, remember to change the data format
for $ columns, refresh the pivot table(s), reapply all the formatting that was
lost in the refresh... then make one small change in underlying financial data
and then repeat all these steps again..

I appreciate all the efforts of the Libreoffice devs but I really hope some one
who is capable of fixing this feels it needs fixing.

thanks..

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200109/6fa0b928/attachment-0001.htm>