Calc is the spreadsheet program included in the LibreOffice Suite.
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-calcWe all know the standard filter, where you pick which rows to show depending on values in a particular column (…
excel libreoffice openoffice-calc libreoffice-calcFor example, in an expression, instead of writing the address A1, how can I write something like: A(B1) with …
libreoffice-calcUsing 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-calcI'd like to filter out rows with a specific color on a specific column. I tried to search nearly everywhere …
openoffice-calc libreoffice-calcI'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-calcI'm trying to achieve something like: =IF( N2="string1", "high", IF( N2="string2" or N2="string3","middle","low") ) Or, in …
if-statement libreoffice libreoffice-calcLet's say I have a Libreoffice.org Calc (maybe this goes for MS Excel too) object defined as the range $…
excel range libreoffice-calcWhat formula in LibreOffice Calc will count the number of distinct Week_Number occurrences? The answer should be 2.
libreoffice-calcMost 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