Posted Feb 16, 2010 16:43 UTC (Tue) by drag (subscriber, #31333)
[Link]
I would not put OO.org out too much. The new 3.2 release is pretty nice. :)
but ya.. they don't hold nothing over Gnumeric in terms of speed. It's a very nice program to use.
Gnumeric 1.10 is out
Posted Feb 16, 2010 19:29 UTC (Tue) by andrel (subscriber, #5166)
[Link]
How do you find Gnumeric superior to OO.O?
Gnumeric 1.10 is out
Posted Feb 16, 2010 19:42 UTC (Tue) by jwb (guest, #15467)
[Link]
For one thing Gnumeric starts instantly whereas OOo Calc starts quite
laboriously. For another Gnumeric's GTK UI fits perfectly into my desktop
while OOo is faking it, and it shows. Lastly I frequently export my charts from
Gnumeric in SVG format, a capability which I believe OOo still lacks.
In fact I just checked OOo 3.1.1 which seems to still be completely unable to
save a chart in any format at all.
Charts
Posted Feb 16, 2010 19:53 UTC (Tue) by corbet (editor, #1)
[Link]
The chart export issue is a big one; I can't imagine why OOo hasn't figured that out yet. If you want an image file from an OOo chart, you have to export the whole document as PDF, bring it up in your favorite PDF viewer, take a screen shot, then whittle it down to the chart. Gnumeric, instead, has a straightforward "save as image" option. As a result, a chart-heavy article due to appear this week was done with Gnumeric rather than OOo.
Charts
Posted Feb 16, 2010 19:59 UTC (Tue) by chaneau (guest, #6674)
[Link]
I think the easiest way is to export in html, you will get your chart as a
jpeg image
intuitivity
Posted Feb 18, 2010 3:09 UTC (Thu) by coriordan (guest, #7544)
[Link]
Great. And when they add SVG export, I guess they'll add a button "export to zip file", which'll give a zipped SVG :-)
intuitivity
Posted Feb 18, 2010 7:00 UTC (Thu) by chaneau (guest, #6674)
[Link]
:-)
Well I don't claim the situation is ideal far from it, but this is a common
trend in Free Software isn't? I mean the hiatus between what a user needs
or wants and what the developer does.
This is one the problem I face everyday, for example I use BoUML for all my
analyses and when I want to integrate the diagrams in my reports, I only
have two choices to export them: png or svg.
As you probably know LaTeX does not deal very well with png unless your
graphic is of the exact size (and resolution), but LaTeX does not support
svg at all, so I use inkscape to convert it to pdf and integrate it in my
reports.
The question is, how difficult would it be to include a pdf exporter to
BoUML? probably not very hard but the developer has no time to do it.
Frankly this does not bother me much (if at all) as inkscape can be quite
easily scripted, but this is not very optimal.
intuitivity
Posted Feb 18, 2010 21:26 UTC (Thu) by amd (guest, #37690)
[Link]
Well, although it is quite unintuitive, you can use imagemagick's convert utility to convert png-
>pdf.
Or anything else that can do it..
intuitivity
Posted Feb 22, 2010 1:01 UTC (Mon) by anselm (subscriber, #2796)
[Link]
As you probably know LaTeX does not deal very well with
png
As a matter of fact LaTeX handles PNG fine. PdfLaTeX, that is -- but if
you're converting PNG to PDF then you're likely to be using that already.
intuitivity
Posted Feb 22, 2010 15:05 UTC (Mon) by chaneau (guest, #6674)
[Link]
As a matter of fact LaTeX handles PNG fine
Well, yes and no, I'm afraid I was not able to convey the point I was
trying to make.
I produce a lot of material with LaTeX, in fact apart from some test I
do with Office suite, I always work with LaTeX, some of these are for
formations and I like to incorporate graphics in my texts, so I have two
options, I can insert either a high resolution bitmap, or a vector graphic
(typically a svg), the difference lies only in the ability to zoom the
document without losing too much quality
Anyway, LaTeX can't import svg files, so I have to convert them to pdf,
which I do with inkscape
And so here is my first point, I would like to be able to export my
graphics in pdf, but the developer has no time to do it and me neither, but
I have nevertheless all the tools to do the job, so the point is moot
My second point was that OpenOffice.org is not able to export a chart,
although if you save your spreadsheet as html, you get your chart as a jpeg
file, so I think everything is there, all you have to do is add a menu
option labelled "export your chart..." but apparently nobody is interested
in actually doing it and here I see a hiatus, but maybe it's just me ;-)
Charts
Posted Feb 16, 2010 20:54 UTC (Tue) by Trelane (guest, #56877)
[Link]
Inkscape can edit (a page at a time) PDFs in vector format.
Gnumeric 1.10 is out
Posted Feb 17, 2010 8:21 UTC (Wed) by rsidd (subscriber, #2582)
[Link]
Let me add another: I frequently open text-format files (csv, tsv) in gnumeric with a simple command-line "gnumeric filename.csv". When I tried that in openoffice, it opened in OpenOffice Writer -- even though I wrote "oocalc" on the commandline. (Hm, I just tried it again and they seem to have fixed it: but I still need to uncheck "space" and "semicolon" as separators, and check "comma", even though it's a CSV file!)
I rarely use spreadsheets, and when I do, I much more commonly write python programs to analyse the CSV file directly, than import into a spreadsheet program. When I do the latter, it is just to take a quick visual look. And Gnumeric is much, much quicker for that purpose.
Gnumeric 1.10 is out
Posted Feb 16, 2010 20:58 UTC (Tue) by Trelane (guest, #56877)
[Link]
The source code is much more sane. :)
Gnumeric 1.10 is out
Posted Feb 17, 2010 15:20 UTC (Wed) by tialaramex (subscriber, #21167)
[Link]
It's a LOT more Excel compatible. With the exception of features that are completely missing (which is unfortunate, but at least obvious) the Excel compatibility in Gnumeric has been very good, and they've taken a few patches from me to improve it. For people who actually need to work with Excel sheets, and particularly for people who need confidence in the numbers they get from such sheets, this is vital.
In practice OO.org can't be expected to deliver even close to 100% compatibility, because the software it derives from historically deliberately isn't compatible with Excel in certain ways, and Excel is riddled with implied-type problems (e.g. date handling, and formulae which convert things into strings, mangle them, and then convert back again) so trying to add more Excel compatibility would mean having a big switch ("Do you want Excel compatibility or OO.org compatibility?") and lots of conditionals scattered through their codebase.