Getting started with UNO and Java with Open/LibreOffice

I just started to develop a Java project using LibreOffice's 4.0.1 UNO SDK, aaaand... I'm pretty much stuck right at the beginning. I think the same can be applied if I used OpenOffice.org instead...

Libreoffice calc: loop throught cells macro

I've been searching a lot but could find little to no info about LibreOffice Basic I'm a bit used to programming macros in excel but this time a need to do a loop until i reach the first empty...

How to insert different text with different format on each page in Libre Office Writer?

How can I add a different text to each header and footer of each page in LibreOffice Writer? If I edit the header of a page, the text automatically changes on the others. I want them to behave...

Rendering out new line properly in openpyxl generated XLSX file

I'm using openpyxl to open an .xlsx file, update some values in it and save it as a different .xlsx file. I am trying to add a footer with new lines in it: # example code wb =...

Convert pdf to docx using Libre Office,an error occurs

I try to convert pdf to docx with Libreoffice,and I use this method provided at Convert PDF to DOC (Python/Bash) ,the code is as follows: import os import subprocess for top, dirs, files in...

TCP SYN_SENT from LibreOffice Headless in Docker Container.

I'm trying to get LibreOffice to run in headless mode within a container so I can use it for document conversions on windows. Running LibreOffice locally via: C:\Program Files\LibreOffice...

How to embed a PDF in an HTML page?

I need to embed a PDF file in an HTML page for the users to see it on every major device. Most of the approaches work fine on desktop but they start to show problems on iPad devices. The PDFs are...

Read Xlsx file in PhpSpreadsheet

I want to read an xlsx file that was created in Microsoft Excel, but when I run the following code... $Source_File = "test.xlsx"; $Spreadsheet =...

python-docx : adding checkbox to .docx doesn't work

I want to add xml to my .docx document using python-docx library. I tried this code from stackoverflow but it doesn't work, I don't know why. I get nothing when opening the docx with LibreOffice...

Pharmacokinetics in Excel - how to account for multiple drug intakes?

As painful as it sounds, I've been tasked to implement a spreadsheet to calculate drug absorption and elimination half-life. I actually use LibreOffice Calc, but a solution tested in Excel would...

LibreOffice API/UNO: How to horizontal right-align text in table cell in writer

I'm using C++ to control LibreOffice/OpenOffice from another application, but I guess you can help me if you know the java-bridge as well. So basically I want to load a document (works), set the...

Using regex in LibreOffice Writer to appending a string to the next line results in a failure or full replacement instead

I am attempting to format a series of test questions for implementation to an online course in LibreOffice Writer. The test question format was changed recently and I have to update all 500+...

Is there a method for page numbering by chapter in LibreOffice Writer?

Writing a user-manual that is written in chapters, each describing a different aspect of the functions. Some of those functions are ready and closed, some still in development or ready but not...

Can't find LibreOffice or OpenOffice executable

Can you help me? When I try to use libre gem, I get the below error. But I already installed Libre office on my laptop and I am using win10, does it matter? IOError at /users/8/request Can't find...

Not able to perform cp command using execSync in aws lambda for lo.tar.gz file from /opt to /tmp

I have a requirement of converting doc files to pdf files, i have followed the instruction given in this link https://github.com/shelfio/libreoffice-lambda-layer and created a layer on aws lambda,...

How to build a custom report from Google Sheets

I've googled to find out a way to build reports from data spreadsheets and it seems google data studio and google sheets are an option to achieve that. Despite some experience on LibreOffice Calc,...

Copy and paste svg image to libreoffice writer using xclip

I am used to use xclip to copy/paste png files into libreoffice writer. The command I use is: xclip -selection clipboard -t "image/png" -i <path_to_file> Now, I want to copy/paste svg images, but...

Libreoffice API (UNO) : text and data from xTextField

How can I get xTextFields from .odt document properly? I tried something like that, but it doesn't work (Any returns a nullptr address): Reference <XTextFieldsSupplier> xTextFieldsSupplier...

python request.get response object to download xlsx file from url saves excel file but file is smaller and not accessible

Although I use stackoverflow regularly to solve problems, this is my first post :). I hope you can help! I have a link that automatically downloads a .xlsx file. You get directed to a simple...

Converting a simple Excel macro to LibreOffice Calc BASIC macro

I want to run the below Excel VBA code in LibreOffice BASIC on a Raspberry PI, what results in a BASIC-runtime-error '423' Cells. If I run the same VBA code on a different version of LibreOffice...

Using pandas module to assign an excel cell value to a variable [Python 3.8, Linux]

Foreword: I'd prefer to avoid lengthy processes if possible. As a beginner, one line with lots of syntax is a little overwhelming, if I need to use something similar, please give a basic note on...

How to get the row and column number of a cell using a LibreOffice Basic function

I would like to write a Libreoffice-Basic function that takes into account the row and column of the cell where the function is placed. I suppose my problem would be solved if I could define a...

Libre office Draw How to change font color of pdf form fillable text box

I hope i'm just missing something small, but i am unable to change the default font color of a form fillable text box in libreoffice Draw. My end goal is to convert a regular PDF to one that is...

About PostgreSQL with Django and CPanel

Django doesn't support earlier version of PostgreSQL, but CPanel doesn't support later version of PostgreSQL, running inspectdb makes faults. Somehow ended up with erased models.py I have Django...

libreoffice-convert not working in nodejs

So, I am using the libreoffice-convert, running in my nodejs application of course. My code as below const file = fs.readFileSync(enterPath); // Convert it to pdf format with undefined filter (see...

LibreOffice: recursively convert documents in folders and subfolders

I have stored many files in the doc format which I can only open with libreoffice on my mac. The command: ./soffice --headless --convert-to docx --outdir /home/user ~/Downloads/*.doc does...

Illegal instruction(core dumped) error on Jetson Nano

Sorry if my description is long and boring but I want to give you most important details to solve my problem. Recently I bought a Jetson Nano Developer Kit with 4Gb of RAM, finally!, and in order...

PhpWord output doesn't work in LibreOffice but works fine in MS Word

This relates to a semi-known issue listed on the GitHub page [link], where the way PhpWord generates tables causes it to set the cell width to "", which isn't valid in LibreOffice, but is fine in...

Docker / Python / LibreOffice: [Java framework] Error in function createSettingsDocument (elements.cxx). javaldx failed

I'm currently pretty stuck finding a solution for the following error: LibreOfficeError: [Java framework] Error in function createSettingsDocument (elements.cxx). javaldx failed! Warning: failed...

AWS Lambda Alpine Python Container shows IMAGE Launch error exec format error

I am writing a Lambda function to convert an excel file to PDF using unoconv with libreoffice, for this I am using alpine base image. The Dockerfile is as follows. # Define global args ARG...