Re: [libreoffice-users] Possible formatting but in calc.

Den tis 7 feb. 2023 kl 20:42 skrev Steve Edmonds <steve.edmonds@ptglobal.com
> :

> On 08/02/2023 05:45, Johnny Rosenberg wrote:
> > Den tis 7 feb. 2023 kl 01:35 skrev Steve Edmonds <
> steve.edmonds@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)
> 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: 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
>
>
> --
> 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

-- 
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