Javascript for LibreOffice scripting

Now, a js example to run in OO Calc:

importClass(Packages.com.sun.star.uno.UnoRuntime);
importClass(Packages.com.sun.star.sheet.XSpreadsheetDocument);
importClass(Packages.com.sun.star.container.XIndexAccess);
importClass(Packages.com.sun.star.table.XCellRange);
importClass(Packages.com.sun.star.table.XCell);
documentRef = XSCRIPTCONTEXT.getDocument();
spreadsheetInterface = UnoRuntime.queryInterface(XSpreadsheetDocument,
documentRef);
allSheets = UnoRuntime.queryInterface(XIndexAccess,
spreadsheetInterface.getSheets());
theSheet = allSheets.getByIndex(0);
Cells = UnoRuntime.queryInterface(XCellRange,theSheet);
cellA1 = Cells.getCellByPosition(0,0);
theCell = UnoRuntime.queryInterface(XCell,cellA1);
theCell.setFormula("Hello World");
// https://wiki.documentfoundation.org/images/f/f0/CG6212-CalcMacros.pdf

 

And here the result:


 

Comments

Post a Comment

Popular posts from this blog

How to fix Android when developer options are not available for this user

Image
I have an Android One with Oreo version and suddenly my Android rebooted and after that it started to behave strangely: 1) Notification section doesn't work. I can't see notifications from my apps and the arrow and the screw icon to settings access don't work. 2) As I can't access to the notification area, I can't enable Use USB to Transfer Files to access to my phone memory. 3) I can't access to developer mode (I before active it with a lot of taps over Build number). Clicking on developer options just shows developer options are not available to this user. 4) I can't update or install the apps on google play. They freeze on Download pending... message 5) Home and Switch buttons don't work. They light up and vibrate when I tap them but they do nothing. This issue is apparently related to a deconfiguration of user accounts. To fix it, you need re-setup the users. As you can't access to the user manager (you are in guest mode ...
Read more

Contiki 3.0 on XM1000

Image
In other post, I installer contiki 3.x on xm1000. Now, we going to install contiki 3.0 (the lastest version). First, you need to dowload the lastest code from github: git clone https://github.com/contiki-os/contiki.git Now we need to add xm1000 compatibility to our contiki. Thanks to DMI   for the xm1000 patch. Without it, you will see the following error: make: *** No rule to make target 'obj_xm1000/cc2420.o', needed by 'contiki-xm1000.a'.  Stop. I upgrade his patch with an app to access to the xm1000 sensors. Download it from https://drive.google.com/file/d/0B7NXiwmWq7jCb3ROSFZZSWliMnc/view?usp=sharing Now, extract it into contiki folder: tar xzvf xm1000.tar.gz cd xm1000 cp -R * $YOUR_CONTIKI_PATH Go to the apps folder and execute an script that I create to automate the process: cd $YOUR_CONTIKI_PATH/platform/xm1000/apps/sensors ./install.sh Enjoy it!
Read more

How to fix VirtualBox error when you try to import an ova file

If you download an ova file to import it to Virtualbox, maybe you will see the following message: Failed to import appliance filename.ova. Seeking within the archive failed (VERR_TAR_UNEXPECTED_EOS). Result Code: VBOX_E_IPRT_ERROR (0x80BB0005) Component: ApplianceWrap Interface: IAppliance {8398f026-4add-4474-5bc3-2f9f2140b23e} If you do it the same throught VBoxManage you will get: # VBoxManage import filename.ova  Progress state: VBOX_E_IPRT_ERROR VBoxManage: error: Appliance import failed VBoxManage: error: Seeking within the archive failed (VERR_TAR_UNEXPECTED_EOS) VBoxManage: error: Details: code VBOX_E_IPRT_ERROR (0x80bb0005), component ApplianceWrap, interface IAppliance VBoxManage: error: Context: "RTEXITCODE handleImportAppliance(HandlerArg*)" at line 877 of file VBoxManageAppliance.cpp To fix it, you must extract ova content and compress again as follows: tar xvf filename.ova tar cvf newfilename.ova filename.ovf filename.vmdk Also, you can i...
Read more