Spreadsheet component of the LibreOffice suite

learn more… | top users | synonyms

3
votes
1answer
11 views

Libreoffice, how to copy from Writer and pasting unformatted in Calc, by default?

I have the revision of a translated text, made by the client, I am the third party reviewer and have to fill up an .xls module with all the source texts, the translated one, and the amended by the ...
3
votes
1answer
281 views

How do I conditionally format a cell that contains a dropdown list

Hi Guys I want to know how to conditionally format a cell that contains a drop down list of 3 values. I want each value to represent a different coloured background when selected in the drop down ...
3
votes
1answer
281 views

Cut and transpose in LibreOffice

When using cut and pasting LibreOffice maintains exact formula used along with moving old references to point to the new location, however when using paste special: transpose it treats the past as if ...
3
votes
1answer
869 views

Changing the cell range of conditional formatting in LibreOffice Calc

Is there any way of changing the range of conditional formatting in LibreOffice Calc (version 3.6)? I have a set applied already to a range of cells, but there is no obvious way of changing which ...
3
votes
1answer
1k views

Open Source Spreadsheet with Sensitivity Analysis

Is there any good Open Source spreadsheet program that has a solver for linear programs (either included or via an extension) that does a proper sensitivity analysis (shadow prices etc)? It seems like ...
2
votes
1answer
764 views

Getting date of last change as a cell value in Open Office Calc

I have a few Open Office spreadsheet files (let us call them source files), each containing the financial info of a particular office of ours. I also have a summary spreadsheet, that reads some key ...
2
votes
1answer
2k views

how to get Libre Office to adjust row height to accommodate text entry?

I need for LibreOffice to automatically adjust row height for text entries. I have tried to acomplish this by checking the wrap text option, which I thought would be the solution, but it is not. How ...
2
votes
1answer
125 views

Tagging or defining automatically in an Excel or Libre office spreadsheet?

I want to review and sort my expenditures in a spreadsheet where I have all my transactions listed. Is there a way to automatically label or tag to categorize the transactions like in a budget ...
2
votes
1answer
722 views

LibreOffice Calc: Formatting Time is adding ' char

I have some data in calc like so: 05:00:27 01:27:02 07:29:57 06:22:01 I select the cells, and right click 'format cells', and choose Time -> 876613:37:46. When I do this, it adds an apostrophe ...
3
votes
0answers
31 views

Disabling spell checker in OpenOffice Calc (or LibreOfffice Calc)

Is there a way to disable the spell checker in OpenOffice Calc (or LibreOffice Calc) without disabling it for the other programs in the office suite? I would prefer to just disable it for a range of ...
3
votes
0answers
3k views

Openoffice Calc - use cell font color in formula

I have some openoffice calc sheets where some rows are maked with the font color red. All other rows are in the default font color. Can I use the font color of a cell within a formula to react to ...
2
votes
0answers
117 views

How to customize default CSV format in LibreOffice?

Every time I export my data to CSV (and I do it often) I have tick the "Edit filter settings" checkbox, choose UTF-8 for the encoding, and semicolon for the fields separator manually. I do this ...
2
votes
0answers
188 views

Disable prompt when opening a CSV file in LibreOffice/OpenOffice Calc

Every time I open a CSV file, LibreOffice presents me with a prompt asking to confirm Character Set, Language, and Separator options (tab, comma, semicolon etc). This prompt is not present in ...
2
votes
0answers
31 views

Libreoffice calc: pagebreak within row?

When printing a LibreOffice Table, LibreOffice will automaticaly place the pagebreaks so that they appear after/before a row. When having many tall rows this results in a heavy paper-usage. How can I ...
2
votes
0answers
690 views

LibreOffice Calc, how to filter rows based on interval

I would like to filter a spreadsheet on LibreOffice 3.4.4 Calc, based on values of a second spreadsheet column. How can I do that ? I would like intersection and, if possible, complement filters. So ...
1
vote
0answers
14 views

Libre Office - merge sheets

In one file I have two sheets, which share some of the columns. I'd need to merge the sheets based on column name, if the column does not exist, add it. Ie. I have Sheet 1 ...
1
vote
0answers
23 views

Change color for all set borders

