Re: [sc-dev] OpenOffice 3.2 Calc adding bitmap image to a cell
Can you advice how to change the pivot point in the calc -macro? oLinked.RotateAngle=rot oLinked.Position=aPos oLinked.Pivot=aPos?? Does not work, since I don't know the internal structure's name... oLinked.Size=aSize oLinked.Name=sDie oDrawPage.add(oLinked) -- Jari On 08/11/10 18:04, Regina Henschel wrote: Hi Jari, Jari Kosonen schrieb: Dear Developers Team, I'm no developer. Can you advice how to add bitmap image into openoffice calc cell by using calc-macro (and no uno-type)? You cannot put an image _into_ a Calc cell, Calc cells can only hold strings, values, and formulas. You can only put an image on the associated draw page and anchor it to a cell. Kind regards Regina - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
Re: [sc-dev] OpenOffice 3.2 Calc adding bitmap image to a cell
Hi Jari, this is the wrong list for your questions. Macros belong to the udk or the api project and images belong to the graphics project. Kind regards Regina Jari Kosonen schrieb: Can you advice how to change the pivot point in the calc -macro? oLinked.RotateAngle=rot oLinked.Position=aPos oLinked.Pivot=aPos ?? Does not work, since I don't know the internal structure's name... oLinked.Size=aSize oLinked.Name=sDie oDrawPage.add(oLinked) -- Jari - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
Re: [sc-dev] OpenOffice 3.2 Calc adding bitmap image to a cell
Hi Jari, Jari Kosonen wrote (11-08-10 08:41) Dear Developers Team, (I am not a developer. Just a community member However, this list is for developer issues.) Can you advice how to add bitmap image into openoffice calc cell by using calc-macro (and no uno-type)? When image added to the calc cell, it should be scaled and rotated as well. I can not find help pages for this problem. You need quite some specific objects for that. Some of them: - drawpage where the picture is placed: thisComponent.Sheets(0).Drawpage - unoStructs for position and size createUnoStruct(com.sun.star.awt.Point) createUnoStruct(com.sun.star.awt.Size) and maybe functions to embed your graphics. Pls look at examples on the forums: http://www.oooforum.org/ http://user.services.openoffice.org/en/forum/ If you have further questions, you can be helped there or at the list d...@api.openoffice.org. Attached example shows how multiple images should be added in the calc-sheet. In general, attachments are stripped from the mails, so your one did not come true. I hope I gave you some suggestions in the right direction, Cor -- Your office 2010 software: the new OpenOffice.org Cor Nouws - ideas/remarks for the community council? - http://wiki.services.openoffice.org/wiki/Community_Council - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
Re: [sc-dev] OpenOffice 3.2 Calc adding bitmap image to a cell
Jari Kosonen wrote (11-08-10 10:43) I rather NOT use the UNO-service type... It requires possibly some structure (com.sun.star.*), but I can not find good help page how to use it. The examples I found by google, etc. searching were for Writer only (not for Calc). pls use the links I send. I know that info is there - I used it some years ago to build a function that does something in the direction you are looking for. But my work is rather mixed in other stuff, so not easy for me to cut and paste. Cor -- Your office 2010 software: the new OpenOffice.org Cor Nouws - ideas/remarks for the community council? - http://wiki.services.openoffice.org/wiki/Community_Council - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
Re: [sc-dev] OpenOffice 3.2 Calc adding bitmap image to a cell
I can find help for inserting graphic to calc: http://wiki.services.openoffice.org/wiki/Documentation/OOo3_User_Guides/Calc_Guide/Adding_graphics, but that is not including macro examples... On 08/11/10 17:50, Cor Nouws wrote: Jari Kosonen wrote (11-08-10 10:43) I rather NOT use the UNO-service type... It requires possibly some structure (com.sun.star.*), but I can not find good help page how to use it. The examples I found by google, etc. searching were for Writer only (not for Calc). pls use the links I send. I know that info is there - I used it some years ago to build a function that does something in the direction you are looking for. But my work is rather mixed in other stuff, so not easy for me to cut and paste. Cor - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
Re: [sc-dev] OpenOffice 3.2 Calc adding bitmap image to a cell
If inserted picture from file manually, it goes to selected cell. But I understand the object is actually free of cell borders. On 08/11/10 18:04, Regina Henschel wrote: Hi Jari, Jari Kosonen schrieb: Dear Developers Team, I'm no developer. Can you advice how to add bitmap image into openoffice calc cell by using calc-macro (and no uno-type)? You cannot put an image _into_ a Calc cell, Calc cells can only hold strings, values, and formulas. You can only put an image on the associated draw page and anchor it to a cell. Kind regards Regina - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org
Re: [sc-dev] OpenOffice 3.2 Calc adding bitmap image to a cell
Thanks. I found it by searching with drawpage. -- Jari On 08/11/10 18:04, Regina Henschel wrote: Hi Jari, Jari Kosonen schrieb: Dear Developers Team, I'm no developer. Can you advice how to add bitmap image into openoffice calc cell by using calc-macro (and no uno-type)? You cannot put an image _into_ a Calc cell, Calc cells can only hold strings, values, and formulas. You can only put an image on the associated draw page and anchor it to a cell. Kind regards Regina - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org - To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org For additional commands, e-mail: dev-h...@sc.openoffice.org