Re: [libreoffice-users] Cannot make formula work

On 2025/04/16 15:04, tim lloyd wrote:
> Could you try and copy/paste the formulas into other cells and see what happens. See if the error 
> is replicated. Or if it just disappears which would be fun.
>
> I think you will have to ensure the cell numbers are consistent as they may change during the paste.
>
> On Wednesday, April 16th, 2025 at 3:42 PM, Thomas Blasejewicz <nyuwa@hb.tp1.jp> wrote:

THIS seems to give a clue.
I copied the function (working and not working) from column H to column B.
The working copy to B came up after adjusting the range with the 
expected value.
The NOT working copy showed the exact same function as the original one =
it still had the range defined for column H.
The working copy had automatically adjusted to column B.

HERE must be something at work, that is not supposed to happen.

Thomas


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