https://bugs.documentfoundation.org/show_bug.cgi?id=35247
Eike Rathke <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |ASSIGNED
Hardware|Other |All
Assignee|[email protected] |[email protected]
|desktop.org |
OS|Windows (All) |All
--- Comment #7 from Eike Rathke <[email protected]> ---
GETPIVOTDATA() uses a text string based interface to obtain matching member
results. This depends on the formatted data (actually the same result entries
that can be seen in the filter lists). This is matched against the [26.01.2010]
text query, for example. To make matters worse, date formatting depends on the
locale, so if not formatted to a specific locale that is also used in the
query, these queries will not work in another locale that uses different
separators or DMY order. For example in en-US all four queries deliver #REF!
Workaround: to be on the safe side format dates in ISO 8601 notation, i.e.
using YYYY-MM-DD format code on date data and also in the query, those deliver
equal results in all locales.
This will need some deep digging and changing things to provide also internal
type information and actual values instead of just formatted display strings.
I'm wrapping my head around this..
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
