Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Gnumeric 1.1.8 - Does it do Pivot Tables yet ?

737 views
Skip to first unread message

***

unread,
Aug 23, 2002, 12:42:33 PM8/23/02
to
I tried gnumeric quite some time ago. It was pre-1.0.0 time.

Now that gnumeric has already gotten to 1.1.8, I wonder if gnumeric
has acquire the ability to do "Pivot Tables" ?

rapskat

unread,
Aug 23, 2002, 2:24:16 PM8/23/02
to
Error Log for Fri, 23 Aug 2002 13:59:45 +0000: segfault in module
"sewer_clow" - dump details are as follows...

> I wouldn't trust my finances to some beta level software.
>
>
>
And yet you use XP.

--
rapskat - 2:20pm up 5 days, 6:08, 1 user, load average: 0.25, 0.70, 0.51
119 processes: 117 sleeping, 2 running, 0 zombie, 0 stopped
CPU states: 1.9% user, 3.8% system, 0.0% nice, 9.0% idle
drop the hot to mail me

I'm changing the CHANNEL ... But all I get is commercials for "RONCO
MIRACLE BAMBOO STEAMERS"!

GeneralPF

unread,
Aug 23, 2002, 2:54:14 PM8/23/02
to
On Fri, 23 Aug 2002 14:24:16 -0400, rapskat assert()ed:

> Error Log for Fri, 23 Aug 2002 13:59:45 +0000: segfault in module
> "sewer_clow" - dump details are as follows...
>
>> On 23 Aug 2002 09:42:33 -0700, ap...@softhome.net (***) wrote:
>>
>>>I tried gnumeric quite some time ago. It was pre-1.0.0 time.
>>>
>>>Now that gnumeric has already gotten to 1.1.8, I wonder if gnumeric has
>>>acquire the ability to do "Pivot Tables" ?
>>
>>
>> I wouldn't trust my finances to some beta level software.
>>
>>
>>
> And yet you use XP.

I fail to see how XP is beta software.

--
General Protection Fault
gene...@yahoo.nospam.com

Frank

unread,
Aug 23, 2002, 3:22:40 PM8/23/02
to
Adolf Torvalds wrote:
> On 23 Aug 2002 09:42:33 -0700, in
> comp.os.linux.advocacy,
> What the flying fuck are pivot tables?

It is the thingy persons in business use to analyse data. I doubt if you
would have any use for it.

rapskat

unread,
Aug 23, 2002, 5:18:44 PM8/23/02
to
Error Log for Fri, 23 Aug 2002 18:54:14 +0000: segfault in module
"GeneralPF" - dump details are as follows...

And I fail to see how it isn't.

--
rapskat - 5:15pm up 5 days, 9:03, 1 user, load average: 0.20, 0.31, 0.48
120 processes: 108 sleeping, 12 running, 0 zombie, 0 stopped
CPU states: 2.3% user, 3.8% system, 0.0% nice, 1.3% idle


drop the hot to mail me

Portable, adj.:
Survives system reboot.

Xaonon

unread,
Aug 23, 2002, 5:36:05 PM8/23/02
to
In article <slrnamd1k4.e...@nitrogen.ertw.com>,
GeneralPF <Gene...@nitrogen.ertw.com> wrote:

You're right, it isn't quite advanced enough to warrant that label.

--
Xaonon, EAC Chief of Mad Scientists and informal BAAWA, aa #1821, Kibo #: 1
Visit The Nexus Of All Coolness (a.k.a. my site) at http://xaonon.cjb.net/
"To fill a world with religion... is like littering the streets with loaded
guns. Do not be surprised if they are used." -- Richard Dawkins

Rick

unread,
Aug 23, 2002, 8:19:28 PM8/23/02
to

Man, that's cold.... calling XP alpha level software... well, maybe not.
--
Rick

Jim Richardson

unread,
Aug 23, 2002, 9:00:06 PM8/23/02
to
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 23 Aug 2002 09:42:33 -0700,


what's a pivot table?


-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.7 (GNU/Linux)

