IMPORTRANGE

NOT ASSERTABLE BY DESIGN, and deliberately recorded as a probe (expected: null) rather than a support claim -- the treatment batch B gave the CUBE* family and COPILOT, batch C gave DETECTLANGUAGE, and batch G gave RTD, STOCKHISTORY and TRANSLATE. THIS ONE IS NOT MERELY REMOTE, IT IS GATED BY A HUMAN CLICK. Google describes the function as "Imports a range of cells from a specified spreadsheet." and states the gate outright: "Spreadsheets must be explicitly granted permission to pull data from other spreadsheets using IMPORTRANGE." and "To grant the permission to the source spreadsheet, click Allow Access." A workbook this harness uploads has clicked nothing, so the documented behaviour is unreachable by construction -- an authorization dependency rather than only a network one. The page also states "IMPORTRANGE automatically checks for updates every hour while the document is open, even if the formula and spreadsheet don't change.", so even an authorized value is a moving one. The spreadsheet id in this formula is a placeholder that names no real document, deliberately: pointing the corpus at a real sheet would make the result depend on that sheet's contents and sharing settings. LIBREOFFICE, MEASURED BEFORE THIS FILE WAS AUTHORED. All four pinned builds (24.2.0.3, 24.8.7.2, 25.2.0.3, 25.8.7.3) were probed with NINE storage spellings -- plain, _xlfn., COM.MICROSOFT., ORG.OPENOFFICE., _xlfn.ORG.OPENOFFICE., ORG.LIBREOFFICE., _xlfn.ORG.LIBREOFFICE., _xlfn.COM.MICROSOFT. and COM.SUN.STAR.SHEET.ADDIN.ANALYSIS. -- and every one of those 36 combinations returned #NAME?. LibreOffice's own parser additionally wrote the name back into the converted file LOWER-CASED ('=importrange("https://docs.google.com/spreadsheets/d/EXAMPLE","Sheet1!A1")'), which is what it does with an identifier it does not recognise as a function at all rather than with a function it knows under a different storage token. A #NAME? under all nine storage forms on all four builds is therefore a genuine absence and not a storage-form artifact of this harness, which is why 'unsupported in LibreOffice' IS a verdict this file publishes even though the returned VALUE is not assertable in any engine. BATCH PROVENANCE (batch J, group B of sheets-lo-only-plan.md -- Google-documented, service- or context-bound; the final batch of the completeness push). This function has x == false in docs/data/compat.json: Microsoft does not document it at all, so this corpus makes no claim about Excel, nothing here is measured against Microsoft's documentation, and the Excel column on the published page reads 'n/a (not an Excel function)' rather than a verdict. The authority is Google's own function help, cited by full URL and by the date it was read (2026-08-31) -- Google publishes no version number for Sheets, so a bare URL dates nothing. GOOGLE SHEETS: this batch builds the Sheets chunk whose ingest will record what the service returns for this call. Until that ingest lands the Sheets column on the published page reads 'Not yet' and nothing in this file claims anything about it. (Stated positively on purpose -- scripts/check_honesty.py bans the blanket negative shape of that sentence, and the guard is worth keeping blunt.) Google's IMPORTRANGE help page, read live on 2026-08-31 at https://support.google.com/docs/answer/3093340.

