Questions tagged [libreoffice]
LibreOffice (LibO) is a free and open source office suite, developed by The Document Foundation. It was forked from OpenOffice.org (OOo) in 2010.
libreoffice
1,768
questions
-4
votes
0
answers
27
views
Libreoffice Calc [closed]
Все строки объединяются в одну колонку. Это не зависит от содержимого файла или формата файла. У меня это работает как с xlsx, так и с csv.
libreoffice 24.2.4.2 322 latest/...
0
votes
0
answers
11
views
How to make multiple relationships between two tables in Libreoffice Base
I have a table with for a event and another table with a list of controls. The table with events can have multiple controls so I want to link the controls table to multiple values on the event table. ...
1
vote
0
answers
40
views
LibreOffice Macros: how to apply paragraph style for every line starting with a number
I'm doing some postprocessing of javascript output in LibreOffice Writer.
I'd like to apply a separate paragraph style for every line that:
starts with a number (like 01.)
is a list and starts with ...
1
vote
0
answers
43
views
Problem when trying to generate PDF files within Django with libreoffice
I have a Django application based on the 3.10.11-alpine3.16 image that runs in a docker container. When I check during the build if a sample PDF is generated, this will succeed, and I see that when ...
0
votes
0
answers
30
views
What is Ubuntu recommending that fixes Libreoffice convert to PDF problem?
Background. I am dockerizing my Django app. One thing it does is generate xlsx spreadsheets or pdf representations thereof. The sheet is generated by openpyxl, and if the user wants PDF the generated ...
0
votes
1
answer
38
views
Replacing one sheet with CSV in the current directory
I have a Data.ods file in which there is a sheet name stocks.I need to change this sheet frequently with another csv file in the current directory .I need to write a macro in Libre Office which asks ...
0
votes
0
answers
39
views
REF error in libreoffice calc, when trying to get address from another book
I need to get address from anoter book in LO calc. I do that in excell with success, but calc return me a ref error. I use 3 functions: match, index and cell.
calc
=CELL("address";INDEX('...
0
votes
0
answers
59
views
Issue running AWS Fargate with Next.js and Libreoffice
I'm attempting to convert an Excel file to a PDF using Next.js. When I run the script, I receive an error in my Cloudwatch that says that the soffice bin is not found. The which command in the ...
0
votes
0
answers
141
views
Converting docx to a PDF file in a lambda function in 2024
I am trying to find an updated way to convert docx and pptx files to PDF in Lambda in a long-term, sustainable manner. I am creating a data ingestion pipeline and Textract cannot work with docx or ...
0
votes
1
answer
35
views
How to modify LibreOffice user settings programmatically?
Is there a official (or at least convenient) API for changing LO's settings?
As part of automated install/update, I want to change user settings (and also LO system settings):
e.g. :
shortcut keys,
...
0
votes
1
answer
57
views
Count distinct values in a filtered list (Libre Office Calc)
I want to count distinct values (dates) in the range B23:B2000 in Libre Office Calc.
Additionally the result should change if a filter is applied.
The range B23:B2000 consists of real dates (e.g. in ...
1
vote
2
answers
51
views
Insert UserField into LibreOffice using API/Macro
i got task to write python script for LibreOffice (for Collabora online to be exact), which inserts userfield into document. I recorded macros in LibreOffice with needed actions
sub Main
rem ----------...
0
votes
1
answer
40
views
Calculate a running 7-day total in LibreOffice Calc, where dates may have multiple entries
How do I write a formula that I can copy and paste into a column in a LibreOffice Calc spreadsheet so that each cell displays a running 7-day total of the values in a different column. Column A ...
0
votes
1
answer
150
views
Is there a way to read/modify ODF files from C# without running Libreoffice in the background?
I've been looking into using the LibreOffice SDK to edit ODF files (Writer and Calc documents/ODS spreadsheets) and I was rather astounded when I came across this in the example source:
/** ...
0
votes
1
answer
64
views
How do I turn the first word in a cell into a hyperlink using a macro in LibreOffice Calc
I have a large spreadsheet and want to automate the process of converting the first word of each cell into a hyperlink, but keeping the rest of the text as it is. I.e. linktext appendedtext to be ...