Stack Overflow
Stack Overflow

Questions tagged [libreoffice-calc]

Calc is the spreadsheet program included in the LibreOffice Suite.

871 questions
0
votes
1 answer

How to get value of all row and set in array in libre calc with marco

If i want to get value all of row in table and I want to set it in array . How I shound do ? Please advice me , Thanks a lot . Sub Cut 'This method is cut value from user selectio and set to Copy variable. Selection =…
minstrel
  • 1
0
votes
1 answer

Why is cell increment not detected correctly in LibreOffice Calc

I have a column which I'd like to fill by selecting the top two cells and then drag down the column. The cell contents are: =Sheet1.B11 =Sheet1.B31 So when I drag down I expect to see =Sheet1.B51 =Sheet1.B71 Instead, I…
shrx
  • 699
  • 2
  • 8
  • 25
0
votes
1 answer

Delete row by content

I need a function (or some other way) to delete all rows that has NULL as content. Example: A B 1 Name ID 2 John 123456 3 Marie 789012 4 Phil NULLL So row 4 should be deleted.
Danilo
  • 382
  • 7
  • 23
0
votes
1 answer

LibreOffice Calc XYDiagram in BASIC: Setting data point size

I want to change the data point's size which result from making an XYDiagram as follows. Dim Rect As New com.sun.star.awt.Rectangle Dim RangeAddress(0) As New com.sun.star.table.CellRangeAddress Rect.X = 0 Rect.Y = 6666 * (x/3) Rect.Width =…
user3064869
  • 530
  • 1
  • 6
  • 19
0
votes
1 answer

Excel, Libreoffice/Openoffice Calc: count 'right' answers

I have a table with students' answers to 20 math problems like this: A | B | C | D | E |... ------------+-----+-----+-----+-----+... problem no | 1 | 2 | 3 | 4 |... ------------+-----+-----+-----+-----+... right answer| …
zuups
  • 1,140
  • 1
  • 11
  • 17
0
votes
1 answer

Merge two spreadsheets by matching one column

I have an inventory list of items without prices. These items have a reference number in one of the column. The prices for these items are on paper price lists (1 column with reference, 1 column with price). I want to match each items with its…
SpidrJeru
  • 119
  • 3
  • 13
0
votes
2 answers

How to find partial matching elements in spreadsheet?

In an Excel spreadsheet I have a column (column A) with e.g. the following elements: Audi, VW, BMW Group, Toyota and I can do a search of an element like this: match("*" & b1 & "*", a1:a5, 0) which will either return the relative number of where…
Alex
  • 41,580
  • 88
  • 260
  • 469
0
votes
1 answer

LibreOffice tooltip for disabled control

In LibreOffice Calc I have a form with checkbox controls. I use the Help Text property to display tooltips for them, but this only works when the control is enabled. How can I make a tooltip display also for a disabled control? Libreoffice version…
SpacemanSpiff
  • 249
  • 7
  • 17
0
votes
2 answers

LibreOffice MATCH produces an NA result for some cell ranges, and an incorrect result for others

I have a weird LibreOffice Calc problem. I have a table of chapters from the five published books in the A Song of Ice and fire series. Here is a facsimile: A B 1 | Book |…
Lou
  • 2,200
  • 2
  • 33
  • 66
0
votes
1 answer

"Skip empty cells" behaviour not as expected

I can't make heads nor tails of the "Skip empty cells" functionality in LibreOffice. When I copy the results of column A, and do Paste Special to column B, selecting "Skip empty cells", this is what I expect: Before After A B A …
Lou
  • 2,200
  • 2
  • 33
  • 66
0
votes
1 answer

Google API on Libre Office suddenly doesn't give info

I have been working with Libre Office for a while now. I have this huge database from which I have to find the coordinates for each given address given there. I was using the GeoLocate API found on this site. However, suddenly, the macro doesn't…
Superiom
  • 113
  • 1
  • 1
  • 11
0
votes
2 answers

How to MATCH based on values from multiple columns

My first table records characters from the book series A Song of Ice and Fire. My second table records characters who have died in A Song of Ice and Fire. In the fourth column in my first table, I want to test each row to see if there is a matching…
Lou
  • 2,200
  • 2
  • 33
  • 66
0
votes
1 answer

How to find a row in a table based on a numerical range?

I have a table of chapters from the book A Game of Thrones, and the page that this chapter starts. I want to take a given page number, find the nearest numerical value going down, and then pick out the chapter name for that row. For example: Eddard…
Lou
  • 2,200
  • 2
  • 33
  • 66
0
votes
1 answer

#VALUE! error in LibreOffice Calc when using custom Macro function

I'm trying to learn to write Macros in LO Calc, version 4.2.2.1. When I run any function in a blank spreadsheet, it returns the #VALUE! error in any cell. Here's one such function, which should output the result of two parameters added…
Lou
  • 2,200
  • 2
  • 33
  • 66
0
votes
3 answers

Reformat CSV file in python for spreadsheet

I have a text file text.csv with dates arranged as such. name1 2010-01-02 (i) 2010-05-07 (i) 2010-06-12 (i) name2 2010-01-02 (i) 2010-05-07 (i) 2010-06-12 (i) name3 2011-01-05 (i) 2011-05-05 (i) 2011-06-14 (i) I'd like to reformat or write the file…
rrrfusco
  • 1,099
  • 5
  • 19
  • 46
1 2 3
…
57 58