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
