To reproduce:
- Add the following formula to a cell: "=A1=FALSE"
Actual: the result is always false
Expected: the result should be true when the cell is empty
Workaround: Use the ISBLANK function.
At this point, only the styling is preserved without the hyperlink itself. Implement logic to add the hyperlink to the generated PDF document.
Workaround: check the attached project.
When the Workbook has more than one sheet a localSheetId should be exported:
<definedName name="xlnm.Print_Titles" localSheetId="0">Sheet1!$A$1</definedName>
localSheetId (from the OOXML specification): Specifies a boolean value that indicates whether the defined name is related to an external function, command, or other executable code.
In some cases when cells are merged the cell borders are not correctly imported.