Seems like a great opportunity, imo, for OOo to make headway via cross-functionality.Įdit: Just noticed this thread with some great discussion about this and someone wanting to learn Excel using Calc. Last I knew MS Office contains something like 90%+ of the market space.? I'm honestly not sure if that is purely businesses, home, or both though. For example MS Word used to have a setting to make it look/feel like WordPefect and stole quite some marketshare from them. In general, as much as anyone can say, is it a goal of OOo to be generally interoperable with Excel? From the standpoint of a User Experience I would think that interoperability would go a long way to helping people leave MS Office for OOo. If you want to move sheets back and forth, you will want to do very careful analysis, development and testing to make sure that your sheets behave the same on both. There are lots of subtle (and not so subtle) differences like this. xls correctly, but I haven't tested it in Excel.Īcknak wrote:Calc is not an Excel clone. I'm not sure if it will still export/import to Excel properly. The problem is that ADDRESS has recently been changed in Calc to take an extra parameter. E.g., in Calc, a sheet name like '10' must be quoted in a cell reference: '10'.$B$4. That avoids any assumptions about the syntax of a cell reference ADDRESS should produce a syntactically correct address in both Excel and Calc. =INDIRECT(ADDRESS(4 2 1 1 TRIM(RIGHT(A4 2))) Instead of =INDIRECT(TRIM(RIGHT(A4 2))&'!$B$4'), or digging out the correct separator character (a clever solution, Villeroy!), why not something like:

this will break cross-functionality with my co-workers using Excel.Ĭalc is not an Excel clone.

Err 502 openoffice