https://bugs.documentfoundation.org/show_bug.cgi?id=160893
Thorsten Behrens (allotropia) changed:
What|Removed |Added
CC|
https://bugs.documentfoundation.org/show_bug.cgi?id=160893
--- Comment #9 from m_a_riosv ---
Maybe some relation with
tdf#144740 Criteria query (COUNTIF(), MATCH() et al) for numeric values broken
considering number formats
tdf#144253 Filtering does not work with formatted calculated values
--
https://bugs.documentfoundation.org/show_bug.cgi?id=160893
--- Comment #8 from ady ---
@Balázs
Considering that the problem affects XLOOKUP() (at least), are you planning on
assigning this to yourself?
If I may suggest, let's see what happens when solving this for XLOOKUP(), and
then we can
https://bugs.documentfoundation.org/show_bug.cgi?id=160893
Gabor Kelemen (allotropia) changed:
What|Removed |Added
CC||kelem...@ubuntu.com
https://bugs.documentfoundation.org/show_bug.cgi?id=160893
--- Comment #3 from ady ---
@Balázs
Polite ping.
XLOOKUP: Internal cell value vs display value (comment 2).
I cannot test with Excel by myself ATM.
@All,
This report is still set as UNCONFIRMED. Is this a bug, or not? We should
https://bugs.documentfoundation.org/show_bug.cgi?id=160893
Roman Kuznetsov <79045_79...@mail.ru> changed:
What|Removed |Added
See Also|
https://bugs.documentfoundation.org/show_bug.cgi?id=160893
--- Comment #2 from ady ---
(In reply to Regina Henschel from comment #0)
> Problem:
> (1) If the Lookup_value is a text that looks like a date, it is interpreted
> as number.
> (2) If the Lookup_array contains dates, neither a
https://bugs.documentfoundation.org/show_bug.cgi?id=160893
m_a_riosv changed:
What|Removed |Added
CC||miguelangelrv@libreoffice.o