Having a table with some complex borders. How can I change the border color for all borders in the table? Know I can change one by one, but that is a hassle. For example: +-----+--+ |1A 2A|3A| |1B ...
1
vote
0answers
68 views

OpenOffice / LibreOffice ugly font rendering

I'm using Calc to generate some graphs of data I have collected. But somehow the font looks increadibly ugly in all of LibreOffice. I'm using Noto Sans CJK JP Light in this chart but pretty much every ...
1
vote
0answers
36 views

LibreOffice Calc changes letter from uppercase to lowercase under certain circumstances

I want to enter SXer into a field, however the X gets automatically converted to x. If I only write SX, the X stays the way it is. If I write SXEr, all letters stay as they are. But somehow I can't ...
1
vote
0answers
26 views

Libreoffice Calc adds extra commas or semicolons to formulas and doesn't return the answer

I am using LibreOffice 3.5.4.2 Build ID: 350m1(Build:2) On a Debian Jessie machine. Whenever I input any inbuilt calc/excel function, it adds random commas (sometimes semicolumns) between ...
1
vote
0answers
44 views

How can I remove " from my string..?

My string has " and I dont want " then what to do..? My string is like : "Hey My name is Viper I want remove " from string How
1
vote
0answers
51 views

How to reference cells by name in Libreoffice 4.2

In the Libreoffice version that came with Ubuntu 12.04, I could select a column, name it, and then construct a formula that referenced this name. e.g. Say I had two columns A=Price and B=Quantity. If ...
1
vote
0answers
90 views

Create a pie chart from amount/category pairs

From a table like Amount | Category 2 A 1 B 5 A how to create a pie chart with one sector per category found in the second colum and the summed up values for each ...
1
vote
0answers
156 views

Equivalent for FILTER() formula in Libre Office

In a Google Spreadsheet, I create a report sheet by entering a formula like this in the top left cell. =FILTER(Sheet1!A2:E, Sheet1!E2:E > 0) This gives me all the rows in the Sheet1 from row ...
1
vote
0answers
58 views

Return an array from a lookup

I have a table with column A containing vendors and column B containing product codes. One vendor has many product codes. In another place I need an array of product codes for a specific vendor. The ...
1
vote
0answers
242 views

updating links in LibreOffice Calc xlsxfile results in err:509

I have just started to use Libreoffice so I am totally new to the system and immediately encountered a problem with a calc document. The document has originally been made in Excel (but on a Mac) and ...
1
vote
0answers
244 views

Why is libre office calc inserting a ' at the beginning of the cell?

This is the most ridiculous thing i've encountered.. I've imported a csv, I end up with nice neat clean rows of numbers, no formatting, nothing weird, no " or ' left over, just numbers. When I go to ...
1
vote
0answers
509 views

How to force LibreOffice Calc to treat time values as numbers

I want to do something very simple in LibreOffice Calc: I have a set of simple CSV files that contain lists of durations, formatted as HH:MM:SS. I need to make a SUM of those lists. With some ...
1
vote
0answers
254 views

LO Calc: Why are data labels placement options greyed out?

When creating pie charts I like to add the values of the individual slices to the chart. LO Calc allows you to do this ('Add data labels') By default Calc places these values in the center of the ...
1
vote
0answers
553 views

Libre Office Calc, User-defined Number format permille

I know that LibreOffice allows you to define custom number formats. I have a spreadsheet that displays some smallish percentages (all are less than 1%). I would like to use permille ‰ instead. ...
1
vote
0answers
166 views

Formatting text in a LibreOffice Calc cell

Currently I'm working on the layout of a calendar for the new year 2013. I found a template that was designed in LibreOffice Calc. How can I layout the text in the cell of a Calc program? What can I ...
1
vote
0answers
572 views

Copy formula across row incrementing sheet number, down column incrementing number by 2

