45 How to color rows based on cell value in OpenOffice and LibreOffice 2013-05-23T04:06:39.123

36 How to remove a plain text protecting single quote from all the selected cells in LibreOffice Calc? 2012-02-26T01:46:08.000

34 LibreOffice Calc: How to get total for HH:MM:SS cells 2012-02-07T16:49:04.677

24 How to add month to date in LibreOffice calc 2013-07-09T17:34:57.257

23 How do I create a sum for each group of data in Libre Office Calc? 2013-03-04T15:29:03.430

22 What is in LibreOffice Calc the equivalent to Excel's "Paste Special > Value"? 2011-12-29T08:04:46.363

13 How to set the default font in LibreOffice Calc? 2011-06-25T14:35:12.747

13 How do I get data or percentage displayed in libreoffice pie chart? 2012-01-22T22:09:07.770

12 How do I get a chart in LibreOffice Calc to have regular time intervals when the data is not regular? 2012-06-17T06:20:21.633

12 How to scale a long LibreOffice Calc sheet to fit on two pages when exporting to PDF? 2013-10-31T19:50:33.720

11 Libreoffice: sum of column except one cell 2014-06-14T13:56:49.867

11 How to get VLOOKUP to return the *last* match? 2014-07-11T18:46:53.363

10 How to separate number by its decimal point in Excel/Calc? 2011-05-09T03:43:43.997

10 LibreOffice pivot table group by month 2012-07-18T14:54:47.957

10 Convert the multi-step sum of booleans into a single formula 2018-07-03T08:57:25.193

9 Permanently and globally stop openoffice calc from autocorrecting dates/time 2011-08-25T22:16:34.653

9 In LibreOffice Calc, how can I use the fill handle to copy formulae, but not the cell/border formatting? 2013-02-01T19:59:29.057

9 Does libreoffice have a math concept like 'infinity'? 2013-05-10T09:41:23.947

9 Switch Calc (or Excel) formulas to English language 2015-08-11T23:50:25.257

8 Move rows with the keyboard in Calc 2013-10-22T11:48:56.977

7 Working with lots of data in LibreOffice 2011-10-19T14:33:55.093

7 LibreOffice conditional formatting based on string value: strange behavior 2012-07-05T06:59:14.373

7 How to make a LibreOffice Calc XY (scatter) plot with named dots? 2012-11-08T15:13:11.423

7 Quickly fill blank cells in a list in LibreOffice Calc 2013-03-08T17:35:05.557

7 how to get Libre Office to adjust row height to accommodate text entry? 2013-03-28T16:38:06.600

7 Default cell background in Calc 2017-11-29T09:20:04.107

6 How do I create a line graph which ignores zero values? 2011-09-07T03:26:59.660

6 LibreOffice: Make all references in selection absolute 2012-02-22T08:57:25.047

6 Why does LibreOffice Calc ask about updating links in Excel 2007 .xls file when Edit | Links is disabled? 2012-04-28T14:53:29.080

6 How can I plot a grouped histogram with LibreOffice Calc? 2012-05-30T17:01:43.000

6 Libreoffice calc relative and absolute cell reference on copy-paste 2013-01-25T09:46:39.973

6 Is it possible to copy & paste a pivot table in a spreadsheet? 2013-05-23T12:11:46.913

6 Equivalent for FILTER() formula in Libre Office 2014-09-04T14:52:01.637

6 How to find and remove external links in (Libre|Open)Office Calc spreadsheet 2015-01-25T10:51:30.090

6 How does the group feature in LibreOffice Calc work? 2015-12-20T08:53:47.513

6 How do I join two tables with LibreOffice Calc? 2016-12-28T13:40:20.737

6 How to set decimal separator in Libre Office Calc? 2017-09-15T15:32:52.503

5 Calculations in terms of degrees minutes seconds in excel , libreoffice/openoffice or any other free spreadsheet 2011-05-11T06:46:24.567

5 LibreOffice Calc prompting to update "links to other files". Why? 2012-02-04T21:28:34.250

5 LibreOffice super/subscripts in axis labels 2012-02-07T09:35:23.900

5 VLOOKUP returns #N/A 2012-04-25T06:21:12.063

5 LibreOffice Calc SEARCH and FIND functions 2012-06-20T12:00:37.227

5 Autocomplete only on demand in OpenOffice Calc 2013-06-07T11:09:24.637

5 How to convert text to numbers for all cells in a spreadsheet? 2013-07-28T06:39:29.730

5 Openoffce Calc - Substitute space with line break by function 2013-08-12T08:57:16.827

5 Currency conversion in LibreOffice Calc? 2013-10-17T09:44:40.187

5 Disable prompt when opening a CSV file in LibreOffice/OpenOffice Calc 2014-02-04T17:08:00.620

5 Interpolate values between two cells 2014-04-04T15:07:59.650

5 Removing functions from a column, but keeping data (convert to normal text)? 2014-09-07T02:53:56.780

4 Can you use infinity in a cell reference in LibreOffice (or any other spreadsheat)? 2011-10-21T16:42:00.930

