Den tis 7 feb. 2023 kl 01:35 skrev Steve Edmonds <steve.edmo...@ptglobal.com >:
> 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 didn't even know you can use AND like that. I always write like: =IF(AND(F22=$B$21;G22<>$B$21);10;20) Kind regards Johnny Rosenberg > > 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+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 > -- 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