Names in FireworkzPro

[Harriet Bazley]

I was trying to port a PipeDream sheet to FireworkzPro and came across a
very insidious problem: it is possible to have a user-defined name in
PipeDream which coincides with one of the new built-in functions in
Fireworkz. Which means that all formulae containing that name/cell
reference simply fail silently to work in the imported sheet, because
Fireworkz now sees the references as functions with bad parameters...

(What seems to me to be a bug is that both PipeDream and Fireworks will
in fact quite happily allow you to attempt to *define* names which clash
with existing functions, e.g. 'index', without this throwing up an error
of any sort at the point of creation. They even appear in the menu of
names which can be inserted into formulae. They just get interpreted as
plain text strings instead of as the defined range or value that shows
up whenever you inspect or edit them!)

[Chris Hughes]

Post by Harriet Bazley
I was trying to port a PipeDream sheet to FireworkzPro and came across a
very insidious problem: it is possible to have a user-defined name in
PipeDream which coincides with one of the new built-in functions in
Fireworkz. Which means that all formulae containing that name/cell
reference simply fail silently to work in the imported sheet, because
Fireworkz now sees the references as functions with bad parameters...
(What seems to me to be a bug is that both PipeDream and Fireworks will
in fact quite happily allow you to attempt to *define* names which clash
with existing functions, e.g. 'index', without this throwing up an error
of any sort at the point of creation. They even appear in the menu of
names which can be inserted into formulae. They just get interpreted as
plain text strings instead of as the defined range or value that shows
up whenever you inspect or edit them!)

I can't really answer your question, but if you posted this on the
Fireworkz mailing list, which Stuart Swales the programmer reads you are
more likely to get a better answer.

[Harriet Bazley]

On 29 Jun 2022 as I do recall,

Post by Chris Hughes
I can't really answer your question, but if you posted this on the
Fireworkz mailing list, which Stuart Swales the programmer reads you are
more likely to get a better answer.

I did try this in the past, and it failed - apparently it's still
failing. :-(

Post by Chris Hughes
We're writing to let you know that the group you tried to contact
(colton-software-fireworkz) may not exist, or you may not have
permission to post messages to the group. A few more details on why
* You might have spelled or formatted the group name incorrectly.
* The owner of the group may have removed this group.
* You may need to join the group before receiving permission to post.
* This group may not be open to posting.

Followed by

Post by Chris Hughes
----- The following addresses had permanent fatal errors -----
(reason: 550-5.1.1 The email account that you tried to reach does not exist. Please try)
----- Transcript of session follows -----

DATA

<<< 550-5.1.1 The email account that you tried to reach does not exist. Please try
<<< 550-5.1.1 double-checking the recipient's email address for typos or
<<< 550-5.1.1 unnecessary spaces. Learn more at
<<< 550 5.1.1 https://support.google.com/mail/?p=NoSuchUser ay11-20020a05600c1e0b00b0039c4133ae38si196776wmb.2 - gsmtp
<<< 503 5.5.1 RCPT first. ay11-20020a05600c1e0b00b0039c4133ae38si196776wmb.2 - gsmtp

[Stuart]

Post by Harriet Bazley

Post by Chris Hughes
I can't really answer your question, but if you posted this on the
Fireworkz mailing list, which Stuart Swales the programmer reads you
are more likely to get a better answer.

I did try this in the past, and it failed - apparently it's still
failing. :-(

I am still getting Emails from coltonsoft-fireworkz so it still exists.
The last one was 30th May.

[Chris Hughes]

Post by Harriet Bazley
On 29 Jun 2022 as I do recall,

Post by Chris Hughes
I can't really answer your question, but if you posted this on the
Fireworkz mailing list, which Stuart Swales the programmer reads you are
more likely to get a better answer.

I did try this in the past, and it failed - apparently it's still
failing. :-(

Might be because you appear to have not used the correct subscribe
address.

The correct address is:

colton-software-fireworkz+***@googlegroups.com

Note the the Plus symbol between fireworkz and subscribe, where as below
you used a minus symbol instead.


[snip]

Post by Harriet Bazley
Followed by

Post by Chris Hughes
----- The following addresses had permanent fatal errors -----
(reason: 550-5.1.1 The email account that you tried to reach does not
exist. Please try)
----- Transcript of session follows -----

DATA

<<< 550-5.1.1 The email account that you tried to reach does not exist. Please try
<<< 550-5.1.1 double-checking the recipient's email address for typos or
<<< 550-5.1.1 unnecessary spaces. Learn more at
<<< 550 5.1.1 https://support.google.com/mail/?p=NoSuchUser
ay11-20020a05600c1e0b00b0039c4133ae38si196776wmb.2 - gsmtp
<<< 503 5.5.1 RCPT first.
ay11-20020a05600c1e0b00b0039c4133ae38si196776wmb.2 - gsmtp

[Harriet Bazley]

On 30 Jun 2022 as I do recall,

Post by Chris Hughes

Post by Harriet Bazley
On 29 Jun 2022 as I do recall,

Post by Chris Hughes
I can't really answer your question, but if you posted this on the
Fireworkz mailing list, which Stuart Swales the programmer reads you are
more likely to get a better answer.

I did try this in the past, and it failed - apparently it's still
failing. :-(

Might be because you appear to have not used the correct subscribe
address.
Note the the Plus symbol between fireworkz and subscribe, where as below
you used a minus symbol instead.

Thanks!

[Stuart]

Post by Chris Hughes
Note the the Plus symbol between fireworkz and subscribe, where as below
you used a minus symbol instead.

Did that work?

I emailed Stuart to say people were having difficulty, he is happy to add
people manually if needed.

[Harriet Bazley]

On 30 Jun 2022 as I do recall,

Post by Stuart

Post by Chris Hughes
Note the the Plus symbol between fireworkz and subscribe, where as below
you used a minus symbol instead.

Did that work?

Yes, it did. :-)