NOT ASSERTABLE BY DESIGN, and deliberately recorded as a probe (expected: null) rather than a support claim -- the treatment batch B gave the CUBE* family and COPILOT, batch C gave DETECTLANGUAGE, and batch G gave RTD, STOCKHISTORY and TRANSLATE. THIS ONE IS NOT MERELY REMOTE, IT IS GATED BY A HUMAN CLICK. Google describes the function as "Imports a range of cells from a specified spreadsheet." and states the gate outright: "Spreadsheets must be explicitly granted permission to pull data from other spreadsheets using IMPORTRANGE." and "To grant the permission to the source spreadsheet, click Allow Access." A workbook this harness uploads has clicked nothing, so the documented behaviour is unreachable by construction -- an authorization dependency rather than only a network one. The page also states "IMPORTRANGE automatically checks for updates every hour while the document is open, even if the formula and spreadsheet don't change.", so even an authorized value is a moving one. The spreadsheet id in this formula is a placeholder that names no real document, deliberately: pointing the corpus at a real sheet would make the result depend on that sheet's contents and sharing settings. LIBREOFFICE, MEASURED BEFORE THIS FILE WAS AUTHORED. All four pinned builds (24.2.0.3, 24.8.7.2, 25.2.0.3, 25.8.7.3) were probed with NINE storage spellings -- plain, _xlfn., COM.MICROSOFT., ORG.OPENOFFICE., _xlfn.ORG.OPENOFFICE., ORG.LIBREOFFICE., _xlfn.ORG.LIBREOFFICE., _xlfn.COM.MICROSOFT. and COM.SUN.STAR.SHEET.ADDIN.ANALYSIS. -- and every one of those 36 combinations returned #NAME?. LibreOffice's own parser additionally wrote the name back into the converted file LOWER-CASED ('=importrange("https://docs.google.com/spreadsheets/d/EXAMPLE","Sheet1!A1")'), which is what it does with an identifier it does not recognise as a function at all rather than with a function it knows under a different storage token. A #NAME? under all nine storage forms on all four builds is therefore a genuine absence and not a storage-form artifact of this harness, which is why 'unsupported in LibreOffice' IS a verdict this file publishes even though the returned VALUE is not assertable in any engine. BATCH PROVENANCE (batch J, group B of sheets-lo-only-plan.md -- Google-documented, service- or context-bound; the final batch of the completeness push). This function has x == false in docs/data/compat.json: Microsoft does not document it at all, so this corpus makes no claim about Excel, nothing here is measured against Microsoft's documentation, and the Excel column on the published page reads 'n/a (not an Excel function)' rather than a verdict. The authority is Google's own function help, cited by full URL and by the date it was read (2026-08-31) -- Google publishes no version number for Sheets, so a bare URL dates nothing. GOOGLE SHEETS: this batch builds the Sheets chunk whose ingest will record what the service returns for this call. Until that ingest lands the Sheets column on the published page reads 'Not yet' and nothing in this file claims anything about it. (Stated positively on purpose -- scripts/check_honesty.py bans the blanket negative shape of that sentence, and the guard is worth keeping blunt.) Google's IMPORTRANGE help page, read live on 2026-08-31 at https://support.google.com/docs/answer/3093340.

NOT ASSERTABLE BY DESIGN, and deliberately recorded as a probe (expected: null) rather than a support claim -- the treatment batch B gave the CUBE* family and COPILOT, batch C gave DETECTLANGUAGE, and batch G gave RTD, STOCKHISTORY and TRANSLATE. THIS ONE IS NOT MERELY REMOTE, IT IS GATED BY A HUMAN CLICK. Google describes the function as "Imports a range of cells from a specified spreadsheet." and states the gate outright: "Spreadsheets must be explicitly granted permission to pull data from other spreadsheets using IMPORTRANGE." and "To grant the permission to the source spreadsheet, click Allow Access." A workbook this harness uploads has clicked nothing, so the documented behaviour is unreachable by construction -- an authorization dependency rather than only a network one. The page also states "IMPORTRANGE automatically checks for updates every hour while the document is open, even if the formula and spreadsheet don't change.", so even an authorized value is a moving one. The spreadsheet id in this formula is a placeholder that names no real document, deliberately: pointing the corpus at a real sheet would make the result depend on that sheet's contents and sharing settings. LIBREOFFICE, MEASURED BEFORE THIS FILE WAS AUTHORED. All four pinned builds (24.2.0.3, 24.8.7.2, 25.2.0.3, 25.8.7.3) were probed with NINE storage spellings -- plain, _xlfn., COM.MICROSOFT., ORG.OPENOFFICE., _xlfn.ORG.OPENOFFICE., ORG.LIBREOFFICE., _xlfn.ORG.LIBREOFFICE., _xlfn.COM.MICROSOFT. and COM.SUN.STAR.SHEET.ADDIN.ANALYSIS. -- and every one of those 36 combinations returned #NAME?. LibreOffice's own parser additionally wrote the name back into the converted file LOWER-CASED ('=importrange("https://docs.google.com/spreadsheets/d/EXAMPLE","Sheet1!A1")'), which is what it does with an identifier it does not recognise as a function at all rather than with a function it knows under a different storage token. A #NAME? under all nine storage forms on all four builds is therefore a genuine absence and not a storage-form artifact of this harness, which is why 'unsupported in LibreOffice' IS a verdict this file publishes even though the returned VALUE is not assertable in any engine. BATCH PROVENANCE (batch J, group B of sheets-lo-only-plan.md -- Google-documented, service- or context-bound; the final batch of the completeness push). This function has x == false in docs/data/compat.json: Microsoft does not document it at all, so this corpus makes no claim about Excel, nothing here is measured against Microsoft's documentation, and the Excel column on the published page reads 'n/a (not an Excel function)' rather than a verdict. The authority is Google's own function help, cited by full URL and by the date it was read (2026-08-31) -- Google publishes no version number for Sheets, so a bare URL dates nothing. GOOGLE SHEETS: this batch builds the Sheets chunk whose ingest will record what the service returns for this call. Until that ingest lands the Sheets column on the published page reads 'Not yet' and nothing in this file claims anything about it. (Stated positively on purpose -- scripts/check_honesty.py bans the blanket negative shape of that sentence, and the guard is worth keeping blunt.) Google's IMPORTRANGE help page, read live on 2026-08-31 at https://support.google.com/docs/answer/3093340.