LibreOffice and OpenOffice…
Create new Table:
B1 = 100
B2 = 2
B3 = -3
C2 = 5
C3 = 0
D1=( =(B1/C1) )
D2=( =(B2/C2) )
D3=( =(B3/C3) )
For column D create Filter with:
Column D < 5
AND YOUR WILL BE SEE 2 ROW !!!
ROW 2 and ROW 3 (with dived 0) !!!
In the MS Excel this is work ok… without this error…
Any body know - How repaire this and how told for developers ?
OK, this does indeed show 2 rows, including that with the error reference “division by 0”.
If you consider this to be a bug, you should report it to the LO developpers:
BugReport - The Document Foundation Wiki