Skip to main content
915 questions
Newest Active Bountied Unanswered
Filter by
Sorted by
Tagged with
1 vote
1 answer
362 views

I am looking for a way to add machine-readable metadata to DOCX reports I generate. The goal is to allow users to modify the document's styles and re-upload it to the system while preserving the ...
Kishieel's user avatar
  • 2,085
1 vote
2 answers
737 views

I am developing a .NET 8 cross-platform application on Debian, which needs to interact with LibreOffice via UNO API. What i'm trying to accomplish is to save an opened Libre Office tab. Here is my ...
sausage_mouse's user avatar
  • 169
1 vote
0 answers
69 views

Using c#, I am loading a new Writer document and writing a text into it. (My version is Apache OpenOffice 4.1.4). I have referred to below link and done some changes and was able to load a document ...
Ajju Dev's user avatar
  • 11
-1 votes
1 answer
38 views

When the “whole sheet export” option is enabled during the PDF export process in Calc, the hyperlinks in the exported PDF do not preserve their original URLs and instead show local file paths. ...
Cui Pengfei 崔鹏飞's user avatar
  • 8,375
0 votes
0 answers
54 views

I have some drawings in multi-paged .ODG files. I would like to have a way to automatically export them to bitmaps, with a controlled set of export options. I'd like the exported format to be PNG or ...
yury10578's user avatar
  • 113
4 votes
2 answers
793 views

How to convert a Multi-Page Text file to PNG, for example:- I have a Text document of 5 pages and I want to convert that into PNG. By default, it's giving a PNG of only 1st page. How to get the PNG ...
Madhu Patel's user avatar
  • 141
0 votes
1 answer
555 views

I'm trying to Load a document using OpenOffice SDK in JAVA. I'm Using XComponentContext xContext = Bootstrap.bootstrap(), and trying to get the remote office component context of OpenOffice through ...
Madhu Patel's user avatar
  • 141
1 vote
0 answers
111 views

I have a large database of car makes and models color auto code structured in these columns: Make - Model - Description - Code and about 14000 rows. I need to have the database with only the first ...
Tommaso's user avatar
  • 21
0 votes
1 answer
190 views

I've got the following table: Question 1 Question 2 Question 3 a a b b a c a c e c b e a d a How do I create a pivot table (or something similar) containing the count of answers per question? i.e. ...
E.J's user avatar
  • 33
0 votes
0 answers
427 views

I am trying to use the libreOffice library using PHP. When I run the code from the console it works fine, but when I run it via the browser it fails. The error is "Failed to create COM object `...
marcveciana's user avatar
  • 1
-1 votes
1 answer
1k views

I've spent many hours searching for open-source code or utilities (but NOT the full LibreOffice suite) that would let me convert an ODG (Open Document Graphic) image to any standard format like PNG or ...
emendelson's user avatar
  • 541
1 vote
1 answer
870 views

I am trying to set up an comfortable environment to develop some python scripts for LibreOffice Calc. Before I tried to edit .py files directly from "/home/user/.config/libreoffice/4/user/Scripts/...
laksdjfg's user avatar
  • 15
0 votes
1 answer
272 views

