260 questions
1
vote
1
answer
61
views
Python macro to enumerate only selected formulas in a LibreOffice Writer doc
I've written this LibreOffice Python macro, that prints (in ASPO terminal) the inner code of each "formula" (i.e. LibreOffice Math element included in LibreOffice Writer content) of my ...
- 776
0
votes
0
answers
91
views
Cannot successfully create the simplest LibreOffice extension for UDF's
New here. Beginner with Python and LibreOffice. Some experience with C#.
OS: Win 11
LO: 25.8
I have been trying to learn how to create a LO extension to provide UDF's for use in LO Calc. I have dozens ...
- 1
0
votes
0
answers
75
views
How do I set visibility of sheet, row or column?
Setting visibility of sheets, rows or columns does not work using XPropertySet::setPropertyValue(). It does not throw an exception or anything, it just does not change the property value.
I am not ...
- 110k
0
votes
1
answer
62
views
The "Sheet" function in Uno FunctionAccess always returns "2"
This function:
Function SheetIndex() As Long
Dim oFunctionAccess As Object
oFunctionAccess = CreateUnoService("com.sun.star.sheet.FunctionAccess")
SheetIndex = oFunctionAccess....
- 14.1k
-1
votes
3
answers
1k
views
App Icon not Shown in Title Bar in UWP für WinUI 3 / Uno
I'm developing an UWP App with UNO / WinUI 3.
I have put images into the Images folder in the UWP project and the application icon is shown in the taskbar as well as application icon at the exe-file.
...
- 156
1
vote
0
answers
171
views
Is there a way to add a Java Swing JPanel to the UNO-AWT of LibreOffice?
I now learned that it is possible to place a Swing JPanel into an AWT Panel. older question
Now the next step. As far as I understand it, the Java Extensions of LibreOffice use UNO-AWT. Is there a ...
- 133
1
vote
1
answer
55
views
Where do table cells get their CharHeight from in LibreOffice Writer
In a Libre Office Writer text document, i would like to reset all explicitely applied font size settings, both in text paragraphs as well as in tables.
For paragraphs i can find such explicit settings ...
- 14.1k
1
vote
2
answers
756
views
How to use LibreOffice UNO API in .NET 8 on Debian?
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 ...
- 1,041
0
votes
1
answer
102
views
Uno Platform building error APT2067: failed processing manifest
I have multiplatform project (targets for iOS, Android and Windows), so far just began, very simple content. I'm debugging only on iOS so far, Android even didn't touch yet. Everything was fine, until ...
- 311
1
vote
0
answers
82
views
LibreOffice UNO API: Column Page Breaks Not Resetting, Unlike Row Breaks
LibreOffice UNO API: Column Page Break Issue in Python
I'm using the LibreOffice UNO API with Python to programmatically apply row and column page breaks in a Calc spreadsheet. However, I'm facing a ...
2
votes
2
answers
5k
views
Insert a cell with a Basic Macro in LibreOffice Calc
I'm trying to insert a cell beginning with the first cell in a range (via the .getCellRangeByName() method of a Document's active Sheet).
I found out how to do this with a Dispatcher from the ...
- 34k
-1
votes
1
answer
39
views
Implementing a Custom “Whole Sheet Export” via UNO API to Preserve Hyperlinks in PDFs
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.
...
- 8,375
0
votes
0
answers
38
views
Parallel calculation of several custom formulas in LibreOfficeCalc
I wrote a custom formula in Python (for example, the name Formula 1) and added it as an extension of LibreOfficeCalc.
There can be a lot of such formulas on the sheet and with different parameters.
Is ...
- 123k
0
votes
1
answer
62
views
Is there a way to load a System.Data.DataTable into a LibreOffice Calc sheet without going cell by cell?
With Excel, and using C#, you can load the entire System.Data.Datatable into the sheet by calling
mySheet.Cells("A1").LoadFromDataTable(myDataTable, True)
where mySheet is an OfficeOpenXml....
- 14.1k
-3
votes
1
answer
202
views
My Arduino Uno PS/2 to USB works only in serial monitor not in other Windows apps
I'm a beginner in Arduino and recently programmed an Arduino Uno board with various PS/2 to USB converters. They work when typing in the Serial Monitor of Arduino IDE, but not in other programs such ...
- 5,120