1 Reply Latest reply on Apr 29, 2015 11:40 AM by philmodjunk

    ScribeDocReadValue plugin can not read Scientific Numbers

    Joshua_1

      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