2023 Archives by date, by thread · List index

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

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/

```
```

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

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