SMath Studio Forum
»
SMath Studio
»
Extensions
»
EXCEL (2003+) I/O with recalculation and export to PNG
  Rank: Advanced Member Groups: Registered
Joined: 03/03/2014(UTC) Posts: 406  Was thanked: 119 time(s) in 92 post(s)
|
Originally Posted by: uni  Originally Posted by: Alex M.
Uni, is there anything i can do on my end for the fix? Havent touched the plugin for years and appreciate the maintenance you have done
Please check that the functions are working as they should. Noticed two bugs potentially not related to plugin itself: 1. The CurrentDirectory( "" ) function call is ties to .exe and not the directory of the page, which messes up my excel references. Is it possible to force running a one SMath exe per .sm file opened? 2. When wrapped inside a function() cal the plugin does not work, but same code works fine outside of function():  test.xlsx (8kb) downloaded 94 time(s). exportXLSX_1.sm (21kb) downloaded 104 time(s).Edited by moderator 10 June 2020 22:35:30(UTC)
| Reason: Not specified
|
|
|
|
|
|
 Rank: Advanced Member Groups: Registered, Advanced Member Joined: 10/11/2010(UTC) Posts: 1,042   Was thanked: 936 time(s) in 533 post(s)
|
When translating numbers to Excel and back, there is a problem with the decimal point. I don’t know yet how to make a replacement, because there is confusion with these signs both in the program and in Excel. Here need to do some research, because I did not study this question. |
|
|
|
|
|
|
Rank: Advanced Member Groups: Registered
Joined: 03/03/2014(UTC) Posts: 406 Was thanked: 119 time(s) in 92 post(s)
|
Originally Posted by: uni When translating numbers to Excel and back, there is a problem with the decimal point. I don’t know yet how to make a replacement, because there is confusion with these signs both in the program and in Excel. Here need to do some research, because I did not study this question. Not seen on my end - this example works fine transferring decimal values back and forth SMath<->EXCEL SampleHowTo.zip (1,331kb) downloaded 245 time(s).Can you confirm it does not work for you?
|
|
|
|
|
|
Rank: Advanced Member Groups: Registered, Advanced Member Joined: 10/11/2010(UTC) Posts: 1,042 Was thanked: 936 time(s) in 533 post(s)
|
Originally Posted by: Alex M. Can you confirm it does not work for you? This example does not work for me and it is related with the decimal part separator, as I understand it. |
|
|
|
|
|
|
SMath Studio Forum
»
SMath Studio
»
Extensions
»
EXCEL (2003+) I/O with recalculation and export to PNG
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.
