At 13:33 07/02/2023 +1300, Steve Edmonds wrote:
I am observing what may be a bug in saving a formula in a cell where
additional spaces are repeatably inserted on editing the formula. If
someone could replicate this I will file a bug. Create a sheet with
cell contents as below.
A3 is =IF((F22=$B$21) AND (G22<>$B$21),10,20)
I'm not sure why you would want this in a cell, as it makes no sense.
Do you perhaps need
=IF(AND(F22=$B$21,G22<>$B$21),10,20)
instead?
I trust this helps.
Brian Barker
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy