1,784 questions
0
votes
0
answers
84
views
How do I get Excel to accept 'textjoin' or 'concat' from NodeJs?
I can get Excel to take formula from NodeJS. Sums are fine. If Statements are fine. Concatenate works too. Textjoin and Concat do not. Excel does not seem to recognize the coding until the text from ...
- 41
0
votes
1
answer
2k
views
How to make LibreOffice Portable only convert single page to pdf
I am trying to display the first page of a word document in the browser as a thumbnail and to do this I convert the docx to a pdf. However this takes some time to occur since it’s converting the ...
- 1,843
1
vote
1
answer
561
views
Libreoffice Calc doing a linear regression with missing data values
In Libreoffice calc, if you try to do a linear regression where some of the data is missing it just returns an Error Err:502. Is there a way for me to ask Calc to just drop/ignore the datapoints with ...
- 18.9k
0
votes
0
answers
48
views
LibreOffice: how to display several opened windows as a grid on the computer's screen?
Basically that. OS: MACOS.
I need to compare several documents visually and wondered whether this option exists, or whether there is third-party software to meet this goal. Thank you very much for ...
- 313
2
votes
0
answers
451
views
.net LibreOffice Handle is not initialized exception
Our team updated an existing winform application to .net 6. Since this update we cannot open files with open office anymore. The SDK cannot be initialized anymore.
the following code throws an ...
- 567
1
vote
1
answer
403
views
clipboard manager extension for writer
I am trying to build a clipboard manager extension for Libre office. When-ever I cut (or copy) text from a document, it should be appended to another file so that I will never loose my work even if I ...
- 32.6k
1
vote
1
answer
384
views
Can't copy project to docker container - Laravel (Lumen)
I am new to Docker trying to Dockerize simple lumen app locally.
Dockerfile:
FROM php:8.1 as php
WORKDIR /var/www
COPY ./ /project
COPY . .
COPY --from=composer:2.4.2 /usr/bin/composer /usr/bin/...
- 957
0
votes
1
answer
490
views
Azure App Service - Install .msi using Azure DevOps Pipeline or Kudu terminal
Need to install LibreOffice to my Azure App Service.
1. Azure DevOps
I used powershell Start-Process to silent install but getting Permission denied.
Start-Process: /home/vsts/work/_temp/5cc8c99d-...
- 1
0
votes
1
answer
81
views
LibreOffice Base Macro run MySQL command ENCLOSED BY (and the enclosed are by qotation markes aka "
Im doing a macro in Libreoffice extract a txt file to mysql but all data has "double quotes".
in mysql terminal this command works fine.
LOAD DATA INFILE '/var/lib/mysql-files/Stock.txt' ...
0
votes
1
answer
367
views
Identifying macros in a spreadsheet using LibreOffice Calc?
Is there a way to find out what macros are in a LibreOffice Calc file?
I went to the menu Tools > Macros > Organize Macros, and reviewed all the options, but I am not seeing anything that tells ...
- 101
0
votes
0
answers
2k
views
How can I convert .pdf to .docx file with libreoffice-convert using nodejs?
I want to convert .pdf to .docx file with libreoffice-convert using nodejs and libreoffice-convert. This is an example code from this package. How can I use this example?
const path = require('path');
...
3
votes
0
answers
351
views
How can I use Libreoffice embedded python in a Venv from Pycharm
I am trying to use Pycharm to develop Libreoffice python Macro with in the virtual environment with not a lot of success. You'll find below a few things I have tried with the differnt errors I have ...
- 8,081
1
vote
1
answer
709
views
Inserting and removing text into a textbox on a SHEET in Libreoffice calc BASIC
As I can't solve my problem I'd like to ask someone more experienced.I created simple dialog (4 fields) to let the user enter few data. After clicking "Submit" button those data should be ...
- 11
2
votes
0
answers
141
views
Losing MathML when converting from HTML to Docx using LibreOffice
I am using LibreOffice to convert a .docx file to an XHTML file. Mathematics is converted to MathML.
My plan is to use LibreOffice in headless mode (or tools based on it) to convert back the XHTML ...
- 21
1
vote
1
answer
153
views
libreoffice python threading sleep
I want to implement an autosave feature for libreoffice writer. I'm using a python macro.
This will periodically save the desktop view of the document back to the file on disk and signal to the ...
- 1,239
1
vote
0
answers
57
views
Libre Office Forms auto functions
In my Libre Office database, on my data entry form I want to add some automatic functions like in a spreadsheet. For example, if a user enters a date in the form, can the "Weekend" boolean ...
- 11
2
votes
1
answer
769
views
Text not correctly converted libreoffice docx to pdf
I have a big problem converting doc/docx to pdf.
I created a file conversion API with Symfony. I mainly work on ubuntu, and never had any problems.
But I have to migrate from Ubuntu to Alpine. And ...
- 61
0
votes
0
answers
2k
views
convert a docx file into pdf file using unoconv
convert a docx file into pdf file using unoconv. It's taking too long to convert as pdf and aborted
DOCX to pdf conversion command:
unoconv -f pdf -o sample.pdf sample.docx
Download the sammple docx ...
- 59
1
vote
0
answers
401
views
convert a docx file into pdf file using unoconv. It's taking too long and aborted
convert a docx file into pdf file using unoconv. It's taking too long and aborted
DOCX to pdf conversion command:
unoconv -f pdf -o sample.pdf sample.docx
Download the sammple docx file
- 59
1
vote
0
answers
1k
views
Convert pdf to docx using libreoffice without textbox
I am working on a service to convert pdf with selectable text, to docx file.
I have used libreoffice to do this with the below command:
libreoffice --headless --infilter="writer_pdf_import" -...
- 91
0
votes
0
answers
221
views
How to create a copy of a linked database in LibreOffice Base
I have a connection to a Microsoft Access to Libreoffice Base using a JDBC connection. When I save the database in Base it retains the connection.
I want to create a copy as a standalone Base database ...
- 333
0
votes
0
answers
346
views
Combine multiple .xls into one file in different sheets without changing format
I'm using python to process some data. In the beginning, I have an .ods file with many sheets. I need to edit cells inside each sheets and save it as a new file. I followed https://stackoverflow.com/a/...
- 110
2
votes
2
answers
1k
views
LibreOffice Calc Macro - Set two different types of fonts within the same cell
Good morning everyone,
I would like to build a Uno Basic macro that allows us to set the formatting one cell in such a way as to have the content first formatted with one character and then ...
- 142
1
vote
1
answer
275
views
Converting a Japanese doc to pdf outputs boxes instead of hieroglyphs
I'm developing a service which is supposed to convert a document of different formats to pdf. All works just fine with English documents, but with Japanese the result leaves much to be desired. Namely,...
- 45
0
votes
1
answer
159
views
libreoffice writer python script to set view layout columns
For text documents in LO writer I want a shortcut to toggle the view between 1 and 2 columns. To that end, I recorded two macros -- which had no effect -- so I'm trying with Python.
The Writer Menu....
- 1,239