e-mail message format
Can anyone tell me which format i need to use for e-mailing to a...@openoffice.org. p.s.: MS Outlook 2007
RE: test
test message 3<неи<неи-Original Message-<неиFrom: K.Misha [mailto:mi...@4k.com.ua] <неиSent: Friday, September 27, 2013 7:12 PM<неиTo: api@openoffice.apache.org<неиSubject: RE: test<неи<неиtest message 2<неи<неи-Original Message-<неиFrom: K.Misha<неи[mailto:mi...@4k.com.ua] <неиSent: Friday, September 27, 2013 7:11 PM<неиTo:<неиapi@openoffice.apache.org<неиSubject: test<неи<неиtest message<неи1<неи<неи<неи<неи ---<неи--<неиTo unsubscribe, e-mail:<неиapi-unsubscr...@openoffice.apache.org<неиFor additional commands, e-mail:<неиapi-h...@openoffice.apache.org<неи<неи<неи<неи<неи--- --<неиTo unsubscribe, e-mail: api-unsubscr...@openoffice.apache.org<неиFor additional commands, e-mail: api-h...@openoffice.apache.org<неи<неи - To unsubscribe, e-mail: api-unsubscr...@openoffice.apache.org For additional commands, e-mail: api-h...@openoffice.apache.org
RE: test
test message 2<неи<неи-Original Message-<неиFrom: K.Misha [mailto:mi...@4k.com.ua] <неиSent: Friday, September 27, 2013 7:11 PM<неиTo: api@openoffice.apache.org<неиSubject: test<неи<неиtest message 1<неи<неи<неи<неи--- --<неиTo unsubscribe, e-mail: api-unsubscr...@openoffice.apache.org<неиFor additional commands, e-mail: api-h...@openoffice.apache.org<неи<неи - To unsubscribe, e-mail: api-unsubscr...@openoffice.apache.org For additional commands, e-mail: api-h...@openoffice.apache.org
test
test message 1<неи - To unsubscribe, e-mail: api-unsubscr...@openoffice.apache.org For additional commands, e-mail: api-h...@openoffice.apache.org
LibOpenOffice library
Good day! Our company has developed a library to automate Apache OpenOffice - http://4k.com.ua/products/others/libopenoffice I would like to know whether there is an opportunity to advertise this product at http://www.openoffice.org/ ? Or with whom I could discuss ways of cooperation? Thank you!
*.docx in OpenOffice 4.0
Hi, Andrew. OpenOffice4.0 opens *.docx format. And if we will watch "MRI Uno object inspector tool" we will see that Args is: Name stringFilterName Handlelong 0 Value any MS Word 2007 XML State .beans.PropertyState DIRECT_VALUE Value is "MS Word 2007 XML". I will test OpenOffice4.0 if it can work with *.docx(writing in this format) and reply to you. Maybe it will be useful for you and other people who use OO SDK. p.s: Language: MS Visual Studio (C++);
*.docx
I distribute OpenOffice in Ukraine. A lot of people ask me if OpenOffice will be working with *.docx extension. Will be?
inspector.oxt
When i'm installing "Object inspector" i have this error: Can you help me with this error? Maybe i have to install Java platform or something else? OS: Win 7 x64 Thanks!
Find\replace in writer
Hello! What interface i need to use to find\replace text in writer documet? Or i need to write it by hands like this: rtl::OUString uText = xText->getString(); rtl::OString str = rtl::OUStringToOString( uText, RTL_TEXTENCODING_MS_1251 ); string s = str.getStr(); int iPos = s.find("@@ADRESS_HOUSE@@"); string s1 = "@@ADRESS_HOUSE@@"; Reference xTextCursor = xText->createTextCursor(); xTextCursor->goRight(iPos, 0); xTextCursor->goRight(s1.length(), 1); xTextCursor->setString(wVal); // wVal = "some string" Thanks!
Change text in writer without changing style and formats
One more question... before changing text i have this: Reference < XTextDocument > xTextDocument (xWriterComponent,UNO_QUERY); Reference< XText > xText = xTextDocument->getText(); rtl::OUString uText = xText->getString(); rtl::OString str = rtl::OUStringToOString( uText, RTL_TEXTENCODING_MS_1251 ); char * str1 = (char *) str.getStr(); Reference < XTextDocument > xTextDocument (xWriterComponent,UNO_QUERY); Reference< XText > xText = xTextDocument->getText(); int nLenOfWideCharStr = MultiByteToWideChar( CP_ACP, MB_PRECOMPOSED, str1, -1, NULL, 0 ); const wchar_t * wVal = (PWSTR)HeapAlloc(GetProcessHeap(), 0, nLenOfWideCharStr * sizeof(WCHAR)); MultiByteToWideChar( CP_ACP, MB_PRECOMPOSED, str1, -1, (wchar_t *)wVal, nLenOfWideCharStr ); Reference xTextCursor = xText->createTextCursor(); xTextCursor->goRight(iStartAt, 0); xTextCursor->setString(wVal); after this code all tables and other styles were deleted. How can i change text without deleting it?
convert OUString to char *
I have this code, made with your example: char * getWText( char * text ) { Reference < XTextDocument > xTextDocument (xWriterComponent,UNO_QUERY); Reference< XText > xText = xTextDocument->getText(); rtl::OUString uText = xText->getString(); rtl::OString str = rtl::OUStringToOString( uText, RTL_TEXTENCODING_UTF8 ); char * str1 = (char *)str.getStr(); return str1; } This is original file: And this is my return str1: What i'm doing wrong? =(
convert rtl::OUString to char *
Hi! I habe this code: Reference < XTextDocument > xTextDocument (xWriterComponent,UNO_QUERY); Reference< XText > xText = xTextDocument->getText(); How can i convert xTextDocument->getText() to char * ? I used to convert it like this: int nLenOfAnsiChar = WideCharToMultiByte(CP_OEMCP, NULL, xText->getString().pData->buffer, -1, NULL, 0, NULL, NULL ); char * str = new char(nLenOfAnsiChar); WideCharToMultiByte(CP_OEMCP, NULL, xText->getString().pData->buffer, nLenOfAnsiChar, str, nLenOfAnsiChar, NULL, NULL ); I converted it from unicode to ansi. But when i'm doing it in writer - i have broken data. I think data here is in ANSI. Thanks!
Change column property in XTextTable
Code in attached file makes TextTable like this: But how i can make table like this: Thanks. <><> #include #include #include /** === begin UNO includes === **/ #include #include #include #include #include #include #include #include #include #include #include #include #include #include #include #include #include #include #include #include #include #include #include /** === end UNO includes === **/ /** === begin UNO using === **/ using ::com::sun::star::beans::PropertyValue; using ::com::sun::star::beans::XPropertySet; using ::com::sun::star::chart::XChartData; using ::com::sun::star::chart::XChartDataArray; using ::com::sun::star::chart::XChartDocument; using ::com::sun::star::document::XEmbeddedObjectSupplier; using ::com::sun::star::frame::XComponentLoader; using ::com::sun::star::lang::XComponent; using ::com::sun::star::lang::XMultiComponentFactory; using ::com::sun::star::lang::XMultiServiceFactory; using ::com::sun::star::sheet::XCellRangeData; using ::com::sun::star::sheet::XCellRangeData; using ::com::sun::star::table::XCell; using ::com::sun::star::table::XTableRows; using ::com::sun::star::text::TableColumnSeparator; using ::com::sun::star::text::XText; using ::com::sun::star::text::XTextContent; using ::com::sun::star::text::XTextCursor; using ::com::sun::star::text::XTextDocument; using ::com::sun::star::text::XTextTable; using ::com::sun::star::text::XTextTableCursor; using ::com::sun::star::uno::Any; using ::com::sun::star::uno::Exception; using ::com::sun::star::uno::Reference; using ::com::sun::star::uno::RuntimeException; using ::com::sun::star::uno::Sequence; using ::com::sun::star::uno::UNO_QUERY_THROW; using ::com::sun::star::uno::UNO_QUERY_THROW; using ::com::sun::star::uno::XComponentContext; using ::com::sun::star::uno::XInterface; using ::com::sun::star::uno::makeAny; /** === end UNO using === **/ using namespace std; using rtl::OUString; namespace ControlCharacter = ::com::sun::star::text::ControlCharacter; int SAL_CALL main( int argc, char *argv[] ) { try { // bootstrap the office Reference< XComponentContext > rContext ( ::cppu::bootstrap() ); Reference< XMultiComponentFactory > rMCF = rContext->getServiceManager(); // instantiate the Desktop and get a reference to XComponentLoader Reference < XComponentLoader > rComponentLoader( rMCF->createInstanceWithContext( OUString( RTL_CONSTASCII_USTRINGPARAM( "com.sun.star.frame.Desktop" ) ), rContext ), UNO_QUERY_THROW ); // load a new empty OOo Writer document Reference< XTextDocument > rTextDocument ( rComponentLoader->loadComponentFromURL( OUString( RTL_CONSTASCII_USTRINGPARAM( "private:factory/swriter" ) ), OUString( RTL_CONSTASCII_USTRINGPARAM( "_blank" ) ), 0, Sequence < ::com::sun::star::beans::PropertyValue >() ), UNO_QUERY_THROW ); // get the XText interface Reference< XText > rText = rTextDocument->getText(); // create a text cursor Reference< XTextCursor > rTextCursor = rText->createTextCursor(); rTextCursor->gotoStart( sal_False ); // insert a paragraph brake rText->insertControlCharacter( rTextCursor->getEnd(), ControlCharacter::PARAGRAPH_BREAK, sal_False ); // get the document's factory Reference< XMultiServiceFactory > rDocFactory ( rTextDocument, UNO_QUERY_THROW ); // create a text table Reference< XTextTable > rTextTable ( rDocFactory->createInstance( OUString( RTL_CONSTASCII_USTRINGPARAM( "com.sun.star.text.TextTable" ) ) ), UNO_QUERY_THROW ); // initalize it with 5 rows and 6 columns rTextTable->initialize( sal_Int32( 5 ), sal_Int32( 6 ) ); // insert it in the document rText->insertTextContent( rTextCursor->getEnd(), ( Reference< XTextContent > & ) rTextTable , sal_False ); // data OUString ustrJan ( RTL_CONSTASCII_USTRINGPARAM( "January" ) ); OUString ustrFeb ( RTL_CONSTASCII_USTRINGPARAM( "February" ) ); OUString ustrMar ( RTL_CONSTASCII_USTRINGPARAM( "March" ) ); OUString ustrApr ( RTL_CONSTASCII_USTRINGPARAM( "April" ) ); OUString ustrMay ( RTL_CONSTASCII_USTRINGPARAM( "May" ) ); OUString ustrJohn ( RTL_CONSTASCII_USTRINGPARAM( "John" ) ); OUString ustrPaula ( RTL_CONSTASCII_USTRINGPARAM( "Paula" ) ); OUString ustrAlan ( RTL_CONSTASCII_USTRINGPARAM( "Alan" ) ); OUString ustrDean ( RTL_CONSTASCII_USTRINGPARAM( "Dean" ) ); Any aRow0[6] = { Any(), makeAny( ustrJan ), makeAny( ustrFeb ), makeAny( ustrMar ), makeAny( ustrApr ), makeAny( ustrMay ) }; Any aRow1[6] = { makeAny( ustrJohn ), makeAny( 5.4 ), makeAny( 6.4 ), makeAny( 3.4 ), makeAny( 5.6 ), makeAny( 9.4 ) }; Any aRow2[6] = { makeAny(
inserting images in writer
Hello! Can you send me some examples of using images in writer? p.s.: *.cxx if you can. Thanks!
RE: Change column property in XTextTable
Thanks!<неи<неи-Original Message-<неиFrom: Peter Eberlein [mailto:pet@refofd.verwalt-berlin.de] <неиSent: Thursday, September 19, 2013 5:24 PM<неиTo: api@openoffice.apache.org<неиSubject: Re: Change column property in XTextTable<неи<неиHi,<неиAm 19.09.2013 13:36, schrieb K.Misha:<неи> Hello!<неи><неи><неи><неи> I have this code:<неи><неи><неи><неи> Reference < XTextDocument > xTextDocument (xWriterComponent,UNO_QUERY);<неи><неи> Reference< XModel > aDrawDoc (xTextDocument, UNO_QUERY);<неи><неи> Reference aFact(aDrawDoc,UNO_QUERY);<неи><неи> Reference< XTextTable > xTextTable(<неи> aFact->createInstance(OUString::createFromAscii("com.sun.star.text.TextTable <неи> ")), UNO_QUERY);<неи><неи><неи><неи> xTextTable->initialize(4,4);<неи><неи><неи><неи> Reference xText = xTextDocument->getText();<неи><неи> Reference xTextRange = xText->getStart();<неи><неи> Reference xTextContent(xTextTable, UNO_QUERY);<неи><неи><неи><неи> xText->insertTextContent( xTextRange, xTextContent, 0 );<неи><неи><неи><неи> Reference xTableColumns = xTextTable->getColumns();<неи><неи> Any rCol = xTableColumns->getByIndex(0);<неи><неи><неи><неи> Reference< XPropertySet > xPropSet2(rCol, UNO_QUERY);<неи><неи> Any mPropVal1 <<= makeAny((unsigned short)150);<неи><неи><неи><неи> But here i have an error:<неи><неи> xPropSet2->setPropertyValue(OUString(RTL_CONSTASCII_USTRINGPARAM("Width")),< неи> mPropVal1);<неи><неи><неи><неи> Can you help me with changing column properties in text table?<неи><неи<неиyou have to use the com.sun.star.text.TableColumnSeparator.<неи<неиIn Java this can look like this:<неи<неиXTextTablesSupplier xTablesSupplier = (XTextTablesSupplier) <неиUnoRuntime.queryInterface(XTextTablesSupplier.class, xTextDocument);<неиXTextTable xTextTable = (XTextTable) <неиUnoRuntime.queryInterface(XTextTable.class, <неиxTablesSupplier.getTextTables().getByName("Table1"));<неиXPropertySet xPropertySet = (XPropertySet) <неиUnoRuntime.queryInterface(XPropertySet.class, xTextTable);<неиcom.sun.star.text.TableColumnSeparator[] sep = (TableColumnSeparator[]) <неиxPropertySet.getPropertyValue("TableColumnSeparators");<неиsep[0].Positi on = 1000;<неиxPropertySet.setPropertyValue("TableColumnSeparators", sep);<неи<неиRegards<неи<неиPeter<неи<неи--- --<неиTo unsubscribe, e-mail: api-unsubscr...@openoffice.apache.org<неиFor additional commands, e-mail: api-h...@openoffice.apache.org<неи<неи - To unsubscribe, e-mail: api-unsubscr...@openoffice.apache.org For additional commands, e-mail: api-h...@openoffice.apache.org
Change column property in XTextTable
Hello! I have this code: Reference < XTextDocument > xTextDocument (xWriterComponent,UNO_QUERY); Reference< XModel > aDrawDoc (xTextDocument, UNO_QUERY); Reference aFact(aDrawDoc,UNO_QUERY); Reference< XTextTable > xTextTable( aFact->createInstance(OUString::createFromAscii("com.sun.star.text.TextTable ")), UNO_QUERY); xTextTable->initialize(4,4); Reference xText = xTextDocument->getText(); Reference xTextRange = xText->getStart(); Reference xTextContent(xTextTable, UNO_QUERY); xText->insertTextContent( xTextRange, xTextContent, 0 ); Reference xTableColumns = xTextTable->getColumns(); Any rCol = xTableColumns->getByIndex(0); Reference< XPropertySet > xPropSet2(rCol, UNO_QUERY); Any mPropVal1 <<= makeAny((unsigned short)150); But here i have an error: xPropSet2->setPropertyValue(OUString(RTL_CONSTASCII_USTRINGPARAM("Width")), mPropVal1); Can you help me with changing column properties in text table? Thanks!
RE: insert image into calc document
Thanks a lot!<неи<неи-Original Message-<неиFrom: Ariel Constenla-Haile [mailto:arie...@apache.org] <неиSent: Thursday, August 08, 2013 6:51 AM<неиTo: api@openoffice.apache.org<неиSubject: Re: insert image into calc document<неи<неиHi,<неи<неиOn Mon, Aug 05, 2013 at 07:21:28PM +0300, K.Misha wrote:<неи> I have a problem with inserting image into calc document!<неи> <неи> I'm doing it this way:<неи> rColProps->setPropertyValue(OUString(RTL_CONSTASCII_USTRINGPARAM("Grap<неи> rColProps->hicURL")), makeAny(sstring));<неи<неиIf you want the image embedded inside the document, instead of linked, do not use the "GraphicURL" property, use "Graphic". This property requires an instance of com.sun.star.graphic.XGraphic. You can get one using the service com.sun.star.graphic.GraphicProvider<неи<неиSee attached code.<неи<неи<неиRegards<неи--<неиAriel Constenla-Haile<неиLa Plata, Argentina<неи - To unsubscribe, e-mail: api-unsubscr...@openoffice.apache.org For additional commands, e-mail: api-h...@openoffice.apache.org
RE: insert image into calc document
Sorry, but i don't know english very well and i can't express my opinion in an affordable manner.<неиI want to leave image in file body of calc document. Code that i wrote here only leaves a link to image like 'D:\image.jpeg'.<неиBut i want to insert image how it insert OpenOffice.org. <неи<неиCan you help me in this question?<неи<неиThanks.<неи<неи-Original Message-<неиFrom: Andrew Douglas Pitonyak [mailto:and...@pitonyak.org] <неиSent: Tuesday, August 06, 2013 6:58 PM<неиTo: api@openoffice.apache.org<неиSubject: Re: insert image into calc document<неи<неиInteresting question<неи<неиWhen you insert your image into the document, it then has an internal <неиURL. The question is how to remove the image from the GUI and leave <неиit in the file.<неи<неи<неиOn 08/05/2013 12:21 PM, K.Misha wrote:<неи> <неи><неи> From: K.Misha [mailto:mi...@4k.com.ua]<неи> Sent: Monday, August 05, 2013 7:21 PM<неи> To: 'oo...@openoffice.com'<неи> Subject: insert image into calc document<неи><неи> <неи><неи> Hello!<неи><неи> <неи><неи> I have a problem with inserting image into calc document!<неи><неи> I'm doing it this way:<неи><неи> <неи><неи> void insertImage( imgPosition iPos, imgSize iSize, char * imgUrl )<неи><неи> {<неи><неи> Reference< com::sun::star::drawing::XDrawPagesSupplier ><неи> xDrawPagesSupplier(xCalcComponent, UNO_QUERY);<неи><неи>Reference< XDrawPages > xDrawPages(<неи> xDrawPagesSupplier->getDrawPages(), UNO_QUERY );<неи><неи>Reference< XDrawPage > xDrawPage( xDrawPages->getByIndex(irSheet),<неи> UNO_QUERY );<неи><неи> Reference< XShapes > xShapes(xDrawPage, UNO_QUERY);<неи><неи> <неи><неи> com::sun::star::awt::Point imgPoint;<неи><неи> com::sun::star::awt::Size imgSize;<неи><неи> <неи><неи> imgSize.Height = iSize.h;<неи><неи>imgSize.Width = iSize.w;<неи><неи> imgPoint.X = iPos.x;<неи><неи> imgPoint.Y = iPos.y;<неи><неи>the size in 100/th mm<неи><неи> <неи><неи>Reference xSheetDocument<неи> (xCalcComponent,UNO_QUERY);<неи><неи> Reference< XModel > aDrawDoc (xSheetDocument, UNO_QUERY);<неи><неи> Reference aFact(aDrawDoc,UNO_QUERY);<неи><неи> Reference< XShape > xShape(<неи> aFact->createInstance(OUString::createFromAscii("com.sun.star.drawing.Graphi <неи> cObjectShape")), UNO_QUERY);<неи><неи>//Reference< XShape > xShape( xShapes->getByIndex(0), UNO_QUERY);<неи><неи> <неи><неи> Reference rColProps(xShape, UNO_QUERY);<неи><неи> <неи><неи> char * img = imgUrl;//"file:///D:/getImage3.jpeg";<неи><неи>int nLenOfWideCharStr<неи> =MultiByteToWideChar(CP_ACP,MB_PRECOMPOSED,img,-1,NULL,0);<неи><неи> wchar_t *cImg = (PWSTR)HeapAlloc(GetProcessHeap(), 0,<неи> nLenOfWideCharStr * sizeof(WCHAR));<неи><неи> <неи> MultiByteToWideChar(CP_ACP,MB_PRECOMPOSED,img,-1,cImg,nLenOfWideCharStr);<не и><неи> <неи><неи>OUString sstring = cImg;<неи><неи> <неи><неи> <неи> rColProps->setPropertyValue(OUString(RTL_CONSTASCII_USTRINGPARAM("GraphicURL <неи> ")), makeAny(sstring));<неи><неи> <неи> //rColProps->setPropertyValue(OUString(RTL_CONSTASCII_USTRINGPARAM("Name")), <неи> makeAny(sstring));<неи><неи> <неи><неи> xShape->setPosition(imgPoint);<неи><неи> xShape->setSize(imgSize);<неи><неи>xDrawPage->add(xShape);<неи><неи> }<неи><неи> <неи><неи> //<неи><неи> But every time when i open this calc document, image must be in this path -<неи> imgUrl. How can i insert image into file body of calc document?<неи><неи> <неи><неи> Thanks!<неи><неи><неи<неи-- <неиAndrew Pitonyak<неиMy Macro Document: http://www.pitonyak.org/AndrewMacro.odt<неиInfo: http://www.pitonyak.org/oo.php<неи<неи<неи-- ---<неиTo unsubscribe, e-mail: api-unsubscr...@openoffice.apache.org<неиFor additional commands, e-mail: api-h...@openoffice.apache.org<неи<неи - To unsubscribe, e-mail: api-unsubscr...@openoffice.apache.org For additional commands, e-mail: api-h...@openoffice.apache.org
insert image into calc document
From: K.Misha [mailto:mi...@4k.com.ua] Sent: Monday, August 05, 2013 7:21 PM To: 'oo...@openoffice.com' Subject: insert image into calc document Hello! I have a problem with inserting image into calc document! I'm doing it this way: void insertImage( imgPosition iPos, imgSize iSize, char * imgUrl ) { Reference< com::sun::star::drawing::XDrawPagesSupplier > xDrawPagesSupplier(xCalcComponent, UNO_QUERY); Reference< XDrawPages > xDrawPages( xDrawPagesSupplier->getDrawPages(), UNO_QUERY ); Reference< XDrawPage > xDrawPage( xDrawPages->getByIndex(irSheet), UNO_QUERY ); Reference< XShapes > xShapes(xDrawPage, UNO_QUERY); com::sun::star::awt::Point imgPoint; com::sun::star::awt::Size imgSize; imgSize.Height = iSize.h; imgSize.Width = iSize.w; imgPoint.X = iPos.x; imgPoint.Y = iPos.y; the size in 100/th mm Reference xSheetDocument (xCalcComponent,UNO_QUERY); Reference< XModel > aDrawDoc (xSheetDocument, UNO_QUERY); Reference aFact(aDrawDoc,UNO_QUERY); Reference< XShape > xShape( aFact->createInstance(OUString::createFromAscii("com.sun.star.drawing.Graphi cObjectShape")), UNO_QUERY); //Reference< XShape > xShape( xShapes->getByIndex(0), UNO_QUERY); Reference rColProps(xShape, UNO_QUERY); char * img = imgUrl;//"file:///D:/getImage3.jpeg"; int nLenOfWideCharStr =MultiByteToWideChar(CP_ACP,MB_PRECOMPOSED,img,-1,NULL,0); wchar_t *cImg = (PWSTR)HeapAlloc(GetProcessHeap(), 0, nLenOfWideCharStr * sizeof(WCHAR)); MultiByteToWideChar(CP_ACP,MB_PRECOMPOSED,img,-1,cImg,nLenOfWideCharStr); OUString sstring = cImg; rColProps->setPropertyValue(OUString(RTL_CONSTASCII_USTRINGPARAM("GraphicURL ")), makeAny(sstring)); //rColProps->setPropertyValue(OUString(RTL_CONSTASCII_USTRINGPARAM("Name")), makeAny(sstring)); xShape->setPosition(imgPoint); xShape->setSize(imgSize); xDrawPage->add(xShape); } // But every time when i open this calc document, image must be in this path - imgUrl. How can i insert image into file body of calc document? Thanks!
insert image into calc document
Hi! Regina, I have understood how to do it. It's a sample of code: Reference< com::sun::star::drawing::XDrawPagesSupplier > xDrawPagesSupplier(xCalcComponent, UNO_QUERY); Reference< XDrawPages > xDrawPages( xDrawPagesSupplier->getDrawPages(), UNO_QUERY ); Reference< XDrawPage > xDrawPage( xDrawPages->getByIndex(0), UNO_QUERY ); Reference< XShapes > xShapes(xDrawPage, UNO_QUERY); com::sun::star::awt::Point imgPoint; com::sun::star::awt::Size imgSize; imgSize.Height = h*10; imgSize.Width = w*10; imgPoint.X = x*10; imgPoint.Y = y*10; the size in 10/th mm Reference xSheetDocument (xCalcComponent,UNO_QUERY); Reference< XModel > aDrawDoc (xSheetDocument, UNO_QUERY); Reference aFact(aDrawDoc,UNO_QUERY); Reference< XShape > xShape( aFact->createInstance(OUString::createFromAscii("com.sun.star.drawing.Graphi cObjectShape")), UNO_QUERY); Reference rColProps(xShape, UNO_QUERY); char * img = imgUrl;//"file:///D:/getImage3.jpeg"; int nLenOfWideCharStr = MultiByteToWideChar( CP_ACP, MB_PRECOMPOSED, img, -1, NULL, 0 ); wchar_t *cImg = (PWSTR)HeapAlloc(GetProcessHeap(), 0, nLenOfWideCharStr * sizeof(WCHAR)); MultiByteToWideChar( CP_ACP, MB_PRECOMPOSED, img, -1, cImg, nLenOfWideCharStr ); OUString sstring = cImg; rColProps->setPropertyValue(OUString(RTL_CONSTASCII_USTRINGPARAM("GraphicURL ")), makeAny(sstring)); xShape->setPosition(imgPoint); xShape->setSize(imgSize); xDrawPage->add(xShape); }
RE: insert image into calc
<неи<неи-Original Message-<неиFrom: Regina Henschel [mailto:rb.hensc...@t-online.de] <неиSent: Friday, May 10, 2013 7:15 PM<неиTo: api@openoffice.apache.org<неиSubject: Re: insert image into calc<неи<неиHi,<неи<неиk.misha schrieb:<неи> Hello!<неи><неи> I have this code:<неи><неи> Reference< com::sun::star::drawing::XDrawPagesSupplier ><неи> xDrawPagesSupplier(xCalcComponent, UNO_QUERY);<неи><неи> Reference< XDrawPages > xDrawPages( xDrawPagesSupplier->getDrawPages(),<неи> UNO_QUERY );<неи><неи> Reference< XDrawPage > xDrawPage( xDrawPages->getByIndex(0), UNO_QUERY );<неи><неи> Reference< XShapes > xShapes(xDrawPage, UNO_QUERY);<неи><неи><неи><неи> com::sun::star::awt::Point imgPoint;<неи><неи> com::sun::star::awt::Size imgSize;<неи><неи><неи><неи> imgSize.Height = 5000;<неи><неи> imgSize.Width = 25000;<неи><неи> imgPoint.X = 6500;<неи><неи> imgPoint.Y = 8100;<неи><неи><неи><неи> Reference xSheetDocument (xCalcComponent,UNO_QUERY);<неи><неи> Reference< XModel > aDrawDoc (xSheetDocument, UNO_QUERY);<неи><неи> Reference aChartDoc;<неи><неи> Reference aFact(aDrawDoc,UNO_QUERY);<неи><неи> Reference< XShape > xShape(<неи> aFact->createInstance(OUString::createFromAscii("com.sun.star.drawing.OLE2Sh<неи> ape")), UNO_QUERY);<неи><неи><неи><неи> xShape->setPosition(imgPoint);<неи><неи> xShape->setSize(imgSize);<неи><неи> xDrawPage->add(xShape);<неи><неи><неи><неи> This code inserts empty ole object into calc document with my imgSize and<неи> imgPoint.<неи<неиAs far as I see, it inserts only a shape. You have to set the property <неиCLSID to create the chart document itself. For a chart it is <неиCLSID="12DCAE26-281F-416F-a234-c3086127382e"<неи<неи><неи> But how can I set the image for this ole object?<неи<неиYou have to set the chart type and fill the data table or the reference <неиto the data range of the spreadsheet. That should be in Model.<неи<неи><неи> Something like this:<неи><неи> xShape->SetUrl("C:\\1.png") or xShape->SetImage("C:\\1.png").<неи<неиI think, the picture should be generated automatically, but I'm not sure <неиwhether a kind of update/refresh is necessary.<неи<неиKind regards<неиRegina<неи<неи<неи<неи-<неиTo unsubscribe, e-mail: api-unsubscr...@openoffice.apache.org<неиFor additional commands, e-mail: api-help@ope<неи<неи<неиRegina, I have understood how to do it.<неиIn documentation of service with wich I initialize XShape are some properties. <неиUsing XPropertySet and setPropertyValue I set option for XShape like UrlPath.<неиAfter this in empty image object appears real image path of wich I set.<неиIf you need this code, tell me please.<неи<неиRegards.<неи
insert image into calc
Hello! I have this code: Reference< com::sun::star::drawing::XDrawPagesSupplier > xDrawPagesSupplier(xCalcComponent, UNO_QUERY); Reference< XDrawPages > xDrawPages( xDrawPagesSupplier->getDrawPages(), UNO_QUERY ); Reference< XDrawPage > xDrawPage( xDrawPages->getByIndex(0), UNO_QUERY ); Reference< XShapes > xShapes(xDrawPage, UNO_QUERY); com::sun::star::awt::Point imgPoint; com::sun::star::awt::Size imgSize; imgSize.Height = 5000; imgSize.Width = 25000; imgPoint.X = 6500; imgPoint.Y = 8100; Reference xSheetDocument (xCalcComponent,UNO_QUERY); Reference< XModel > aDrawDoc (xSheetDocument, UNO_QUERY); Reference aChartDoc; Reference aFact(aDrawDoc,UNO_QUERY); Reference< XShape > xShape( aFact->createInstance(OUString::createFromAscii("com.sun.star.drawing.OLE2Sh ape")), UNO_QUERY); xShape->setPosition(imgPoint); xShape->setSize(imgSize); xDrawPage->add(xShape); This code inserts empty ole object into calc document with my imgSize and imgPoint. But how can I set the image for this ole object? Something like this: xShape->SetUrl("C:\\1.png") or xShape->SetImage("C:\\1.png"). Thanks!
insert image ino calc doc
Hi! How I need to initialize XShapes and XShape interfaces? Reference< XShapes > xShapes(?); Reference< XShape > xShape(?); Thanks!
insert image in calc document using VS C++
Hi! Do you some examples in VS C++ how to insert image into calc document? Reference< com::sun::star::drawing::XDrawPagesSupplier > xDrawPagesSupplier(?); xDrawPagesSupplier->getDrawPages(); How I need to initialize xDrawPagesSupplier? Because I have an error when xDrawPagesSupplier->getDrawPages(); Thanks!
RE: OO SDK
Thanks a lot!<неиDo you have any examples in VS C++?<неи<неи<неи-Original Message-<неиFrom: Ariel Constenla-Haile [mailto:arie...@apache.org] <неиSent: Wednesday, May 08, 2013 6:58 PM<неиTo: api@openoffice.apache.org<неиSubject: Re: OO SDK<неи<неиHi k. misha,<неи<неиOn Wed, May 08, 2013 at 02:56:31PM +0300, k.misha wrote:<неи> Hi!<неи> <неи> <неи> <неи> How I can insert Image to a calc document using oo sdk 3.4.1?<неи<неи(Side note: please use descriptive subjects in the mails, something like "Inserting image in Calc")<неи<неиEach spreadsheet is described here:<неиhttp://www.openoffice.org/api/docs/common/ref/com/sun/star/sheet/Sp readsheet.html<неи<неиAs you can see, it supports ::com::sun::star::drawing::XDrawPageSupplier<неиThen:<неи<неи- access a spreadsheet<неи- get the draw page for this spreadsheet<неи- create a com.sun.star.drawing.GraphicObjectShape at the document<неи factory, set its size, position and graphic URL/css.graphic.XGraphic<неи- add the shape to the draw page.<неи<неиSample code in Basic:<неи<неиREM * BASIC *<неи<неиSub Main<неиDim oDoc as Object<неиoDoc = StarDesktop.loadComponentFromURL(_<неи"private:factory/scalc",_<неи "_default",_<неи0,_<неиArray())<неи<неиDim oGraphic as Object<неиDim oGraphicProvider as Object<неиoGraphicProvider = CreateUnoService(_<неи"com.sun.star.graphic.GraphicProvider")<неи Dim aArgs(0) as new com.sun.star.beans.PropertyValue<неиaArgs(0).Name = "URL"<неиaArgs(0).Value = "private:graphicrepository/framework/res/backing.png"<неиoGraphic = oGraphicProvider.queryGraphic(aArgs)<неи<неиIf IsNull(oGraphic) OR oGraphic.getType() = com.sun.star.graphic.GraphicType.EMPTY Then<неи Exit Sub<неиEnd If<неиDim oSize100thMM as Object<неиoSize100thMM = oGraphic.Size100thMM<неиIf oSize100thMM.Width = 0 OR oSize100thMM.Height = 0 Then<неиDim oSizePixel as Object<неи oSizePixel = oGraphic.SizePixel<неиIf oSizePixel.Width = 0 OR oSizePixel.Height = 0 Then<неиExit Sub<неиEnd If<неи Dim oUnitConversion as Object<неиoUnitConversion = oDoc.getCurrentController().getFrame().getContainerWindow()<неи oSize100thMM = oUnitConversion.convertSizeToLogic(oSizePixel,com.sun.star.util.MeasureUnit. MM_100TH)<неиEnd If<неи<неиDim oSheets as Object<неиDim oSheet as Object<неиoSheets = oDoc.getSheets()<неиIf NOT oSheets.hasElements() Then<неи'ToDo insert one<неиExit Sub<неиEnd If<неиoSheet = oSheets.getByIndex(0)<неи<неиDim oDrawPage as Object<неиoDrawPage = oSheet.getDrawPage()<неи<неи Dim oGraphicShape as Object<неиoGraphicShape = oDoc.createInstance("com.sun.star.drawing.GraphicObjectShape")<неи<неи Dim oPoint as new com.sun.star.awt.Point<неиoPoint.X = 5000<неи oPoint.Y = 200<неи<неиWith oGraphicShape<неи .setPosition(oPoint)<неи.setSize(oSize100thMM)<неи.Graphic = oGraphic<неиEnd With<неиoDrawPage.add(oGraphicShape)<неиEnd Sub<неи<неи<неиRegards<неи--<неиAriel Constenla-Haile<неиLa Plata, Argentina<неи - To unsubscribe, e-mail: api-unsubscr...@openoffice.apache.org For additional commands, e-mail: api-h...@openoffice.apache.org
OO SDK
Hi! How I can insert Image to a calc document using oo sdk 3.4.1? Thanks.
RE: UNP API
Very funny, Joe =)<неи<неи<неи-Original Message-<неиFrom: JOE CONNER [mailto:joeconner2...@gmail.com] <неиSent: Wednesday, April 10, 2013 8:16 PM<неиTo: api@openoffice.apache.org<неиSubject: Re: UNP API<неи<неиOn 04/10/2013 03:34 AM, k.misha wrote:<неи> Hi!<неи><неи> How can I select a sheet in calc document?<неи><неи> Thanks!<неи><неи><неиJust click on the tab at the bottom.<неи<неи-- Joe Conner, Poulsbo, WA USA<неи<неи- <неиTo unsubscribe, e-mail: api-unsubscr...@openoffice.apache.org<неиFor additional commands, e-mail: api-h...@openoffice.apache.org<неи<неи - To unsubscribe, e-mail: api-unsubscr...@openoffice.apache.org For additional commands, e-mail: api-h...@openoffice.apache.org
UNP API
Hi! How can I select a sheet in calc document? Thanks!
RE: UNO API
Hi! I have a code:<неи<неиReference< ::com::sun::star::sheet::XSpreadsheetDocument > xSpreadsheetDocument(xCalcComponent, UNO_QUERY);<неиReference< ::com::sun::star::sheet::XSpreadsheets > xSpreadsheets = xSpreadsheetDocument->getSheets();<неиReference< ::com::sun::star::container::XNameAccess > xNameAccess(xSpreadsheets, UNO_QUERY);<неи<неиSequence< OUString > sElementNames = xNameAccess->getElementNames();<неи<неиI want to get a list of sheets in document. How I can see it using printf("%s", variable)?<неи<неиThanks!<неи - To unsubscribe, e-mail: api-unsubscr...@openoffice.apache.org For additional commands, e-mail: api-h...@openoffice.apache.org
RE: uno api problem
I already fixed this problem this way:<неи<неиint nLenOfWideCharStr =<неи MultiByteToWideChar(<неиCP_ACP,<неи MB_PRECOMPOSED,<неиfontName,<неи-1,<неи NULL,<неи0<неи);<неи<неи wchar_t *cFontName = (PWSTR)HeapAlloc(GetProcessHeap(), 0, nLenOfWideCharStr * sizeof(WCHAR));<неи<неи MultiByteToWideChar(<неиCP_ACP,<неи MB_PRECOMPOSED,<неиfontName,<неи-1,<неиcFontName,<неи nLenOfWideCharStr<неи);<неи<неи OUString sstring = cFontName;<неи<неи rColProps->setPropertyValue(OUString(RTL_CONSTASCII_USTRINGPARAM("CharFontName")), makeAny(sstring));<неи<неиThanks :)<неи<неи<неи-Original Message-<неиFrom: jg [mailto:j...@jgoettgens.de] <неиSent: Saturday, April 06, 2013 3:15 PM<неиTo: api@openoffice.apache.org<неиSubject: Re: uno api problem<неи<неиThis might also work:<неи<неиxPropertySet->setPropertyValue(L"CharFontName", makeAny(OUString((const <неиsal_Unicode *)L"Corbel")));<неи<неиOr, if the value is not a constant (MFC):<неи<неиCStringW value;<неи...<неиOUString value((const sal_Unicode *)((LPCWSTR)value));<неиxPropertySet->setPropertyValue(L"CharFontName", Any(value));<неи<неи<неи<неиjg<неи<неи-<неиTo unsubscribe, e-mail: api-unsubscr...@openoffice.apache.org<неиFor additional commands, e-mail: api-h...@openoffice.apache.org<неи<неи
uno api problem
Hi! I have some problems using UNO API! I have this example: Int x = 0; Int y = 1; Char * fontName = "Corbel"; Reference< XSpreadsheet > rSpSheet (rSheet, UNO_QUERY); Reference< XCell > rCell = rSpSheet->getCellByPosition(x, y); Reference< XPropertySet > xPropSet(rCell, UNO_QUERY); OUString sstring = OUString(RTL_CONSTASCII_USTRINGPARAM(fontName)); xPropSet->setPropertyValue(OUString(RTL_CONSTASCII_USTRINGPARAM("CharFontNam e")), makeAny(sstring)); But when I look into a cacl document, there is wrong value in cell(0,1). I's "Cor". But must be "Corbel". Can you help me and show where I'm wrong? Thanks.
RE: UNO API
Hi! I build C++ project and connected to OpenOffice service. I used a code from example "DocumentLoader"!<неиI wrote some functions like SetText(), SetBold(), GetText() which are working with OO Calc. I used examples in wiki to build my project and write functions. But I can't find more examples or documentations to work with more interfaces and write more useful functions =(<неи<неи-Original Message-<неиFrom: Shukla, Mangesh [mailto:mangesh.shu...@siemens.com] <неиSent: Tuesday, April 02, 2013 1:39 PM<неиTo: api@openoffice.apache.org<неиSubject: RE: UNO API<неи<неиHi Misha,<неиHave you succeeded in setting up the build environment using the scripts. Are you able to build the C++ samples given in the SDK. I ask this, because it is important that you follow the steps mentioned in the wiki. http://wiki.openoffice.org/wiki/SDKInstallation<неи<неиHere you will also find instructions to build the C++ samples under VC++ .<неи<неиOnce you are able to do this, let me know if you have any specific query on the use of UNO Api's.<неи<неиThanks,<неиMangesh.<неи<неи-Original Message-<неиFrom: k.misha [mailto:mi...@4k.com.ua] <неиSent: Tuesday, April 02, 2013 4:01 PM<неиTo: api@openoffice.apache.org<неиSubject: RE: UNO API<неи<неиBut where can I get some examples in visual studio C++? That documentation don't have enough examples =(<неи<неи-Original Message-<неиFrom: Andreas Säger [mailto:ville...@t-online.de] <неиSent: Tuesday, April 02, 2013 1:06 PM<неиTo: api@openoffice.apache.org<неиSubject: Re: UNO API<неи<неи-BEGIN PGP SIGNED MESSAGE-<неиHash: SHA1<неи<неиAm 02.04.2013 12:00, k.misha wrote:<неи> http://wiki.openoffice.org/wiki/Documentation/DevGuide/OpenOffice.org_Developers_Guide<неи<неиThis<неи> page is empty!<неи<неи-<неи<неиThis page is far from empty. It contains lots of text with an index to<неиthousands of documentation pages covering each and every aspect.<неи<неи-BEGIN PGP SIGNATURE-<неиVersion: GnuPG v1.4.11 (GNU/Linux)<неиComment: Using GnuPG with undefined - http://www.enigmail.net/<неи<неиiQEcBAEBAgAGBQJRWq2SAAoJEGTlfXWiA5oe3AYIAIGRa5YHm+15dnarzkZn3PSb<неиVOM8GiRPLh+TzaXwGixtAgpO9PVgDZumHCEbPNBXMf5yjKOHdqz1NxiF84+HWvmK<неи8TCOuJg8tuQ2fKjaRALu+cB9/tfHviSFWeKJ3EXx6kMsN3w5fCzGBSuFdklIYSBI<неиLi2LtVQ1BtIKV6oLUIxZ+rjM9w4CU+5I6Y+s7AnlW1JHGAirGSzehXmUhpdhUNib<неиxqHjQKQpSfrr5bbKM2dJVRL9a92G6q/bpVhEQnlGvMJtVTb9ccK7sdo9X/2n8aky<неиJAunOebYotihDNANgAjMX0MUQRpeTSJitIoKhrREZIxo2Pcj0H4wFZb2tub3Oj8=<неи=Za7H<неи-END PGP SIGNATURE-<неи<неи-<неиTo unsubscribe, e-mail: api-unsubscr...@openoffice.apache.org<неиFor additional commands, e-mail: api-h...@openoffice.apache.org<неи<неи<неи<неи<неи-<неиTo unsubscribe, e-mail: api-unsubscr...@openoffice.apache.org<неиFor additional commands, e-mail: api-h...@openoffice.apache.org<неи<неи<неи---<неи ssi,-i inbrepoi.aer<неиrdtn mn,-i ie@efcac.g<неи - To unsubscribe, e-mail: api-unsubscr...@openoffice.apache.org For additional commands, e-mail: api-h...@openoffice.apache.org
RE: UNO API
But where can I get some examples in visual studio C++? That documentation don't have enough examples =(<неи<неи-Original Message-<неиFrom: Andreas Säger [mailto:ville...@t-online.de] <неиSent: Tuesday, April 02, 2013 1:06 PM<неиTo: api@openoffice.apache.org<неиSubject: Re: UNO API<неи<неи-BEGIN PGP SIGNED MESSAGE-<неиHash: SHA1<неи<неиAm 02.04.2013 12:00, k.misha wrote:<неи> http://wiki.openoffice.org/wiki/Documentation/DevGuide/OpenOffice.org_Developers_Guide<неи<неиThis<неи> page is empty!<неи<неи-<неи<неиThis page is far from empty. It contains lots of text with an index to<неиthousands of documentation pages covering each and every aspect.<неи<неи-BEGIN PGP SIGNATURE-<неиVersion: GnuPG v1.4.11 (GNU/Linux)<неиComment: Using GnuPG with undefined - http://www.enigmail.net/<неи<неиiQEcBAEBAgAGBQJRWq2SAAoJEGTlfXWiA5oe3AYIAIGRa5YHm+15dnarzkZn3PSb<неиVOM8GiRPLh+TzaXwGixtAgpO9PVgDZumHCEbPNBXMf5yjKOHdqz1NxiF84+HWvmK<неи8TCOuJg8tuQ2fKjaRALu+cB9/tfHviSFWeKJ3EXx6kMsN3w5fCzGBSuFdklIYSBI<неиLi2LtVQ1BtIKV6oLUIxZ+rjM9w4CU+5I6Y+s7AnlW1JHGAirGSzehXmUhpdhUNib<неиxqHjQKQpSfrr5bbKM2dJVRL9a92G6q/bpVhEQnlGvMJtVTb9ccK7sdo9X/2n8aky<неиJAunOebYotihDNANgAjMX0MUQRpeTSJitIoKhrREZIxo2Pcj0H4wFZb2tub3Oj8=<неи=Za7H<неи-END PGP SIGNATURE-<неи<неи-<неиTo unsubscribe, e-mail: api-unsubscr...@openoffice.apache.org<неиFor additional commands, e-mail: api-h...@openoffice.apache.org<неи<неи - To unsubscribe, e-mail: api-unsubscr...@openoffice.apache.org For additional commands, e-mail: api-h...@openoffice.apache.org
RE: UNO API
http://wiki.openoffice.org/wiki/Documentation/DevGuide/OpenOffice.org_Developers_Guide<неи<неиThis page is empty!<неи<неи-Original Message-<неиFrom: Andreas Säger [mailto:ville...@t-online.de] <неиSent: Tuesday, April 02, 2013 12:56 PM<неиTo: api@openoffice.apache.org<неиSubject: Re: UNO API<неи<неи-BEGIN PGP SIGNED MESSAGE-<неиHash: SHA1<неи<неиAm 02.04.2013 11:45, k.misha wrote:<неи> Hi!<неи> <неи> <неи> <неи> Could someone give me some examples for working with UNO API in<неи> Visual Studio C++!<неи> <неи> p.s.: And some documentation if you have.<неи> <неи> <неи> <неи> Thanks!<неи> <неи> <неи<неи> http://wiki.openoffice.org/wiki/Documentation/DevGuide/OpenOffice.org_Developers_Guide<неи-BEGIN PGP SIGNATURE-<неиVersion: GnuPG v1.4.11 (GNU/Linux)<неиComment: Using GnuPG with undefined - http://www.enigmail.net/<неи<неиiQEcBAEBAgAGBQJRWqsbAAoJEGTlfXWiA5oedlsH/jyuEl8tJAgKZul1MHV9fiF2<неиcYS/Rf4/+s1v9FT7DkVZvlKhnucxVjGp0Y/1KIya7jX0YHVD5pKd4skglcBws5P/<неи3kmrbLcmEY+i+wAT9uTzqe+ix0hUrA8ZzFT4BYHmhTCizaQsD7Chrf9BPg/sIzN+<неиuSCtu0Tsufi3tKrgQbMKi2mjucCYAPzfqmAGm+VngA62uz8E8nkCdBGqzD+1rpiW<неиJ+JxbRI2MSne4nnSmHWiSm9G0jOuy0+UDU0c/HJQGns4K/1CpJz7siGlWOpSY9Kd<неиH7NMZJ117KTdr8bt2yL0k8pLWXaXZhoUrLkVqeZaEnBytZuGbobk7OMWsiuYojU=<неи=AhyI<неи-END PGP SIGNATURE-<неи<неи-<неиTo unsubscribe, e-mail: api-unsubscr...@openoffice.apache.org<неиFor additional commands, e-mail: api-h...@openoffice.apache.org<неи<неи - To unsubscribe, e-mail: api-unsubscr...@openoffice.apache.org For additional commands, e-mail: api-h...@openoffice.apache.org
UNO API
Hi! Could someone give me some examples for working with UNO API in Visual Studio C++! p.s.: And some documentation if you have. Thanks!
FW: help
From: k.misha [mailto:mi...@4k.com.ua] Sent: Wednesday, March 13, 2013 2:02 AM To: 'api@openoffice.apache.org' Subject: help Hello! Can you help me to start with OpenOffice SDK? I installed OOO and OOO SDK. Do you have some examples for working with OOO SDK? I watch example in forum, but that example does not work with OOO SDK 3.4.1. That example for OOO SDK 3.3.0. Help me, please, if you can! p.s.: working with OOO sdk in visual studio 2008 C++.