Den tis 7 feb. 2023 kl 20:42 skrev Steve Edmonds <[email protected] >:
> > > On 08/02/2023 05:45, Johnny Rosenberg wrote: > > Den tis 7 feb. 2023 kl 01:35 skrev Steve Edmonds < > [email protected] > >> : > >> 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) > > > I was programming before spreadsheets existed and blindly used the same > simple construct as basic in the spreadsheet and that worked so kept > using it. > I was programming before I started to use spreadsheets, but I never tried that syntax in a spreadsheet. Probably because I was new to the idea and checked everything with the manual before using it. Kind regards Johnny Rosenberg > && didn't work but would be nice if it did. > Also what is nice is that (F22=$B$21) will evaluate to 0 or 1 when used > in an equation. (F22=$B$21)*5 is the equivalent of if(F22=$B$21,5,0) > Yes, that's neat. Kind regards Johnny Rosenberg > Steve > > 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: [email protected] > >> 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: [email protected] > 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: [email protected] 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
