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 <ny...@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+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