Li Wei wrote: > I have not realized the problem is so difficult > I'd rather do manual calculation, it's one-time task > The file is paste from a Excel file
Pasting from an Excel file looks odd to me, I guess it gives unpredictable results. Better open the Excel file with LO and paste it from there.