GNOME Bugzilla – Bug 768255
cell("ADDRESS",Sheet1!A1) evaluates differently in Excel 2013
Last modified: 2018-05-22 14:26:24 UTC
If in a workbook Book1 with two sheets Sheet1 and Sheet2, cell("ADDRESS",Sheet1!A1) is entered on Sheet2, then Gnumeric returns: $A$1 while Excel 2013 returns: [Book1]Sheet1!A1 (or [Book1.xlsx]Sheet1!A1 if the file is saved. If the formula is entered on Sheet1 the results in Excel 2013 and Gnumeric match.
We can change that to add some indication of sheet, but I never think we will do cell() XL compatible. I am not even sure XL is compatible between versions.
-- GitLab Migration Automatic Message -- This bug has been migrated to GNOME's GitLab instance and has been closed from further activity. You can subscribe and participate further through the new bug through this link to our GitLab instance: https://gitlab.gnome.org/GNOME/gnumeric/issues/307.