260 questions
51
votes
19
answers
154k
views
how to convert xls to xlsx
I have some *.xls (excel 2003) files, and I want to convert those files into xlsx (excel 2007).
I use the uno python package, when I save the documents,
I can set the Filter name: MS Excel 97
But ...
34
votes
1
answer
3k
views
OOo/LibreOffice UNO / Java: How to get calling spreadsheet cell of a calc function?
In an UNO extension for OpenOffice/LibreOffice Calc (Spreadsheet), written in Java, how can you determine the calling cell inside the implementation of a UDF (spreadsheet function)?
Remarks
In Excel/...
19
votes
1
answer
11k
views
How to resize page to fit drawing contents in Open office/Libre Office Draw
I am programmatically drawing a flowchart in open office draw by means of Java UNO Runtime Reference api.After I have drawn the flowchart I want to resize the page according to the area aquired by the ...
11
votes
1
answer
22k
views
How to use LibreOffice API (UNO) with Python + Windows?
This question is focused on Windows + LibreOffice + Python 3.
I've installed LibreOffice (6.3.4.2), also
pip install unoconv and pip install unotools (pip install uno is another unrelated library),...
9
votes
2
answers
11k
views
Can I use VSCode for developing WINDOW DESKTOP Apps using WinUI 3 or MAUI or UNO stack?
I am trying to set up a project in VSCode to build & run windows desktop apps: WinUI / MAUI / UNO because our team is mostly using VSCode.
I am aware that Visual Studio 2022 is recommended for ...
8
votes
2
answers
660
views
What is the (single) best online source for learning OpenOffice.org scripting API [closed]
I am using OpenOffice.org for most of my not so very frequent Office Suite needs and most of the time it is more than adequate replacement for it's commercial alternative.
Where it falls short though ...
7
votes
3
answers
13k
views
Running libreoffice as a service
I'm building a web application, that, among other things, performs conversion of files from doc to pdf format.
I've been using LibreOffice installed on the same server along with my web application. ...
7
votes
3
answers
5k
views
OpenOffice.org development with pyUno for Windows—which Python?
At home, on Linux, I've experimented with pyUNO to control OpenOffice.org using Python. I've been using Python 2.6. It all seems to work nicely.
Now I thought I would try one of my scripts (run a ...
7
votes
5
answers
9k
views
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 of ...
7
votes
1
answer
2k
views
unotools insert image into document (libreoffice)
I'm trying to insert an image into a libreoffice document that is handled/controlled by unotools.
Therefore I start LibreOffice with this command:
soffice --accept='socket,host=localhost,port=8100;...
7
votes
3
answers
16k
views
Reading Openoffice Calc (.ods) programmatically using c#?
I want to know if it is possible to read OpenOffice Calc spreadsheet programatically with c#, I can do this for Excel(.xls and .xlsx) but unable to find a solution for reading calc spreadsheet.
Help ...
6
votes
2
answers
6k
views
Is there a simple way to write an ODT using Python?
My point is that using either pod (from appy framework, which is a pain to use for me) or the OpenOffice UNO bridge that seems soon to be deprecated, and that requires OOo.org to run while launching ...
6
votes
3
answers
5k
views
unoconv works from terminal using www-data but not from php script also as www-data
I wrote the following function in php
public static function convert($originFilePath, $outputDirPath, $toFormat)
{
$command = 'echo $PATH & UNO_PATH=/usr/lib/libreoffice unoconv --format %s --...
6
votes
1
answer
4k
views
Connecting to LibreOffice with named pipes
I can connect with sockets just fine, but I heard that using pipes is faster when everything is local, so I wanted to try it out, but I can't get a connection.
I start Libre with
> soffice --...
6
votes
2
answers
10k
views
Getting python to import uno / pyuno
I've been searching all day for a solution and can't seem to find anything that works, just a bunch of a leads that seem outdated or non-functional.
I'm basically trying to get to a hello-world state ...