Stack Overflow
Stack Overflow

Questions tagged [libreoffice-calc]

Calc is the spreadsheet program included in the LibreOffice Suite.

871 questions
-1
votes
2 answers

How to calculate average annual salary in libreoffice calc

I have salary data table from 10 years period. Every column has properly set data type (date for "B", number for "C" and "E". I'm trying to write a formula to calculate average salary for every year. In column "E" I've manually entered all possible…
Dainiasas
  • 21
  • 3
-1
votes
1 answer

VBA work fine in Microsoft word but not working in Libre office writer how to fix

I use this code to replace text in word file its work fine in Microsoft Office but have not work on Libre office writer' Private Sub CommandButton1_Click() Dim AppWord As Word.Application Set AppWord = GetObject(,…
Vijaya Kumar
  • 29
  • 4
-1
votes
1 answer

Detecting text language in LibreOffice calc

I want to automate text language detection in LibreOffice Calc. I have only 4 languages, each language has its own character set. Languages are not or rarely mixed in cells. Languages are: English, Hebrew, Arabic, Russian. As depicted in the picture…
Dudi Boy
  • 4,551
  • 1
  • 15
  • 30
-1
votes
1 answer

group the results of a matching function

i have three columns in excel, one that holds the row id, the next one a product serial number, and the last one again some serial numbers. 098 11079851 11079851 110 11089385 25853201 118 11089385 22412115 798 11079851 22412115 what i need…
user11517014
-1
votes
1 answer

How to apply adapted conditional formatting to multiple rows?

I have a table with data, where I want to highlight the highest and lowest values in each row (using max() and min() built-ins with conditional formatting). That works fine using an equals comparison with something like max(B2:W2). However when I…
U. Windl
  • 3,480
  • 26
  • 54
-1
votes
1 answer

Excel cell with line breaks. tabs with date values

I didn't found that whats wrong in below code =” Please find a report for “&TEXT(B4, "dd mmmm, yyyy ")&" | "&TEXT(B4, "dddd"); I also want the below lines in single cell. Please find a report for 30 August, 2018 | Thursday Total B.T.    =  03…
Suhas Bachhav
  • 403
  • 1
  • 7
  • 28
-1
votes
1 answer

Start Cell with Prefixed Equality Sign in LibreOffice Calc

In MS Excel you can control cell contents starting with an equality sign by prefixing with a single quote: '= some text This prevents interpretation as formula and the single quote is not displayed. I know, I could achieve that by a formula,…
Pinke Helga
  • 6,378
  • 2
  • 22
  • 42
-1
votes
2 answers

Libreoffice calc, how to iterate over cells

I like the program suite from LibreOffice. I am trying to make a script/code/formula in LibreOffice calc that can count the number of words in the cells such as in the cell selection E5 to AT14 Something like this: =LEN(E5:AT14) =SUM(E5:AT14) I…
Salvia
  • 1
  • 1
-1
votes
1 answer

Updating value from Excel to Sql Server

I have an excel having following columns and values(Sample Data) F_PRODUCT OLD_F_COMP_ID F_C_NUMBER NEW_F_COMP_ID 00231149 017-002-00-2 C_4457 017-002-01-X ADRENALINE SPRAY 017-002-00-2 C_4457…
Ram
  • 727
  • 2
  • 16
  • 33
-1
votes
1 answer

Sort text column alphanumerically (letters before numbers)

I am trying to sort our inventory list alphanumerically by part number such that letters are sorted before numbers. For instance, given the…
Pockets
  • 163
  • 1
  • 6
-1
votes
1 answer

Enter value in cell which already contains formula

I'm creating a LibreOffice calc spreadsheet but I can also use Excel if this will make things easier. The spreadsheet is based around a scientific formula with 3 variables, let's call them a, b and c. To be honest, there is also a 4th variable, d.…
lugge86
  • 255
  • 3
  • 11
-1
votes
1 answer

LibreOffice Calc display formula reference cell

When i select the cell with formula, there will show the related cell with highlight in old version(new version don't have it). What is the setting in new version ?
kenleung
  • 37
  • 7
-1
votes
1 answer

Spreadsheet Formula to Sum Values Over A if B is not in a List of Values

I have a table that looks the following: | A | B | C | | 40 | 1 | 1 | | 180 | 2 | 2 | | 34 | 1 | | 2345 | 3 | | 23 | 1 | | 1 | 2 | | 4354 | 3 | | 2 | 2 | | 343 | 4 | | 2 | 2 | | 45 | 1 | | 23 | 1 | | 4556 | 3 | I want to get…
hochl
  • 12,524
  • 10
  • 53
  • 87
-1
votes
1 answer

Using Java to get OfficeLibre Cell value

I can not seem to find any documentation on accessing a value in a .ods table, specifically OfficeLibre from Java. I am using OfficeLibre as a background program for a JavaFX program to dump and get data to, and I can not figure out how to access…
David Frick
  • 641
  • 1
  • 9
  • 25
-1
votes
1 answer

An issue with Vlookup

Example I want in B11 to sum up all 1s (from CLIENT A) and in C11 the amount of appearance of CLIENT A (in this example four times). Same for CLIENT B in B12 and C12.
Loskyll
  • 3
  • 3
1 2 3
…
57 58