Re: [libreoffice-users] Macros in spreadsheets

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