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 Gnumeric. Is there any simple table maker app available that can accept only simple unformatted text? All these software are very complicated for this simple work.
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 column lets call it category and it will have value of A or B.
Can that be done using LibreOffice or gnumeric or any software available on Ubuntu or should I do it programmatically?
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 .71
Pear .40
In other words, I've picked unique "Item" values and summed over them. This seems like something a spreadsheet ought to be able to do, but I've not been able to find it in the gnumeric manual nor googling. (And maybe the answer is the python plugin.)
(I originally tagged this openoffice, as there was no gnumeric tag. I suspect there's a way to do this in ooo iff there's a way in gnumeric. Thanks to the kind soul who created a gnumeric tag and retagged!)