Stack Overflow
Stack Overflow

Questions tagged [libreoffice-calc]

Calc is the spreadsheet program included in the LibreOffice Suite.

871 questions
3
votes
2 answers

Libre Office Calc Vs Excel

My company will be changing from Excel to Libre Office Calc. I have built up a collection of Excel VBA Macros (especially screen scrape macros). Will my Macros work without changes? Anybody else that has made the change, how do you make the change…
Anthony
  • 542
  • 1
  • 8
  • 25
3
votes
2 answers

Extracting specific string from spreadsheet cell

I've got an LibreOffice Calc spreadsheet and need to extract a small string from a cell in each row. The cells contain about a paragraph of text and look similar to the below but all with different words, lengths etc. The one common thing is the…
Johnny John Boy
  • 3,009
  • 5
  • 26
  • 50
3
votes
1 answer

What types of "office:value-type" and "calcext:value-type" attributes exist in LibreOffice Calc "table:table-cell" tag?

I'm building LibreOffice Calc files with python code, and I want to find all types of "office:value-type" and "calcext:value-type" attributes that I can use (e.g. "string", "float", "int" - I'm not sure that's all of them). Thanks! P.S. please…
CTACyok
  • 33
  • 7
3
votes
1 answer

How to use LibreOffice functions into Basic?

I've asked here about the good way to do so. Now I'm trying the following code found here, and get some unexpected errors. I suppose I'm not using it the correct way. Any idea ? Sub Main Dim aResult Dim aFunc Dim oRange aFunc =…
Samuel
  • 594
  • 1
  • 6
  • 22
3
votes
2 answers

How can you extract the currently-selected range of cells in LibreOffice calc via pyuno?

When using pyuno in a LibreOffice / OpenOffice calc python macro, I would like simply to be able to select a range of cells, and when the macro is run, for all of the cell data (e.g. as some iterable object) to be able to be retrieved within the…
Mark
  • 3,357
  • 30
  • 31
3
votes
2 answers

How to use INDEX when applying an IF and not a MATCH?

I have two datasets in LibreOffice Calc containing the Cartesian coordinates of objects in a plane. One is old data with X number of objects, the other is newer data with the same X objects + N new ones. Excel Spreadsheet: A B …
Psymon343
  • 31
  • 4
3
votes
1 answer

How do I install and use AODL?

I want to make a button that saves a libreoffice calc file. I've done some research on google and found a site to download AODL, but the download link doesn't work (link). I've downloaded AODL at another site: sourcefourge.net My question is: Have I…
M Zeinstra
  • 1,931
  • 4
  • 17
  • 46
3
votes
3 answers

#NAME? error after opening spreadsheet with macro

I created and saved a spreadsheet that uses a macro for an interpolation task. When I open the document again all the cells calling the function are shown as #NAME? although the document still seems to contain the macro: When I open Tools | Macros |…
user829755
  • 1,489
  • 13
  • 27
3
votes
1 answer

Dynamic coloring cells in libreOffice Calc

I have a table of percentages: A | B | C ------------------- 1| 12% | 22% | 42% ------------------- 2| 52% | 2% | 82% ------------------- 3| 72% | 32% | 92% Is it possible to create a colour map (like a heat map) based on the values in…
sop
  • 3,445
  • 8
  • 41
  • 84
3
votes
1 answer

LibreOffice Calc sort rows by column comparison

I'm trying to sort rows based on two columns matching. For example, in the following table, two users rate the same books. In sorting the example table below, Book 2 should come first, and Book 4 second, because the user's ratings both match. …
James
  • 4,644
  • 5
  • 37
  • 48
3
votes
2 answers

Applying row based filter instead of column based in LibreOffice or other SpreadSheet tool

We all know the standard filter, where you pick which rows to show depending on values in a particular column (or columns). Is it at all possible to the the same, but picking which columns should be visible depending on the values of a single…
Ister
  • 73
  • 1
  • 2
  • 7
3
votes
1 answer

Using regex in a libreoffice calc macro to extract text from parentheses in a cell

Using Libreoffice 3.5.7.2 on Ubuntu 12.04. I have text in calc cells in the form of: (IBM) Ibm Corporation. I am trying to use regex to extract the text between the ()'s using a basic macro. This is what I have tried so far. Sub getMktValue() Dim…
Agent_15x
  • 373
  • 4
  • 13
3
votes
1 answer

Detecting blank cells through vlookup

ISBLANK detects blank cells, but returns FALSE for cells with formulae. I need to detect blank cells that has been looked up through VLOOKUP. Example, A1 .. F7: 1 foo =isblank(b1) =vlookup(a1,a$1:b$9,2) =isblank(d1) 2 a =isblank(b2) …
Trygve Flathen
  • 686
  • 7
  • 15
3
votes
1 answer

Run existing Macro only on Selected Cells, instead of the whole sheet

I have the following macro (LibreOffice Calc): Sub CalcFindAndReplace Dim oDoc,aFind,aReplace,aRayCount,FandR,oSheet oDoc = ThisComponent aFind = Array("Mecanica","Cancion","Murcielago") aReplace =…
Martín
  • 31
  • 2
3
votes
2 answers

Reliable means of exporting LibreOffice Calc 3 to LaTeX?

I am trying to export a LaTeX table from LibreOffice Calc. I am not using Excel because I am running Ubuntu. I have tried using the calc2LaTeX macro, but have not been able to make it work for LibreOffice 3. I am looking for something with the…
Qu0rk
  • 371
  • 1
  • 3
  • 9
1 2 3
…
57 58