On Fri, 2005-05-20 at 11:29 +0200, Daniel Rentz wrote: > Hi, > > Jonathon Blake schrieb: > > > >>Do you mean this one (still under review), or some other document? > > > > When I finish the spreadsheet I'm working on, I'll give a > > comprehensive reply to Daniel's question about what Calc lacks, that > > makes it unusuable for Excel Power Users. > > These are the built-in Excel functions missing in Calc: > > CALL Calls a function in a DLL > USDOLLAR Same as DOLLAR, imported as DOLLAR by Calc > FINDB FIND working on bytes instead of characters > SEARCHB SEARCH working on bytes instead of characters > REPLACEB REPLACE working on bytes instead of characters > LEFTB LEFT working on bytes instead of characters > RIGHTB RIGHT working on bytes instead of characters > MIDB MID working on bytes instead of characters > LENB LEN working on bytes instead of characters > ASC Convert text to half width > DBCS Convert text to full width > DATEDIF Date difference (Lotus compatibility function) > DATESTRING Date to text (not implemented in Excel) (*) > NUMBERSTRING Number to text (not implemented in Excel) (*) > GETPIVOTDATA Get value from pivot table > PHONETIC Get Asian phonetic text (Rubi) from cell > BAHTTEXT Thai currency (Baht) to text > > (*) These functions exist in Excel, but they always return #N/A. > > > Regards > Daniel
I, as an Excel power user (self proclaimed), have never used one of those functions...hmmm. In fact I doubt I ever would. However I do think that there is a great need for a function to return Thai currency (Baht) as text... -- Rick Barnes www.nostabo.net ************************************************* There are 10 kinds of people, those that can read binary numbers and those that can't... --> Sent via Evolution 2.2.1 running on a Linux 2.6.11 Gentoo kernel.
signature.asc
Description: This is a digitally signed message part
