Problem with string wariable

#1 Posted: 2/26/2019 11:47:01 AM

1 likes in 7 posts.

Group: User

I was having problems importing an excel file, thought it was a problem with the extension, but some sheets continued to work. The problem was due to the name of the file used as argument to the plugin.

The only difference between the strings shown below, is that in the first case the name was copied from a windows explorer window and pasted between ""(lazy me

), and the other was typed directly.

Both look the same, but SMath stores them differently, and when passed as an argument to the plugin, it fails.

Var_String1:

      <math>
        <input>
          <e type="operand">var_string1</e>
        </input>
        <result action="numeric">
          <e type="operand" style="string">M2U4\005F\m03\005F\2\005F\Error\002E\xlsx</e>
        </result>
      </math>

Var String2:

      <math>
        <input>
          <e type="operand">var_string2</e>
          <e type="operand" style="string">M2U4_m03_2_Error.xlsx</e>
          <e type="operator" args="2">:</e>
        </input>
      </math>

Error ST.sm (4 KiB) downloaded 28 time(s).

Excel plugin:
https://en.smath.info/fo...yaf_postst4375_Plugin---EXCEL--2003--I-O-with-recalculation-and-export-to-PNG.aspx

1 users liked this post

Davide Carpi 2/26/2019 3:39:00 PM

#2 Posted: 2/26/2019 3:53:54 PM

Davide Carpi

1415 likes in 2872 posts.

Group: Moderator

XlsxImportExport plugin updated; please let me know if it works properly so I'll update similar plugins.

If you like my plugins please consider to support the program buying a license; for personal contributions to me: paypal.me/dcprojects

#3 Posted: 2/26/2019 4:57:51 PM

Farja

1 likes in 7 posts.

Group: User

Thanks Davide, i was using the Excel I/O plugin (EXCEL (2003+) I/O with recalculation and PNG export - 1.99.6849.42653), but the problem also applies to XlsxImportExport plugin.

The updated XlsxImportExport plugin (1.3.6996.39330) work properly with the same problematic strings (space, underscore, dot, etc). So i will switch to this one.

Best regards,
Farja

#4 Posted: 2/26/2019 8:57:46 PM

Davide Carpi

1415 likes in 2872 posts.

Group: Moderator