LibreOffice

501

Solutions

944

Contributors

LibreOffice is a free and open source office suite. The LibreOffice suite comprises programs for word processing, the creation and editing of spreadsheets, slideshows, diagrams and drawings, working with databases, and composing mathematical formulae. It is available in 110 languages. LibreOffice uses the international ISO/IEC standard OpenDocument file format as its native format to save documents for all of its applications. LibreOffice is also compatible with other major office suites through a variety of import/export filters. LibreOffice is available for a variety of computing platforms, including Windows, OS X) and Linux.

Share tech news, updates, or what's on your mind.

Sign up to Post

Hi,

I have a LibreOffice Calcs document, and with VBA, from a workshet, I would like to:
- Retrieve the used range of the worksheet.
- Iterate over cells in that used range.

Here is what I have done so far:
Dim openOffice As Object
Set openOffice = CreateObject("com.sun.star.ServiceManager")

Dim starDesktop As Object
Set starDesktop = openOffice.createInstance("com.sun.star.frame.Desktop")

Dim args(0) As Object
Set args(0) = openOffice.Bridge_Construct("com.sun.star.beans.PropertyValue")
args(0).name = "Hidden"
args(0).value = True

Dim doc As Object
Set doc = starDesktop.loadComponent.FromUrl("file://c:/temp/myDoc.ods", "_blank", 0, args)

Dim ws As Object
ws = doc.sheets().getByName("Sheet1")

    '// used range ??????????

Open in new window


