Wednesday, December 22, 2010

Excel 2010 - useless importing feature

Have you ever tried importing a OpenOffice Spreadsheet? Quite a few problems :

- no formulas are imported
- graphics are lost

Essentially you just get the calculated data that was visible when the ODS was saved.

Another problem with Excel 2010, if you paste raw data, either separated by commas or tabs, it will just insert everything into the first column of cells.

At least in OpenOffice, it asks about the formatting when pasting a block of data (from Notepad or Acrobat Reader)

I know OpenOffice is not perfect, sometimes requiring the use of a mouse, or little things here and there that I have to use help to figure out, but at least the interface is labelled in a standard way. It imports Microsoft xlsx quite well, retaining formulas and graphics.

As a personal user, working with technical and financial data, other than legacy, I still cannot understand why Excel is used.

No comments:

Post a Comment