OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Bug or user with XML and Calc

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
Helfgott
Newbie
Newbie


Joined: 24 Apr 2012
Posts: 2
Location: Buenos Aires

PostPosted: Tue Apr 24, 2012 9:26 am    Post subject: Bug or user with XML and Calc Reply with quote

Hi guys.

Today i faced a "problem" with Open Office Calc 3.3.0 in Windows XP / Windows Server 2003:
===========================
The problem:
===========================
Try to open an XML file saved as "filename", that means, without extension or "filename.xlm" with *.xml extension.
Open Office Calc just shows a blank/empty spreadsheet, nor errors or warnings.
===========================
Facing the problem
===========================
I found this statement in the file:

<x:WorksheetOptions> </x:WorksheetOptions>

If you delete this statement, file is readed but no formated.
===========================
Solution
===========================
Save the file as filename.xls it works like a charm.

I saved a copy of the procedure in my blog http://asdfg.com.ar/wordpress/xml-en-open-office-calc-abre-en-blanco-pero-tiene-datos/ (spanish) for reference.
===========================
Aditional Question
===========================
Anyway, is it a bug of Oo 3.3.0? maybe i need to enable some option? I tested same in several computers (almost 5) including Windows XP and Server 2003.

**EDIT: Btw, i tested this in Ubuntu with Oo 3.2 and at least it shows you a Input / Output error




Thanks in advance.
_________________
Very Happy I like Open Source Stuff, just like you.
Back to top
View user's profile Send private message Visit poster's website MSN Messenger
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Tue Apr 24, 2012 10:34 am    Post subject: Reply with quote

Since Excel-XML is rather outdated and this project has far more consumers and complainers than contributors, nobody will ever write a better XML import filter for Excel specific XML.
_________________
Rest in peace, oooforum.org
Get help on https://forum.openoffice.org
Back to top
View user's profile Send private message
Helfgott
Newbie
Newbie


Joined: 24 Apr 2012
Posts: 2
Location: Buenos Aires

PostPosted: Wed Apr 25, 2012 6:30 am    Post subject: Reply with quote

Villeroy wrote:
Since Excel-XML is rather outdated and this project has far more consumers and complainers than contributors, nobody will ever write a better XML import filter for Excel specific XML.


That must be true, but i didn't ask for "filter or fix" i just was wondering why it happens.

Anyway, i solved it before come here and post, hoping this will be usefull for 2 or 3 people with the same problem.
_________________
Very Happy I like Open Source Stuff, just like you.
Back to top
View user's profile Send private message Visit poster's website MSN Messenger
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group