Problem with string wariable

#1 Опубликовано: 26.02.2019 11:47:01

1 сообщений из 7 понравились пользователям.

Группа: 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 КиБ) скачан 28 раз(а).

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

1 пользователям понравился этот пост

Davide Carpi 26.02.2019 15:39:00

#2 Опубликовано: 26.02.2019 15:53:54

Davide Carpi

1415 сообщений из 2872 понравились пользователям.

Группа: 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 Опубликовано: 26.02.2019 16:57:51

Farja

1 сообщений из 7 понравились пользователям.

Группа: 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 Опубликовано: 26.02.2019 20:57:46

Davide Carpi

1415 сообщений из 2872 понравились пользователям.

Группа: Moderator