MicroOffice

MicroOffice - 🚧 Word, Excel and Visio - Messages

#1 Posted: 8/15/2019 1:58:22 PM
Вячеслав Мезенцев

Вячеслав Мезенцев

1402 likes in 1708 posts.

Group: Moderator

MicroOffice [ β ]

SMath Viewer compatibility mono compatibility Sources


Implementation started.

I don't know how, but I think it is possible to show office documents as images. For editing we can open Word, Excel or Visio as external editors. Documents can be embedded to worksheet.

2019-08-15_21-52-55.png
Russia ☭ forever, Viacheslav N. Mezentsev
3 users liked this post
frapuano 8/16/2019 3:02:00 AM, Arie 8/16/2019 4:10:00 PM, Николай Цопа 3/22/2020 2:10:00 PM
#2 Posted: 8/15/2019 6:27:29 PM
Вячеслав Мезенцев

Вячеслав Мезенцев

1402 likes in 1708 posts.

Group: Moderator

Using this technique it is possible to use the Plotly.js library to draw graphs. Basically, this method allows you to access the usual form, but with limited interaction.

2019-08-16_02-24-45.png
Russia ☭ forever, Viacheslav N. Mezentsev
#3 Posted: 9/29/2019 3:02:47 PM
overlord

overlord

554 likes in 1333 posts.

Group: Moderator

This will be a good plugin I think.
Is there any way to show the office document as objects, not as images?
In mathcad when I paste an excel table it is imported as an object.
It can be edited with right click and externally edited as you mentioned for your implementation.
But it is also shown as object and pdf-friendly.

smath.pdf (64 KiB) downloaded 175 time(s).
mathcad.pdf (284 KiB) downloaded 129 time(s).

Regards
#4 Posted: 9/29/2019 5:04:42 PM
Jean Giraud

Jean Giraud

983 likes in 6866 posts.

Group: User

If you want that Excel data table in Smath, easy:
1. capture the Execl, select, crop image
2. copy image, paste in Smath.
The tool is freeware WinGrab.
#5 Posted: 9/29/2019 5:44:14 PM
overlord

overlord

554 likes in 1333 posts.

Group: Moderator

Jean, it is obvious you didn't check the pdf files. You really wouldn't need to tell me about how to crop images if you did, I already did that.
Problem is not how to do it, problem is font render quality. Smath copies excel tables as images, which has no font so no print quality.

1. there is undeniable quality difference between cropped image version (smath), which you mentioned, and font version (mathcad).
2. windows has its own screen capture program that works perfectly. no need to install or keep additional software for this purpose.
3. you actually don't need any software to copy image of excel tables, Ctrl+C is enough. than you can paste it as an image in smath.
But if you make pdf from smath file which has image copied excel table, quality is a disaster.

Regards
#6 Posted: 9/29/2019 7:48:04 PM
Jean Giraud

Jean Giraud

983 likes in 6866 posts.

Group: User

Wrote

But if you make pdf from smath file which has image copied Excel table, quality is a disaster.


The two PDf look same [I checked both]
That's why I suggested NOT use Microsoft.
If I make an Smath PDF as captured, PDF is 1/1
My PDF is CutePDF freeware, NOT Smath PDF.

#7 Posted: 9/29/2019 8:07:19 PM
Jean Giraud

Jean Giraud

983 likes in 6866 posts.

Group: User

Wrote

If I make an Smath PDF as captured, PDF is 1/1
My PDF is CutePDF freeware, NOT Smath PDF.


...open with Adobe Reader [the freeware]
Images captured/crop as described earlier,
pasted in Smath, Smath => CutePDF

Type T_J.pdf (399 KiB) downloaded 105 time(s).
#8 Posted: 9/29/2019 9:19:40 PM
Jean Giraud

Jean Giraud

983 likes in 6866 posts.

Group: User

... so simple, so perfect for publishing Smath *.PDF

CosmosPDF.pdf (120 KiB) downloaded 129 time(s).
#9 Posted: 9/30/2019 9:24:13 AM
overlord

overlord

554 likes in 1333 posts.

Group: Moderator

Wrote


The two PDf look same [I checked both]
That's why I suggested NOT use Microsoft.
If I make an Smath PDF as captured, PDF is 1/1
My PDF is CutePDF freeware, NOT Smath PDF.



Please zoom in both pdf. You will see they are not same.
Your last example has the same diseas, if you zoom in to your cosmos.pdf you will see.
Texts in cropped images are not looking good at pdf and paper.
#10 Posted: 9/30/2019 10:16:06 AM
Вячеслав Мезенцев

Вячеслав Мезенцев

1402 likes in 1708 posts.

Group: Moderator

Wrote

Is there any way to show the office document as objects, not as images?


Unfortunately, no. As I know for good quality you must use .Net graphic library and there is no simple way to translate graphics from another application. In such projects, I try to find ways to use the existing code to expand the functionality of the program even if the quality of the document decreases. There are so many components that are based on the Control class, it would be great to use at least some of them. Because writing a useful plugin from scratch is very difficult.

Russia ☭ forever, Viacheslav N. Mezentsev
1 users liked this post
overlord 9/30/2019 3:15:00 PM
#11 Posted: 9/30/2019 11:10:48 AM
Jean Giraud

Jean Giraud

983 likes in 6866 posts.

