First sheet showing how the formula works correctly within a single sheet. Second sheet referencing the first and exhibiting the problem follows.
sheet1.ods (application/vnd.oasis.opendocument.spreadsheet), 8.53 KB, created by Tilman Vogel on 2017-11-17 10:36:41 UTC
(hide)
 
Creator: Tilman Vogel
Created: 2017-11-17 10:36:41 UTC
Size: 8.53 KB

Attachment is not viewable in your browser because its MIME type (application/vnd.oasis.opendocument.spreadsheet) is not one that your browser is able to display.

Download the attachment.

Actions: View
Attachments on bug 113898: 137824 | 137825