https://bugs.freedesktop.org/show_bug.cgi?id=58036
--- Comment #2 from mariosv <[email protected]> --- Hi Joel, the workaround is there, but: - No where you can know about this limitation, so I have spent much time to know how to do it. If it is no possible to solve for 4.x release, maybe we need to mention on the help of the function. - Breaks the share between different languages, because you need to use the TEXT(date;format) function with dates, and the second parameter of the function is not updated as the number cell format, when one use other local settings. Or combine several function to get the text. - The GETPIVOTDATA() function, is very powerful, even of course need understand how it works, but if you can not make it works without know or understand why, less people are going to get the benefit of use it. - And will be more easy, when IFERROR() function can be applied. - For me the more important is that I can organize the data without worried about the Pivot table format, and using cell references inside the function to set the field and the conditions. - But I fear that the problem is not with the function but with the way how the data are in the Pivot table, so not easy to solve. - Or it was developed to work so. Then not a bug and the workaround is the right way. Who knows? - As I can see in ML Ask Forums, many people use calc as a little database or to retrieve data from a database, and Pivot table with a couple of enhancements would be one of the more important tools in calc. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
