LibreOffice

501

Solutions

949

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

I have a spreadsheet in LibreOffice Calc that includes an image at the top of every sheet. However, now there is no image but merely a pathname to the image which is no longer valid.

Is it possible to redirect this pathname so that it points to the new location of the image?

How do I embed the image so that it does not need the image to be held in a particular location?

Thank you
0
Get your problem seen by more experts
LVL 12
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

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
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 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
Can you have a macro automatically run when a Libre calc file is opened?
0
I have two separate column of number sets.  I want to compare the two and come up with a 3rd column set of numbers from column A that don't have any of the sets of numbers in column B.

Thanks
0

LibreOffice

501

Solutions

949

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
>