Super User Stack Exchange
Super User Stack Exchange

Questions tagged [openoffice-calc]

OpenOffice's spreadsheet application. Tag questions about macro programming or formulas with macros or worksheet-function respectively

's spreadsheet component. Analogous to .

Apache OpenOffice is an open source office productivity suite.

More specific tags include for scripting and for formulas.

352 questions
167
votes
6 answers

Is there a way to scroll, by pixel, instead of by cell, in either Excel or OpenOffice Calc?

We have lots of spreadsheets that have lists of numbered sound files for an educational app. We use spreadsheet features such as "fill down" for the numbering, and we often use formulas to check whether contents of cells are the same when edits are…
Triynko
  • 3,274
  • 7
  • 24
  • 27
88
votes
4 answers

OpenOffice: get distinct values from column

How do I get a list of all distinct values from a column of values? Basically, this question: How do I get the distinct/unique values in a column in Excel? but I need the answer for Open Office Calc instead of MS Excel. I'm using Open Office 3.2
David Oneill
  • 2,630
  • 7
  • 28
  • 41
81
votes
9 answers

How to create a formula for every row in a column in Google SpreadSheet?

I use three columns. A, B and C. In column C I have a formula every row =A1*(1.6*B1) and then for the next row I have =A2*(1.6*B2) in C2. How can I do so I don't have to type in the new formula in column C for every row? I use it in both Google Docs…
Jonas
  • 26,874
  • 52
  • 105
  • 125
65
votes
3 answers

How to color rows based on cell value in OpenOffice and LibreOffice

How do you automatically set the background color of an entire row based on the value of a specific column in that row in OpenOffice and LibreOffice? There are similar questions for Excel, but this doesn't completely work in LibreOffice. I can set a…
Cerin
  • 8,746
  • 16
  • 54
  • 65
42
votes
1 answer

How NOT to print sheet name and page number in OpenOffice.org Calc?

When I print a spreadsheet in OpenOffice.org Calc (latest version), it keeps adding the name of my current sheet to the top, and a page number to the bottom of my print out. How do I turn this off? P.S. I am running it on Mac OS X 10.6.4 Snow…
hpy
  • 6,001
  • 20
  • 60
  • 86
31
votes
11 answers

Export Excel graphs as vector graphics files (e.g. SVGs)?

How can I export a graph generated in Excel as an editable vector graphics file, e.g. a SVG? When I right click on a graph in Excel the 'Save as Picture...' option only gives non-vector formats (like PNGs and JPGs) as options. The only resource I've…
tog22
  • 915
  • 3
  • 11
  • 21
26
votes
3 answers

Copying just text, not formulas, in OpenOffice Calc

How do I copy and paste the text (not the formulas) from one Calc sheet to another in OpenOffice?
kelly
25
votes
1 answer

Preventing LibreOffice from using smart quotes (“ ”) instead of (dumb) straight quotes?

I use LibreOffice Calc to make lists of programs with different parameters to run on an hpc cluster. For each batch of commands I must do a find and replace on the smart quotes, as they cause errors in command line arguments. It would be nice to cut…
tweirick
  • 413
  • 4
  • 8
20
votes
4 answers

Can you reference an entire column in OpenOffice Calc (like A:A in Excel)?

I'd like to refer to an entire column, like you can in Excel by using A:A. I found a discussion on the openoffice.org forums which is a few years old, and suggests there is/was no neat way to do it. The options presented are Use A1:A65536. Use…
Andy
  • 3,037
  • 3
  • 20
  • 28
17
votes
7 answers

How to get VLOOKUP to return the *last* match?

I'm used to working with VLOOKUP but this time I have a challenge. I don't want the first matching value, but the last. How? (I'm working with LibreOffice Calc but an MS Excel solution ought to be equally useful.) The reason is that I have two text…
Torben Gundtofte-Bruun
  • 18,100
  • 39
  • 108
  • 145
17
votes
2 answers

LibreOffice pivot table group by month

Im having data like this: Date Customer Amount Month 09-01-12 A 20 =A2 (formatted so it shows month name) 10-01-12 B 10 =A3 (formatted so it shows month name) 18-01-12 B 25 etc 05-02-12 A 15…
Lennart
  • 277
  • 1
  • 2
  • 8
17
votes
3 answers

How do I get a chart in LibreOffice Calc to have regular time intervals when the data is not regular?

I have an area chart in LibreOffice Calc where I would like the X axis to be measured in one month intervals spaced evenly apart. The data going into the graph, however, is not regularly spaced at one month. There can be zero, one, or two entries in…
Questioner
  • 798
  • 3
  • 12
  • 32
15
votes
1 answer

How to scale a long LibreOffice Calc sheet to fit on two pages when exporting to PDF?

I have Libreoffice and I want to export a long calc sheet to a pdf document with the fit-to-page function from the page preview in the file menu but it doesn't seems to work. I want to fit my sheet up to 2 pages because it's unreadable otherwise.…
Micromega
  • 1,914
  • 7
  • 33
  • 43
14
votes
1 answer

How to highlight whole row and column under cursor in OpenOffice Calc?

I need to work with large table. Something like in this illustation image will be helpfull for better orientation: Is there some settings which makes this possible?
user3123061
  • 263
  • 2
  • 7
14
votes
9 answers

How to find and remove external links in (Libre|Open)Office Calc spreadsheet

I have a LibreOffice Calc spreadsheet which pops up a message asking me whether I wish to update external links. I did not add external links myself, but did copy data from another Calc window at one point, after which this issue started. (I assume…
equaeghe
  • 445
  • 1
  • 5
  • 14
1
2 3
…
23 24