iD8DBQE9ZtqVd90bcYOAWPYRAqzpAKCjjjt2VY0n++Sro5vZFDRPDHMS+gCg6ElX
uFbTxB6odckeFJWxYaeLM0o=
=R1uJ
-----END PGP SIGNATURE-----

--
Jim Richardson
Anarchist, pagan and proud of it
http://www.eskimo.com/~warlock
Linux, from watches to supercomputers, for grandmas and geeks.

Matthias Warkus

unread,
Aug 23, 2002, 3:50:34 PM8/23/02
to
23 Aug 2002 09:42:33 -0700, message by
*** <ap...@softhome.net>:

> I tried gnumeric quite some time ago. It was pre-1.0.0 time.
>
> Now that gnumeric has already gotten to 1.1.8, I wonder if gnumeric
> has acquire the ability to do "Pivot Tables" ?

ISTR it has, but I'm not quite sure.

mawa
--
Rudel:


Wolfgang

Frank

unread,
Aug 24, 2002, 7:39:54 AM8/24/02
to
*** wrote:
: : I tried gnumeric quite some time ago. It was pre-1.0.0 time.

: :
: : Now that gnumeric has already gotten to 1.1.8, I wonder if gnumeric
: : has acquire the ability to do "Pivot Tables" ?

LOL - I guess the short answer is NO !

***

unread,
Aug 24, 2002, 11:10:33 AM8/24/02
to
Jim Richardson <war...@eskimo.com> wrote in message news:<mql6ka...@grendel.myth>...

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> On 23 Aug 2002 09:42:33 -0700,
> *** <ap...@softhome.net> wrote:
> > I tried gnumeric quite some time ago. It was pre-1.0.0 time.
> >
> > Now that gnumeric has already gotten to 1.1.8, I wonder if gnumeric
> > has acquire the ability to do "Pivot Tables" ?
>
>
> what's a pivot table?


Sorry if I have to resort to examples from Excel to explain it -

Webpages:

http://www.nulook.uneb.edu/train/tutorial/Spreadsheets/advexcel/pivottab.html

http://lacher.com/toc/tutpiv.htm

http://howto.lycos.com/lycos/series/1,,69+35046,00.html

http://www.sqlteam.com/item.asp?ItemID=5741

http://www.ucas.ac.uk/figures/fps/pivot.html

http://www.cpearson.com/excel/pivots.htm


Pdf:

https://ereports.osu.edu/assisthr/WebHelp/
Using_Insight/jobaid_pivot_table_tips.pdf

And here's one that is related to Oracle Express -

http://www.orafaq.com/msgboard/warehouse/messages/434.htm

Hope that above examples help !

***

unread,
Aug 25, 2002, 9:24:23 AM8/25/02
to
To all who is interested to know what "Pivot Table" is, the following
webpage has some explaination:

Linux Spreadsheets

http://vip.hex.net/~cbbrowne/spreadsheets.html


Go to section 1.3, and we see the following:

"Pivot tables are roughly analagous to database views, and are
doubtless
essentially copied from the functionality of Lotus Improv."


So my question still stands - if gnumeric 1.1.8 has no "Pivot Tables"
as one of it's features, isn't it time for one ?

Jody Goldberg

unread,
Aug 26, 2002, 12:48:57 AM8/26/02
to

Sadly not. I'd like to add them, but will probably not have time in
this development cycle. The two main features that are still
missing in gnumeric are pivots and auto-filters. The latter will
probably make it into 1.2, but without some help, eg work on a pivot
guru, I will not have time before the freeze.

Jody Goldberg

unread,
Aug 26, 2002, 12:52:13 AM8/26/02
to
In article <00ucmu0ft3aem1omj...@4ax.com>, sewer...@linuxmail.org wrote:
> I wouldn't trust my finances to some beta level software.

Beta level ? While Gnumeric did have a long beta (close to a year).
The 1.0.x release is definitely usable in a production setting.
While we may lack some features, we're extremely stable and
numericly significantly more accurate.

Jody Goldberg

