Stack Overflow
Stack Overflow

Questions tagged [libreoffice-calc]

Calc is the spreadsheet program included in the LibreOffice Suite.

871 questions
48
votes
4 answers

Does LibreOffice Calc support JSON file importing/sorting?

I've been trying to import a couple of .json files into LibreOffice Calc. Although I can get the raw data in, it isn't sorting as I would think it might (by placing different pieces of info into each cell). Does LibreOffice provide support for…
Joe
  • 3,120
  • 3
  • 25
  • 30
37
votes
3 answers

How to generate pdf from a libreoffice calc sheet fitting the page width?

Using LibreOffice 4.1.2.3 in Ubuntu 13.10 I am desperately trying to export the content of a sheet (4 columns) into a pdf (portrait), so all 4 columns fit on a page. A page nicely explains all the settings - but they do not have any effect! I select…
Alex
  • 41,580
  • 88
  • 260
  • 469
26
votes
3 answers

How to refer to a cell when the address is in a variable

For example, in an expression, instead of writing the address A1, how can I write something like: A(B1) with B1 = 1.
Hoa Vu
  • 2,865
  • 4
  • 25
  • 33
19
votes
3 answers

Replace LibreOffice formulas with their calculated values in an entire column at once

I can replace a formula in one cell by its calculated value by selecting the cell, hitting F2 then F9 and Enter. When I want to do this for every cells in a column, and height of that column == N, then the repeating of this job N times is not happy…
user3766478
  • 641
  • 2
  • 7
  • 16
17
votes
4 answers

Libreoffice Calc: convert many cells with text to numbers

I have got many cells in my file whose content is of the form '14.05 I want to mass convert these cells, which contain text, to numbers, which I can compute with. 14.05 Is there a build-in function in Libre Office for such mass conversion, or do…
shuhalo
  • 5,732
  • 12
  • 43
  • 60
17
votes
3 answers

xlsxwriter and LibreOffice not showing formula's result

I'm trying to create an Excel file with a simple formula: import xlsxwriter workbook = xlsxwriter.Workbook('testxlsx.xlsx', {'strings_to_numbers': True}) ws = workbook.add_worksheet() ws.write('A2', 'Number one') ws.write('B2', '1') ws.write('A3',…
Luc
  • 173
  • 1
  • 6
16
votes
1 answer

How to sort rows according to one of the columns?

I have a table in which I attempted to sort rows by the D column: So I selected the column and clicked Data > Sort > Current Selection > OK. The result is this: Which is not what I want because it has modified cells in the D column. Before, there…
Andrej Repiský
  • 477
  • 1
  • 6
  • 19
16
votes
1 answer

Can I use OR in LibreOffice calc IF statement?

I'm trying to achieve something like: =IF( N2="string1", "high", IF( N2="string2" or N2="string3","middle","low") ) Or, in psuedo code: String input = if( input.equals("string1") ) { return "high" } else if ( input.equals("string2)…
DaFoot
  • 1,475
  • 8
  • 29
  • 58
14
votes
2 answers

LibreOffice Calc: how to highlight row as per cell value?

In the spreadsheet I want to automatically highlight row once a particular cell value is entered. I've configured H column with list values: [valid,invalid] in Data→Validity. The idea is to apply custom hlt-invalid-bg style to row where "invalid"…
Onlyjob
  • 5,692
  • 2
  • 35
  • 35
14
votes
3 answers

Converting LibreOffice Calc URLs to text

I have a LibreOffice 3 spreadsheet (on Ubuntu 11.04) with a column of hundreds of hyperlinks which simply display as 'Link'. I need to convert these to just plain text, or at worse hyperlinks which display the hyperlink rather than the text 'Link'. …
Christian Mayne
  • 1,709
  • 7
  • 26
  • 42
13
votes
3 answers

Define global variables

I'm trying to test some algorithms in LibreOffice Calc and I would like to have some global variables visible in all cell/sheets. I searched the Internet and all the posts I have seen are so cryptic and verbose! What are some simple instructions of…
Foad S. Farimani
  • 12,396
  • 15
  • 78
  • 193
12
votes
3 answers

Spreadsheet calculations with (at least) the accuracy of a C double

I was doing some calculations for planning an improved implementation of my prime sieve when I noticed that the Libre Office spreadsheet was showing the wrong values for numbers far below 2^53, which is the limit for precise integer calculations in…
DarthGizka
  • 4,347
  • 1
  • 24
  • 36
12
votes
2 answers

How to highlight a cell if there is a specific word inside?

I'm looking for something that can highlight all cells/strings that contains a specific string. I'm using Calc on LibreOffice.
Videl
  • 840
  • 2
  • 7
  • 18
11
votes
4 answers

How do I change the date format from MM/DD/YYYY to DD/MM/YYYY in libreoffice calc?

I have a spreadsheet with existing date values that I'd like to convert from MM/DD/YYYY to DD/MM/YYYY format. Is there any way of doing this? The spreadsheet comes from a csv file from someone else that i have opened in calc.
Steve
  • 418
  • 1
  • 4
  • 16
11
votes
5 answers

How to swap two cells in LibreOffice Calc

I'd like to be able to select two cells in LibreOffice Calc, and press a magic key of some kind, with the result that the content of the two cells are exchanged. How do I do that? I found this solution for Excel, but it doesn't work in…
Jesper K. Pedersen
  • 148
  • 1
  • 6
1
2 3
…
57 58