AnsweredAssumed Answered

ScribeDocReadValue plugin can not read Scientific Numbers

Question asked by Joshua_1 on Apr 29, 2015
Latest reply on Apr 29, 2015 by philmodjunk

Summary

ScribeDocReadValue plugin can not read Scientific Numbers

Product

FileMaker Pro

Version

13

Operating system version

Windows 8

Description of the issue

Plug-in "360Works Scribe" returns an error when attempting to read an excel cell that has scientific formatting. The error it returns is as follows:

java.lang.IllegalArgumentException: Malformed exponential pattern "0.00E+00"

All other formatted cells load fine except the scientific ones.

Steps to reproduce the problem

Set Field [Wafer::GlobalTxt1; ScribeDocLoad("C:\.....xlsx")]
Set Field [Wafer::GlobalNum1; ScribeDocReadValue("F2")

/* Where column "F" in Excel is formatted as Scientific Numbers*/

Expected result

1.20E+19

Actual result

Error

Exact text of any error message(s) that appear

java.lang.IllegalArgumentException: Malformed exponential pattern "0.00E+00"

Workaround

None

Outcomes