Re: [libreoffice-users] Strange issue with NOW() that i have not encountered before

I am expecting that NOW() will update every time any cell recalculates.
I do not know how recalculation is controlled.

I have come across this before and ended up referencing a fixed time in
cell (pasted from NOW())
steve

On 31/10/2019 09:02, pete wrote:
> Hi Folks
>
> I am having an issue with NOW()   .
>
> I am using    =IF(ISBLANK(A3),"", IF( ISNUMBER(B3), B3, NOW() ) )  
> I have copied this by dragging the corner of the cell to 100 other cells the
> problem is  when i enter data into a cell in coloum 3 the time changes in every
> cell in coloum 3 and it should not it does not in another sheet that is using
> exactly the same formula .
>
> What am i doing wrong  ..
>
> Thanks Pete .



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