123 Is there a way to scroll, by pixel, instead of by cell, in either Excel or OpenOffice Calc? 2014-07-03T19:37:26.383
77 How to create a formula for every row in a column in Google SpreadSheet? 2011-03-21T21:03:19.213
76 OpenOffice: get distinct values from column 2011-01-27T20:48:22.377
45 How to color rows based on cell value in OpenOffice and LibreOffice 2013-05-23T04:06:39.123
37 How NOT to print sheet name and page number in OpenOffice.org Calc? 2010-10-16T07:54:10.097
25 Export Excel graphs as vector graphics files (e.g. SVGs)? 2012-04-23T15:30:29.137
21 Copying just text, not formulas, in OpenOffice Calc 2009-11-12T02:55:27.697
19 Can you reference an entire column in OpenOffice Calc (like A:A in Excel)? 2010-07-06T08:56:30.313
18 Preventing LibreOffice from using smart quotes (“ ”) instead of (dumb) straight quotes? 2013-09-10T20:03:20.137
13 How to set the default font in LibreOffice Calc? 2011-06-25T14:35:12.747
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 Open Office Calc: Convert a date to timestamp 2012-08-08T14:41:39.850
11 How to get VLOOKUP to return the *last* match? 2014-07-11T18:46:53.363
10 OpenOfficeOrg Calc: enter data into all selected cells? 2011-03-11T08:35:41.447
10 Sorting in Calc: how to make column headers become dropdown menus for sorting 2011-06-13T07:41:58.390
10 LibreOffice pivot table group by month 2012-07-18T14:54:47.957
9 Permanently and globally stop openoffice calc from autocorrecting dates/time 2011-08-25T22:16:34.653
9 How to highlight whole row and column under cursor in OpenOffice Calc? 2015-04-09T08:46:35.187
8 How can I make a newline in an Openoffice.org Calc formula? 2009-12-19T18:07:52.873
8 Move rows with the keyboard in Calc 2013-10-22T11:48:56.977
7 In OpenOffice Calc, how do I drag and drop cells to insert rather than replace their destination? 2010-03-26T16:14:32.737
7 OpenOffice.org calc: how to dynamically update a data range for a graph? 2011-04-15T17:45:27.783
7 OpenOffice Calc: reduce file size when saving as Excel 2014-07-05T11:05:11.357
6 How to create diagram in spreadsheet with dates on x-axis? 2010-01-13T12:47:56.410
6 How do I test if a cell in OpenOffice Calc contains #N/A? 2010-03-02T09:57:42.013
6 Inserting an image into a OpenOffice.org Calc cell 2010-04-15T21:25:00.663
6 How do I export the charts in a spreadsheet as PNGs? 2011-04-20T21:17:58.800
6 Copy value in Open Office Calc 2011-05-23T21:35:41.527
6 How do I create a line graph which ignores zero values? 2011-09-07T03:26:59.660
6 How to reference variable sheet in OpenOffice Calc? 2012-07-11T20:53:30.370
6 Libreoffice calc relative and absolute cell reference on copy-paste 2013-01-25T09:46:39.973
6 How to find and remove external links in (Libre|Open)Office Calc spreadsheet 2015-01-25T10:51:30.090
6 Alternate If() function in Excel/OOCalc 2015-10-02T16:37:52.277
5 Is it possible to create a "background bar" for a cell in OO calc? 2009-11-23T15:38:13.323
5 Set CSV import default to UTF-8 in Calc 2010-03-15T12:06:54.627
5 Calculations in terms of degrees minutes seconds in excel , libreoffice/openoffice or any other free spreadsheet 2011-05-11T06:46:24.567
5 How can I split a formula into multiple lines in OpenOffice calc? 2011-05-24T13:59:53.190
5 Saving to CSV file always adds quotation marks in OpenOffice 2011-09-15T10:18:06.117
5 Autocomplete only on demand in OpenOffice Calc 2013-06-07T11:09:24.637
5 Openoffce Calc - Substitute space with line break by function 2013-08-12T08:57:16.827
5 Is it possible to remove the hyperlink background in OO Calc? 2013-11-30T02:23:26.773
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 Set a row to follow my cursor anywhere in Calc 2009-08-31T11:21:48.253
4 How to stop OpenOffice Calc from rounding numbers? 2010-02-10T19:59:11.197
4 Finding difference in time using OpenOffice.org Calc 2010-02-22T21:24:17.960
4 Freeze both row and column in OpenOffice Calc 2010-06-07T16:26:42.683
4 Spreadsheet forumula questions to pick a random DVD 2011-01-30T15:36:54.090
4 Open Office Calc - Round to 5? 2011-07-25T17:46:41.440
4 OpenOffice Calc - how to insert BLANK in a formula? 2011-10-15T12:13:34.420
4 Finding min/max values in column where cell matches something 2012-09-14T11:33:40.647
4 Spreadsheet VLOOKUP: Search in second column and return first 2012-09-27T14:04:42.880
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 Fill right in OpenOffice/LibreOffice 2016-03-17T07:10:56.360
4 Handle pasting of decimal with dot (1.7) when locale is expecting comma (1,7) 2018-01-02T23:52:50.163
4 In LibreOffice Calc, how can I change the cell selection black ring to something lighter for dark backgrounds? 2018-06-15T22:59:04.720
3 Prevent Excel from updating absolute references when target is moved 2010-02-17T16:38:19.107
3 Ubuntu: Convert OpenOffice Calc to Excel workbook using CLI 2010-03-01T15:04:28.707
3 Disabling Autoformat in Openoffice 2010-07-01T15:40:23.253
3 Days in year between certain dates 2010-11-01T08:47:12.640
3 Open Source Spreadsheet with Sensitivity Analysis 2011-02-10T16:15:13.220
3 is text from a cell in a column? 2011-04-06T05:23:12.270
3 Get adjacent column value in OpenOffice.org Calc 2011-07-03T03:15:05.090
3 How do I make a random selection in a spreadsheet using more than one criteria 2011-08-15T15:26:31.630
3 How to set 2 conditions / criterias for VLOOKUP / LOOKUP / etc in OpenOffice Calc (or Excel) 2011-11-10T20:54:27.953
3 Sort Numerically in OO Calc functions alphabetically 2012-01-10T13:51:53.850
3 Is it possible to create a combination line and area chart in OpenOffice Calc? 2012-03-14T08:06:08.667
3 Can two rows be reordered into one column in OpenOffice/LibreOffice Calc? 2012-03-15T02:03:11.030
3 Retrieve content of different cells based on input 2012-05-23T14:05:29.637
3 OpenOffice Calc - Highlighting the higest value in a column 2012-08-30T14:17:34.427
3 Excel/Calc/Whatever: Flip my axes - ie reflect my table across the diagonal 2012-08-31T20:28:25.280
3 Modify value of a cell using the old value as part of the new one? 2012-09-08T17:53:41.683
3 OpenOffice Calc weighted average 2012-09-10T15:55:08.770
3 How can I use extremely large numbers in my spreadsheet programs? 2013-06-02T16:06:58.370
3 Openoffice Calc - use cell font color in formula 2013-07-25T07:15:17.507
3 Excel says my files are corrupted, but they are not 2013-12-02T11:46:06.240
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 Get DayName from Date in OpenOffice Calc? 2015-03-11T15:00:21.127
3 Can you apply names in OpenOffice Calc the same way you can in Excel? 2015-05-15T14:42:12.603
3 LibreOffice Calc equivalent to Excel "Evaluate Formula" feature 2015-07-11T18:15:02.427
3 Which delimiter allows major spreadsheet programs to open CSV files by double-clicking? 2015-08-17T11:26:12.960
3 How to create an array of values in LibreOffice Calc? 2016-09-23T16:51:33.253
3 Highlighting every other row in LibreOffice (or OpenOffice) without conditional formatting? 2016-12-01T07:55:00.890
2 embed pictures from web by url in excel spreadsheet (or oo calc) 2009-10-08T12:19:06.120
2 Copying a region of Calc cells into a Writer document as a table 2009-11-04T04:44:48.380
2 showing the formulas but not the values in Open Office Calc 2009-11-12T05:13:17.553
2 In a spreadsheet (Excel, Google Docs, OpenOffice), how do I transpose data from rows to columns, but only non-null cells? 2009-12-17T14:44:31.287
2 How do I use address data in Calc to populate labels in Writer in the OpenOffice.org suite? 2010-07-24T19:09:54.223
2 Repeat rows at top of printed page 2010-08-18T15:32:07.107
2 Database access through odbc driver and excel 2010-08-27T15:07:54.110
2 Copying Formulas to Show 2010-10-24T07:03:45.110
2 What syntax allows the condition in OpenOffice's SUMIF function to match a regular expression in a different cell? 2011-03-11T18:27:17.943
2 How to conditionally highlight cells in OpenOffice Calc? 2011-05-24T09:00:13.843
2 Copy only cell content in OOCalc 2011-05-26T23:21:44.823