4 How to rearrange or reorder the contents of a Sheet (LibreOffice Calc) 2011-12-11T18:42:02.460

4 How can I split the wedges of a pie chart to show extra information per wedge in consecutive rings? 2012-01-31T15:12:55.893

4 Finding min/max values in column where cell matches something 2012-09-14T11:33:40.647

4 What does Libre Office do to an existing Excel sheet to bloat its size? 2012-10-16T16:39:24.710

4 LibreOffice / Excel: how to paste data with newline/endline characters inside a single cell 2012-11-01T12:08:44.430

4 LibreOffice Calc Date Insert - Ctrl + ; 2013-02-03T21:00:47.507

4 How do I select non-adjacent ranges in libreoffice calc? 2013-02-13T17:22:09.600

4 LibreOffice: stop automatic formatting of text into a formula? 2013-05-31T12:57:39.797

4 Open only the first 10 lines of large CSV file in LibreOffice Calc 2014-01-03T00:54:21.987

4 LibreOffice pivot: How to count 1 per line? 2014-01-20T03:50:54.783

4 Default font and cell padding when opening files in LibreOffice/OpenOffice Calc 2014-02-04T17:16:20.443

4 Applying Conditional Formatting to all computed values in LibreOffice Calc 2014-02-11T17:40:45.653

4 Libreoffice: How to count words and characters in cells 2015-04-22T09:41:18.990

4 LibreOffice Calc changes letter from uppercase to lowercase under certain circumstances 2015-11-08T18:43:49.717

4 Fill right in OpenOffice/LibreOffice 2016-03-17T07:10:56.360

4 Is there a way to convert 1K to 1000 and 1M to 1,000,000 In LibreOffice Calc 2016-08-27T17:59:02.250

4 How to get number value with leading zeros in LibreOffic Calc? 2017-02-24T09:30:09.797

4 Handle pasting of decimal with dot (1.7) when locale is expecting comma (1,7) 2018-01-02T23:52:50.163

4 How to set line height in Libre Office Calc 2018-07-03T08:58:02.073

3 Open Source Spreadsheet with Sensitivity Analysis 2011-02-10T16:15:13.220

3 Adding a constant in LibreOffice Calc 2011-06-19T10:10:51.307

3 Can two rows be reordered into one column in OpenOffice/LibreOffice Calc? 2012-03-15T02:03:11.030

3 How can I apply a date filter in LibreOffice? 2012-04-24T16:09:22.727

3 Excel/Calc/Whatever: Flip my axes - ie reflect my table across the diagonal 2012-08-31T20:28:25.280

3 How do you find the maximum value in a column, skipping to every nth value? 2012-09-05T23:13:41.147

3 Changing the cell range of conditional formatting in LibreOffice Calc 2012-09-11T08:15:25.667

3 How to efficiently insert a table from R into a Word document? 2012-09-17T13:09:37.237

3 Cut and transpose in LibreOffice 2012-10-04T13:56:45.390

3 Numbers imported into Ubuntu Libreoffice calc from text or csv files are coming in as text 2012-10-13T13:27:53.790

3 LibreOffice Calc/Writer: How to get the dates for specifc weekdays per month? 2012-12-19T00:27:42.113

3 Lookup the nearest value in a column? 2013-03-01T14:56:28.547

3 Sum up to N highest-value out of a series? 2013-03-26T21:20:45.613

3 libreoffice what is a fast way to paste special > text and numbers only (aka paste special values)? 2013-05-07T01:52:03.620

3 How to do a "great circle" calculation in MS Excel or LibreOffice? 2013-06-02T15:26:29.857

3 Openoffice Calc - use cell font color in formula 2013-07-25T07:15:17.507

3 How do I convert a delimited list to a multicolumn table in excel? 2013-08-24T15:06:35.443

3 Find last value in a cell range that meets a condition 2013-09-09T16:10:58.353

3 LO Calc: Why are data labels placement options greyed out? 2013-09-20T07:36:04.780

3 Column order in stacked bar chart is the the opposite from spreadheet 2013-09-30T04:14:52.870

3 How do I conditionally format a cell that contains a dropdown list 2013-10-15T13:38:43.120

3 Decimating rows in spreadsheet 2013-11-26T16:54:35.037

3 LibreOffice Calc - How can I create a custom legend? 2014-04-09T20:18:55.283

3 LibreOffice calc: How to apply multiple tables to a single chart 2014-04-13T15:39:11.520

3 Match cell content based on line break 2014-05-30T14:11:30.903

3 How to save single sheet, as separate file in LibreOffice? 2014-10-31T15:47:27.483

3 #NAME? when referencing cell in different worksheet 2015-01-01T22:00:30.937

3 How to lock a cell for editing in LibreOffice Calc? 2015-04-10T13:35:29.920

3 How to color rows based on two cell values in Open/Libre Office? 2015-04-12T08:52:39.420

3 Switch off autocorrect in libreoffice calc for specific document, column, cell 2015-07-06T13:52:20.347