Tag: openoffice-calc

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