Excel Compatible

[Funkis]

Hi… I imported a Excel spredsheet and I cant get it to work properbly… Will someone please look at it?

I am a total spredsheet noob, but im trying to create a csv file and use it in a script.

http://s17.postimg.org/wvafnrt3z/spredsheet2.png
http://s9.postimg.org/4ytq014nj/spredsheeterr.png

Why do I get these errors? And the formating does not look like this when I open the spredsheets in Excel…

How can I make this work?

[mariosv]

I think the issue is that Table1[] function it is not implemented in calc. Also I think someone is working on it.

If I am right can be replace with a more simple formula in this case:
In E2:
=A2&" "&B2
and copy down.
In the second replace:
Table1[…]
with
C2
and copy down.

[mmohrhard]

This is a special formula syntax and we have a GSoC student working on it.