Stack Overflow
Stack Overflow

Questions tagged [uno]

Use this tag for question about Uno which is the component model of OpenOffice.org.

Resources:

251 questions
48
votes
18 answers

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 there is no Filter name like 'MS Excel 2007', How can…
Thomas
  • 707
  • 2
  • 6
  • 14
34
votes
1 answer

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/VBA this is possible via Application.Caller The…
Christian Fries
  • 16,175
  • 10
  • 56
  • 67
19
votes
1 answer

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 contents drawn.I have noticed that Microsoft…
Alok
  • 929
  • 10
  • 26
8
votes
1 answer

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), but still I get this error after import…
Basj
  • 41,386
  • 99
  • 383
  • 673
8
votes
2 answers

What is the (single) best online source for learning OpenOffice.org scripting API

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 is the scripting API. I am yet to find the…
Roland Tepp
  • 8,301
  • 11
  • 55
  • 73
7
votes
3 answers

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 graphical diff for ODF doc) on Windows. But when I…
Craig McQueen
  • 41,871
  • 30
  • 130
  • 181
7
votes
3 answers

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. By shelling out and calling libreoffice binary…
oldhomemovie
  • 14,621
  • 13
  • 64
  • 99
7
votes
5 answers

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 LibreOffice, so any help is appreciated. I'm…
MaxArt
  • 22,200
  • 10
  • 82
  • 81
6
votes
3 answers

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 me if anyone has solution.
bharath ayyagari
  • 61
  • 1
  • 1
  • 2
6
votes
1 answer

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;urp;StarOffice.Service' Inside my python code I can…
SerAlejo
  • 473
  • 2
  • 13
6
votes
2 answers

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 my script is not satisfactory at all. Can anyone…
MP0
  • 1,033
  • 2
  • 10
  • 17
6
votes
3 answers

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 --output %s %s'; $command = sprintf($command,…
Kim Stacks
  • 10,202
  • 35
  • 151
  • 282
5
votes
1 answer

OpenOffice writer - programmatically updating tables with cell formulas

I'm really stuck trying to find out how to force a programmatic refresh of openoffice writer (3.3) cell calculations when the cell values are bookmarks and the bookmarks are updated programmatically (via UNO calls in Java). Example | start | stop …
Adam
  • 35,919
  • 9
  • 100
  • 137
5
votes
1 answer

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 --headless --invisible --norestore --nodefault…
Nate Parsons
  • 14,431
  • 13
  • 51
  • 67
5
votes
1 answer

OOo: UNO (Java) TrackedChanges: How to accept (or hide) Tracked Changes when Document is hidden?

My Problem: I write an automated system that needs to read .doc and .odt, performs some operation on it and exports it to pdf again. Currently that works fine for everything I need, I could solve all problems until this one: If a user provides a…
Angelo Fuchs
  • 9,825
  • 1
  • 35
  • 72
1
2 3
…
16 17