the number in this cell is formatted as text or preceded by an apostrophe

Hi @ aviadplanewize,

Thanks for sharing this issue. I recently ran in to something similar when implementing the clickable links. It’s semi-easy for me to see when something is a link, and should therefor be clickable. But numbers are a different story. Consider this:

When something is a 2, you’ll want a numeric cell. So I set that. But when for example you have a phone number, and it starts with a zero; you’ll want a string, because otherwise, the leading zero will be stripped by excel. So you see it’s tricky business ??

I have an idea by wrapping al values in a set of typeclasses, which will give me more information about the value, and the things the excel needs to do with those. It will take some time though to implement.

I’ll get back to you on this, when I have the solution ready.

wath if you add a filter to value to tel if is number ?

Yeah this is pretty much how it’s going to be set up. I’ve made some changes already. The value is changed to a value-object so it knows whether or not it’s a numeric value, or text. Reason for this method is the ability to change the render-implementation later on, without changing the plugin itself.

With the help of filters you can set a field to be numeric / boolean / text.

This works well in the test. So we’re getting there. This update will be ready in 1.3.0. Hope to release later this week. Seems like a new version arises every week at the moment ??

Hi @aviadplanewize, just a heads up that I released version 1.3.0, which includes a fix for your issue. Please checkout the FAQ for a code example.

I hope this helps. I definitely helps the plugin, as further improvements to cell types and values are easier to implement.

thnk you very much

is a event for ALS research !!!
you elp me alot !!!!

Great cause! Very best of luck. Shalom!