... what I understand in there: you have the Pareto software, you made the chart,
and transited to Excel to further paste back to Smath. Wouldn't it be simpler to
capture directly from Pareto, resize/resample, reduce 256 colors and paste in Smath ?

Jean

================ I understand [my own way] all what you are doing ==============

I was Excel mad up to WIN Millenium. The switch to Mathcad 8 then 11 replaced my Excel
work because more oriented to solving maths. Since 2000, I have never opened Excel again.

My two most precious tools, companions of Smath are: WinGrab & IrfanView.
Same tools that I got mid 90. If an image is not compatible for pasting in WinGrab,
I transit to Paint, then paste in WinGrab for color reduction [256]. WinGrag will also capture image from web and from any screen display.

Often, images from *.PDF, web ... are poor quality [not sharp].
Then paste in IrfanView and use the "Sharpen" once or multiple times.
From the same IrfanView menu, you can "resize/resample" at whatever %
by respecting aspect ratio. Same quality than PhotoShop for 0$.
Naturally, if an image is to destroyed by JPEG, zoom[+] is poor.

You are right: Smath is more maths oriented than Graphs, thus combine + Excel.

Jean

The excel_IO appears not to be working anymore as part of a custom function. It was working previously on my computer, but with one of the upgrades to SmathStudio it has stopped working. When the excel_IO is used as the right part of a custom function, the variables with equal signs get placed in the excel worksheet cells instead of the values of the variables. See the two screen shots below from the Steel Properties Look-up.sm and corresponding excel file. The excel_IO otherwise appears to work but not as right part of custom function with variable input.

Thanks for the work around and tips. Your plug-in is really valuable because linking excel and smath opens up many possibilities with engineering calculations. Wish the line function was not needed because you would not really think it was necessary in this case in my opinion. I hope it can be removed at some point.

A sample of a Plot produced by combination of excel_EMF function and Image Region inside the SMath workbook.
The example was borrowed from one of the calculations by Jean Giraud.

Note the difference of as-printed quality between X-Y Plot output and excel_EMF output.

moody.pdf (93kb) downloaded 152 time(s). Inst_Colebrook MOODY_excelPlot.sm (21kb) downloaded 143 time(s). moody_plot.xlsx (32kb) downloaded 114 time(s).

Edited by user 10 October 2016 22:36:13(UTC)  | Reason: Not specified

Jean,

There are two ways to display EXCEL plots / ranges:

1. excel_PNG - produces LARGE bitmap files that print well at 300+ DPI
2. excel_EMF - produces a clipboard of a metafile (native .net vector graphics) which results in a vector graphics PDF prints.

I like using excel_EMF - it produces best as-printed quality plots and is much faster than excel_PNG

Also I saw that you were spooling "Moody" function output to file to speed up processing. No need for that - just define Moody:=eval(your_code) so the function is not executed every time you call it in a SMath worksheet.

Source code updated.

A couple of days ago when I started SMath Studio it listed the plug-in EXCEL (2003+) I/O to be updated. I updated the plug-in and after doing so it does not work the same as it did before. In my sheet, a function is setup to use the plug-in. The function now returns a matrix with a single element of zero were before the function would return a single decimal value.



Is there something that needs to be setup differently?

Thanks for any help.

Partially fixed, please check.

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