Stack Overflow
Stack Overflow

Questions tagged [libreoffice-calc]

Calc is the spreadsheet program included in the LibreOffice Suite.

871 questions
6
votes
3 answers

How do I get dynamic change of height in rows or cells?

How to get dynamic height in a cell? If I put too much text in a cell it will not show all the info since it's not room for it. I want my calcsheet to dynamically change the height in the entire row when needed.
AndersBrontosaurus
  • 63
  • 1
  • 5
5
votes
1 answer

How to use WEBSERVICE libreoffice calc function?

This used to work in libreoffice calc but can no longer get it to work. I enter this in a cell: (my personal key is altered) =WEBSERVICE("http://api.currencylayer.com/historical? access_key=123456&date=2021-03-08") And I'm supposed to get back a…
haelix
  • 4,245
  • 4
  • 34
  • 56
5
votes
2 answers

Using Python to access LibreOffice Calc using Uno

I'm trying to write a script to manipulate a Ubuntu Mint _LibreOffice Calc sheet using Python 3.7,. For some reason I'm getting an error when I try to import Uno. I can run a macro from inside Calc calling this desktop =…
Jeff O
  • 133
  • 1
  • 1
  • 7
5
votes
2 answers

How can I add quotation marks to a libreoffice calc cell text?

In libreoffice calc I have a column with thousand words. Each word I need to put into quotation marks. Example (A1 and A2 are cells) start word (A1): car end word (A2): "car" Normally, I can reference cells and add new text with…
NewbieXXL
  • 155
  • 1
  • 1
  • 11
5
votes
3 answers

LibreOffice Calc: How to get file path of the current ods document into the cell?

I would like to get current document folder path as a cell value. I need it for proper relative reference creation used in a function call OFFSET(INDIRECT()) I am out of luck with google. I found basic function…
urkon
  • 233
  • 1
  • 5
  • 15
5
votes
2 answers

Function accessing cell range

I don't find how to use cell ranges with functions. I vainly searched some examples. I wrote the following test. I get "Object variable not set" error on both "for" lines (one is without "RangeAddress", and the second is with it, because I'm not…
Gregory MOUSSAT
  • 832
  • 4
  • 13
  • 22
5
votes
1 answer

Auto Height in LibreOffice Calc

Typical you would format auto height rows with PHPExcel like this: $file = new PHPExcel(); $file->getActiveSheet()->setCellValue('A1', 'Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et…
witrin
  • 3,701
  • 1
  • 24
  • 49
5
votes
1 answer

LibreOffice Calc / OpenOffice Calc: How to filter rows based on their background color?

I'd like to filter out rows with a specific color on a specific column. I tried to search nearly everywhere but couldn't find my answer. Hope for some good advice, thanks.
prx
  • 59
  • 1
  • 1
  • 2
4
votes
2 answers

How to reference dynamically a cell on another sheet in libreoffice?

In LibreOffice Calc I want to reference a sheet and a cell depending on the values in other cells. For example with =INDIRECT(C$3 & ".D24") I can reference the sheet, depending on the value of C3 and there the cell D24. That works quite well, but…
Asara
  • 2,791
  • 3
  • 26
  • 55
4
votes
2 answers

Reversing Text to Columns in Excel/Calc

Most spreadsheet software I've used has a text-to-columns function that splits a single column into multiple columns using several criteria (delimiter, # of character, etc). I want to do this in reverse. I know I can use a formula to create a third…
Lee Blake
  • 341
  • 1
  • 2
  • 15
4
votes
1 answer

LibreOffice Calc: How to control which values are incremented on drag down?

I have a complex formula in a cell with various references to other cells. =INDEX($Sheet1.B1:B100;MATCH(C1;$Sheet1.D1:D100;0)) I want all cell in the same column to have the same formula with only one reference incremented. But if I select the…
user5950
  • 242
  • 1
  • 12
4
votes
1 answer

LibreOffice macro get index current sheet

Does someone know how to get the index of the current sheet in LibreOffice Macro Basic? I successed to get the name: cursheet = my_doc.getcurrentcontroller.activesheet.Name But how to get index? Moreover is there a place to find the documentation…
Lemaitre Cedric
  • 139
  • 2
  • 7
4
votes
1 answer

Given an ISO 8601 week number, get date of first day of that week in LibreOffice Calc spreadsheet

LibreOffice Calc spreadsheet offers a function ISOWEEKNUM to return the standard ISO 8601 week number of the specified date. I want the opposite. ➠ Given a standard week number, give me the date of the first day of that week (the Monday date).…
Basil Bourque
  • 303,325
  • 100
  • 852
  • 1,154
4
votes
2 answers

Is it possible to remove characters before a certain point?

I want to delete a set of characters which are behind a backslash in LibreOffice Calc. For example: My/Name Is/Jeff where I would like to delete My and Is such that only /Name and /Jeff remain. Does Libre's inbuilt functionality allow something…
Rushat Rai
  • 743
  • 2
  • 15
  • 31
4
votes
1 answer

Libreoffice Calc - generate list as combination of multiple columns or cell ranges

I would like to know if there is a function in LibreOffice Calc that could generate a list from multiple columns or cell ranges. Assume I have the following unique data +------+------+------+ | col1 | col2 | col3 | +------+------+------+ | 1 | a …
praet0ri4n
  • 53
  • 1
  • 8
1 2
3
…
57 58