[prev in list] [next in list] [prev in thread] [next in thread] 

List:       koffice-devel
Subject:    Re: KSpread formulas parsing questions
From:       John Dailey <dailey () vt ! edu>
Date:       2002-01-08 3:31:59
[Download RAW message or body]

If you have to store parsed data for an excel file, then you might have to use 
the m_pCode member of a KSpreadCell object to get the parse tree.

John
dailey@vt.edu

> Hi,
>
> actually (as far as I know),  in MS Excel file every formula is stored as a
> stream of proprietary records using RPN syntax. If you store the formula
> string as a string, it will not become formula in excel (again IMHO).
>
> So, koscript is used, do you store somewhere the parsed formula in some
> type of data structure? Can you direct me to some more detailed
> information?
>
> Thanks
>
> Petr Tuma
>
> > Le Monday 07 January 2002 04:36, koffice@sensenet.cz a écrit :
> > > Hi,
> > >
> > > I'm writing an export filter KSpread -> MS Excel, I need to parse
> > > formulas and I haven't found enough information about it.
> >
> > Hi,
> > we used koscript to parse formula.
> >
> > > Are there formulas parsed anywhere, or do I need to do it myself?
> > >
> > > Can anybody point me to the part of the code that can give a parsed
> > > fomula (if possible) or at least the unparsed formula as a string?
> >
> > Why you want to parse formula ?
> > can Excel not parse a string ?
> > I think that excel can parse a string.
> >
> > Regards
> >
> > > Thanks
> > >
> > > Petr Tuma
> > > ______________________________________
> >
> > _________
> >
> > > koffice-devel mailing list
> > >
> > > koffice-devel@mail.kde.org
> > > http://mail.kde.org/mailman/listinfo/koffice-devel
> >
> > _______________________________________________
> > koffice-devel mailing list
> > koffice-devel@mail.kde.org
> > http://mail.kde.org/mailman/listinfo/koffice-devel
>
> _______________________________________________
> koffice-devel mailing list
> koffice-devel@mail.kde.org
> http://mail.kde.org/mailman/listinfo/koffice-devel

_______________________________________________
koffice-devel mailing list
koffice-devel@mail.kde.org
http://mail.kde.org/mailman/listinfo/koffice-devel
[prev in list] [next in list] [prev in thread] [next in thread] 

Configure | About | News | Add a list | Sponsored by KoreLogic