Top "Libreoffice-calc" questions

Calc is the spreadsheet program included in the LibreOffice Suite.

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 …

json sorting import libreoffice-calc
Applying row based filter instead of column based in LibreOffice or other SpreadSheet tool

We all know the standard filter, where you pick which rows to show depending on values in a particular column (…

excel libreoffice openoffice-calc libreoffice-calc
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 …

libreoffice-calc
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), …

pdf libreoffice-calc
LibreOffice Calc / OpenOffice Calc: How to filter rows based on their background color?

I'd like to filter out rows with a specific color on a specific column. I tried to search nearly everywhere …

openoffice-calc libreoffice-calc
Libreoffice calc: loop throught cells macro

I've been searching a lot but could find little to no info about LibreOffice Basic I'm a bit used to …

macros libreoffice libreoffice-basic libreoffice-calc
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 …

if-statement libreoffice libreoffice-calc
How to define dynamic ranges on Calc (or Excel)?

Let's say I have a Libreoffice.org Calc (maybe this goes for MS Excel too) object defined as the range $…

excel range libreoffice-calc
LibreOffice Calc count the number of distinct occurrences

What formula in LibreOffice Calc will count the number of distinct Week_Number occurrences? The answer should be 2.

libreoffice-calc
Reversing Text to Columns in Excel/Calc

Most spreadsheet software I've used has a text-to-columns function that splits a single column into multiple columns using several criteria (…

excel string vba libreoffice-calc text-manipulation