Stack Overflow
Stack Overflow

Questions tagged [libreoffice-calc]

Calc is the spreadsheet program included in the LibreOffice Suite.

871 questions
4
votes
6 answers

Reverse columns order in libre office calc

Suppose I have This This Cells: And then for some reason I want to reverse the order of columns automatically to become something like This: any help will be appreciated!
SirSaleh
  • 1,452
  • 3
  • 23
  • 39
4
votes
1 answer

LibreOffice Calc new line in cell format code

Is it possible to put new line character in cell format code? For example to have week day name under the date in the same cell?
Szybki
  • 1,083
  • 14
  • 29
4
votes
1 answer

Referencing the row below the current one in OpenOffice / LibreOffice Calc

In OpenOffice Calc / LibreOffice Calc, I need to find out if a cell in the row below the current cell is empty. To do this, I use the ISBLANK() function. For example, ISBLANK(B5) That works well, but I need the function to be generic to always look…
RockPaperLz- Mask it or Casket
  • 5,361
  • 10
  • 45
  • 69
4
votes
2 answers

Export a range of data in excel to ascii plain text formatted table csv or txt file using vba

I need to export only a range of data from Excel or LibreOffice Calc file to ascii plain text table - text file. The output should be in the format as follows : +--------+--------------+--------+ | Name | Place | Phone …
adam1969in
  • 117
  • 2
  • 9
4
votes
2 answers

Image does not show in header when opened with LibreOffice

I've needed to create a custom invoice using Python XlsxWriter, where I need to create a custom header with a company logo. The resulting workbook must be opened using LibreOffice, not Excel. Using the example from here. My code is: #!/usr/bin/env…
Gavin Yap
  • 642
  • 12
  • 26
4
votes
1 answer

selecting a cell in LibreOffice Calc

So I have a macro to clear some cells A2-A250 but I want to return to cell A1 once I have finished Sub reset Dim oActiveSheet As Variant Dim oCellRangeByName As Variant oActiveSheet =…
OliverH
  • 61
  • 1
  • 3
4
votes
1 answer

LibreOffice Calc, how to count the number of columns in a table?

My request is very simple. I just opened a csv file with LibreOffice Calc, and I notice that the columns go from A to BL. I need to know how many columns there are, in this A-BL range. How could I do that?
DavideChicco.it
  • 3,318
  • 13
  • 56
  • 84
4
votes
1 answer

Separate text from URL in Excel column

What I have is a column in Excel with a list of URLs like this: first link second link ... What I would like is to separate the "text" from the "URL" like this: first link | http://www.example.com/1 second link | http://www.example.com/2 ... I'm…
Aubrey
  • 507
  • 4
  • 20
4
votes
3 answers

Is a cell value in column B in column A? (LibreOffice-Calc)

Column A has a sorted-descending list of some bum's Top-250 movies, in the following format: Apocalypse Now (1979) Column B has a sorted list of My Top-100, in the same format. Both lists have been copied and pasted into a Notepad text doc to…
Larry
  • 165
  • 1
  • 8
4
votes
1 answer

Generate new writer document from template with calc cell values

I have a LO Calc spreadsheet to collect my invoices in. I would like to automagically fill a new writer doc from a specific template with the values from one row of the invoice spreadsheet. Best would be to set the filename according to the calc…
lars k.
  • 562
  • 4
  • 18
4
votes
1 answer

LibreOffice Calc: How to open CSV with numbers as text?

I'm trying to open a CSV (UTF-8) file with the following content in LibreOffice (4.4.7). Content is: 00442523534546234234;asdf asdf;888234800000000023400000 But what I get after the import is: 4,42523534546234E+017 asdf asdf …
robsch
  • 9,358
  • 9
  • 63
  • 104
4
votes
1 answer

LibreOffice Link to external data

I have a problem to import into LibreOffice an external csv . I press OK, and everything is formatted correctly After the "ok" button is disabled and I can not continue.. Any suggestion?
Fr4ncx
  • 356
  • 6
  • 22
4
votes
1 answer

Multiple the numbers of a specific column with a number in libre office

How can I multiple the numbers of column A with the number eg 5? I use LibreOffice. Thank you
elli
  • 1,109
  • 1
  • 13
  • 20
4
votes
1 answer

Create ODS worksheets from CSV files

I have a set of CSV files, which I need to convert to a single ODS (or even excel) spreadsheet with multiple tabbed worksheets. Currently I'm using the pyexcel library for python, but it's buggy and horribly slow. Libreoffice has a nice file…
Rachie
  • 433
  • 1
  • 6
  • 17
4
votes
1 answer

Parametrized conditional formatting

I am trying to dynamically set the Style of a row in Calc. After giving up using a macro (see Changing cell background color in LibreOffice), I tried with Conditional Formatting rules (Format --> Conditional Formatting). I would like to set a…
Campa
  • 4,267
  • 3
  • 37
  • 42
1 2 3
…
57 58