By explicitly formatting cells as Number this seems solved…. (they become xsd:double)
Only now my dotsin the values become comma’s in TBC! 😊 [cid:image001.png@01D7AB07.27DB8E60] Dr. ir. H.M. (Michel) Bohms Scientist Specialist Structural Reliability T +31 (0)88 866 31 07 M +31 (0)63 038 12 20 E michel.bo...@tno.nl<mailto:michel.bo...@tno.nl> Location<http://www.tno.nl/locations/DTS> [cid:image002.gif@01D7AB07.27DB8E60]<http://www.tno.nl/> 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. Van: 'Bohms, H.M. (Michel)' via TopBraid Suite Users <topbraid-users@googlegroups.com> Verzonden: donderdag 16 september 2021 12:51 Aan: topbraid-users@googlegroups.com Onderwerp: [topbraid-users] RE: semantic sheet datatypes Now i changed my system setting (as also used by excel) to . as separator. But now my . values in the sheet become strings! Hmmmm? [cid:image004.png@01D7AB07.27DB8E60] Dr. ir. H.M. (Michel) Bohms Scientist Specialist Structural Reliability T +31 (0)88 866 31 07 M +31 (0)63 038 12 20 E michel.bo...@tno.nl<mailto:michel.bo...@tno.nl> Location<http://www.tno.nl/locations/DTS> [cid:image002.gif@01D7AB07.27DB8E60]<http://www.tno.nl/> 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. Van: 'Bohms, H.M. (Michel)' via TopBraid Suite Users <topbraid-users@googlegroups.com<mailto:topbraid-users@googlegroups.com>> Verzonden: donderdag 16 september 2021 09:37 Aan: topbraid-users@googlegroups.com<mailto:topbraid-users@googlegroups.com> Onderwerp: [topbraid-users] semantic sheet datatypes 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: [cid:image006.png@01D7AB07.27DB8E60] 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 E michel.bo...@tno.nl<mailto:michel.bo...@tno.nl> Location<http://www.tno.nl/locations/DTS> [cid:image002.gif@01D7AB07.27DB8E60]<http://www.tno.nl/> 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-users+unsubscr...@googlegroups.com<mailto:topbraid-users+unsubscr...@googlegroups.com>. To view this discussion on the web visit https://groups.google.com/d/msgid/topbraid-users/0f20078c7b184de595c10fc04650c8f7%40tno.nl<https://groups.google.com/d/msgid/topbraid-users/0f20078c7b184de595c10fc04650c8f7%40tno.nl?utm_medium=email&utm_source=footer>. -- 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-users+unsubscr...@googlegroups.com<mailto:topbraid-users+unsubscr...@googlegroups.com>. To view this discussion on the web visit https://groups.google.com/d/msgid/topbraid-users/3055a08a30474f0b83a05faa4463c86a%40tno.nl<https://groups.google.com/d/msgid/topbraid-users/3055a08a30474f0b83a05faa4463c86a%40tno.nl?utm_medium=email&utm_source=footer>. -- 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-users+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/topbraid-users/fb399760342046c183502a06114465bb%40tno.nl.