https://bugs.documentfoundation.org/show_bug.cgi?id=171994
Bug ID: 171994
Summary: FILTER( <matrix>; <include> ;{#N/D}) : #N/D is
automatically inserted and causes ERR539
Product: LibreOffice
Version: unspecified
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Hi
My version is 6.22 French.
When I create a formula with FILTER(<matrix>;<include>;{}), it works fine. When
I look the formula later, I see than it has been changed to
FILTER(<matrix>;<include>;{#N/D}). If I save and reload the worksheet, the
result is then ERR539 in the hole matrix result.
If I clear the #N/D in the formula, the error is released and I get the correct
resulting matrix.
To get rid, I will create a macro that will do a search/replace to get the term
away.
Thank you for the reading, and sorry for the bad English.
--
You are receiving this mail because:
You are the assignee for the bug.