I have some files (.odt) stored in a mysql database which I try to download Spring backend (not Spring boot): Controller: @RequestMapping(value = "/downloadRequest", method = RequestMethod....
KurtJ's user avatar
  • 33
0 votes
0 answers
90 views

I want to be able to sign a Microsoft office or OpenOfiice document with with a digital certificate without using the Gui softwares. I already signed PDF and XML (with xml-dsig). Some people say I can ...
user3502626's user avatar
  • 838
0 votes
0 answers
82 views

How a can open programmaticly LibreOffice in modal mode in separate process, like winword.exe /w? under windows/linux Didn't find anything...
binks's user avatar
  • 11
0 votes
0 answers
800 views

I have a LibreOffice Calc spreadsheet that has a column with HTML formatting in it, including links. There is some data in the HTML that I need to preserve and extract. This would be easy to do if I ...
cazort's user avatar
  • 836
2 votes
0 answers
452 views

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 ...
Dom's user avatar
  • 567
1 vote
0 answers
223 views

Does exists any way to generate image thumbnails for Microsoft Office, Open Office, PDF's and another most frequently used files/documents? Server side of my app is running on NodeJS. Thanks a lot for ...
klaucode's user avatar
  • 340
0 votes
1 answer
127 views

How can I disable track changes in OpenOffice Writer / LibreOffice Writer using the UNO Java API?
robertspierre's user avatar
  • 5,418
0 votes
1 answer
366 views

I'm new with OO Calc macros. With this code I can style cells on F13:F16 range REM ***** BASIC ***** Option Explicit Sub Main oDoc = ThisComponent osheets = odoc.getSheets() osheet = osheets....
user3713179's user avatar
  • 361
0 votes
1 answer
377 views

I am having Libreoffice7 installed with custom python 3.8.6 in Windows. I want to use PyUNO to navigate the view cursor to a specific position based on the X, Y coordinates(of instance com.sun.star....
Tcoder's user avatar
  • 1
0 votes
0 answers
26 views

How can I extract word in binary file or .doc file with open office library in Java? I can't find good documentation or example of how to do it.
Ben's user avatar
  • 131
0 votes
1 answer
241 views

Whenever I place Imports System.Xml above the rest of the code I get an error: BASIC syntax error. Expected: Sub. And when I place it inside any of the Subs I get another error: BASIC syntax error. ...
oscark's user avatar
  • 13
0 votes
0 answers
116 views

We are usingthe UNO library to edit template in LibreOffice. The existing implementation was developed using LibreOffice 6.4.4. With this version this worked without any problems. Likewise with ...
Chien Pham's user avatar
  • 1
0 votes
1 answer
706 views

I am writing an extension for LibreOffifce. A tree with columns on my sidebar is needed. (example - https://doc.qt.io/qt-5/qtwidgets-itemviews-simpletreemodel-example.html) I found information about ...
user477598's user avatar
  • 1
0 votes
1 answer
229 views

I've spent several hours trying to sort data in OpenOffice Calc in Delphi. I tried to follow the examples in basic (from "OpenOffice.org Macros Explained"*) or C#, but still no result. Data ...
loltrol's user avatar
  • 103
1 vote
1 answer
143 views

Good day. I am using pandas to read a column of data in a xlsx file. I only have 1 column and it is filled with ages of people. This is my code: import math import pandas as pd import openpyxl df = ...
H2WO's user avatar
  • 31
0 votes
1 answer
221 views

I have a XTextTable instance. How can I 1) clone the text table (both content and format) into a new XTextTable instance and 2) insert the new instance below the text table using insertTextContent ...
Silvia Leung's user avatar
  • 47
1 vote
1 answer
612 views

How is the Basic wrapper call formed to run a LibreOffice Calc Python User Defined Function using non-integer spreadsheet ranges? I'm not clear on how to declare the function properly for the values ...
flywire's user avatar
  • 1,435
1 vote
1 answer
772 views

Declaration Dim currDoc As Object Dim currSheet As Object Dim cell As Object currDoc = ThisComponent currSheet = currDoc.sheets(0) Logic cell.Formula = cDbl(cell.Value) Desired Output 100,00
Tobi S's user avatar
  • 161
0 votes
1 answer
128 views

I have this macro that works as expected. I type any junk word for e.g. testd on a new line, place the cursor at the beginning of the word and run the macro. The word is added to standard dic. I can ...
shantanuo's user avatar
  • 32.6k
0 votes
1 answer
124 views

I have a range of values F1:F144 and i want to make sum of values less than 50. I tried =SUM(F1:F144,'<'50) but it doesn't work (i don't want to sort them).
Bouraoui Al-Moez L.A's user avatar
  • 1,009
-1 votes
1 answer
65 views

I'm trying to perfect a regular expression to take paragraphs of text and arrange them with a 65 character per line limit, and specifically not to split any words. I'm using Apache OpenOffice to Find ...
Huckleberry Finn's user avatar
  • 159
0 votes
1 answer
100 views

I made an OpenOffice drawing with multiple layers and would like to export this to a multilayer pdf file. Can I do this directly or do I need auxiliary software ? (I use Openoffice 4.1.7 on a Win10 PC)...
Tim's user avatar
  • 21
