Can we able to read actual value instead of display value from excel.

Use the text() function to format the value as required.

Format Excel column as Text to store/read full precision as string, then todecimal().

Hi Stefan, the plugin is returning the formatted display value (9.79) in text. I need to get the actual value (9.7881336)

Below is the excel image.

Hi Shubham, we receiving the excel files from outside and we performing the extraction, so we couldn't able to format the column.

Saikrishnan V said:

plugin is returning the formatted display value

How do you know?

We using the plugin in the expression rule and below is the extracted data (highlighted one is the display value).

This is showing a text type. So somewhere the numeric value is turned into text. The root cause could be the Excel, or the plugin.

But if you cannot modify the Excel, nor the plugin, not many options are left.

You could try to just dump the Excel into a database table and check whether the data types survive this transformation.