Re: [1/2OT] soffice and data import

[Camaleón <noelamac@gmail.com>]

On Sun, 05 Aug 2012 23:49:40 +0800, lina wrote:

> I got a temp file which was generated by "paste temp_a temp_b".
> 
> The temp file look like:
> 
> $ paste temp_a  temp_b
> 3 1.0 	3 1.0
> 5 2.0 	4 2.0
> 	        5 3.0
> 
> When I used the commend "soffice -o temp -calc" (This commend was told
> by someone from list long time ago, very helpful)
> 
> the
> 5 3.0
> jumped to the left rows.

(...)

Have you tried to get a dump with a different separator field (e.g., 
comma ",")? That way you'll get something like:

3,1.0,3,1.0
5,2.0,4,2.0
5,3.0

Which can be processed by "oocalc" more accurately.

Greetings,

-- 
Camaleón