Re: [libreoffice-users] Possible formatting but in calc.
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 linked also to this email thread, but I have not set it to new nor to low priority; I'll leave that for devs. -- 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
Re: [libreoffice-users] Possible formatting but in calc.
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 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. But hold on! Anything starting with an equals sign is regarded as a formula. And formulae are *always* edited by a spreadsheet program after entry. In particular, names of functions such as IF() and AND() can be entered in lower case - if() and and() - but these are edited to upper case by the program. Trailing spaces seem always to be trimmed. And =TRUE is edited to =1 - even though the result may be displayed as TRUE if the cell format requires this. If I enter =002+003, the formula is edited to =2+3. If what is entered is pretending to be a formula but is actually nonsense, is it so surprising or worrying that the edited result is equal (but slightly different) nonsense, also masquerading as a formula? Brian Barker -- 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
Re: [libreoffice-users] Possible formatting but in calc.
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 space characters before it. > > > > This behavior happens even when the first comparison does not exist: > > > > =IF(AND ( > > > > To be clear, it is enough to have one space character after AND in > > order to trigger the additional space characters before it, each time > > the formula is edited. You do not need an initial space character > > before AND for this to happen. > > > > Without the space character after AND, the behavior is not replicated. > > 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 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. Kind regards Johnny Rosenberg > > -- > 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
Re: [libreoffice-users] Possible formatting but in calc.
> 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 first comparison does not exist: > > =IF(AND ( > > To be clear, it is enough to have one space character after AND in > order to trigger the additional space characters before it, each time > the formula is edited. You do not need an initial space character > before AND for this to happen. > > Without the space character after AND, the behavior is not replicated. 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. -- 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
Re: [libreoffice-users] Possible formatting but in calc.
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 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+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 > -- 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
Re: [libreoffice-users] Possible formatting but in calc.
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 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. && 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) 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+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
Re: [libreoffice-users] Possible formatting but in calc.
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 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
Re: [libreoffice-users] Possible formatting but in calc.
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 first comparison does not exist: =IF(AND ( To be clear, it is enough to have one space character after AND in order to trigger the additional space characters before it, each time the formula is edited. You do not need an initial space character before AND for this to happen. Without the space character after AND, the behavior is not replicated. -- 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
Re: [libreoffice-users] Possible formatting but in calc.
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 =IF((F22=$B$21) AND (G22<>$B$21),10,20) I'm not sure why you would want this in a cell, as it makes no sense. Do you perhaps need =IF(AND(F22=$B$21,G22<>$B$21),10,20) instead? I trust this helps. Brian Barker -- 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
[libreoffice-users] Possible formatting but in calc.
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 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
