https://bugs.documentfoundation.org/show_bug.cgi?id=98965

--- Comment #1 from freeseek <[email protected]> ---
I believe I have tracked down the issue more precisely.

It seems like the problem is that some strings in the problematic xls file are
ended with a vertical tab (\v or \x11 or ^K) rather than a line feed (\n or
\x10). The following commands:
# wget --user-agent=""
http://www.sciencedirect.com/science/MiamiMultiMediaURL/1-s2.0-S0140673614617050/1-s2.0-S0140673614617050-mmc2.xls/271074/html/S0140673614617050/8362fd82294e4f65e12123ba7f198387/mmc2.xls
# sed -i -e 's/Nephrotic syndrome, type 2 \v/Nephrotic syndrome, type 2 \n/g' \
  -e 's/Spinocerebellar ataxia 29, congenital nonprogressive\v/Spinocerebellar
ataxia 29, congenital nonprogressive\n/g' \
  -e 's/Congenital disorder of glycosylation, type IIk \v/Congenital disorder
of glycosylation, type IIk \n/g' \
  -e 's/Charcot-Marie-Tooth disease, type 4J \v/Charcot-Marie-Tooth disease,
type 4J \n/g' \
  -e 's/Diaphragmatic hernia 3 \v/Diaphragmatic hernia 3 \n/g' \
  -e 's/Tetralogy of Fallot \v/Tetralogy of Fallot \n/g' \
  -e 's/Phosphoserine aminotransferase deficiency\v/Phosphoserine
aminotransferase deficiency\n/g' \
  -e 's/Deafness, autosomal dominant 48 \v/Deafness, autosomal dominant 48
\n/g' \
  -e 's/Periventricular heterotopia with microcephaly\v/Periventricular
heterotopia with microcephaly\n/g' \
  -e 's/Epileptic encephalopathy, early infantile, 8 \v/Epileptic
encephalopathy, early infantile, 8 \n/g' \
  -e 's/Congenital disorder of glycosylation, type Is \v/Congenital disorder of
glycosylation, type Is \n/'g mmc2.xls
# localc --convert-to xlsx mmc2.xls

Do work fine and the file is properly converted. The sed commands replace the
offending vertical tabs with the appropriate line feeds. The issue remains that
localc is unable to process the vertical tabs during conversion to xlsx but it
is perfectly capable of processing the vertical tabs when opening the xls file
or when converting to html.

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to