Stack Overflow
Stack Overflow

Questions tagged [libreoffice-calc]

Calc is the spreadsheet program included in the LibreOffice Suite.

871 questions
4
votes
1 answer

How to access a cell in LibreOffice Calc using numeric indices?

Is there a function in LibreOffice Calc that accepts an integer x and an integer y and spits out the contents of the cell with that position? There is a function ADDRESS that spits out the address of a given [x;y]. The problem is that I do not know…
Martin Drozdik
  • 12,742
  • 22
  • 81
  • 146
4
votes
2 answers

Libreoffice calc: loop throught cells macro

I've been searching a lot but could find little to no info about LibreOffice Basic I'm a bit used to programming macros in excel but this time a need to do a loop until i reach the first empty column and it needs to be in libreoffice. In excel i…
Newbie
  • 863
  • 1
  • 7
  • 16
4
votes
2 answers

How to get last position of a character in LibreOffice Calc

I want to get last occurrence from multiple occurrences of a character in LibreOffice Calc. For e.g. I have a string abc1ba2ac2adeaa43add. Now if I am searching for a it should return 18.
Ashvin Kanani
  • 831
  • 2
  • 14
  • 22
3
votes
2 answers

How to reference a cell or range in an external spreadsheet?

I have one spreadsheet already saved with some data, then in a new spreadsheet in the same folder on the same hard drive I'm trying to reference a cell in the previously saved spreadsheet file. From what I've read, I'm supposed to click Insert on…
Gigatron
  • 1,995
  • 6
  • 20
  • 27
3
votes
5 answers

How to generate a random alphanumeric string with a formula in Excel (or Google Sheets or LibreOffice)

I'm trying to generate a random 8 character alphanumeric string in Excel (or Google Sheets or Libreoffice, which both have the same challenge) using a formula. I'd like to get something like this: 6n1a3pax I've tried various formulae including ones…
Sam Critchley
  • 3,388
  • 1
  • 25
  • 28
3
votes
1 answer

SUM using row range specified on other cells in LibreOffice Calc

Suppose I have the following spreadsheet in LibreOffice calc: | A | B | C | D | ------------------- |1| 1 | 2 | | 2 | |2| 2 | 3 | | 3 | |3| 6 |10 | | | |4|11 | 2 | | | I want a formula that does a sum =SUM(A1:B4) but using only rows…
Rodrigo
  • 67
  • 1
  • 4
3
votes
1 answer

How to extract real name, first name, lastname, and create nickname from name that have acronyms, aristocratic title, academic titles/degrees

I am trying to extract name, firstname, lastname, create nickname/firstname, and nickname/lastname from name list that have acronyms, aristocratic title, academic titles/degrees, nickname inside parentheses or after slash-backslash in libreoffice…
Eko Subha
  • 47
  • 5
3
votes
1 answer

convert csv to dbase in LibreOffice in headless mode

I can convert a csv file with dates to dbase in LibreOffice in regular mode. H_beg date and H_end_date work perfectly. dbview thexport.dbf H event id : 210721001 H name : CCCR WEEK NIGHT 072121 H tot sect : 1 H beg date : 20210721 H end date :…
verlager
  • 794
  • 5
  • 25
  • 43
3
votes
4 answers

How to sum the numbers in cells if there is text?

Guys please help with such a problem. Need to sum numeric cells with text inside? He gave an example of the table, like 1 + 3 + 8 = 12. Is there any way to solve this? Thank !
Gen Ts
  • 404
  • 2
  • 18
3
votes
2 answers

Conditional formatting based on formula addressing current row in LibreOffice Calc

I have a column of cells in LibreOffice Calc with conditional formatting to apply a style to those cells. The conditional formatting is programmed to format the cell if the following formula is true: AND(B106=0,C106=0) The trick is that instead of…
RockPaperLz- Mask it or Casket
  • 5,361
  • 10
  • 45
  • 69
3
votes
1 answer

Define a LibreOffice Calc custom function in Python

I am writing custom functions in LibreOffice Calc. Such functions must be called in Calc as if they were native functions, e.g. as EDATE(), DAYS() etc. Upto now what I am doing for each custom function is: Define a Python function Define a…
Nicola Mingotti
  • 860
  • 6
  • 15
3
votes
1 answer

How to fetch data from a website using LibreOffice's Calc?

I'm searching for a way to fetch some data from a website using LibreOffice's Calc. I was using Google Sheets with the IMPORTXML function before, but because it's very unreliable I want to use Calc instead. My functions there looked like…
DMT
  • 424
  • 2
  • 6
  • 12
3
votes
1 answer

How to delete all images from all sheets of a Libreoffice Calc Workbook

I have a Libreoffice Calc workbook with over 60 sheets many of which have heavy images that were copied to them. I would like to delete all of the images with a Calc Basic macro. I have tried the following which fails with a Basic runtime error…
John B. Walugembe
  • 589
  • 4
  • 12
3
votes
1 answer

Custom sort order

I need to sort data in LibreOffice Calc using a user-defined sorting function (Small, Medium, Large, X-Large). The sort menu offers a "custom sort" option, but the sorts are all pre-defined and I do not see how to add a new one. Disclaimer: I am…
Alex Vermillion
  • 35
  • 1
  • 4
3
votes
1 answer

How to filter rows based on specific values in Libreoffice?

I have a table with several columns. I want only the lines where target value is different from alg value. In this case where target is 1 and alg is 0. So, line 2, 4 and 5 should stay and line 3 should be removed. How to do that?
minerals
  • 6,090
  • 17
  • 62
  • 107
1 2 3
…
57 58