Pleased to see Calc has improved import/open .123 files but there are still quite a bit of forumula editing to do on importeg of external VLOOKUP refs.
We have 100s of .123 to import and wondered if there are any pathfinding examples of the best way to do all such post-import conversions ? (maybe there are helpful Calc "conversion" macros ? any development plans to improve upon .123 import formula
compatibility ?)
Two "killer" features that keep us bound to Lotus .123 (far too long) are:
- (i) RangeNames that allow special characters eg "GDPn$_g" or "GDPn£_WD" (we work with Column data expressed in many different currencies & percentage/ratio formats in the same sheet)
- (ii) @XINDEX(range;column-heading;row-heading;[worksheet-heading])
Returns the contents of a cell located at the intersection specified by column-heading, row-heading, and worksheet-heading.
(i) "$" or "£" seem illegal in RangeNames in Calc v4 - any workarounds/hacks or specialist extensions that may help ?
(ii) I'm aware of the nasty Excel hack by nesting two =MATCH() inside an =INDEX() but wondered if Calc has a more elegant solution ?
(what are the formula/character limits on Calc cell formulas ?)
Most kind
