Eclipse Community Forums: NatTable » Use of coma in formula

Home » Eclipse Projects » NatTable » Use of coma in formula

Use of coma in formula [message #1791803]

Thu, 05 July 2018 09:22

Eclipse User

Hi everyone,

I am using NatTable formula feature and I would like to know what is the use of "," in formula.
For example, when I write the formula : "=A1,A2" NatTable display "A1,A2" but when I put "=A1, A2" (with a white space after the coma) NatTable display the reference value of the A2 cell.

Best regards,
Pauline

Attachment: DisplayFormula.png
(Size: 9.05KB, Downloaded 142 times)
Attachment: DisplayFormulaResult.png
(Size: 8.53KB, Downloaded 137 times)

Re: Use of coma in formula [message #1791810 is a reply to message #1791803]

Thu, 05 July 2018 10:00

Eclipse User

Actually I don't understand your formula. What do you expect that should happen on A1,A2? I suppose the formula parser sees the whole thing as a text without the space and with the space it can only interprete A2 because A1, is not understandable.

Re: Use of coma in formula [message #1791838 is a reply to message #1791810]

Fri, 06 July 2018 01:24

Eclipse User

Please note that Excel reports both variants you showed as a formula error!

Re: Use of coma in formula [message #1791852 is a reply to message #1791838]

Fri, 06 July 2018 04:41

Eclipse User

Thank you Dirk for your quick answer,

I am sorry, my question was not clear. I was not sure if the comma was interpreted and had a meaning, I was not understanding the result of my tests. Now I understand, but I think that it is strange that there is a result when the formula is not entirely interpreted, I think that it could get back a formula error or could be interpreted it as a string.

Best regards,
Pauline

Re: Use of coma in formula [message #1791856 is a reply to message #1791852]

Fri, 06 July 2018 04:54

Eclipse User

Feel free to create a ticket

Previous Topic:	Problem using SortColumnCommand on a table with a CompositeFreezeLayer
Next Topic:	How to select rows with matching text in whole row or single column

Goto Forum:

-=] Back to Top [=-

Current Time: Wed Jul 23 08:41:49 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter