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