Stack Overflow
Stack Overflow

Questions tagged [libreoffice-calc]

Calc is the spreadsheet program included in the LibreOffice Suite.

871 questions
-1
votes
1 answer

Group 2 columns and sum values for another column

I have the following problem: I need to group data and perform a sum in another column in libreoffice calc/excel spreadsheet, just like a group by would do in SQL In the following example, I would like the cells A26, A27 to become one line, and cell…
Rogger Fernandes
  • 805
  • 4
  • 14
  • 28
-1
votes
1 answer

Return a list of matches in an area as a column

I want to have the results of a regex search on a particular sheet show up as a column on another sheet. It wouldn't be too hard to do, say, conditional highlighting or something, to just eyeball where the results are, but what I really need is the…
Undoware
  • 99
  • 2
  • 5
-1
votes
1 answer

How do percentages get calculated in LibreOffice?

Cell A1 contains value 0.974, and cell A2 contains formula =A1. Formatting for cell A1 is a number like -1234.123, and formatting for cell A2 is a percent like -12.95%. The result shown in A2 is 97.35%. How is that being calculated? And how do I…
Kaishu
  • 377
  • 1
  • 7
  • 21
-1
votes
1 answer

Convert VBA Simple Macro to LibreOffice Macro

I have the following macro, which takes a sparse set of data and copies the only entry from each row into the left-most column. Example of data I am hoping someone could rewrite this macro into one that will work with the same data in…
Jon Friedman
  • 64
  • 1
  • 10
-1
votes
1 answer

Python "Hello World" for Libreoffice-calc and Openoffice-calc

There is a python-helloworld example for Libre/Openoffice-writer (which is included in Libreoffice 4.1.6.2: def HelloWorldWriter( ): """Prints the string 'Hello World(in Python)' into the current document""" #get the doc from the scripting…
Roland Seuhs
  • 1,878
  • 4
  • 27
  • 51
-1
votes
1 answer

Reading HTML page using Libreoffice Basic

I'm new to LibreOffice Basic. I'm trying to write a macro in LibreOffice Calc that will read the name of a noble House of Westeros from a cell (e.g. Stark), and output the Words of that House by looking it up on the relevant page on A Wiki of Ice…
Lou
  • 2,200
  • 2
  • 33
  • 66
-1
votes
2 answers

can macros in python work with ms excel

If I were to write a macro in python for libreoffice calc and save the file as an xlsx file will the macro work in ms excel on a windows pc? I am thinking of learning python so I can write macros for ms excel in python on libreoffice.
user3125707
  • 399
  • 2
  • 5
  • 20
-1
votes
1 answer

libre office calc: Changing the interval that labels display at

I have a 2 column spreadsheet. The first column is a label, the second is a value. I want to make a chart that displays every single label on the y axis but by default calc displays the labels at intervals, like every 5th one. How can I change this?…
user1131308
  • 309
  • 4
  • 12
-1
votes
2 answers

Date string conversion from R to CSV in Libre Calc

I'm trying to get acquainted with weatherData in R. Having downloaded a set of temperature data I've then exported it to CSV. Opening the CSV in Libre Calc shows the date and time for each temperature reading as a string of ten digits. In spite of…
Curious56
  • 51
  • 1
  • 3
-1
votes
3 answers

how to calculate date difference

my data column1 column2 1-Sep-11 31-Aug-12 1-May-12 30-Apr-14 1-Mar-09 28-Feb-14 1-Apr-13 31-Mar-14 1-Apr-10 31-Mar-13 i want how many years difference between column1 and column2 out put like column1 …
Ram
  • 147
  • 3
  • 6
  • 16
-1
votes
2 answers

Arbitrary input

I have LibreOffice 4.1.2 on my winbox and I cannot make it accept an arbitrary input. The minimal test: create a new Calc document; input KBr; press Enter. Then the text turns into Kbr. Setting the cell format to Text does not help at all.…
naudhr
  • 11
  • 1
-1
votes
1 answer

Last matching date in spreadsheet function

I have a spreadsheet where dates are being recorded in regards to individuals, with additional data, as such: Tom | xyz | 5/2/2012 Dick | foo | 5/2/2012 Tom | bar | 6/1/2012 On another sheet there is a line in which I want…
Joshua
  • 15
  • 5
-2
votes
1 answer

Validate LibreOffice cell contents against a REGEX

I need to enforce a column cell validity against a REGEX. So I ask if it is possible to validate a cell (really all cells in a column) agaist a REGEX. I see we have data validity custom formula option, but I can't find any docs about how to use it…
MarcoS
  • 17,323
  • 24
  • 96
  • 174
-2
votes
1 answer

Could anyone give a simple but generally useful template for python code to be embedded into LibreOffice Calc?

Update acknowledging comment 1 and 4: Indentation corrected, does compile in Geany, obvious redundancies stripped. The first question is: why am I getting the args error when I try to run my code? The error message refers to a LO file.... (linux)…
Micklos
  • 97
  • 9
-2
votes
3 answers

Spreadsheet - Conditional formatting cells based on other cells

Conditional formatting a cell is simple enough. It's also simple enough to conditionally format a single cell based on another single cell. What I'm not sure about is doing it for many cells in such a way that I don't have to format each individual…
hiigaran
  • 285
  • 1
  • 10
1 2 3
…
57
58