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.
0 kommentar(er)
