Difference between revisions of "Calc/Add-In/CompleteAddIn"
SergeMoutou (Talk | contribs) (→The C++ Code) |
SergeMoutou (Talk | contribs) (→The fourth method) |
||
Line 80: | Line 80: | ||
</nowiki></pre> | </nowiki></pre> | ||
− | ===The fourth | + | ===The fourth Method=== |
− | + | The goal of the fourth method is to show how we can implement a matrix function : starting from a cell range and obtaining a celle range. | |
<pre><nowiki> | <pre><nowiki> | ||
//It's a matrix operation should be called like : {=METHODFOUR(A1:B4)} | //It's a matrix operation should be called like : {=METHODFOUR(A1:B4)} | ||
Line 102: | Line 102: | ||
} | } | ||
</nowiki></pre> | </nowiki></pre> | ||
+ | What is done by this example is not great : only add four to every cells of the cell range. | ||
+ | The code is not complete with this four method. If you want to create a component you have to add code, if you want to make a scriptable component you still add more code and if you want to create an AddIn you have to add more. | ||
+ | |||
+ | ==The complete Code== | ||
==See also== | ==See also== |
Revision as of 16:15, 17 April 2006
We start from an example of SDK slightly modified :
<OpenOffice.org1.1_SDK>/examples/DevelopersGuide/Components/CppComponent
This example contains two files but I only use one file (and one service).
Contents
IDL File
Here is the corresponding IDL file :
// IDL #include <com/sun/star/uno/XInterface.idl> #include <com/sun/star/lang/XInitialization.idl> #include <com/sun/star/lang/XServiceName.idl> #include <com/sun/star/lang/XLocalizable.idl> #include <com/sun/star/sheet/XAddIn.idl> module my_module { interface XSomething : com::sun::star::uno::XInterface { string methodOne( [in] string val ); string methodTwo( [in] string val ); long methodThree( [in] sequence< sequence< long > > aValList ); sequence< sequence< long > > methodFour( [in] sequence< sequence< long > > aValList ); }; service MyService2 { interface XSomething; interface com::sun::star::lang::XInitialization; interface com::sun::star::lang::XServiceName; interface com::sun::star::sheet::XAddIn; }; };
Four method named methodOne, methodTwo, methodThree and methodFour will be implemented.
Implementing in C++ the four methods
We first give the C++ code of the four method presented in IDL file.
The two first Methods
The two first methods are similar :
OUString MyService2Impl::methodOne( OUString const & str ) throw (RuntimeException) { return OUString( RTL_CONSTASCII_USTRINGPARAM( "called methodOne() of MyService2 implementation: ") ) + m_arg + str; } OUString MyService2Impl::methodTwo( OUString const & str )throw (RuntimeException) { return OUString( RTL_CONSTASCII_USTRINGPARAM( "called methodTwo() of MyService2 implementation: ") ) + m_arg + str; }
They only take a string (from a OOoCalc Cell) and add a message and put all the message+string in the result cell.
The third Method
The third method is more complicated : it returns a value calculed from a cell range (the sum).
sal_Int32 MyService2Impl::methodThree(const Sequence< Sequence< sal_Int32 > > &aValList ) throw (RuntimeException) { sal_Int32 n1, n2; sal_Int32 nE1 = aValList.getLength(); sal_Int32 nE2; sal_Int32 temp=0; for( n1 = 0 ; n1 < nE1 ; n1++ ) { const Sequence< sal_Int32 > rList = aValList[ n1 ]; nE2 = rList.getLength(); const sal_Int32* pList = rList.getConstArray(); for( n2 = 0 ; n2 < nE2 ; n2++ ) { temp += pList[ n2 ]; } } return temp; }
The fourth Method
The goal of the fourth method is to show how we can implement a matrix function : starting from a cell range and obtaining a celle range.
//It's a matrix operation should be called like : {=METHODFOUR(A1:B4)} Sequence< Sequence< sal_Int32 > > MyService2Impl::methodFour(const Sequence< Sequence< sal_Int32 > > &aValList )throw (RuntimeException) { sal_Int32 n1, n2; sal_Int32 nE1 = aValList.getLength(); sal_Int32 nE2; Sequence< Sequence< sal_Int32 > > temp = aValList; for( n1 = 0 ; n1 < nE1 ; n1++ ) { Sequence< sal_Int32 > rList = temp[ n1 ]; nE2 = rList.getLength(); for( n2 = 0 ; n2 < nE2 ; n2++ ) { rList[ n2 ] += 4; } temp[n1]=rList; } return temp; }
What is done by this example is not great : only add four to every cells of the cell range. The code is not complete with this four method. If you want to create a component you have to add code, if you want to make a scriptable component you still add more code and if you want to create an AddIn you have to add more.
The complete Code
See also
- Add-in : adding OooCalc functions (Chapter 14 from UNO/C++ document) http://perso.wanadoo.fr/moutou/MyUNODoc_HTML/UNOCppAPI14.html
- Add-In in C++ http://www.oooforum.org/forum/viewtopic.phtml?t=29552
- How to add-in in OpenOffice.org Calc http://sc.openoffice.org/addin_howto.html
- service AddIn http://api.openoffice.org/docs/common/ref/com/sun/star/sheet/AddIn.html