Flexibility Smart Marker parameter "numeric"

Aspose.Cells Product Family
1

Hello –

I’m using some Smart Markers in an Excel “template” with much success. However, occassionally my end users will attempt to merge text data into Excel, which is handled nicely by the “numeric” parameter.

My question is this: sometimes they’ll use currency data formatted with “$” and commas between thousands, like “$2,500.00”. This data is not “forced” to be numeric, even if the “numeric” parameter is used in the Smart Marker formula.

What I would really like is for Cells to be more aggressive in converting a cell’s value to numeric when the “numeric” parameter is included. So, for example, if my Smart Marker formula is
&=Invoice.Amount(numeric)

and the data for that cell is “$2,500.00” (as opposed to 2500), it would be great if Cells would interpret that as a value resulting in a cell value of the numeric 2500 (which would be formatted using Excel to whatever the end user wanted.)

Any plans on the road map that would address this?


2

Hi,

Thanks for considering Aspose.

We will check the feasibility and effectiveness of the feature you are requiring for and may consider it soon in our future versions.

Thank you.

3

We can try to interpret “$2,500.00” as 2500 but you have to format it in your template file. Hopefully we can make this featurn in the next month.

4

Looking forward to it, Laurence.

By the way, to go along with this, it’d be great to convert the text “2,500” (with no currency symbol) to numeric too. I’m sure there are other combinations of punctuation to consider too.

Thanks again.

Michael