Ask Ubuntu
Ask Ubuntu

Questions tagged [gnumeric]

Gnumeric is a spreadsheet application that's part of the gnome project.

Some Gnumeric-related resources:

14 questions
46
votes
5 answers

How to find duplicate rows in gnumeric or Libreoffice calc

I have gnumeric and libreoffice calc. How to find duplicate rows? if I could use libreoffice, it's better, but anything is good for me. I have the latest stable version of both software
Lynob
  • 6,775
18
votes
5 answers

Remove all hyperlinks from a spreadsheet

When I copy/paste from a website into gnumeric (or LibreOffice Calc) from a website, I want to be able to quickly strip away all hyperlinks and leave just text. How do I do this? Solutions in either program will be accepted, although gnumeric is…
David Oneill
  • 12,614
9
votes
1 answer

How do I make MS Excel macros work in Ubuntu?

I have a spreadsheet written in MS Excel, an .xls document, which contains macros. I'm having a problem finding a program what will allow me to open the document and the macros work. I tried opening the document in LibreOffice and the macros won't…
Jason Smith
  • 539
4
votes
2 answers

How to export a Gnumeric table into Latex under Ubuntu 14.04?

According to the Gnumeric manual available at http://www.fifi.org/doc/gnumeric-doc/html/C/, Latex 2e is one of the supported file formats, available via the Save as... dialog. Using Ubuntu 14.04 and having installed Gnumeric from the Ubuntu…
user309094
  • 41
3
votes
0 answers

How to construct sunburst charts in gnumeric

I'm trying to arrange species into a sunburst (multilevel pie or ring) chart that summarizes their numbers at genus, family level and so on. I cannot seem to realize that with gnumeric (and neither with LibreOffice calc for that matter) as I happen…
Stockfisch
  • 572
  • 5
  • 17
3
votes
1 answer

Sum over unique tags in a range

Suppose I have a spreadsheet in which I track my fruit purchases. It might look like this: Date Item Amount 1-Apr-2012 Apple .35 2-Apr-2012 Pear .40 3-Apr-2012 Apple .36 I want a summary range that looks like this: Apple …
jma
  • 193
2
votes
1 answer

Simple app for making Question answer pair table that could be exported in csv format?

I tried Libreoffice, but its Import option while pasting in the cell is very annoying.I also tried Gnumeric but I am not able to paste using middle button.Parcellite to make copy paste faster and middle button pasting is not working with…
UbuntuLover
  • 2,969
  • 3
  • 12
  • 15
1
vote
1 answer

Gnumeric Nlsolve does nothing

I am attempting to do simple non-linear decision models on my laptop running Ubuntu 15.04; however when I click solve Gnumeric appears to not do anything when I have the "non-linear model" selected. When I solve the window pops up saying it found a…
claytonrsh
  • 113
  • 5
1
vote
1 answer

Ubuntu upgrade to 20.04, cannot uninstall prior version of gnumeric

I upgraded Ubuntu 18.04 to 20.04 a few days ago using Software Updater. After the upgrade, Gnumeric will not open my old gnumeric files. If I start Gnumeric then open a Gnumeric file, the hard drive lights a bit then it crashes. There are errors…
seedlessly
  • 13
  • 2
1
vote
0 answers

Is it possible to covert multiple sheet excel into one?

Is it possible to covert a multiple sheet excel file into one sheet, and have the original sheet name as a column in the final sheet? So if you have multiple sheet excel A and B where all sheets have the same column names, you combine them, add a…
Lynob
  • 6,775
0
votes
0 answers

gnumeric set date and number format at same time?

Im using this two command for separate for set date and number format respectly LC_TIME=en_AU.UTF-8 gnumeric LC_NUMERIC="pe" gnumeric But I dont know how I could do in same time please help me
Alejandro Diego
  • 1
0
votes
1 answer

Gnumeric wont convert text to lowercase

Applying function =lower(A1) on column and cell B1 does nothing. It justs prints as is and adds apostrophe before the function, '=lower(A1). Followed this general advice for spreadsheets. I just want to convert all the text in column A to…
arjun
  • 367
  • 3
  • 16
0
votes
0 answers

Gnumeric tables to latex

I've been using Gnumeric's functionality to export tables to be usable in LaTeX. My question is if there is an easy way to locally change the font size fot hose tables. My tables are quite complex (produced by SPSS actually, but that's another…
JCBR
  • 1
0
votes
0 answers

How can I make new rows in Gnumeric keep the previous formatting?

I want to build for me a sheet with text columns for First Name, Name, Country, Politic group, email, position in the institution (e.g.: deputy or president of one group etc.), web page with more information (often a page of the politic group…
oui
  • 21