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 do I count the number of ocurrences, considering a range (bigger than x, smaler than y), in LibreOffice Calc?

I have a spreadsheet in LibreOffice. What I need to know, is how to calculate the number of occurrences in a range, for columns D and E. For example, how many times a number in column D is bigger than 3, but smaller than 5. The return should…
Lucas Lopes Lisboa
  • 1
0
votes
1 answer

LibreOffice SDK, Calc Add-in Java extension: assign function to a new category

I develop a Calc Add-In with huge set of sheet functions. I would like to put them into a new category. In LibreOffice Calc Java extension, the in XAddIn interface has two functions: getProgrammaticCategoryName() and …
Mixaz
  • 4,068
  • 1
  • 29
  • 55
0
votes
1 answer

SUM(IF()) not working

I want to calculate the sum of a column but only if the value of another column on that row has a certain value: --------- | A | 1 | | A | 2 | | B | 5 | --------- This should yield: A=3 and B=5. After some attempts, I copied the following from…
Laoujin
  • 9,962
  • 7
  • 42
  • 69
0
votes
1 answer

LibreOffice: Cells with text to date

I have loaded an xlsx file where the original author used Microsoft Office to create the file. In the spreadsheet, there is a column of dates given in format like "DD/MM/YYYY TT:MM:SS", but they are stored as text. Furhteron, "DD/MM/YYYY TT:MM:SS"…
rexkogitans
  • 279
  • 2
  • 17
0
votes
1 answer

Compare/check multiple columns in multiple sheets and find the unmatched values

I have two sheets in libreoffice calc, both sheets have same columns, i need to compare these sheets column values(multiple columns) and need to check rows are equal, if not equal then need to differentiate the unmatched values. How can i do…
Manikandan Arunachalam
  • 1,470
  • 3
  • 17
  • 32
0
votes
1 answer

make libre office calc stop converting columns in to formulas

I have columns in a csv like this: "== 1:D2410, == 2:D2420" When I import them with libre calc it turns them in to this: == A1:D2410, == A2:D2420 Which is horrible. These are not mathematical formulas. How do I turn this off? I have deselected…
Peter Black
  • 1,142
  • 1
  • 11
  • 29
0
votes
1 answer

LibreOffice Calc macro - How to remove header and footer in given sheet?

Default header and footer show up when I print out invoice created by macro. I want to remove them in my macro.
Maciej
  • 9,355
  • 2
  • 15
  • 18
0
votes
1 answer

Form controls hidden in Libre Office basic macro designer - but shown in testmode

I have imported an original VBA form (the design) into Libre Office (Version 4.4.2.2) . However, some form controls are hidden in the designer mode, but are clearly there in the preview/test mode. Does anyone know, how I can edit the "hidden"…
Christoph S
  • 697
  • 1
  • 6
  • 29
0
votes
0 answers

How do I calculate the standard deviation of all values in a column that are greater thant a certain number in Libre Office?

Consider a column of a spread sheet, e.g. column A in the picture. How can I get Libre Office to calculate the standard deviation of this column, but without considering values below a certain threshold (A14 in the picture)? In the picture my…
con-f-use
  • 3,772
  • 5
  • 39
  • 60
0
votes
2 answers

How to sum under different sheet with conditions? Libreoffice calc

I have a libre office calc spreedsheet containing over 10 sheets. They have the same structures. on the standard sheet there are multiple columns with start and end which people need to put their timestamp(C2 = 2015-04-21 02:28 and D2 = 2015-04-21…
user3724234
  • 45
  • 6
0
votes
1 answer

Looking for a command that returns a value with the number of cells with content

I'm using LibreOffice Calc, if that makes a difference. I'm looking for a command that returns a value after looking over a column and seeing how many cells have content in it. ie. I have a column,D, of 10 rows - how do I return a value of how…
timoseewho
  • 111
0
votes
2 answers

LibreOffice Calc Cell Texts

Is it possible in LibreOffice Calc to have a cell equal what another cell has including some extra text in the new cell. For example: Cell H4 contains "Hi". Cell J4 would have "=H4 + Bob". Bob would be the extra manually entered text. So the new J4…
some random dude
  • 457
  • 1
  • 4
  • 11
0
votes
0 answers

Automate evaluation of formulae

This is my situation: 1) A and B change values often. I can write and save them in .xls with xlwt. 2) X.xls process their values with some formula, but xlwt would not evaluate the formula and return only 0. 3) if I open X.xls and save from…
user2239318
  • 2,578
  • 7
  • 28
  • 50
0
votes
1 answer

How do I write a python macro in libreoffice calc to send and receive data

The premise: I am working in libreoffice calc and need to send an instruction to another program that I know to be listening on a TCP port, via a macro. I am expecting a reply from the listening program and want to insert the reply data into the…
Rolf of Saxony
  • 21,661
  • 5
  • 39
  • 60
0
votes
1 answer

Setting cell with a formula

In LibreCalc I am trying to set a field to a color depending on what number is entered in the field. The column C needs to be the color red if it is 25% or less of Column B. Column C also needs to be the color green when it is above 75% and the…
Alex.w
  • 7
  • 2
1 2 3
…
57 58