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

2023-02-10 Thread ady
On Fri, Feb 10, 2023 at 1:47 PM Johnny Rosenberg wrote: > > should be reported as a bug. > I think it should. Then it's up to the developers to decide whether or not > to do something about it. Maybe it could be set to low priority, though. I agree. I already opened a new bug report for it. I

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

2023-02-10 Thread Brian Barker
At 17:45 10/02/2023 +0100, Johnny Rosenberg wrote: At 12:29 10/02/2023 -0300, Ady Noname wrote: While the correct / expected syntax of the AND() function is not what Steve used, the question is whether the "additional spacing" behavior should be reported as a bug. I think it should. Then

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

2023-02-10 Thread Johnny Rosenberg
Den fre 10 feb. 2023 kl 16:33 skrev ady : > > If there is at least one space character _after_ the AND function, > > then each edition of the formula adds one space character _before_ > > AND. > > > > After several editions, you end up with the same one space character > > after AND, but several

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

2023-02-10 Thread ady
> If there is at least one space character _after_ the AND function, > then each edition of the formula adds one space character _before_ > AND. > > After several editions, you end up with the same one space character > after AND, but several space characters before it. > > This behavior happens

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

2023-02-07 Thread Johnny Rosenberg
Den tis 7 feb. 2023 kl 20:42 skrev Steve Edmonds : > > > On 08/02/2023 05:45, Johnny Rosenberg wrote: > > 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

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

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

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

2023-02-07 Thread Johnny Rosenberg
Den tis 7 feb. 2023 kl 01:35 skrev Steve Edmonds : > 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

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

2023-02-07 Thread ady
If there is at least one space character _after_ the AND function, then each edition of the formula adds one space character _before_ AND. After several editions, you end up with the same one space character after AND, but several space characters before it. This behavior happens even when the

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

2023-02-06 Thread Brian Barker
At 13:33 07/02/2023 +1300, Steve Edmonds wrote: 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

[libreoffice-users] Possible formatting but in calc.

2023-02-06 Thread Steve Edmonds
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