[libreoffice-users] Possible formatting but in calc.

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)

You will notice one space before and after the AND;
Click into the cell and edit the formula changing =IF((F22... to 
=IF((F21.... and hit ENTER.
Click into the formula again, are there now 2 spaces before the and?

Every edit I get an additional space added before the AND.

If there is no space after the AND (=IF((F22=$B$21) 
AND(G22<>$B$21),10,20)) this does not occur.

Steve



--
To unsubscribe e-mail to: users+unsubscribe@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