Welcome! Log In Create A New Profile

Advanced

WD26 SPREADSHEET CONTROL

Posted by jtadebruin 
Forum List Message List New Topic
jtadebruin
WD26 SPREADSHEET CONTROL
February 20, 2022 08:30PM
Hey

When i use a formula in the spreadsheet control I often get an error #NOM?
But why?




TIA
Jan
Reply Quote
Marc De Swert
Re: WD26 SPREADSHEET CONTROL
February 21, 2022 05:01PM
Hi Jan,

perhaps is the language the problem

i did the same but in dutch just change IF into ALS

=ALS(A1>3;"bigger";"not bigger")

and no problemo here spinning smiley sticking its tongue out
Reply Quote
SteveSitas
Re: WD26 SPREADSHEET CONTROL
February 22, 2022 11:33AM
Hi Jan,

confirmed ...

Regards
Steven Sitas
Reply Quote
jtadebruin
Re: WD26 SPREADSHEET CONTROL
February 22, 2022 12:50PM
Hey Steven and Marc

Unfortunately no success for me yet
What language have you set as your default?

TIA
Jan
Reply Quote
SteveSitas
Re: WD26 SPREADSHEET CONTROL
February 22, 2022 06:55PM
Hi Jan,

I mean I can confirm the bug ..
v26 - both on English and Greek

Did you report it to PCSoft?

Regards
Steven Sitas
Reply Quote
jtadebruin
Re: WD26 SPREADSHEET CONTROL
February 23, 2022 05:40PM
I will do that

to be continued
Reply Quote
Marc De Swert
Re: WD26 SPREADSHEET CONTROL
February 24, 2022 09:22AM
my language "Nederlands (Belgie)"
Reply Quote
jtadebruin
Re: WD26 SPREADSHEET CONTROL
February 28, 2022 08:12PM
Hey

I have an answer from PCSOFT.

I have to use a comma as separator in the formula.
So, that is not the list separator in my regio settings.

I have askes PCSOFT if Windev will allways use a comma in the spreadsheet control.
This behavior is not compatible with Excel.

To be continued

Jan
Reply Quote
Newer Topic Older Topic
Author:

Your Email:


Subject:
Spam prevention:
Please, enter the code that you see below in the input field. This is for blocking bots that try to post this form automatically. If the code is hard to read, then just try to guess it right. If you enter the wrong code, a new image is created and you get another chance to enter it right.
Message: