1,784 questions
Advice
0
votes
3
replies
31
views
LibreOffice OLE automation
I am using C++ builder for OLE automation in MS Excel. I now need to implement support for LibreOffice Calc. The following code works well in MS Excel. It is inserting an array of strings into ...
- 69
0
votes
1
answer
67
views
LibreOffice Writer: how to prevent a single table row (“widow row”) from moving to the next page?
In LibreOffice Writer, when a table spans multiple pages, sometimes only the very last row is pushed onto the next page.
This creates a single “widow row” on the new page, which looks ugly and reduces ...
0
votes
0
answers
70
views
How do I set visibility of sheet, row or column?
Setting visibility of sheets, rows or columns does not work using XPropertySet::setPropertyValue(). It does not throw an exception or anything, it just does not change the property value.
I am not ...
-1
votes
2
answers
97
views
Query for "grouping" rows
I'm trying to set up a query that would display the data in a certain way, but I can't manage it.
Tables:
CREATE TABLE T_EMPLOYEES (
EMP_ID INTEGER IDENTITY NOT NULL,
EMP_LASTNAME VARCHAR (32) ...
- 63
-4
votes
2
answers
81
views
Using COUNTIF to check for duplicates?
I am using Nextcloud Forms to have students write comments. They use the same form every week, and it all gets put into one big spreadsheet. (There are 101 students.) Because of the simple nature of ...
- 7
0
votes
1
answer
114
views
Redraw images in Libre Office Calc via basic macro
I want to write a macro which reloads all images inserted in a Calc document. I've heard of linking images, but I don't know the specific commands in LibreOffice Basic. So far the best answer I've got ...
0
votes
0
answers
41
views
Manipulating Annotation on Spreadsheet Libreoffice in SDK c#
How can I use Libreoffice XSheetAnnotationShapeSupplier in c# to change the size?
This line:
XSheetAnnotationShapeSupplier xShapeSupplier = (XSheetAnnotationShapeSupplier)xSpreadsheet;
Error generated:...
- 1
-1
votes
1
answer
143
views
Adding custom shortcut for Libre-office
I wonder if there is any keyboard shortcut available for the menu bar item Data -> Text to Columns..
I looked into various online resources like the below one, however could not find anything ...
- 3,896
1
vote
1
answer
46
views
Where do table cells get their CharHeight from in LibreOffice Writer
In a Libre Office Writer text document, i would like to reset all explicitely applied font size settings, both in text paragraphs as well as in tables.
For paragraphs i can find such explicit settings ...
- 1,264
0
votes
0
answers
40
views
How to filter column 1 using column 2?
I have a libreoffice document filled with multiple columns, including one named customerid. These customer ID appear multiple times each, as this is a raw data log.
I isolated around 50 customer id of ...
- 1
0
votes
1
answer
137
views
Libreoffice excel to pdf conversion problem
When I am trying to run this code on an excel document:
import subprocess
subprocess.run(['libreoffice', '--headless', '--convert-to', 'pdf',
'test_docs/doc.xls', '--outdir', '...
- 41
0
votes
0
answers
170
views
How to use a LibreOfficeKit GTK+ widget in QtCreator
I am trying to make Linux application in Qt Creator with LibreOfficeKitGtk widget, from usual QT project with widgets template.
In main.cpp I added a GTK initialization:
#include <gtk/gtk.h>
...
- 97
0
votes
0
answers
45
views
IllegalArgumentException error when try to connect to linux libreOffice with java BootstrapSocketConnector
I use the libreOffice class DocumentConverter to convert .odt to .pdf.
In local, with windows libreOffice (24.2.4.2 LibreOffice Community) its works, but in Linux Enviroment (Preproduction) it give me ...
- 7
2
votes
3
answers
176
views
How can import package-numpy for libreoffice's macro to call python?
"numpy" is installed in for libreoffice24.8:
ls /opt/libreoffice24.8/program | grep numpy
numpy
numpy-2.2.2.dist-info
numpy.libs
Edit a test python script for macro in libreoffice24.8 to ...
- 375
1
vote
1
answer
440
views
JODConverter throws error messages - Entity: line 1: parser error : Document is empty. But it does its job
I am using JODConverter from my web application. Even though it does its job such as converting MS Office files into PDF, the error messages make me worried if I need to do something about it.
...
- 141
0
votes
0
answers
68
views
How to export search results using Find and Replace in LibreOffice Calc
We have an ODS file with two spreadsheets. (Picture 1)
We are able to use ‘Find All’ to locate cells containing the string ‘Steve’. (Picture 2)
However, we are unable to copy them. Because they are on ...
- 522
0
votes
1
answer
45
views
Generate Id with macro in LibreOffice
I have a CSV with the following structure:
ID290;ID11;..\Phase2-fusionner_dossiers\Dossiers\TA30\Dossier n° 1300254\T30_1300254_69402_accuse reception courrier.pdf;..\Phase2-fusionner_dossiers\...
- 57
0
votes
1
answer
124
views
Create a PDF/UA compliant PDF from an ODT with LibreOffice & Python UNO
Please consider the following example:
import uno
def create_pdf(file_url):
local_context = uno.getComponentContext()
resolver = local_context.ServiceManager.createInstanceWithContext(
...
- 631
0
votes
0
answers
30
views
How to programmatically add a frame in LibreOffice Writer?
How do you programmatically (in content.xml ??) add to a odt document a frame of style "MyFrameStyle" with content x ?
context: pandoc lua filter
- 6,513
0
votes
1
answer
34
views
Incrementing row reference after 3 iterations
I'm having trouble trying to solve how to run this function =IF($Page1.C3<>"",G2+1,"") the function is working but for a easy replicate I need for the C row to increment by ...
- 1
0
votes
2
answers
174
views
LibreOffice command works directly from terminal but doesn't work from code
I currently have this command that already works directly from terminal, as I mentioned in the title, but doesn't work it when I use it from my code.
lowriter --invisible --headless --convert-to pdf:...
- 605
0
votes
0
answers
187
views
libreoffice xlsx to pdf get Unspecified Application Error
I use
soffice --convert-to 'pdf:calc_pdf_Export:{"SinglePageSheets":{"type":"boolean","value":"true"}}' a.xlsx
to convert xlsx to pdf, but I got ...
0
votes
2
answers
191
views
Removing all but the first letter of every word using regex in LibreOffice Writer [duplicate]
I have found a couple posts around the internet and on here on how to remove all but the first letter of every word in a paragraph (or the whole text) using regex and Microsoft Word, but nothing has ...
- 49
0
votes
1
answer
152
views
XSSFWorkbook.lockStructure() not working when opening generated XLSX file with LibreOffice
I'm creating a protected XLSX file like this:
XSSFWorkbook wb = new XSSFWorkbook();
wb.lockStructure();
wb.setWorkbookPassword(PASSWORD, null);
When I open the file generated by Excel, I check that ...
- 564
-1
votes
1
answer
37
views
Implementing a Custom “Whole Sheet Export” via UNO API to Preserve Hyperlinks in PDFs
When the “whole sheet export” option is enabled during the PDF export process in Calc,
the hyperlinks in the exported PDF do not preserve their original URLs and instead show local file paths.
...
- 8,375