Group: User

Wrote

Please zoom in both pdf. You will see they are not same.
Your last example has the same diseas, if you zoom in to your cosmos.pdf you will see.
Texts in cropped images are not looking good at pdf and paper.


At right is the original in Smath document.
At left is the 100% Adobe, copied/pasted.

CosmosPDF.PNG
#12 Posted: 9/30/2019 11:18:02 AM
Jean Giraud

Jean Giraud

983 likes in 6866 posts.

Group: User

Wrote

At right is the original in Smath document.
At left is the 100% Adobe, copied/pasted.


Smath document.

PDF Cosmos Test.sm (711 KiB) downloaded 90 time(s).

After this post, I will re-download check.
#13 Posted: 9/30/2019 11:30:01 AM
Jean Giraud

Jean Giraud

983 likes in 6866 posts.

Group: User

Wrote

After this post, I will re-download check.


... re-download sanity checked confirmed 1/1.
Conclusion:
1. NO need for Microsoft for Smath *.PDF
2. Go by the procedure explained above.
3. Procedure presumably applicable to Smath past SS 6179.
4. Check [3] on latest SS.

Cheers ... Jean
#14 Posted: 9/30/2019 11:57:54 AM
Jean Giraud

Jean Giraud

983 likes in 6866 posts.

Group: User

Simply, I don't understand what Microsoft has to do wrt Smath
I used only Paint in my Win 7, a damned poor Paint vs XP Home.
#15 Posted: 9/30/2019 3:22:41 PM
overlord

overlord

554 likes in 1333 posts.

Group: Moderator

Wrote


Unfortunately, no. As I know for good quality you must use .Net graphic library and there is no simple way to translate graphics from another application. In such projects, I try to find ways to use the existing code to expand the functionality of the program even if the quality of the document decreases. There are so many components that are based on the Control class, it would be great to use at least some of them. Because writing a useful plugin from scratch is very difficult.


Thank you for your kind and explanatory reply. So I have to get on with images.
#16 Posted: 9/30/2019 3:49:33 PM
Jean Giraud

Jean Giraud

983 likes in 6866 posts.

Group: User

Wrote

So I have to get on with images.


Have you tried: select the Excel table, copy/paste in IrfanView.
Does not => f..k Microsoft Office.
Since Mathcad 8 Pro. select math regions [including table]
copy/paste in IrfanView ... bingo as an image,
copy image, paste in Smath [PDF Cosmos].
I asked for same feature in Smath, apparently was to be
added in SS 6179 < SS Newer.
The alternate captured procedure offered ... few more clicks.
#17 Posted: 9/30/2019 5:21:51 PM
Davide Carpi

Davide Carpi

1417 likes in 2873 posts.

Group: Moderator

Wrote

Since Mathcad 8 Pro. select math regions [including table]
copy/paste in IrfanView ... bingo as an image,
copy image, paste in Smath [PDF Cosmos].
I asked for same feature in Smath, apparently was to be
added in SS 6179 < SS Newer.


It is available since version 0.98.6523

If you like my plugins please consider to support the program buying a license; for personal contributions to me: paypal.me/dcprojects
#18 Posted: 9/30/2019 6:27:50 PM
Jean Giraud

Jean Giraud

983 likes in 6866 posts.

Group: User

Wrote

It is available since version 0.98.6523

.
... then Collab Overlord should try.
Thanks Davide.

#19 Posted: 10/2/2019 3:43:06 PM
Alexander O. Melnik

Alexander O. Melnik

127 likes in 494 posts.

Group: Moderator

Wrote

Jean, it is obvious you didn't check the pdf files. You really wouldn't need to tell me about how to crop images if you did, I already did that.
Problem is not how to do it, problem is font render quality. Smath copies excel tables as images, which has no font so no print quality.

1. there is undeniable quality difference between cropped image version (smath), which you mentioned, and font version (mathcad).
2. windows has its own screen capture program that works perfectly. no need to install or keep additional software for this purpose.
3. you actually don't need any software to copy image of excel tables, Ctrl+C is enough. than you can paste it as an image in smath.
But if you make pdf from smath file which has image copied excel table, quality is a disaster.

Regards



EXCEL I/O plugin will plot regions of excel for you without quality loss by using excel_EMF(#) function
https://en.smath.com/forum/yaf_postst4375_Plugin---EXCEL--2003--I-O-with-recalculation-and-export-to-PNG.aspx

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.

File not found.File not found.File not found.
moody_comp.png
1 users liked this post
overlord 10/2/2019 6:28:00 PM
#20 Posted: 10/2/2019 6:36:35 PM
overlord

overlord

554 likes in 1333 posts.

Group: Moderator

Wrote

EXCEL I/O plugin will plot regions of excel for you without quality loss by using excel_EMF(#) function
https://en.smath.com/forum/yaf_postst4375_Plugin---EXCEL--2003--I-O-with-recalculation-and-export-to-PNG.aspx

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.


This has much more render quality than I expected, actually there is no quality loss. Thank you very much.
If combination of excel_IO and image plugin can do this, there should be no reason MicroOffice plugins can't imho.
Smath can even store excel data embedded in *.sm file and it can be viewed without quality loss like your example.
So there won't be any need for an excel file (as a source) for viewing.


  • New Posts New Posts
  • No New Posts No New Posts