Re: ***SPAM*** Re: [libreoffice-users] Macros in spreadsheets

That happens to me with some list emails, easiest solution is to add a 
rule to prevent classing as spam.
Steve

On 5/01/23 5:36 am, Tim-L wrote:
> Your mail list emails are now being marked as spam.  Why, I cannot 
> find out.
>
>
>
> On 1/3/23 14:51, 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