0 votes
1 answer
41 views

I'm struggling with some code using LibreOffice 7.1.0 on Windows 10 to append images from a folder into separate slides in Impress. I've been looking here and OpenOffice documentation. This call ...
user2338150's user avatar
  • 485
0 votes
1 answer
389 views

PyOD is a super simple python library (https://github.com/mirkonasato/pyodconverter). It has one command usage > "C:\Program Files (x86)\OpenOffice 4\program\python-core-2.7.18" ...
Bellator's user avatar
  • 352
1 vote
2 answers
795 views

I'm using unoconv to convert XLSX => PDF. I need LibreOffice to wrap text and increase row heights dynamically depending on the contents of the XLSX file. Is there a way to do this programmatically,...
ldiqual's user avatar
  • 15.4k
0 votes
0 answers
943 views

I am creating an excel using NPOI. In this I want to call an exe(notepad++) when the user clicks a cell. As far as I know this behavior can be achieved only through macros. So is there any possibility ...
prabhakaran's user avatar
  • 5,320
1 vote
2 answers
2k views

I have upgraded my application from Wicket 1.x to 8.x version. I am facing an issue to convert Excel file into PDF format. Using this below dependencies: <dependency> <groupId>net.sf....
user3552342's user avatar
  • 707
1 vote
1 answer
1k views

Sort uppercase cells separately from lowercase ones Hi! I would like to resolve the following: I want to group cells with mixed content, numbers, lowercase and uppercase words into separate columns so ...
Calm's user avatar
  • 23
1 vote
1 answer
1k views

I am using PHP as a backend end, I generate a Docx file on the backend and I want to send it to the frontend to make the user print it directly without downloading it. So I wanted to convert the Docx ...
Hazem Khairy Mohamed's user avatar
  • 73
0 votes
1 answer
286 views

(I posted this elsewhere, but this may be a better forum.) I recently bought a new laptop and am trying to avoid MS Office. I've loaded OpenOffice 4.1.8, but am having issues writing query statements ...
deke's user avatar
  • 23
0 votes
1 answer
266 views

(character set ,seperator options, and Fields in Apache Open Office) The original file I have is a csv file. I want to change the character set ,seperator options, and Fields using python code and ...
Gun hanwei's user avatar
  • 93
0 votes
1 answer
525 views

I want to know is there any solution to 1)use python to launch apache open office 2)open an csv file 3)Auto fill in Text Import 4)then save it into xls file. import subprocess subprocess.Popen('C:\...
Gun hanwei's user avatar
  • 93
0 votes
0 answers
694 views

Open Office Document types (like .odt,.ods,...) are based on an extended version of XML. XML documents with XSL documents can be easily used to make web browser renderable web pages. I created an Open ...
Aniruddha Sarkar's user avatar
  • 1,923
0 votes
0 answers
814 views

I have a requirement where I need to use openoffice in a standalone server and use a Java program for Document conversion. Right now, I have a setup where I have started openoffice in my linux ...
BlackViper's user avatar
  • 73
0 votes
1 answer
165 views

Here (https://www.howtoexcel.org/formulas/how-to-find-the-position-of-the-first-non-blank-cell-in-a-range/) is a source for Excel where the following formula is described: {=MATCH(FALSE,ISBLANK(B3:B9),...
user avatar
1 vote
1 answer
93 views

I have a code that was working perfectly fine until LibreOffice 5. But in LibreOffice 6 (both 32 and 64 bits) it stopped working. public String getNextSentenceOO() { while (moreParagraphsOO) { ...
Marcos Fernandez's user avatar
  • 566
0 votes
1 answer
331 views

I am planning to write openoffice macros using openoffice basic language. I am struggling to find the objects and methods related to openoffice documents. I googled and found some example codes and ...
Muthuvel's user avatar
  • 5
0 votes
1 answer
147 views

I have a spreadsheet with many worksheets in it. Each worksheet has a few column headers on the first row. A user can add rows to these worksheets, and these rows get processed in my VB app by using ...
Derek Jee's user avatar
  • 147

1
2 3 4 5
…
19