Excel : Unexpected merged cell range in Table

[Philippe Henri]

Hello,

A one line/ one column table (with no headers) in an excel file causes an exception in openxml/CellReferencesRange.java, function Split()

→ Unexpected merged cell range

(the cell reference is A6 and not A6:A6…)

example excel attached

‌

regards

Phil

‌

[Denis Konovalyenko]

Below is a stack trace for this:

java.lang.IllegalStateException: Unexpected merged cell range: A6

    at net.sf.okapi.filters.openxml.CellReferencesRange.split(CellReferencesRange.java:66)
    at net.sf.okapi.filters.openxml.CellReferencesRange.first(CellReferencesRange.java:51)
    at net.sf.okapi.filters.openxml.CellReferencesRange.rows(CellReferencesRange.java:75)
    at net.sf.okapi.filters.openxml.CellReferencesRange.anyMatch(CellReferencesRange.java:123)
    at net.sf.okapi.filters.openxml.CellReferencesRange.anyMatch(CellReferencesRange.java:129)
    at net.sf.okapi.filters.openxml.SharedStringsPart.lambda$formEventsFor$0(SharedStringsPart.java:173)
    at java.base/java.util.stream.ReferencePipeline$2$1.accept(ReferencePipeline.java:176)
    at java.base/java.util.HashMap$EntrySpliterator.forEachRemaining(HashMap.java:1746)
    at java.base/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:484)
    at java.base/java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:474)
    at java.base/java.util.stream.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:150)
    at java.base/java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:173)
    at java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
    at java.base/java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:497)
    at net.sf.okapi.filters.openxml.SharedStringsPart.formEventsFor(SharedStringsPart.java:176)
    at net.sf.okapi.filters.openxml.SharedStringsPart.open(SharedStringsPart.java:105)
    at net.sf.okapi.filters.openxml.OpenXMLFilter.nextInDocument(OpenXMLFilter.java:447)
    at net.sf.okapi.filters.openxml.OpenXMLFilter.next(OpenXMLFilter.java:254)
    at net.sf.okapi.filters.openxml.OpenXMLFilter.next(OpenXMLFilter.java:263)

‌

[Denis Konovalyenko]

A fix was added to the scope of the opened pull request #613.

[Philippe Henri]

@Denis Konovalenko