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.

In message <8c403f005a.harriet@bazleyfamily.co.uk>
Harriet Bazley <harriet@bazleyfamily.co.uk> 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

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 -----
> <colton-software-fireworkz-subscribe@googlegroups.com>
> (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 <colton-software-fireworkz-subscribe@googlegroups.com>... User unknown
> <<< 503 5.5.1 RCPT first. ay11-20020a05600c1e0b00b0039c4133ae38si196776wmb.2 - gsmtp

--
Harriet Bazley == Loyaulte me lie ==

You cannot kill time without injuring eternity.

In article <e6d971005a.harriet@bazleyfamily.co.uk>,
Harriet Bazley <harriet@bazleyfamily.co.uk> 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/

In message <e6d971005a.harriet@bazleyfamily.co.uk>
Harriet Bazley <harriet@bazleyfamily.co.uk> 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:

colton-software-fireworkz+subscribe@googlegroups.com

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 -----
>> <colton-software-fireworkz-subscribe@googlegroups.com>
>> (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 <colton-software-fireworkz-subscribe@googlegroups.com>... User
>> unknown
>> <<< 503 5.5.1 RCPT first.
>> ay11-20020a05600c1e0b00b0039c4133ae38si196776wmb.2 - gsmtp

--
Chris Hughes

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

> In message <e6d971005a.harriet@bazleyfamily.co.uk>
> Harriet Bazley <harriet@bazleyfamily.co.uk> 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:
>
> colton-software-fireworkz+subscribe@googlegroups.com
>
> 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.

In article <3f3095005a.harriet@bazleyfamily.co.uk>,
Harriet Bazley <harriet@bazleyfamily.co.uk> wrote:
> > The correct address is:
> >
> > colton-software-fireworkz+subscribe@googlegroups.com
> >
> > 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/

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

> In article <3f3095005a.harriet@bazleyfamily.co.uk>,
> Harriet Bazley <harriet@bazleyfamily.co.uk> wrote:
> > > The correct address is:
> > >
> > > colton-software-fireworkz+subscribe@googlegroups.com
> > >
> > > 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.