Questions tagged as 'libreoffice'

I want to sum the value (and show in any cell) of the cell Cx when Dx is equal to 1 and add the values of Cy when Dy is 2. For example: In the photo, when the value of cell Dx is 1, I want the value of Cx (of the same line) to go to L3 and th...

This question refers to the use of python macros in LibreOffice. I've been doing some research on the subject and found that one of the ways to add a macro written in Python to LibreOffice would be to put it in the directory: ~/.config/libreo...

I am creating a macro in LibreOffice Calc and need a way to select some non-consecutive cell ranges, and capture which are those selected ranges. For example, I want to select the intervals "A1: A10", "C5: C13", "H7: H9" and to be able to captur...

I'd like to know how I can perform the following filter: ===> Thatis,howtoremovetheduplicatesinthe"action" column, but leaving the record with the highest priority (in this case, '1' is the person with the highest priority and '8' is the...

What command can I use to close the libreoffice writer via terminal in ubuntu? Thank you.     

I have an open office spreadsheet file with 27 spreadsheets inside. All spreadsheets are the same, 3 columns, title, nothing more. I need a way to format all spreadsheets one at a time. - line width - color of the headers - width of columns...