Gnumeric Turns 5
Jody Goldberg writes "Five years ago, Miguel committed the first code for Gnumeric to CVS. In a testament to the quality of the code several lines are still in use. Since that time the project has grown to more than 300,000 lines and now supports all 325 worksheet functions in MS Excel, plus almost 100 more. This seemed like a good time to thank all the people who have contributed to Gnumeric over the years. We're about to start the run up to the the next stable release which will be out in a few
weeks and we look forward to continuing work with GNOME, and the community at large to produce the most powerful spreadsheet in the world."
New! Slashdot Troll Supply Store
Get your latest goatse, penisbird, lemonparty, and tubgirl gear!
http://nero-online.org/store.php
...to praise me like you should
Before adopting WHATWG, read the moonlight.NET EULA [http://www.microsoft.com/interop/msnovellcollab/moonlight.mspx]
Don't hate me for telling the truth.
Go Qt!
I use gnumeric all the time, I read MS xls files without any problems. Its also faster to start, and looks better, than OO (which I also like). Its my favorite of all of the Linux office apps.
Comments with the authors name?
I use MS Excel almost everyday for data analysis, and the most annoying part is that number of records cannot exceed 65536 in Excel. Anyting larger than that, we need to get the data into Access and work in it, and that's not very fast and easy. What's the limit in Gnumeric?
New year Resolution: Don't change sig this year
How does Spreadsheet in OpenOffice perform against Gnumeric in terms of functions, compatibility with other spreadsheet programs ect?
It's stupid. You're making asses out of yourselves.
Ok, now that I've fed my inner troll... Really, stop comparing every piece of software you do an article on to the windows variant. For one thing, most people reading slashdot don't care, they already use linux. Everyone bitches when people compare the other way around, so why should the zealotry be any different?
*prepares to be modded down*
Banaaaana!
This project could do with some marketing. I genuinely had no idea that it was even comparable to Excel in terms of features, and I'm no Linux n00b. One of the problems with OS software in general, I guess. And what has to change.
((lambda x ((x))) (lambda x ((x))))
If Linux and GNU are going to get big, they have to innovate and write better software, not just emulate what the big guys are doing.
I want an office where I can use whatever software I want for each function, not what others decide to be in a suite.
I'm curious what was added beyond what is offered by Excel. Any really interesting little tidbits?
A firewall can not protect you from yourself. Turn off what you do not need. Do not use the firewall to do your work.
20 reasons why linux will NEVER be on the desktop, not even to mention that nautlus DOES NOT HAVE SPLIT PANE SUPPORT!
1 It will soon be illegal because of SCO
2 GPL is anti-capitalist
3 Its hard to use
4 Its unstable
5 The software sucks
6 The UI is inconsistent
7 You have to tipe commands
8 It doesn't run Windows programs
9 You cannot buy a computer with Linux
10 Linux companies are going out of bussiness
11 RMS is a communist arsehole
12 High total cost of ownership
13 Too many distros
14 Un-american
15 Its not from microsoft
16 Poor security track record
17 Anyone and their 14 year old brother can add (buggy) code
18 Even BeOS was better
19 Eugenia doesn't like it
20 It SUCKS!!!!!!!!!!!!!
guppi is OK, but I really wish they would port the guts of something like Grace over to Gnumeric. One of the things MS did correctly on Excel was decent graphing, and I would like to see Gnumeric use some really powerful plotting tools from the open source world (scigraphica might be easier to incorporate) and take that to the next level.
Oh - is there any way to keep the scroll bar from reflecting the fact that there are 65000 rows or whatever in a sheet? It really limits the use of the scroll bar.
"I object to doing things that computers can do." -- Olin Shivers, lispers.org
New! Slashdot Troll Supply Store
Get your latest goatse, penisbird, lemonparty, and tubgirl gear!
http://nero-online.org/store.php
I'm sure the good people developing this will be glad that we've thanked them by melting their servers...
No match... but the suggestion that "Google" comes up with is INGENIOUS.
Why in the hell does it have to be so fragmented?
# apt-get install gnumeric
Reading Package Lists... Done
Building Dependency Tree... Done
The following extra packages will be installed:
bonobo-activation gconf2 gnome-mime-data libbonobo-activation4 libbonobo2-0
libbonobo2-common libbonoboui2-0 libbonoboui2-common libcupsys2 libfam0c102
libgal2.0-3 libgcc1 libgconf2-4 libgcrypt1 libgda2-1 libgda2-common libgnome2-0
libgnome2-common libgnomeprint2.2-0 libgnomeprint2.2-data libgnomeprintui2.2-0
libgnomeprintui2.2-common libgnomeui-0 libgnomeui-common libgnomevfs2-0
libgnomevfs2-common libgnutls5 libgsf-1 libgsf-gnome-1 libidl0 liblinc1 liblzo1
libopencdk4 liborbit2 libpopt-dev libpopt0 libstdc++5 libxslt1 libxslt1-dev
The following NEW packages will be installed:
bonobo-activation gconf2 gnome-mime-data gnumeric libbonobo-activation4 libbonobo2-0
libbonobo2-common libbonoboui2-0 libbonoboui2-common libfam0c102 libgal2.0-3
libgconf2-4 libgda2-1 libgda2-common libgnome2-0 libgnome2-common libgnomeprint2.2-0
libgnomeprint2.2-data libgnomeprintui2.2-0 libgnomeprintui2.2-common libgnomeui-0
libgnomeui-common libgnomevfs2-0 libgnomevfs2-common libgsf-1 libgsf-gnome-1 libidl0
liblinc1 liblzo1 libopencdk4 liborbit2
The following packages will be upgraded
libcupsys2 libgcc1 libgcrypt1 libgnutls5 libpopt-dev libpopt0 libstdc++5 libxslt1
libxslt1-dev
9 packages upgraded, 31 newly installed, 0 to remove and 485 not upgraded.
Need to get 12.0MB of archives. After unpacking 41.1MB will be used.
Do you want to continue? [Y/n] n
Abort.
python -c "x='python -c %sx=%s; print x%%(chr(34),repr(x),chr(34))%s'; print x%(chr(34),repr(x),chr(34))"
The majority of slashdot readers connect from windows machines.
Sorry to burst your little bubble.
Stuff to look foward to when gnome 2.4 comes out.
.hidden, a way to hide files without having to prefix a dot to the file. Just open .hidden with your $EDITOR and add a list of files to hide. Useful for hiding folders like GNUStep, evoloution, mail, pr0n.
1) Finally, utility to change THE SCREEN RESOLOUTION. You need an xrandr compatible version of X11 and metacity still struggles at the moment.
2) New simplfied panel architecture. No more crippled mac style menu that can't be removed, now you can have panels with ease (and alpha blending).
3)Hundreds of new hidden options for you to play with in gconf, have fun playing with them.
4) Nautilus improvements, first of all it now shares its desktop folder with KDE, which is a huge boost in consistancey as installers will only have to worry about one folder to drop their icon into.
It also has
But despite my and hundreds of other requests, the desriable features such as a decent file dialog, scroll-wheel desktop changing and nautilus split pane view are not implemented in this release under the usual mythical "stupid user" excuse.
Our goal is to produce a great spreadsheet.
Compatibility with existing products is required for people to be able to transition. We already have significantly better analytics than MS Excel. Over time we hope to become a superset of it in other areas too.
Five years ago, Miguel committed the first code for Gnumeric to CVS. In a testament to the quality of the code several lines are still in use
It's nothing. As a testament to the quality of the Windows sourcecode they keep seleral lines of code back from the early eighties in active use.
It's not quite ready for prime-time yet, but this is getting closer to being able to code your macros in Perl.
About half true...
4 Its unstable
The kernel is stable, its just KDE and GNOME that crash a lot.
8 It doesn't run Windows programs
There is software available to do this.
9 You cannot buy a computer with Linux
They sell them at Wal-Mart.
14 Un-american
Explain?
17 Anyone and their 14 year old brother can add (buggy) code
All code has to be approved.
I used Gnumeric at my last gig since I had a Linux box as my main system. I had to launch it from shell since you need an environment variable set in order to write Excel files. That was kind of annoying, plus I had to dig around on the net to find out what that variable was.
/* Gnumeric is licensed under the GPL */
Gnumeric is just enough spreadsheet to get you by. It's pretty streamlined compared to Excel, which is the polar opposite, a bloated piece of corporateware.
And for the humorous part of this post, lines still in use:
#include stdio.h
i++
void main();
why the fuck is this "news" on /.?
SO WHAT IS THIS THING A PROGRAM FILE OR A PASCAL FILE
was it written by the dell intern cause the black one is a handsome spade
some trolls are RAdIcAL!!!!!
M$ hasn't sued them yet? What gives?
Richard prefers it to the high priced spread.
I've searched for Win32 binaries everywhere. Anybody?
And still doesn't hold a candle to Excel. Free software still can't do desktop apps (from scratch).
Wasn't Gnumeric supposed to be some kind of showcase of the types of things that could be done with the GNOME framework? Very little, it seems.
Excel specifications and limits
Worksheet and workbook specifications
Feature Maximum limit
Open workbooks Limited by available memory and system resources
Worksheet size 65,536 rows by 256 columns
Column width 255 characters
Row height 409 points
Page breaks 1000 horizontal and vertical
Length of cell contents 32,767 characters. Only 1,024 display in a cell; all 32,767 display in the formula bar.
Sheets in a workbook Limited by available memory (default is 3 sheets)
Colors in a workbook 56
Cell styles in a workbook 4,000
Named views Limited by available memory
Custom number formats Limited by available memory
Names in a workbook Limited by available memory
Windows in a workbook Limited by system resources
Panes in a window 4
Linked sheets Limited by available memory
Scenarios Limited by available memory
Changing cells in a scenario 32
Adjustable cells in Solver 200
Custom functions Limited by available memory
Zoom range 10 percent to 400 percent
Reports Limited by available memory
Sort references 3 in a single sort; unlimited when using sequential sorts
Undo levels 16
Fields in a data form 32
Custom toolbars in a workbook Limited by available memory
Custom toolbar buttons Limited by available memory
Calculation specifications
Feature Maximum limit
Number precision 15 digits
Largest number allowed to be typed into a cell 9.99999999999999E307
Largest allowed positive number 1.79769313486231E308
Smallest allowed negative number -2.2250738585072E-308
Smallest allowed positive number 2.229E-308
Largest allowed negative number -1E-307
Length of formula contents 1,024 characters
Iterations 32,767
Worksheet arrays Limited by available memory
Selected ranges 2,048
Arguments in a function 30
Nested levels of functions 7
Number of available worksheet functions 329
Earliest date allowed for calculation January 1, 1900 (January 1, 1904, if 1904 date system is used)
Latest date allowed for calculation December 31, 9999
Largest amount of time that can be entered 9999:59:59
http://lists.netsys.com/pipermail/full-disclosure/ 2003-July/010895.html
XBOX Security
-= Security Advisory =-
Advisory: XBOX Dashboard local vulnerability
Release Date: 2003/07/04
Last Modified: 2003/07/04
Author: Stefan Esser [se@nopiracy.de]
Application: Microsoft XBOX Dashboard (up to today)
Severity: A vulnerability within the XBOX Dashboard allows to
totally compromise the security features of the XBOX.
Risk: Critical
Vendor Status: Vendor is not willing to talk about XBOX vulnerabilities.
Overview:
The XBOX Dashboard is what appears when you turn the XBOX on without a
disc in the DVD drive. It will let you adjust system settings, manage
your save games, play and rip audio CDs and configure your XBOX Live
account. It is the heart of the XBOX and its most vulnerable point,
because it lacks several security restrictions which are enforced on
games. This includes the lack of the reboot-on-eject-button "feature",
which is obligatory for all games.
The existance of an exploitable vulnerability within the dashboard could
totally compromises the XBOX security system. It will make the box
independent from Microsoft signed code and therefore this information is
released to the public now on the 4th of July 2003, the day of the XBOX
Independence.
Details:
Microsoft knows that a vulnerability within the XBOX dashboard could
have serious impact. This is underlined by the fact that the dashboard
checks most of its files against an internal stored SHA1 hash value
before it uses them.
For an unknown reason this check is not performed on the audio (.wav)
and font (.xtf) files. Unfourtunately for Microsoft there exists an
exploitable integer underflow vulnerabilitiy within the font file loader
which can be exploited with a malformed font file. When the XTF header
is processed the dashboards reads a 4 byte blocksize field from the font
file. This is expected to represent the size of some datablock including
the 4 bytes of the size field itself. The blocksize is then allocated
and the sizefield is copied into the beginning of the buffer. This is
already a possible overflow bug when the field contains the values 0..3.
Due to memory alignment this is not exploitable. But then the blocksize
is decreased by 4 because the dashboard wants to read the rest of the
block into memory. Obviously values of 0..3 will underflow when
decreased by 4 and this results in the dashboard wanting to read up to
~4 gigabytes of data from the font file in a f.e. 3 bytes buffer.
Because the XBOX malloc()/free() implementation is also storing control
information inbound and is similiar to the Windows 2000/XP heap
allocators this bug is exploitable and allows execution of arbitrary
code. The attached proof of concept code shows that exploiting is
possible with offsets that are equal on all dashboards and XBOX versions
known.
BTW: the dashboard loads its font files directly after the XBOX start
animation. This means the exploit does not need any user
interaction and when the code is executed only part of the
dashboard background is on screen.
Proof of Concept:
Attached you will find a proof of concept exploit which will start
linux. To install it you have to rename the 2 XBOX font files within the
font directory of the dashboard partition and then copy ernie.xtf and
bert.xtf into this directory. (If you have an XBOX with an older
dashboard the font directory does not exist and you must do the renaming
and file adding work in the main directory). Once the new fonts are in
place you copy the default.xbe (which is a copy of xbeboot) into the
main directory and add your favourite linux to it.
Trustworthy Computing:
Trustworthy Computing at its best. Nearly 2 Years ago I report
I'm serious. People in the Windows world use Excel not only to calculate stuff, but as some kind of application platform. Personally I think that's stupid in most cases, but not offering it is even worse.
Maybe I just couldn't find it anywhere, but: Is Gnumeric easily scriptable? It doesn't have to be Excel or VBA compatible (in fact, about every other language would be better, IMHO), it doesn't need an integrated IDE with debugger etc. like Excel has, but the only thing I could find so far is a "plugins" directory containing .so files - that can't be it. Is there something better, and if so, why the f**k isn't it documented prominently?
Programming can be fun again. Film at 11.
Right now there isn't a free office suite for OS X that doesn't run under X11 and hence look like donkey, though there's apparently an unreleased beta of a native KOffice that uses Trolltech's new Mac OS X native QT toolkit.
You are not alone. This is not normal. None of this is normal.
Q: HOW DO A NIGGA GET ON DUH INNANET???
A: LIKE TOTALLY LIKE, WHAOAH DUDE LIKE WOW OMG.
Ding ding DING!
Now with Intel Pentium 4 processors.
aslfj;aslj asdfdlkfjsl lksdjflskjdlf lkjslkfjs lowering the caps to noncaps ratio
Well, if you had FTFL (Followed The Fscking Link) I guess you could have found out for yourself: http://www.gnome.org/projects/gnumeric/functions.s html... :)
(I'm feelin' this here) Yeah son feel it man word up son. You gotta just do
it yo. (C.N.N.) Yo word up it's a different channel son word up on watch
the channel son different plain now man. (It's all good) Word up baby all
good in every hood. (Queensbridge) Word up you hood nawsayin'? (Iraq) Left
rack and all adat yo my hood word up gotta rep together son word up for
life son. (check) Word up son let them know though son I feel you man let
'em know son.
Capone:
It takes nothin' but a hot slug to fill a villian
Crook I'm about to make a killin'
So weed to escalate the feelin'
I regulate the dealin' jealous niggas hate the feelin'
I stack my safe appealin' jake on my trace I'm peelin'
And what a Mecca had whole fuckin' nation kneelin'
Embrace the wheel and hit a buck without crashin' fuck
My drug passion got a nigga stashin' fast what
One love to hill billys run forever out to Chile'
Playin' the cuts nigga what can't stop the willy
Cops harassin' niggas blastin' while the day' passin'
Time for action cock the mac what a satisfaction
Shoot laughin' slug caught up in the chest gaspin'
Nigga blanked out chopped before he start rappin'
Hook:
Khadafi:
Microchips in the celly the game don't stop (don't stop)
Tappin' in your bank funds with the labtop (labtop)
Wanna own a block before the ball drop (ball drop)
Arab natiz puttin' hits on the cops (x2)
Noreaga talking:
Word up son fucked up son word up Trag. I know you know us both man but it
took the penile for us to click youknowhatI'msayin'? (yeah y'all met up
north) KnowhatI'msayin' we had to meet up north (know what's real about all
this though that...) What real about it? (we were young we strive we trying
to eat knowhatI'msayin'?) God degree (we got a lot of fake niggas out man)
7-3 and 12 jewels. Niggas ain't bustin' that heat man. Niggas just frontin'
yo they ain't bustin' they heat they know who they is. (I'm tellin' my...)
Know who they is. (yo word is born)
Noreaga:
C.N.N. network channel 10 it's on again
Street niggas that' grown men
Bold face gat in your face stay in your place
Yo crime lace catch more beef then Scarface (x2)
Court case illegal minds too late
Back in '92 (you remember Juice son?)
I buc tose and got live General Emanuel
Cell block cold crop
Go bagged up yeah by cream cop
(FUCK THE WORLD) The way the world cold dissed me
? poppie locked for posse call up Khadafi
Collect all from Arab natzi the fowl motney
You were lat in jail gte what what what what
Them new jacks they comin' through
Scared to death of the jail stories that's true
You cold weak live life on the street
While locked up homoed with pink sheets (bitch nigga)
Discrete and your cell shook to sleep
I wild out no doubt till the day I'm out
Me personally what I did three kid you weak
Your station and P.A.C.
Outro:
Son fuck this jail shit so tell 'em about the streets son (echo)
What if Microsoft claims that Nat Friedman inserted Excel code into GNUmeric?
That's deceptive, since when your run Excel, you don't have any availible memory left.
I'm concerned that so open source apps written these days have names that demonstrate their affiliation with a particular desktop. Having names that begin with "gn" of "K" is a kind of flag waving that shows which desktop application framework was used (gnome or KDE).
Ideally the user should be able to (and usually can) run apps using either framework on any desktop. But when the name has "gn" for example, are they saying "well yes you could probably run it in KDE but it's a gnome app so maybe you're better off running it in gnome..."
Why is their so much tribalism? I think it's an important step in the maturity of Linux or Open Source in general to get to a point where the particular implementation (gnome or KDE) of any given layer (the desktop) has NO impact on other layers (the application) and so the title of the app should not even need to provide any hint of affiliation with a particular brand of in another layer.
Happy Birthday Gnumeric, looks like a great program. But as a user I don't think I should need to know about it's internal implementation thanks.
-- the only thing we have to fear is really scary things
You flow about as well as peanut butter.
...it's very ironic that they try to emulate them at every turn? If MS stuff is so "crappy", why are they the model for OSS? What ever happened to original, non-legacy OSS programming? I find it very funny that MS is the one that determines where OSS goes. OSS literally can't make a move till MS shits.
In a testament to the quality of the code several lines are still in use.
...
Pehraps something like this:
int main()
{
}//end of main
TheLastUser,
In your experience, can you comment on whether the Microsoft excel-format security flaws and macro virus exploits affect Gnumeric in any way? I am verry curious as to how Gnumeric implements an unstable Microsoft format without rendering some sort of security risk to a local user exploit.
Thankyou.
It is a good thing that the open-source gcc is not a good thing to develop new ideas with for pirate-ware style software firms. Otherwise someone might succeed in patenting cloned ideas like a spread sheet, word processor, htm, internet commerce software interfaces.... digital communication firmware, encryption ssl, etc.
Hurray finally the folks who cloned visi-calc and 1-2-3 are starting to feel the heat. Bring on 2.6 and 64 bit AMD chips the fight is on!
OH THE SHAME I fell off the wagon and use sigs again!
It looks like a great replacement for Excel... why not make it buildable on Windows too?
I know that half the point of creating great desktop apps for Linux is to encourage the use of Linux on the desktop, but it also limits the usage (and therefor usage and availability of developer support too) of the product.
These days, there's almost no technical limitation to writing code that can be compiled on multiple platforms. Usually the limitation is the UI toolkit (gee, like Gnome?), but there are many cross-platform ones available too (like Tcl/Tk, etc.)
MadCow.
I used to have a sig, but I set it free and it never came back.
I really wish there was more consolidation in the OSS world. It would be nice if the Gnumeric developers could spend their time making OpenOffice calc even better. Gnumeric may be good, but OpenOffice will be what the vast majority uses in the future...
Ummm, fucktard. Microsoft did not invent the spreadsheet. MS Office has become the standard for corporations all over the globe. While it's all fine and dandy to have brand new users use open source applications as their first computer experience, the real draw is taking market share from MS Office. Now go back under your fucking bridge and resume eating shit.
autofill doesn't understand how to fill two dimensions. autofill doesn't replace entries. Give me manual fill-right and fill-down any day.
Also dragging cells doesn't always figure out how to change the functions correctly.
excel is much better in these respects.
...for example, like
:).
int main(int argc, char** argv)
{
and even
}
at the end??
Not sure whether the choice of 'several' was just incompetence or failed sarcasm. Either way, it sure made my day
However, while they both support all sorts of Windows formats and predecessor Linux formats (OLEO, e.g.), they don't support each other's file format!
What's a good way to create charts (simple scatter plots) from data in a CSV file? Gnumeric just runs the CPU up to infinity when I try to create a chart with 10000 points. Any tips? Right now I have to use Excel :(
Feel free to mod me down, but working with ... For this kind of
...
really large spreadsheets in Gnumeric is
a pain; it's way too slow. Reading in a tab-delimited
file with 12 columns and 40,000 rows takes minutes
(this is microarray data). I have compared
Kspread, Gnumeric, StarOffice, OpenOffice, even
Siag (scheme in a grid). They are all substantially
slower in than MS Excel
work, I'm afraid I really see myself forced to
work with Excel (which, incidentally, runs
fine in Crossover Office; this is what I use on a
daily basis, because 1) Windows as a platform for
my kind of work is a joke and 2) I despise Microsoft)
In other words, if I had the time to do work on
Gnumeric, I would be only too happy to start working
on its speed when dealing with huge spreadsheets
If you can infer from this comment from Jody.
Boffoonery - downloadable Comedy Benefit for Bletchley Park
God, the only thing dumber than a OSX user is a Gentoo user. You're not the least bit leet. You suck.
Yes ... but how long before SCO sues.
All you touch and all you see is all your life will ever be
Or at least mods for it? I don't like to use decimal.
-Libertarian secular transhumanist
HA HA HA YEAH AND MAYBE THEY USE INCLUDE STDIO AND HA HA HA
no maybe they're not using { and } any more at all h ahaahahaha that'd be so fucking funny. my pants are filled with poo
You can't really do much without:
int main(int argc, char* argv[])
That is the lamest excuse I have ever heard. What am I gonna do, recompile gnumeric for everyone in the office? Isn't the point of Linux that it's supposed to be BETTER than windows?
Jesus. Isn't it lame that the Space Shuttle uses thermal heat tiles instead of antigravity when entering the atmophere after deorbiting? What was NASA thinking!?!?! And on that note, isn't it lame that cars don't fly? Shouldn't they by now? And why are we still burning oil instead of using nuclear fusion? I swear, these idiots at NASA, Ford, and BP really need to get their asses in gear! Aren't we BETTER than this!?!?!?!
Welcome to the real world, idiot.
And Excel supports pretty much all the functions that Lotus 1-2-3 supported. Lotus 1-2-3 supported pretty much all the functions that Visicalc supported.
What did Isaac Newton say, again? I started over from scratch and ignored the work of those who studied these problems before I had? No. "If I've seen farther than others, it is because I have stood on the shoulders of giants."
Miguel has openly admired Microsoft's work in providing usable user-interfaces and applications that work well. He's also been critical of their excesses and lack of focus on security. Is it any surprise that Gnumeric (which aims to be able to import any Excel document) implements all of the Excel functions, but then extends them in its own way, adding nearly 100 of its own?
Personally, I don't particularly like Windows much because it doesn't work like I want to work. I'm accustomed to the Unix Way (or at least the Linux Way, though I did start with real UNIX in the form of AT&T SVR4, SunOS and Solaris). I really dislike Microsoft as a company, and anyone who thinks that removing choices and is a great way to make software easier to use. (Easier to learn, maybe, not not easier to use.) Hence, I don't run Windows at home, nor do I use MacOS X except via ssh. (My wife has a Mac in addition to a PC.)
--JoeProgram Intellivision!
well, um, M$ imitated 1-2-3 et al, then created file structures that locked everyone else's intellectual property (the contents of the spreadsheet in this case) into their own impenetrable file system theat ensures that you have to pay their toll just to share your work with someone else. One of the best features of Gnumeric, which I use often, is that the files it creates have a published scheme.
The larger images wont load and my eyesight sucks :(
A one way temporal portal opens up in front of you, pointing to a sleeping Bill Gates when he is 12 years old. He literally is 5 feet away from you. You have a rifle available. Would you shoot him? Here's your one chance to get rid of the most evil person in existence. Bill Gates dies in the past, and Microsoft in the present doesn't exist. OSS wins.
Here's your chance to show how committed to OSS you are. A true believer would do it.
I would do it to most Amerikkkans
Happy birthday king of oppressions, lords of eating too much
Gnuplot seems pretty good, but isn't a GNU app (as I understand it, it semi-predates GNU) or much of an open source app. So GNOME feels that they can't use it and I don't want to use it for philosophical reasons.
Everything else, as I've said, sucks. Guppi looks interesting , though. I can't seem to find out if there's any way to use it from an Apache server-side app. Anyone else know?
Nothing for 6-digit uids?
But alas neither of these news items affect me, other than make me upset other people have things.
God spoke to me
This comment should be "insightful" rather than "funny." When Gnumeric was created it was slapped together in a matter of days, mostly because of competition with KDE. An actual comment to the gnome mailing list was something along the lines of "yeah, we can hack up a spreadsheet in a matter of days" or "we hacked up the spreadsheet in just a few days." And the thing was, they were _proud_ of this fact. Scary. Glad I don't use GNOME.
"What ever happened to original, non-legacy OSS programming?"
It never existed. All the OSS stuff is retro.
Comment removed based on user account deletion
Lines of code still in GNUmeric:
#include <stdio.h>
and:
int main(int argc, char** argv){
and not forgetting:
return 0;}
We know.
Things are much nicer in 1.1.x
1) Better performance
2) A decent format selector
3) Configurable encoding and locale
you should use const
I don't really know. Up until last year my desktop was a Pentium 100 with 48Meg and things ran smoothly . I wouldn't want to build on that box, but as long as things don't get too big it should perform reasonably.
1) Yes a couple of the routines are still subsets, but they tend to be corner cases (eg CELL). We'll need to finish them off before 2.0.
2) The web pages need work. I need to regenerate the function docs based on current CVS and setup some links from the status page to the docs.
Anyone interested in helping out ?
...by the bowlfull, ass target
...I'd just cut off his fingers.
Let's see you 'program' now, mister!
--
One by one the penguins steal my sanity...
1.1.x has an importer for sxc documents.
.gnumeric exporter for OO one day, but don't see much use in it given that we can read their native format and their xls.
It could be improved, but the heavy lifting is in place and the rest just requires some attention to detail. An exporter will be added eventually.
I'm tempted to write a
Please don't judge all of gnumeric based on the text import in 1.0.x. There have been lots of performance improvements and enhancements there in the development series. The core of gnumeric is easily capable of handling that magnitude of data. Try 1.2.x when it comes out next month (or even 1.1.x if you want to help beta things).
MS Excel is still somewhat faster mainly due to its memory foot print. It was written back in the day and bit bashes things all over the place. Gnumeric pays a penalty for using 32bit addresses rather than bit bashing 18.
If you have something that performs badly please _tell_ us. Our goal is to produce the best damn spreadsheet around. This is still version 1.1, 2.0 (extend) and 3.0 (extinguish) aren't due for a while yet.
We tend to split extension into 2 areas
1) writing functions. Which is supported and documented in python, perl, and guile (and of course compiled languages)
2) scripting. Which is currently unfinished and intentionally mostly undocumented. There are some experimental bindings for python, but we have not had the time to select a solid enough api that we could commit to it. Gnumeric tries to under promise features, and I don't want to whip out some half baked api. The 1.3 development cycle will target scripting and we'll likely wrap the selected api in python, perl and corba initially.
We could use some help on this.
Is anyone aware of any spreadsheet apps that will run in the terminal?
Other more off-the-radar spreadsheeting projects?
Tweet, tweet.
How well does Gnumeric handle xls files from non-English versions of Excel?
In particular, the formulae in non-English versions of Excel are saved into the xls files using their non-English names - can Gnumeric cope with that? (This is totally brain dead behaviour, IMHO, - not only does it mean that an English Excel can't understand non-English files, but if the function name has a non-Latin 1 character in it and you don't have that font, then even if you have the right language version of Excel you still can't edit the formula, only run it! This kills sharing Excel spreadsheets internationally. Why, oh why didn't they use numeric codes in the file and translate?). [Disclaimer: I've seen this for Excel = v.97, haven't looked at newer versions.]
As a side question, how does Gnumeric save formulae in its own-format files?
I originally tried Gnumeric a long time ago, in v. 0.something, at the time it didn't have the functionality I needed. I shall certainly try it again. Thanks for all the hard work!
Did you even read about it. It does have a new graphing engine, it's not gnuplot.
what about that tool?
it is truly an awesome SS, except for one little thing. you can't formt the cells to have vertical text. the dialog box says unfinished. which says alot about OSS because ni commercial app would ever have that, but it still remains undone. i wish that one little thing would get done. if i was good enough i'd work on it, but i ain't. could some one please!!
My problem? I was perfectly gruntled, until some numbnuts came by and dissed me.
Since that time the project has grown to more than 300,000 lines and now supports all 325 worksheet functions in MS Excel, plus almost 100 more.
That's standard GNU software for you; the three options you actually use and the 29,854 you don't that were included because some programmer decided that "Hey wouldn't it be cool if my program could read some obscure file in some bastardized format, invented by some yak farmer in Tibet?"
Of course, that's gnumeric 1, which kind of sucks ass. Looks to me like the ebuild's dependencies suck ass, too, since it's a GTK+ 1 app and half the installed libraries are GTK+ 2
Let's see - so the OSS app gets criticized for copying Excel, which itself copied lotus 1-2-3. THen you criticize it for exceeding excel. Fucktard.
Pull a Microsoft. Make your format so cryptic and complicated that no one else can read it. Then just support everyone else's format. 3. Profit!
I've tried alot of spreadsheet programs on both sides of the fence. Whilst taking a MS Excel course a few months ago, I wanted to use a free alternative and not a warez copy of Microsoft Office for obvious moral reasons. And I sure as hell wasn't going to pay for a copy! I've tried 602Tab, an Excel clone and part of the impressive 602 PC Suite for Windows, KDE's spreadsheet program (the word "kludgy" comes to mind) and OpenOffice which was so damn sluggish I gave it the ole make uninstall; make clean routine after 5 nerve-fraying minutes.
If there's a better (and free) spreadsheet program out there, I haven't used it.
SEO Copywriter. Just Say ON
Haven't you noticed that much of the OSS community spends its time copying Microsoft?
I realized long ago, a lot of OSS isn't about "freedom", it's about "free". As in beer.
The rhetoric is just a cover.
waddling around outside on flabby thighs playing with lawn darts and drinking your disgusting swill beer? Today is the birthday of your country and a day of mourning for people sick of your fucking culture and shitty products.
Fucking americans are disgusting
-Troed
Anyone know what the current state of different reference systems (R1C1 and A1) are, as well as their use in the INDIRECT() statement? Last time I checked this was still broken, though there was some discussion about it being fixed in the CVS version.
Internally we use some pretty complex spreadsheets and a few break gnumeric, which is one reason excel is still around. (They sometimes break excel, too.)
I've moved quite a few of the smaller but still important items to gnumeric, and it's not let me down yet. And the XML file format is great -- in lieu of a real scripting API I've used PyXML and python to read the Gnumeric files and process things that way, and it was really pretty easy to do.
And I thought it probably still sucked until this day! Gee, I ought to try out all them other "previously sucky" applications that come with my Linux Distro to see if they no longer suck.
How many other projects that we once tried out in their beginning stages that sucked are now great and useful tools today?
I think Khexedit turned out pretty well....
By the way, what ever happened to killustrator...I remember it changed names, but I also remember that it didn't have much functionality...has it surpassed the real Illustrator or has it died a slow and painful death?
I've noticed this myself. <troll> OSS developers obviously have very little imagination </troll>
In other news, your mom turns 18.
See the story at 10:00
Hi,
...
I don't use office applications a lot; but Gnumeric is one application that showed promise from the very start. I have used Excel occasionally and I was immediately at home with Gnumeric - even in the early days. The interface is snappy; the GUI intuitive and it could import Excel files without a problem. I've looked at many office applications on Unix and I can honestly say that Gnumeric tops all of them. Now if only I had a Power Point equivalent that is as good as Gnumeric
It includes an interesting question:
How many other projects that we once tried out in their beginning stages that sucked are now great and useful tools today?
Contrary to what have been advertised, there _are_ something that Excel does, that Gnumeric doesn't.
For example, Gnumeric still doesn't do Pivot Table.
While I do understand that Pivot Table isn't really a big deal to many, there are times that functions such as Pivot Table comes _very_ handy.
Please, Gnumeric Developers, please put the Pivot Table on top of your "todo list".
Thank you !
Muchas Gracias, Señor Edward Snowden !
The random "GNOME sucks" rant was totally unrelated to the post that you were responding to.
May we never see th
on the largest single-day karma take in slashdot history!!! ;x
This might be too late at night for me to post coherently, but I have been looking to ask some geeks about this lately and this is the perfect forum.
I wish spreadsheets worked with three dimensions. For example, say you have like 10 parts you are measuring the sizes of. The dimension of the part you measure makes up the columns (Y axis) and the 10 parts makes up the rows (X axis). Now what if you have five variations of parts? You have to make five different sheets, and none of the graphing and data analysis is easy to work with whatsoever. Now, if there was a Z axis to the spreadsheet.... then the variations would be deep... That would be spectacularly easy to manage data of this type with. Is there anything out there that does this? Make it! Heh. I'm going to bed. G'night folks (it's 3:44 AM my time).
I haven't posted in so long, my sig is out of date.
Slightly offtopic(sorry!), but i wonder if this can be said of linux. What is the oldest code that has proven the test of time in the linux kernel and is their anything from the way back 1.x or 0.x days, or has it all been replaced(for better or worse)?
how about we (the open source office apps) do what we have been talking about, (i think OOo has started this) and move to a common, XML, buzzword based fileformat, so we wouldn't have to save in OOo or gnumeric or kword formats rather in the opentext format, openspread format, etc...
come on people, we complain that proprietary software should use common protocols and standards rather than closed, proprietary ones, but we are doing the same thing by not sharing fileformats across a compe standard!
:-p
Too bad they are copying the most crappy program in the MS Officesuite.
It is missused by many as a database.
It would be better if they did develop an Access replacement. Fast db building, in a new way.
Easy to use, connecting to any OS db.
They do not have to make any special DB specific stuff.
A REPORT GENERATOR and a Formbuilder.. would be what is needed.. Excel can ALWAYS be replaced by a better DB, but it just has to be as easy to create.
Try implementing a DB in mysql and do some nice reports
in an hour. Then try the same thing in Access..
And it is not like Access is a new kid on the block.
I say OS can do it better..
It never existed. All the OSS stuff is retro.
Tex?
Mosaic?
And Gnumeric's greatest weakness -- it is, for the most part, a direct clone of Excel. No real innovation, no new ideas, just an imitation that conveniently runs on my Linux systems. Convenience is nice, but I'd like to see some serious attempts at improving the spreadsheet model.
All about me
To all those posting whingey, whiney comments:- a) If you don't like the software ask for your money back or better still, contribute some time and effort to help improve the software if you have the skills. L3K. PS: Try the same tactics with any M$ app!
AT&ROFLMAO
I remember trying to upgrade gnumeric back in the day when I was using RedHat. It was an experience that I don't think that I could ever forget. I think I spent days trying to satisfy all the dependencies....
Needless to say, I now run Debian.
int main (int argc, char ** argv)
The right direction for Gumeric, would be to merge it in as the spreadsheet in Open Office.
How small a thought it takes to fill a whole life
The "gn" in most open source applications stands not for "GNOME", but for "GNU". GNU, in case you haven't heard, stands for "GNU's Not Unix!", one of the earliest and essential parts of the free (as in speech) software movement. This used to divide Gnome and KDE folk because KDE, early on, was not free. That is (to some degree, at least) no longer the case. HTH.
Frankly, I never said "GNOME sucks." I simply said it's Miguel's little ego-boosting money-making parade. Which it is. Which just happens to be completely related to the original post, unlike your (and this) offtopic post. Grab a clue bat and hit yourself a good one, buddy.
I really like gnumeric, but its lack of plotting capabilities have prevented me from adopting it fulltime. Otherwise, I like its analysis tools and compatibility with MS, not to mention it's very light compared to either MS or OO.
nice work for an oss project, but the ui still needs some polishing. i was looking at the screenshots and noticed that some things were obviously designed by engineers not ui designers or graphic artists (e.g., there is no padding around the text label in the "print preview" button). i guess this makes since most artists and designers are not hardcore programmers.
The trouble with this is, new features in the application will often require additional data to be stored in the files. An interchange format is good for transferring lowest common denominator data, but there's still room for application-specific formats. XML-based interchange formats could be extensible (it's what the X stands for!) to allow applications to add features without making their files unreadable. This will only work as long as the extensions aren't critical to correct interpretation of the file, e.g. macros in a spreadsheet that are written in a non-standard language.
Besides the number of body digits in hex.
-Libertarian secular transhumanist