unread,
Aug 26, 2002, 12:57:01 AM8/26/02
to
In article <cee672a2.02082...@posting.google.com>, *** wrote:
> So my question still stands - if gnumeric 1.1.8 has no "Pivot Tables"
> as one of it's features, isn't it time for one ?

We're currently focusing on other features eg pango and multibyte
character support in cells, improved XL export, expanded finance
functions. Pivots and auto-filters are the last big missing
features, but without some additional man power I doubt we'll get to
them until next year.

We'd welcome some assistance in adding them. Anything from
supplying a coherent set of test cases for the importer, to
documentation of how they are supposed to work. Not all
contributions need to be code.

GeneralPF

unread,
Aug 26, 2002, 2:54:16 PM8/26/02
to
On Fri, 23 Aug 2002 17:18:44 -0400, rapskat assert()ed:

> Error Log for Fri, 23 Aug 2002 18:54:14 +0000: segfault in module
> "GeneralPF" - dump details are as follows...
>
>> On Fri, 23 Aug 2002 14:24:16 -0400, rapskat assert()ed:
>>> Error Log for Fri, 23 Aug 2002 13:59:45 +0000: segfault in module
>>> "sewer_clow" - dump details are as follows...
>>>
>>>> On 23 Aug 2002 09:42:33 -0700, ap...@softhome.net (***) wrote:
>>>>
>>>>>I tried gnumeric quite some time ago. It was pre-1.0.0 time.
>>>>>
>>>>>Now that gnumeric has already gotten to 1.1.8, I wonder if gnumeric has
>>>>>acquire the ability to do "Pivot Tables" ?
>>>>
>>>>
>>>> I wouldn't trust my finances to some beta level software.
>>>>
>>>>
>>>>
>>> And yet you use XP.
>>
>> I fail to see how XP is beta software.
>
> And I fail to see how it isn't.

Even though XP has bugs, it wasn't released to be tested. It was intended
to be a final product.

Are you saying Red Hat Linux 7.2 is a beta product since bugs are still being
found?

The Ghost In The Machine

unread,
Aug 27, 2002, 12:00:14 AM8/27/02
to
Followups.

In comp.os.linux.advocacy, Jody Goldberg
<jo...@gnome.org>
wrote
on Mon, 26 Aug 2002 04:52:13 GMT
<slrnamjcv...@athlon.thegoldbergs.ca>:

Bear in mind that 'sewer_clown' is one of our, erm, favorite
trolls, whose motto appears to be a variant of:

"If it doesn't flit, it must be shit". :-)

Colorful butterflies flit.... :-)

--
#191, ewi...@earthlink.net
It's still legal to go .sigless.

***

unread,
Aug 28, 2002, 5:09:21 AM8/28/02
to
Jody Goldberg <jo...@gnome.org> wrote in message news:<slrnamjd8...@athlon.thegoldbergs.ca>...


Thank you, Jody, for your reply !

Please do not misunderstand me, I am NOT demanding that the Pivot
Table feature to be put into Gnumeric immediately.

I do understand, and very much appreciate, what all of you have done.
All of you have worked hard, often silently, and without any hope of
public acknowledgement.

I do understand that Gnumeric _does_ have a schedule - pango,


multibyte character support in cells, improved XL export, expanded

finance functions, etc. comes to mind. And I am really happy that you
guys haven't forgotten about Pivot Table.

It's all right for me if the Pivot Table is scheduled for 1.2.x (or
even 1.3.x) release. What many of us need is a bug-free implementation
of Pivot Tables, and since it's now near the end of Gnumeric's 1.1
series, I think Pivot Tables could benefit more with more testing
opportunities in the 1.3.x cycle.

I am certainly no "guru" in Pivot Tables, but whatever I can help out,
I will be more than glad to do so.

In the meantime, if you want to get a "roundup" of "Pivot Table
gurus", to send you test cases, methinks the best way to do so is for
the Gnumeric people (you guys with authority) to make some
annoucements, maybe through slashdot and/or lwn, where there are lots
of people visiting.

Anyway, thanks again for your reply !

Sincerely,
Lee

0 new messages