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!)

--
Harriet Bazley == Loyaulte me lie ==

We will release no software before its time.

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)

In message <[email protected]>
Harriet Bazley <[email protected]> wrote:

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.

--
Chris Hughes

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)

On 29 Jun 2022 as I do recall,
Chris Hughes wrote:

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. :-(

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 weren't able to post:

* 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

----- The following addresses had permanent fatal errors ----- <[email protected]>
(reason: 550-5.1.1 The email account that you tried to reach does not exist. Please try)

----- Transcript of session follows -----
... while talking to gmr-smtp-in.l.google.com.:

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
550 5.1.1 <[email protected]>... User unknown
<<< 503 5.5.1 RCPT first. ay11-20020a05600c1e0b00b0039c4133ae38si196776wmb.2 - gsmtp

--
Harriet Bazley == Loyaulte me lie ==

You cannot kill time without injuring eternity.

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)

In article <[email protected]>,
Harriet Bazley <[email protected]> wrote:

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.

--
Stuart Winsor

Tools With A Mission
sending tools across the world
http://www.twam.co.uk/

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)

On 30 Jun 2022 as I do recall,
Chris Hughes wrote:

In message <[email protected]>
Harriet Bazley <[email protected]> wrote:

On 29 Jun 2022 as I do recall,
Chris Hughes wrote:

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:

[email protected]

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

Thanks!


--
Harriet Bazley == Loyaulte me lie ==

If it's not broken, don't fix it.

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)

In message <[email protected]>
Harriet Bazley <[email protected]> wrote:

On 29 Jun 2022 as I do recall,
Chris Hughes wrote:

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:

[email protected]

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


[snip]

Followed by

----- The following addresses had permanent fatal errors -----
<[email protected]>
(reason: 550-5.1.1 The email account that you tried to reach does not
exist. Please try)

----- Transcript of session follows -----
... while talking to gmr-smtp-in.l.google.com.:

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
550 5.1.1 <[email protected]>... User
unknown
<<< 503 5.5.1 RCPT first.
ay11-20020a05600c1e0b00b0039c4133ae38si196776wmb.2 - gsmtp

--
Chris Hughes

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)

In article <[email protected]>,
Harriet Bazley <[email protected]> wrote:

The correct address is:

[email protected]

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.

--
Stuart Winsor

Tools With A Mission
sending tools across the world
http://www.twam.co.uk/

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)

On 30 Jun 2022 as I do recall,
Stuart wrote:

In article <[email protected]>,
Harriet Bazley <[email protected]> wrote:

The correct address is:

[email protected]

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

Did that work?

Yes, it did. :-)

--
Harriet Bazley == Loyaulte me lie ==

He who hesitates is last.

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)