From koffice Thu Nov 10 13:44:11 2005 From: Tomas Mecir Date: Thu, 10 Nov 2005 13:44:11 +0000 To: koffice Subject: Re: a few newbie questions... Message-Id: <492258b10511100544s12bbdc1dj4ad3f3ae8041a8e1 () mail ! gmail ! com> X-MARC-Message: https://marc.info/?l=koffice&m=113163028002057 Hi there ! On 11/10/05, Ananth A wrote: > is it possible to open password protected MS Excel files using KSpread ?? > when i tried to open a protected excel document (using koffice 1.3.5), i got > an error message and kspread promptly quit. i assumed it would at least give > me the blank sheet which i had opened before. Password-protected excel files can't currently be opened, unfortunately, as they are also encrypted, and no one has implemented the decryption yet. > also, are there any scripting examples available online?? the koffice > website shows scripting support for kspread but im quite clueless as to how > to start writing them... :( Hmm, well, there are integrated functions (like SUM and so), and then there's DCOP interface, which could be used to accomplish many things, but I think it requires some programming knowledge. There are plans for some more straight-forward scripting, probably for 2.0. > and, is there any workaround by which i can get a working pivot table > feature ?? There's the GETPIVOTTABLE function, in the Database functions. It's only partial, comparing to Excel, but maybe it'll be sufficient to what you want ? / Tomas ____________________________________ koffice mailing list koffice@kde.org To unsubscribe please visit: https://mail.kde.org/mailman/listinfo/koffice