OpenXML Filter: TranslateExcelCellsCopied NullPointerException

Good day,

While using TranslateExcelCellsCopied set to true we received the following exception.

java.lang.NullPointerException: Cannot invoke "net.sf.okapi.filters.openxml.CellValue.asFormerInteger()" because the return value of "net.sf.okapi.filters.openxml.Cell.value()" is null
    at net.sf.okapi.filters.openxml.SharedStringsPart.formNonContextualisedEventsFor(SharedStringsPart.java:154)
    at net.sf.okapi.filters.openxml.SharedStringsPart.open(SharedStringsPart.java:123)
    at net.sf.okapi.filters.openxml.OpenXMLFilter.nextInDocument(OpenXMLFilter.java:455)
    at net.sf.okapi.filters.openxml.OpenXMLFilter.next(OpenXMLFilter.java:260)
    at net.sf.okapi.filters.openxml.OpenXMLFilter.next(OpenXMLFilter.java:269)
    at net.sf.okapi.filters.openxml.AbstractOpenXMLRoundtripTest.runOneTest(AbstractOpenXMLRoundtripTest.java:92)
    at net.sf.okapi.filters.openxml.AbstractOpenXMLRoundtripTest.runOneTest(AbstractOpenXMLRoundtripTest.java:39)
    at net.sf.okapi.filters.openxml.AbstractOpenXMLRoundtripTest.runOneTest(AbstractOpenXMLRoundtripTest.java:34)
    at net.sf.okapi.filters.openxml.AbstractOpenXMLRoundtripTest.runOneTest(AbstractOpenXMLRoundtripTest.java:30)
    at net.sf.okapi.filters.openxml.OpenXMLRoundTripTest.sameCellsNotCopiedMergedCells(OpenXMLRoundTripTest.java:1014)

I will create a Pull Request with a possible fix.

Cheers,
Warnar

Comments (3)