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