Ask Your Question
0

Poor Import of Excel File

asked 2015-04-12 22:37:04 +0200

pixelstuff gravatar image

updated 2015-04-12 22:43:55 +0200

This Excel template for a check register is pretty nice in Excel, but almost every aspect of it imports poorly in LibreOffice. Can this be used to improve the next version of the import feature for Calc?

http://exceltemplates.net/financial/f...

You can sort of see in the thumbnail what it should look like and download the file near the bottom.

Some of the problems are:

  • the green alternating colors are missing
  • the pie chart doesn't work
  • the check register lines don't total
  • the categories don't total
  • there is a cell, bottom right, that should a new row to the register when hitting "tab"

This is technically an Excel template, but it doesn't matter if you save it to a regular Excel file. LibreOffice still opens it with the same missing features.

edit retag flag offensive close merge delete

Comments

Its a pretty weird example of unneeded overhelmed obfuscated stuff!

why the hell should Libreoffice deal with everything breeded out by some Excel-fanboy?

karolus gravatar imagekarolus ( 2015-04-12 23:15:54 +0200 )edit

I think the issue is that the template takes care of excel table functions not implemented in LibreOffice, If I'm not wrong some work is being done on this area.

m.a.riosv gravatar imagem.a.riosv ( 2015-04-12 23:31:12 +0200 )edit

I believe it still continues to be the case that the import of the old file format (i.e, XLS, etc.), rather than the new forms (XLSX, etc.), continues to be more reliable. Perhaps that may change, but I get the impression the *X "open" format is more complex and less amenable to interchange than the old "closed" ones. Could be wrong about that, though.

David gravatar imageDavid ( 2015-04-13 00:56:26 +0200 )edit

Actually see question https://ask.libreoffice.org/en/questi... , seems accepted answer is reporting a bug as I guessed in my answer.

akostadinov gravatar imageakostadinov ( 2017-01-23 15:23:07 +0200 )edit

2 Answers

Sort by » oldest newest most voted
0

answered 2017-01-22 17:40:13 +0200

JohnHa gravatar image

Not everything is supported - see Help. Always save in LO formats or you risk losing data and/or formatting.

edit flag offensive delete link more
0

answered 2017-01-23 15:17:27 +0200

akostadinov gravatar image

Hi, I think it is better to file a bug request instead to ask a question. It is not granted the issues would be fixed but being in the bug tracker increases the chances. Also your example can be used as a test case.

https://wiki.documentfoundation.org/Q...

See "Submitting a bug".

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2015-04-12 22:37:04 +0200

Seen: 167 times

Last updated: Jan 23 '17