Is there a official (or at least convenient) API for changing LO's settings? As part of automated install/update, I want to change user settings (and also LO system settings): e.g. : shortcut keys, toolbars (show/hide/change), extensions (install *.oxt) app-specific view settings, e.g. calc default font default folders etc.... Reason: Automation is required for large scale deployment, and sometimes after update, or as part of other processes. I prefer a platform-agnostic & version-agnostic solution. I prefer Python, but open to other ways. I tried to manipulate the settings file directly ..read more

I am pasting a list of IP addresses into a spreadsheet, for example: 87.122.122.222 and I seem I cannot prevent for Libreoffice Calc to make 87122122222 out of it. This only happens for some addresses, others are not being changed: 93.205.5.123 Any suggestions? I tried Format -> Cell and set it to Text format but that doesn't change anything. I tried prepending spaces to force it look like text, but Libreoffice removes those as well ..read more

How do I write a formula that I can copy and paste into a column in a LibreOffice Calc spreadsheet so that each cell displays a running 7-day total of the values in a different column. Column A contains dates. Some dates have multiple entries and, therefore, are on multiple rows; for example, Row 3 and Row 3 both have values for April 12. Column E has a value for each entry, in kilograms. Column F will have the running 7-day total of the values in Column E. So for April 18, it will add all the values in Column E from the first April 12 entry through the final April 18 entry. How do I do this ..read more

I've been looking into using the LibreOffice SDK to edit ODF files (Writer and Calc documents/ODS spreadsheets) and I was rather astounded when I came across this in the example source: /** Connect to a running office that is accepting connections. @return The ServiceManager to instantiate office components. */ private XMultiServiceFactory connect( String [] args ) { m_xContext = uno.util.Bootstrap.bootstrap(); return (XMultiServiceFactory) m_xContext.getServiceManager(); } Are you seriously expected to install LibreOffice on any mac ..read more

I have a large spreadsheet and want to automate the process of converting the first word of each cell into a hyperlink, but keeping the rest of the text as it is. I.e. linktext appendedtext to be converted to [linktext] appendedtext (linktext appearing as a link). I can create the hyperlink, but cannot see how now to add the appended text. All my efforts seem to delete the hyperlink. Thank you for any help or suggestions. My code is:- sub HyperLink rem ---------------------------------------------------------------------- rem define variables dim document as object dim dispatcher as object ..read more

when I try to enter multiple values ​​using insert into in the libreoffice tools: INSERT INTO "SERVICES TABLE" ("NUMBER", "FAULT DESCRIPTION") VALUES (32323, 'ASDF'), (3234, 'DASFF'); I get the following error: 1: Unexpected token: , in statement [,] Does anyone know the correct format for multiple values. I have tried all the formats and I can't get any valid ones when I try to enter multiple values ​​using insert into in the libreoffice tools: Does anyone know the correct format for multiple values. I have tried all the formats and I can't get any valid ones ..read more

I have this cell formula... =IF( (VLOOKUP(E2,$L$1:$M$12,2,0)+D2)<>"", (VLOOKUP(E2,$L$1:$M$12,2,0)+D2),"") It seems like a prime situation where someone would have coded something like =IF( (VLOOKUP(E2,$L$1:$M$12,2,0)+D2)<>"",cond,"") where cond was the evaluation of the previous test criteria. Does such a thing exist ..read more

Hi folks i have converted a ppt file to pdf using , /usr/bin/libreoffice--headless --convert-to pdf after convertion i am getting the error "PyPDF2.utils.PdfReadError: EOF marker not found" while reading file using python library PyPDF2 and also not able to open the converted pdf in adobe ..read more

I don't really know how to ask this question properly but this what I'm trying to do is that when I select a value from let say listBoxA, which would be getting its data from table A, the value selected would then be compared from a junction table and depending on the relations listbox B would then have only use values from table B that have a relationships with table A Ex. Table 1. Size Categories | PK | SizeCategoryID | 0 | 1 | | | Size Category | Tshirt Sizes | Memory Sizes | Table 2. Size Values | PK | SizeValueID | 0 | 1 | 2 | 3 | 4 | | | Size Value | S | M | L | 32 | 64 | Table 3. Size R ..read more

I'm encountering challenges running a LibreOffice macro using soffice from my ASP.NET web application hosted in IIS. Locally (outside IIS), I could execute the macro with the following command from application started using Visual Studio or command prompt: soffice.exe --headless "macro:///Standard.Test.Main("C:/Macro/1/WorkProcedure.xlsx","file:///C:/Macro/1/")" Since the hosted application uses a different user (IIS AppPool user) compared to my development environment, the above command no longer works. I tried using the -env:UserInstallation argument but haven't achieved success with the f ..read more