UPDATED

- SMath Studio 0.96.5146 or later required

- [EDIT: February 10, 2014] dll direct download removed (SMath without Extensions Manager is no longer supported)


best regards,

Davide

Edited by user 10 February 2014 23:10:09(UTC)  | Reason: dll direct download removed

This is because Viewer's Store.FileName property contains the file name of the parent SMath worksheet (I suppose is by design).

I've tried to implement a workaround (uploaded in the EM). Should works also on unix systems but I'm not sure. Test it deeply and report any issue. If it works I'll do the same for the XLSX plugin.


Best regards,

Davide

Edited by user 16 December 2014 12:21:48(UTC)  | Reason: Not specified

Using collapsed area a file is created when you open the executable, this it means that the function is evaluated; the content of the collapsed region is no more evaluated when you change the combobox item. I guess the issue is in the RequestEvaluation triggered from the combobox in the SMathViewer vs the collapsed areas, that is not in my hands (API stuff).

BUG opened: SV-1254

Edited by user 16 December 2014 21:28:13(UTC)  | Reason: Not specified

Hello!

First of all - thank you for the plugin - I was playing with it for a while and it seems to import data from ODS very well.

Now, for the export function, is there a way to "modify" a single cell in existing ODS file? What I am trying to achieve is to use spreadsheet as a large data processor (it is quite good at it), while I would like to use Smath to feed variables into the spreadsheet and to get output from it.

Many thanks

Davide,

I have spent some time trying to develop a complete solution that would export data from smath to xlsx or ods, recalculate the spreadsheet using new values, and import the updated output back into smath.

Unfortunately I am stuck.

1. Excel plugin does not seem to import value that is obtained by a formula (multiply one cell by another)
2. Neither XLSX nor ODS plugins update the spreadsheet using external links at the time of import.

Please see attached. If we successfully tackle this I believe it will be used by a few people - Smath and Excel are powerful tools and each has strengths and weaknesses.

Best Regards

That makes sense; possibly pyUNO can be used to update ODS file in background. However given my non-existing programming skills it is highly unlikely I will be able to incorporate it myself - I will just stick to reopening files manually.

Thank you for your help

Is there any particular way that I may assist you with this? If you point me in the right direction I could research how this feature may be implemented (xlsx files) - I am not a programmer but can attempt my best to piece pieces together.

A little bit background on why I think that is important:

Quite often we, number crunchers, have previously created spreadsheets (in Excel) to do specific tasks. Those spreadsheets have been triple checked by ourselves and others to contain no bugs. At times it is enforced that we use specific spreadsheets for specific calculations.

It would be immensely useful to use SMath Studio to input data in a given spreadsheet and to record corresponding output. In fact it will effectively make use of a spreadsheet as a monstrous data crunching formula that was previously verified to work by others. You feed in data, record output for different variable sets and present them in a readable format of SMath Workbook.

Best Regards

PLUGIN UPDATED SMath Studio 0.97.5737

• importData.ODS(): can access files opened by other processes (only saved data);
  
• importData.ODS(): sheet name no more case-sensitive;
  
• importData.ODS(3): range of cells accepted as 3rd argument;

Edited by user 20 January 2016 19:36:42(UTC)  | Reason: Not specified

Jean, it might not be true for you in particular, but for many in my field it is a requirement to re-use existing spreadsheets. Additionally it is hard to beat excel when you need to mass edit your formulas to correct an error or add a feature (in fact find/replace in not even an option in SMath). I would hate to make a choice between CAS and spreadsheets. Both are great; in their own ways.

Anyway, it has been quite a while since the post you are looking at - I have addressed my own request by creating plugin excel_IO, which I find very useful.

Cheers,

Alex M.

Beautiful function your FindReplace function Jean

I think he is looking for a general search & replace, both for math and text and able to acting on the whole worksheet.

I'm working on something, search works pretty fine with small limitations

Edited by user 23 January 2016 14:58:01(UTC)  | Reason: Not specified