Stack Overflow
Stack Overflow

Questions tagged [libreoffice-calc]

Calc is the spreadsheet program included in the LibreOffice Suite.

871 questions
-1
votes
1 answer

Weird result with bing numbers and percent cell

I'm working in a sheet with huge numbers, the sheet behaves as it should, but for one cell, same style/formatting inherited from the cells above. Here is what involved cell contains: **J13**: =(I13/E13)*100 **E13**:…
Ritardi.Net
  • 99
  • 2
  • 11
-1
votes
1 answer

Python script to open and edit cells in a libre office Calc document?

An interesting problem I stumbled across- would it be possible for a python script to open up a calc document and change the values of cells? Absolutely no idea how to approach that, suggestions welcome :)
Cadellin
  • 1
  • 1
  • 1
-1
votes
1 answer

Unable to get Libre Office to load on redhat 6. Get stuck at the splash screen

This recently starting happening. I had been happily using libre office previously. I have tried rebooting and re-installing libre office with no effect. Using version 5.3.3.2-2.x86_64 of libre office. Using Redhat 6 version…
Jeff Gaer
  • 134
  • 1
  • 11
-1
votes
2 answers

Copy data from Spreadsheet[LibreOffice Calc] to tables of Text Document[LibreOffice]

This was very interesting and challenging task for me. I want to copy data (1000s of rows with multiple columns) from Libre Office calc[spreadsheet] to the tables in Libre Office Writer[Text Document]. I spent almost a day to figure out the…
Praveen Hiremath
  • 4,209
  • 2
  • 17
  • 11
-1
votes
1 answer

Matching a row where two cols have multiple, repetitive values

I'm trying to match two cells in an area that has two columns, each with multiple repetitive values, and simply return something that indicates there is a match row. I'm doing this in LibreOffice Calc, but I'd like to be able to share it in an Excel…
RainMan Jim
  • 1
  • 3
-1
votes
2 answers

Split comma separated string/value to columns

I have comma separated CODE value in column "A2" and "A3" Screenshot 1 I want to split the comma separated CODE values to SP_1,SP_2 ... SP_10 columns like as the below screenshot Screenshot 2 Is there any formula to do this?
Sumon Sarker
  • 2,707
  • 1
  • 23
  • 36
-1
votes
1 answer

How can I merge CSV rows that have the same value in the first cell?

This is the file: https://drive.google.com/file/d/0B5v-nJeoVouHc25wTGdqaDV1WW8/view?usp=sharing As you can see, there are duplicates in the first column, but if I were to combine the duplicate rows, no data would get overridden in the other columns.…
aaa
  • 41
  • 2
  • 9
-1
votes
1 answer

libreoffice calc - varargs in macros

I understand Excel has a TEXTJOINfunction which allows one to display multiple values as a tuple. I also understand Libre Office does - for whatever reason - not have them. How do I write an auxiliary macro vec that produces the desired tuple…
User1291
  • 7,664
  • 8
  • 51
  • 108
-1
votes
1 answer

How to use LOOKUP from two different sheets?

I have a Calc document that has N sheets. First sheets are equal and contain some data. Last sheet is a summary. My problem is that I need to use the LOOKUP function in the last sheet to look up for data in the N-1 previous sheets. This doesn't…
Ivan
  • 14,692
  • 17
  • 59
  • 96
-1
votes
2 answers

'Sampling' equivalent function in Calc

Is there a 'Sampling' equivalent function (that is present in Excel) in Calc? I would select a random subset of cells from a big set.
PenguinEngineer
  • 295
  • 1
  • 8
  • 30
-1
votes
1 answer

Dropdown list in excel using formula

Is it possible to generate drop-down list using a formula in excel ? I know it can be done using Data-validation but I don't want to use it. For example: I have 1, 2, 3, 4 in A1-A4,In cell B1 I will use a formula, which will render a dropdown list…
Aerl
  • 1
-1
votes
1 answer

LibreOffice/Excel Table Calculation Formula

I have three Columns in one sheet. Col1 Have Combination Of Col2 Values, I need to replace Col1 Value as equal Of COl2 = col3 Value. Is there Any Formula to do this in LibreOffice Calculation. Actual Table: Col1 | col2 | Col3 A | A | X …
Kamal kannan
  • 253
  • 3
  • 17
-1
votes
1 answer

How can I find values in a table on excel or LibreOffice Calc?

I'am triyng to make a table, where I put person names in the first column and citys in the first row. I am going to choice one person name and one city, I want to know how many of this certain name staying in this certain city. I would like to know…
victorcd
  • 429
  • 2
  • 6
  • 17
-1
votes
1 answer

MS-Excel Interest calculation using =IF

I want to calculate an interest on a fee, that is if a client has not paid full amount of fee before the 15th of the month an interest of 10% should added to the amount to be paid my cells are Amount payable Column B Amount paid Column c…
lord-ivan
  • 73
  • 2
  • 3
  • 12
-1
votes
1 answer

Matching value in A to value in B to return value from C where A has duplicates

I have data like: A B C 1 1 hi 2 2 hello 3 3 howdy 3 4 hi 4 5 hi there 5 6 hello there 5 7 howdy 6 8 hi A and B contain the same values, however A has some duplicates which need to be kept. B does not contain any duplicates or any other values not…
gingerling
  • 1
1 2 3
…
57 58