https://bz.apache.org/bugzilla/show_bug.cgi?id=59746
Nick Burch <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |NEEDINFO OS| |All --- Comment #4 from Nick Burch <[email protected]> --- The problem is that all the rows in your file neglect to say which one they are! In a normal file, the sheet xml should be like: <x:sheetData> <x:row r="1"> <x:c r="A1" t="str"> <x:v>Destination</x:v> </x:c> <x:c r="B1" t="str"> <x:v>Dial Code</x:v> </x:c> </x:row> <x:row r="2"> <x:c r="A2" t="str"> <x:v>Abkhazia - Fixed</x:v> </x:c> <x:c r="B2" t="str"> <x:v>7840</x:v> </x:c> Where each row indicates the row number. However, in your files, the row numbers are missing: <x:sheetData> <x:row hidden="0" outlineLevel="0" collapsed="0"> <x:c s="1" t="inlineStr"> <x:is> <x:t>Checked</x:t> </x:is> </x:c> <x:c s="1" t="inlineStr"> <x:is> <x:t>Ion</x:t> </x:is> </x:c> </x:row> <x:row hidden="0" outlineLevel="0" collapsed="0"> <x:c s="4" t="b"> <x:v>1</x:v> </x:c> <x:c s="4" t="inlineStr"> <x:is> <x:t>[M+H]+1</x:t> </x:is> </x:c> My guess is that Excel assumes that a row with no row number should be treated as the next row, and if all have no row number start from row 1. Any chance you could produce a much smaller problematic excel file from the other software, perhaps with just a few 10s of lines, which we could use for unit testing and a possible fix? -- You are receiving this mail because: You are the assignee for the bug. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
