https://bugs.documentfoundation.org/show_bug.cgi?id=170876
--- Comment #3 from ady <[email protected]> --- (In reply to ady from comment #2) > The problem is in the name of the first worksheet. > > The part of the formula that says: > > sheet1!$b$3:$b$4 > > is not recognized as a valid reference. > > The name of the worksheet does not seem to "really" be "sheet1"? > > Is there some space or some other symbol somewhere in that worksheet name > that confuses Calc when importing the name, and the import is translating > that name differently for the worksheet name itself in comparison to the > formula syntax? Or, could the import problem just be some incorrect forced capitalization of the first letter of the worksheet name (either for the worksheet name / label itself or for the formula)? "Sheet1" vs "sheet1"? Either way, the name of the worksheet and the name in the formula do not exactly match when Calc imports the xlsx (2007) file. -- You are receiving this mail because: You are the assignee for the bug.
