You are viewing a plain text version of this content. The canonical link for it is here.

Posted to users@openoffice.apache.org by Michael Shaver <mo...@msn.com> on 2021/04/30 01:33:55 UTC

Bug

Set a row100 columnA to 1
Set a row 101 columnA to 0.00000001
Set row 99 to =A100-$A$101

Pull A99 upwards to A0
Display the results at 20 decimals
Format the numbers to 20 decimals

At and above A89 the result is invalid.
This can be corrected by changing A100 to =TRUNC(A100-$A$101; 20)

Thank you for your attention
PS I tried but could not use Bugzilla.  morbas49@msn.com<ma...@msn.com>