1,784 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
-2
votes
1
answer
68
views
How to force block of text containing newlines not to straddle a page break [closed]
Version: 25.8.2.2 (X86_64) / LibreOffice Community
Build ID: 580(Build:2)
CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: CL threaded
In a ...
Advice
0
votes
3
replies
48
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 ...
0
votes
1
answer
78
views
Using LibreOffice portable to convert Excel to PDF in an ASP.NET Core Web API (IIS and IIS Express for development)
I had used LibreOffice portable a while back to convert documents to PDF and I cannot for the life of me figure out how to do it again.
Every time I run this in IIS Express for development I am ...
0
votes
1
answer
97
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
88
views
Cannot successfully create the simplest LibreOffice extension for UDF's
New here. Beginner with Python and LibreOffice. Some experience with C#.
OS: Win 11
LO: 25.8
I have been trying to learn how to create a LO extension to provide UDF's for use in LO Calc. I have dozens ...
0
votes
0
answers
75
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 ...
0
votes
1
answer
69
views
PAC validation erros when using libreoffice command line tools to export html as PDF/UA
I'm trying to export from HTML to PDF/UA using libreoffice command line tools with this command:
soffice --headless --convert-to 'pdf:writer_pdf_Export: {"SelectPdfVersion":{"type":...
-1
votes
2
answers
110
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) ...
0
votes
0
answers
88
views
How to reliably convert .docx (generated with docxjs) to PDF without breaking table column layout?
I'm generating a .docx file using docx (docxjs) in Node.js.
The document contains dynamic tables with multiple columns, some columns may contains image which change depending on the data, sometime it ...
-4
votes
2
answers
90
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 ...
2
votes
0
answers
84
views
Insert image from in-memory binary to ODT file LibreOffice
I want to replace a string in my ODT file with an image, but this image is from binary data, not a file. I don't want to write to temp file and load it, I want to purely do so in memory.
I have this ...
0
votes
1
answer
149
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 ...
2
votes
0
answers
170
views
How do I write to a VB6 byte array instead of to a filepath with UNO / LibreWriter API?
I use the following code to save my LibreWriter document to disk. It works fine:
Public Sub SaveToPath(ByRef oSM As Object, ByRef oDoc As Object, ByVal uFilepath As String)
Dim Args(0 To 1) As ...
0
votes
0
answers
48
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:...
0
votes
0
answers
54
views
cmake from WSL with LibreOffice
There is something weird happening in the interaction between libreoffice, cmake and wsl.
I have a bunch of ODT files in a directory and I'm trying to use cmake to generate a makefile which will ...