NOTES:
The used range can be anywhere in the worksheet (doesn't necessary start with A1 cell).
0
Cloud Class® Course: Certified Penetration Testing
LVL 12
Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

I trade options.  At present I am entering each trade into a spreadsheet .  I can manipulate each individual trade rather easily but when I want to summarize data I have to determine each piece of data I need and what cell it is in and then manually create a summary function.  

Spreadsheets are good for certain things.  Databases are good at storing data for manipulation.

I want to store my trades in a database .  I chose MySql  because it is free.  I am using OpenOffice  calc as my spreadsheet .  I want to be able to export data from MySql  to OpenOffice  Calc .

I want to be able to create forms so I can view the data in the database .  

 I want to avoid using Microsoft products because I don't want to pay the license fees.  I am the only one who will use the data so I want to keep costs low.

From looking at many web pages I gather people are using PHP or Django to display and manipulate MySql  data and create forms.  

I am willing to spend some time to study but I am not going to be an expert programmer.  I have experience using SQL server and using SQL expressions.  I have some experience programming active server pages and ADO.

I have 2 computers both running Windows 7 pro.  They are networked together.  I plan to have one computer running MySql  and the other will be a client machine.

So what I want to do is:
Export data from MySql  to OpenOffice  Calc
Create forms so I can view data in the MySql  database
Print some reports.


QUESTIONS:
0
I am having problems with PDF files that come up as Libre Office Draw files and can see no way of saving or printing them. For example I am trying to download "The Complete Windows Networking Troubleshooting Guide" which is described as a PDF file but comes up as "https://www.offidocs.com/osessionx03/#/client/REVGQVVMVABjAGRlZmF1bHQ=" which is a Libre Office Draw file. I am running Windows 10 Pro and have never had this problem before as my PDF files always open in Adobe Reader. Can anyone please advise?
0
Hi...,
my code is compiling but not adding Header in Calc.
I`m having the problem getting the default header value in OpenOffice Calc 4.1.3.

please give me solution.. :(


   Object oHeader = xStyleProps.getPropertyValue("LeftPageHeaderContent");
            if (oHeader != null) {
               XHeaderFooterContent xHeader = (XHeaderFooterContent) UnoRuntime
                  .queryInterface(XHeaderFooterContent.class, oHeader);
                 
                 
               XText xText = (XText) UnoRuntime.queryInterface(XText.class,
                  xHeader.getCenterText());

               
               if (xText != null)
                  xText.setString("testing");
           
            }
0
LibreOffice Gallery
I was recently poking around with LibreOffice and figured out how easy it is to add great vector clip art to one's own LibreOffice gallery collection.
0
Adding awesome vector clipart to LibreOffice

I was recently poking around with LibreOffice and figured out how easy it is to add great vector clip art to ones LibreOffice gallery collection.  My experience with both LibreOffice and the site that provides so many awesome clip art images in vector and many other formats was so pleasant, I figured I would post this tutorial to give then both some love.

Step one in the tutorial is where we download the vector images we want to add to our gallery. This is where flaticon.com comes in.  They have over six hundred thousand icons - all of which you can download in multiple image formats including .png, .svg, .eps and .psd.  Many of the icons are available with their free account but you can get full access to a richer set of icons with their premium plans. Plans range from about $7.50 to $9.99 per month at the time of this writing. If you like their work, consider getting one of their premium plans.  

Gallery1.PNG  Gallery2.PNG











Once you are on flaticon.com, if you are a free user look for one of the icon packs with the [S] in the top left corner - this means the pack is available for free. Icon packs are saved as zip files by default, so you will need to unzip the folder to a familiar location on you hard drive such as Photos folder if you are using Windows - as I am in this tutorial.

With the folder unzipped, you are now ready to fire up LibreOffice. I am using LibreOffice Version: 5.3.4.2 (x64).



Gallery3.PNG
0
I am using LibreOffice Version: 5.4.4.2 (x64) and I can't seem to figure out what combination of keys I need to hold in conjuction with a left click of the mouse to open a hyperlink in a document.  I can see that the text has a link by hovering the mouse over the text as it then lists the link, but it would be helpful if I could just click on it and it worked as it should.  I just don't know how to do so.
0
Hi All,

I am using Libre Office Calc (Version 5.1.6.2) on a machine, and I want to be able to check part of a formula by evaluating it.

In Excel, you can select the part of the formula in the formula bar, press F9, and it will evaluate the result, replacing that section of the formula with the value (numeric, text, error or whatever), and leaving the remainder of the formula as it was.

How do I do that in Libre Office Calc?

Thanks,

Alan.
0
I am desperately trying to make LibreOffice work in my environment as my users already use a base version of Office Online Apps (The package does not come with the full Office Client) which is 99% effective for them. However, there are certain cases when they require a program local to their computer which I was hoping LibreOffice would be good enough to use. In most cases it seems to work fine. However, sometimes when their main program (An EMR application) spits out an XML file but instead of opening in Libre Office I get the following error:

LibreOffice 5.3.6.1 - General Error. General input/output error

It only happens with some reports for this application so I fear the problem is something specific to the applicaiton, and not LibreOffice. Still, I wanted to check to see if there was any setting anyone was aware of that I could make this work for me since, if there isn't, I'll probably have to bite the bullet and buy (or subscribe to) Microsoft Office.

I have included the error as a screen-shot. It's not much and if there's something specific about the reports the users are running that might be of assistance I can try to get that for you as well.

Thanks
ERROR-REPORT.PNG
0
I have numbered paragraphs in LibreOffice, see image. The paragraph tab stop is set to where the 2nd and following lines are shown. However, the 1st line is indented further than the rest of the paragraph. There is not tab-stop there. Format > Paragraph shows "Before Text:" = 0.31", "First Line:" = -0.31". Changing "First Line" moves the whole first line, including extra spacing. Change "Before Text" does nothing obvious. This is annoying. Is there a way to fix this?Indentation
0
Cloud Class® Course: Microsoft Exchange Server
LVL 12
Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

I am trying to implement Linux workstations in the office which means using LibreOffice instead of Word. While Writer renders .doc[x] files pretty well, my users face the problem that sometime Writer will paginate differently than Word; in particular if there are charts, tables or forms that fit on one page in Word, but get split over two pages in Writer. Users feel that this makes Writer unusable as people cannot reference e.g. "page 13" from the original Word document and have it show correctly when viewed with Writer.

Has anyone run into this? Is there a solution?
0
Hi,
I have a problem to open Access Database file, using Libre Base. Any advice?
0
Hi Experts,
This is a bit complicated question. I've got a table with english content which was composed originally on a probaly jewish environment using PowerPoint. I'm using Linux and the I opened the .pptx file in  LibreOffice Impress. Editing the text I got some strange phenomena.
The HOME is on the right, the END is on the left. The left arrow goes to the right and the right arrow goes to the left. The DEL deletes the right character.
My big problem is how appears the cell content.
Instead of the right "24 - 12 VDC" appears "VDC 24 - 12". As I press the END and the cursor is in the top left position, after clicking (without changing the position of the cursor) the cursor jumps behind the VDC  (right from char C) which the real end of the text is. The same happens when I click left from V.
After pressing END the cursor is blinking in the top left position in the row. As I drag the pressed mouse in the right direction the first selected character is the C.
Or start position is the the top left position in the row. 1x press on the right arrow the cursor jumps between D and C. One more press and goes between V and D. One more: jumps before 20 and one more: jumps behind 20.
When I am in  the the top left position in the row the DEL don't work but the BACKDEL (marked with left arrow) deletes the C.
When I delete the whole content and I write in the cell "24 - 12 VDC" the VDC jumps forward and appears "VDC 24 - 12".

Could somebody help me? Every answer appreciated.
0
Hi

I had this question after viewing Open office calc - Extract url from hyperlink..

As I have a lot of folder names inside the list of bookmarks thus the referenced version doesn't fully solve my problem but it did what it said.

I also tried the formula
= if (vartype=9,1,0) 

Open in new window

but got #name? as a result.

And
=oCell.GetTextFields.getByIndex(0).URL

Open in new window

as a formula result in Err 501.

Would be happy about clear and competent help (free of charge).

Klaus
0
I wish an open-source web cms-site to publish my portfolio (architecture). The sistem shall have configurable fields, and ideally the ability to set-up multi-multi relationships. I don't need social - users, etcetera, only catalog but the way I want. Html5+css3 output.
I would then like to access the same database with libreoffice to easilly retrive different projects for different curricula/portfolio (i.e. only hotels, or only over a certain budget) and format the information in different ways (information in tables, or in forms...).
I don't want to keep both a cv and a website repeating allways the same informations.
I have a small cms experience (old Modx), I was looking at Processwire and Boltcms, but could'nt find any based on firebird as libreoffice does. Wich would be a good solution?
Thank you
0
I have a cell with the date and time.  However, when I open the sheet the next day all dates change to current date.  What I want to do is either have a timestamp entered in another cell D1 when the day and time in C1 is entered.   Or - have a formula that timestamps instead of one that adds date and time so when I scan RFID chip number in A1 it time stamps in D1.
0
Can you have a macro automatically run when a Libre calc file is opened?
0
Hi, I want to use this code in Libre Calc as a macro.  It is VB.  Is that possible?  How can I change it so that it works in Calc?

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
   


Dim rCell As Range
    Dim rChange As Range
   
    On Error GoTo ErrHandler
    Set rChange = Intersect(Target, Range("A:A"))
    If Not rChange Is Nothing Then
        Application.EnableEvents = False
        For Each rCell In rChange
            If rCell > "" Then
                With rCell.Offset(0, 1)
                    .Value = Now
                    .NumberFormat = "hh:mm:ss"
                End With
            Else
                rCell.Offset(0, 1).Clear
            End If
        Next
    End If

ExitHandler:
    Set rCell = Nothing
    Set rChange = Nothing
    Application.EnableEvents = True
    Exit Sub
ErrHandler:
    MsgBox Err.Description
    Resume ExitHandler
End Sub
0
on a windows 10 PC - 64 bit; my client finds OFFICE too expensive while the stuent version is 149euro, and does NOT have Outlook - the home & Business that has outlook costs 269 Euro
i know i can install Open office, but it does not come with an outlook compatible progam

question : what softwares to choose for OFFICE and outlook
if possible - retain mail adress, and easy transfer of the existing pst file
0
Cloud Class® Course: C++ 11 Fundamentals
LVL 12
Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

I have exported Website data from Wordpress into a Linux LibreOffice  Calc file in CSV format (which cannot be opened with Calc), and then imported that CSV data  into the hosting database using PHP MyAdmin.  Is this a common method, and why is it downloading only 5 rows of data, when 7 rows appear on Wordpress Participants Database?
0
Could someone please help me with the following:

We have lots of vehicles and need to keep the "Road Tax Due Date" and "MOT Expiry Date" updated.

This information is available from the site https://www.vehicleenquiry.service.gov.uk/.

The parameters required are Vehicle Registration Number and Vehicle Make. These details are there in my excel worksheet.

How can I automate the updating of the "Road Tax due date" and the "MOT expiry date" to the respective vehicle in my excel list instead of manually browsing to the website, updating the form and copying and pasting the results to my excel sheet.

Automating this will save me a load of time and make it highly accurate.

Thanks
Alcuino
1
Hi,

I would like to know if ther is any formula to automatically assign the same correlative number to equal or repetitive codes.

For column  ORDEN is there any  formula to assing the same number to ORDEN for each equal Ordernumber as in this example?
That is ORDEN 1 for all repetied order 200001195
ORDEN 2 for all repeted order 200001198

ORDEN      Ordernumber
1      200001195
1      200001195
1      200001195
2      200001198
2      200001198
3      100005020
3      100005020
3      100005020
3      100005020

Thanks again
0
Hi,

I am trying to make a function (lookup or vlookup) in google drive calc that could search for a value on a column and if it find it return other value.
As in the test file atached  I would like to enter a value on J2 cell , to look for this value on range f2:f45 and if finded return the correspond value on range A2:A45.

Thank you !!
0
I have text from Word that I need to paste onto a PDF file, but I need the text upside down.

How do I do this?

Thanks
0
I am creating a flash card game with question on the front and the answer on the back of each card.

I want the text on the front to be larger, since it will contain less text than the back and it will need to be readable from across the table.

I need to fit as much as 100 characters, with spaces, centered on the outward face of the card.

What's a good font for this? I expect to use Black or dark blue on white to give a strong contrast.


On the backside, I may need as much as 275 characters, with spaces.

What's a good font for this? I will indeed use Black on white to give the strongest contrast ratio.


Thanks
0

LibreOffice

501

Solutions

944

Contributors

LibreOffice is a free and open source office suite. The LibreOffice suite comprises programs for word processing, the creation and editing of spreadsheets, slideshows, diagrams and drawings, working with databases, and composing mathematical formulae. It is available in 110 languages. LibreOffice uses the international ISO/IEC standard OpenDocument file format as its native format to save documents for all of its applications. LibreOffice is also compatible with other major office suites through a variety of import/export filters. LibreOffice is available for a variety of computing platforms, including Windows, OS X) and Linux.

Top Experts In
LibreOffice
<
Monthly
>