I have information on four different sheets I would like to copy to this summary sheet. I want to know how do I copy the formula across the row and down the column on this summary sheet(say this is ...
1
vote
0answers
104 views

Extracting “tag1, tag2” values from a column in LibreOffice-calc

I've got a LibreOffice calc spreadsheet with columns containing some freeform text, followed by a column with "tags" which I've entered (coded interview data). For example: 1234,"some explanation ...
0
votes
0answers
12 views

How to create a new Libreoffice-Calc document from template with specific name and save it immediately via commandline?

I'm looking for a way to create a new spreadsheet from a template, name it and save it immediately with the help of the command-line. I tried the -n switch, but it creates a temporary file called ...
0
votes
0answers
33 views

LibreOffice (Calc) | Search & Replace | unable to look for 'comments'

CTRL+F enables the SearchBar (quick search) CTRL+H brings up Find & Replace dialog (more options) I'm unable to find a way to look for comments that are within with a cell (with ability to ...
0
votes
0answers
32 views

Libre Office Calc Issue: Summarizing columns with too many rows

I'm writing a script that reads data taken from a database. THe data is modified (de-duplicated) and put into a .csv file I have a problem as I want to find the sum of a particular column in excel. ...
0
votes
0answers
15 views

Currency aware summation in LibreOffice Calc

I have a spreadsheet with columns of the form: Date A B Total 01/01/15 $100 £200 xxx 08/01/15 $110 £195 xxx 15/01/15 $115 £205 xxx where A and B are ...
0
votes
0answers
19 views

How to show the total number of results in a “Find All” search in LibreOffice Calc?

LibreOffice Calc provides the useful search function to "Find All" instances for a search term. It outputs a result window which looks as follows: What I miss is the total number of found search ...
0
votes
0answers
29 views

LibreOffice Calc Automatic Detection of Duplicates

Is there any way you can automatically detect a duplicate of any previous cell, the very moment you entered the text? like when you input the word "data" it will be automatically highlighted because ...
0
votes
0answers
33 views

LibreOffice Calc equivalent to Excel “Custom Views” feature

Custom Views are an Excel feature that comes very handy when, for example, you want to save a filtered version of a worksheet and then pass to another vision of the same worksheet with different set ...
0
votes
0answers
32 views

Switch off autocorrect in libreoffice calc for specific document, column, cell

There is a way to completely turn off autocorrect in libreoffice calc. However, I would prefer turn off autocorrect in less scale: document, worksheet, column/row, cell. How it can be obtained?
0
votes
0answers
149 views

oocalc unknown node setting file

When I run oocalc, I get a warning: W: Unknown node under /registry/extlang: deprecated This looks like a Python warning to me. However, I do not see the warning when running Python scripts. My ...
0
votes
0answers
111 views

Libreoffice-calc: Apply a macro to a csv-file on the command-line

With Libreoffice/Openoffice it is rather straightforward to do these steps: Import csv file Copy macro from another file Run macro Remove macro Save file in csv and xls formats (no macros, just ...
0
votes
0answers
69 views

Concatenate a reversed range in Libre Office

I'm kind of new with programming, but I have to make an excel document, that I can use interactively because the output of one of my programs doesn't fit with the input of the others... I have lot of ...
0
votes
0answers
53 views

Disable spell checking/auto correct in Libre Office Calc for a specific file?

Is it possible to disable spell checking and/or auto correct in the Libre Office Calc application on a file by file basis? Normally in calc I want spell checking turned on, but for some files it just ...
0
votes
0answers
25 views

Position cells within view and copy functions/formulas from existing cells in Libre Calc?

I would like to keep a specific range of rows visible in Libre Calc. As new rows of data are entered, I would like the sheet/page to scroll, keeping the current row visible. As a comment made me ...
0
votes
0answers
163 views

LibreOffice calc; is it possible to automatically make cells coloured according to the HTML code entered into them?

I am creating a LibreOffice calc spreadsheet designed to be basically be a customized version of the table entitled "Default element colors, by atomic number:" on this page ...
0
votes
0answers
154 views

Is it possible to recover cells with hidden content wiped out upon opening with LibreOffice

Some of my .xls Microsoft Excel files contain cells with hidden information formatted using custom code ;;; to deter casual viewing. I made the switch to LibreOffice a year ago and converted all the ...
0
votes
0answers
85 views

Libreoffice won't let me have a read-only ComboBox

I have a database table with some entries. I want to display all the fields of this table as a ComboBox. I want the user to be able to select this any entry in this ComboBox without modifying the ...
0
votes
0answers
441 views

How to fill in formulas automatically in LibreOffice Calc?

How can I get LibreOffice Calc to automatically fill in formulas from the current row into the next row? I have a spreadsheet for keeping track of my personal finances and I'd like to just press ...