Import the this sample file that contains the custom validation formula
=ISNUMBER(MATCH("*@*",A1,0)) in the Server Import/Export Demo. The following error is thrown and logged on the developer's console:
Can't handle character with code: 64 (input: \"ISNUMBER(MATCH(\"*@*\",A1,0))\")"
Opening the file with the built-in open command works as expected as well as hardcoding the formula - REPL
No data is displayed after filtering the second column (expected), but the header is duplicated.
Additional notes: the file has been tested against the Open XML SDK tool and it reports 4 issues related to Fonts, however, the duplication occurs even after modifying the original file and applying an arbitrary font and font-size to the whole document, so that it passes the tool's verification successfully.
No data is displayed and there is no header duplication.