OK, found the sheet.
Had to copy it from the machine I used the sheet on last month as can't
access physically the machine ATM.
The sheet was working fine on that machine but produces the symptoms you
mention on this laptop. I will see if I can find the cause.
Steve
On 4/01/23 8:51 am, Steve Edmonds wrote:
I understand what you are seeing, I had the same issue with a macro
for a function, I called it money() for rounding financial tax
calculations appropriately. At some point when I updated LO it just
stopped calculating displaying as you describe and I had to go through
the same rigmarole you are experiencing for it to recalculate.
Not sure if I resolved the issue or gave up, I will need to dig the
sheet out.
Steve
On 3/01/23 11:13 am, Michael Tiernan wrote:
On 12/23/22 11:02 AM, Andrew Pitonyak wrote:
If you are looking to cause functions to recalculate,
Thanks for the reply.
Here's the thing. It's not that I want to force a recalculate, it's
that I have to in order to get the macros to respond.
Here's an example: (What I expect when the spreadsheet finishes
opening.)
/*Cell*//*
*/ /*Contents*//*
*/ /*Display*//*
*/
D1
192.168.17.231/24
192.168.17.231/24
D2
=ipwithoutmask(D1)
192.168.17.231
D3
=ipmask(D1)
255.255.255.0
D4
=ipmasklken(D3)
24
Now, when I actually do open the spreadsheet, it says:
/*Cell*//*
*/ /*Contents*//*
*/ /*Display*//*
*/
D1
192.168.17.231/24
192.168.17.231/24
D2
=ipwithoutmask(D1)
#NAME?
D3
=ipmask(D1)
#NAME?
D4
=ipmasklken(D3)
#NAME?
So, if I say it differently, it *seems* like the Macros aren't run
when the spreadsheet is opened.
The macro library has a "Main" entry that is empty. If I choose
"Tools" -> "Macros" -> "Run macro" and then select "Main" and execute
it, there's no visible change.
BUT, if I go into the contents of "D2" and add a space at the end of
the formula "=ipwithoutmask(D1)" to read "=ipwithoutmask(D1) " and
hit return and the macro executes and displays the proper value.
HOWEVER, none of the other cells change so I have to go into each one
and do the same sort of thing, add a space at the end of the line or
between the macro and the parenthesis, each time, hit return and it
works properly.
This is obviously not the correct way it should work.
Hence my query about "starting" macros when the document is opened.
So, that leads to, am *I* doing something wrong?
Thanks for everyone's time.
--
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