[Libreoffice-bugs] [Bug 54651] PIVOTTABLE time-format gone
https://bugs.freedesktop.org/show_bug.cgi?id=54651 Kohei Yoshida changed: What|Removed |Added Status|NEW |ASSIGNED Assignee|libreoffice-b...@lists.free |kohei.yosh...@suse.de |desktop.org | --- Comment #12 from Kohei Yoshida --- The difficulty is how to determine the "representative" number format for a column when the column contains a mixture of number formats. Counting solves it of course, but that would affect performance a bit if done incorrectly. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 54651] PIVOTTABLE time-format gone
https://bugs.freedesktop.org/show_bug.cgi?id=54651 --- Comment #11 from Kohei Yoshida --- (In reply to comment #10) > Created attachment 74353 [details] > formatting of the pivot table is determined by the last row content > > removing start/end from last row thus causing IF function to output blank > (i.e. double quote - "") causes pivot table to assume that the whole column > is text forcing different formatting Very good observation. This narrows it down significantly. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 54651] PIVOTTABLE time-format gone
https://bugs.freedesktop.org/show_bug.cgi?id=54651 --- Comment #10 from ktos.obcy+freedesk...@gazeta.pl --- Created attachment 74353 --> https://bugs.freedesktop.org/attachment.cgi?id=74353&action=edit formatting of the pivot table is determined by the last row content removing start/end from last row thus causing IF function to output blank (i.e. double quote - "") causes pivot table to assume that the whole column is text forcing different formatting -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 54651] PIVOTTABLE time-format gone
https://bugs.freedesktop.org/show_bug.cgi?id=54651 --- Comment #9 from ktos.obcy+freedesk...@gazeta.pl --- OK, mea culpa. As expected same is happening in 4.0.0 final. I've been playing with it for a bit and it seems that the issue is related to the output of the function being /empty/ - i.e. double quotes (to have blank field - it seems that then Cals ignores source formatting and assumes the input/output to be plain numeric/text determining pivot table formatting) and also from the fact that (as it seems) formatting of the whole pivot table is taken from last row of the input table selection. I'm going to attach simple testcase sheet. In that testcase if you remove start/end time from last row and refresh pivot table then the issue manifest itself. for the moment I've "fixed" my initial sheet by replacing conditional function: =IF(F278-E278>0;F278-E278;"") with simple /0/ (also, using =IF(F278-E278>0;F278-E278;0) would work) as then times are displayed on in whole pivot table. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 54651] PIVOTTABLE time-format gone
https://bugs.freedesktop.org/show_bug.cgi?id=54651 Joel Madero changed: What|Removed |Added QA Contact||jmadero@gmail.com -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 54651] PIVOTTABLE time-format gone
https://bugs.freedesktop.org/show_bug.cgi?id=54651 Joel Madero changed: What|Removed |Added Version|4.0.0.2 rc |3.6.1.2 release --- Comment #8 from Joel Madero --- Version is the oldest version that we can confirm the problem, not the latest it's been tested on. We use comments to say "we tested it on X.X.X.X and it's still present -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 54651] PIVOTTABLE time-format gone
https://bugs.freedesktop.org/show_bug.cgi?id=54651 ktos.obcy+freedesk...@gazeta.pl changed: What|Removed |Added Version|3.6.1.2 release |4.0.0.2 rc --- Comment #7 from ktos.obcy+freedesk...@gazeta.pl --- Just tested with the latest 4.0RC2 and the bug is still present. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 54651] PIVOTTABLE time-format gone
https://bugs.freedesktop.org/show_bug.cgi?id=54651 Kohei Yoshida changed: What|Removed |Added Summary|FORMATTING Pivot Table |PIVOTTABLE time-format gone |time-format gone| --- Comment #6 from Kohei Yoshida --- PIVOTTABLE has its own BSA keyword. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs