semantic sheet datatypes

7 views
Skip to first unread message

Bohms, H.M. (Michel)

unread,
Sep 16, 2021, 3:36:57 AM9/16/21
to topbrai...@googlegroups.com

When using the semantic spreadsheet option I see that numbers are mapped to xsd doubles.

 

But…in the spreadsheet people are using comma’s… so I get:

 

But a double should have a point in the end.

 

So wouldn’t the heuristic not be a string when comma stuff is encountered?

 

Thx Michel

 

 

 

Dr. ir. H.M. (Michel) Bohms
Scientist Specialist
Structural Reliability

T +31 (0)88 866 31 07
M +31 (0)63 038 12 20
michel...@tno.nl

Location

 

This message may contain information that is not intended for you. If you are not the addressee or if this message was sent to you by mistake, you are requested to inform the sender and delete the message. TNO accepts no liability for the content of this e-mail, for the manner in which you use it and for damage of any kind resulting from the risks inherent to the electronic transmission of messages.

 

Bohms, H.M. (Michel)

unread,
Sep 16, 2021, 6:51:32 AM9/16/21
to topbrai...@googlegroups.com

Now i changed my system setting (as also used by excel) to . as separator.

 

But now my . values in the sheet become strings!

 

Hmmmm?

 

 

 

Dr. ir. H.M. (Michel) Bohms
Scientist Specialist
Structural Reliability

T +31 (0)88 866 31 07
M +31 (0)63 038 12 20
michel...@tno.nl

Location

 

This message may contain information that is not intended for you. If you are not the addressee or if this message was sent to you by mistake, you are requested to inform the sender and delete the message. TNO accepts no liability for the content of this e-mail, for the manner in which you use it and for damage of any kind resulting from the risks inherent to the electronic transmission of messages.

 

--
You received this message because you are subscribed to the Google Groups "TopBraid Suite Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to topbraid-user...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/topbraid-users/0f20078c7b184de595c10fc04650c8f7%40tno.nl.

Bohms, H.M. (Michel)

unread,
Sep 16, 2021, 8:28:50 AM9/16/21
to topbrai...@googlegroups.com

 

By explicitly formatting cells as Number this seems solved…. (they become xsd:double)

 

 

Only now my dotsin the values become comma’s in TBC! 😊

Reply all
Reply to author
Forward
0 new messages