Pages

▼

Monday, April 25, 2016

Tested the Libre Office software.

Today I tested Libre Office suite. The last version is 5.1.2.2 and has many features.
I like to used because I can export my work under Microsoft Office and also to open document.
You can download it from libreoffice official page.
This software can be used with many ope systems, like:
You have LibreOffice come with Impress, Calc , Writer, Math and Draw to deal with any type of issue.  I don't like for example the way to rename the macro. You need to go to : Tools -Macros -Organize Macros -LibreOffice Basic.. the Organizer button and finally double click to the name of the macros , rename and close. I think this come from permisions of the macros.
Also You can deal with macros what do you want. For example in this example I delete some fields from one document - one matrix make from A3 to B10.
  Dim myDoc As Object
  Dim mySheet As Object
  Dim myCell As Object
  Dim myRange As Object
  Dim myFlags As Long
 
  myDoc = ThisComponent
  mySheet = myDoc.Sheets(0) ' Refers to Sheet1 as in 0, 1, 2 etc
  myRange = mySheet.getCellRangeByName("A3:B10")
 
  myFlags = com.sun.star.sheet.CellFlags.VALUE + _
      com.sun.star.sheet.CellFlags.DATETIME + _
      com.sun.star.sheet.CellFlags.STRING + _
      com.sun.star.sheet.CellFlags.ANNOTATION + _
      com.sun.star.sheet.CellFlags.FORMULA + _
      com.sun.star.sheet.CellFlags.HARDATTR + _
      com.sun.star.sheet.CellFlags.STYLES + _
      com.sun.star.sheet.CellFlags.OBJECTS + _
      com.sun.star.sheet.CellFlags.EDITATTR
 
  myRange.clearContents(myFlags)
This is a simple type of macro using LibreOffice Basic language. You can also use Python , BeanShell, JavaScript.
So if you like this software and you want to survive this software, you can make a donation of at least 5 USD.

LibreOffice is Free Software and is made available free of charge. Your donation, which is purely optional, supports our worldwide community.If you like the software, please consider a donation.