Recent Posts1
Developer's Corner / an ole component for calculation?
« Last post by oyster on September 07, 2008, 12:08 AM »During my work, I often write documnets in ms-word. But the doc has many numbers in it, which need to be calculated via a some complex function and to be modified frequently.
Is there a method to write an ole control, so that
1. when I choose menu 'insert->object' in ms-word, a window is popped up, then I can type in the calculation steps in some program language
[attach=#1][/attach]
2.when I close the 'fake ms-word add-in for calculation' window, the result (here, it is 8) is shown in the doc
[attach=#2][/attach]
3.when I double-click the result 8, I can view/edit the code again like what I do in step 1
4.the prg is stored in DOC file too
mathtype equation ( http://www.dessci.com/mathtype ) is such kind of thing, but only for displaying nice equation
I don't think vba is a good answer, the main reason is: the vba code has an incompact link with its result in the documnet. If there are many calculation, I have to remember which function yields which result, when I have to modify, I must browse all VBA function name
for the calculation part, I prefer to python(www.python.org) interpreted langauge for the following reasons:
1.the pythonxx.dll supplies many math operations and functions(+-*/, sin/cos/..., log, pi, pow etc), which is only about 1.7M
2.if more math function is need, scipy+numpy can be used, however ~23M space will be used; or we can use http://code.google.com/p/sympy/ which is smaller but with limited function
I can write program in FB, python and a little C. Can any one tell me
1.is this kind of software possible
2.which technology is used? if there are some simple code demo, it will be better.
thanx
Is there a method to write an ole control, so that
1. when I choose menu 'insert->object' in ms-word, a window is popped up, then I can type in the calculation steps in some program language
[attach=#1][/attach]
2.when I close the 'fake ms-word add-in for calculation' window, the result (here, it is 8) is shown in the doc
[attach=#2][/attach]
3.when I double-click the result 8, I can view/edit the code again like what I do in step 1
4.the prg is stored in DOC file too
mathtype equation ( http://www.dessci.com/mathtype ) is such kind of thing, but only for displaying nice equation
I don't think vba is a good answer, the main reason is: the vba code has an incompact link with its result in the documnet. If there are many calculation, I have to remember which function yields which result, when I have to modify, I must browse all VBA function name
for the calculation part, I prefer to python(www.python.org) interpreted langauge for the following reasons:
1.the pythonxx.dll supplies many math operations and functions(+-*/, sin/cos/..., log, pi, pow etc), which is only about 1.7M
2.if more math function is need, scipy+numpy can be used, however ~23M space will be used; or we can use http://code.google.com/p/sympy/ which is smaller but with limited function
I can write program in FB, python and a little C. Can any one tell me
1.is this kind of software possible
2.which technology is used? if there are some simple code demo, it will be better.
thanx
