It would sure be nice to find a document that lists: But even when the names of the functions are the same, I'm not sure if the arguments are always the same. VLOOKUP and INDIRECT exist in both products. I've already noticed that IFERROR doesn't exist in Calc but there is a similarly named function in Calc called ISERROR which may or may not be equivalent. Having glanced at the functions list in both products, I'm under the impression that Calc largely mirrors what is available in Excel so I'm hoping there aren't too many changes but perhaps I'm overoptimistic.įor example, I am trying to convert this from Excel to its Calc equivalent: I have to believe that someone else has been down this road so I'm wondering if any documentaion exists that talks about the differences between Calc (ideally for OOO 4.1.2 or not long before) and Excel (ideally for Excel 2013)? Is there a checklist that says what has to be changed and what the changes are as well as what can be left alone because it works the same in Calc? Unfortunately, I'm not terribly familiar with either but I've already discovered there are at least *some* differences. I'm trying to convert an Excel spreadsheet to its Calc equivalent.
0 Comments
Leave a Reply. |