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

[SOLVED] How to insert/import Excel file to Impress?

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Impress
View previous topic :: View next topic  
Author Message
faithima
General User
General User


Joined: 21 Mar 2011
Posts: 22
Location: Philippines

PostPosted: Tue Mar 22, 2011 12:59 am    Post subject: [SOLVED] How to insert/import Excel file to Impress? Reply with quote

I'm having a hard time looking for a solution on how to insert Excel file in Impress. I did click in the Menu Bar the Insert > File then look for my excel file but there's a prompt message telling "The file could not be loaded". What should I do? please help. Thanks! Crying or Very sad
_________________
**********************************************************
"It's not a BUG, it's an undocumented feature."
**********************************************************


Last edited by faithima on Mon Apr 04, 2011 10:17 pm; edited 3 times in total
Back to top
View user's profile Send private message
ftack
Moderator
Moderator


Joined: 27 Jan 2003
Posts: 3102
Location: Belgium

PostPosted: Tue Mar 22, 2011 11:58 am    Post subject: Reply with quote

Why would you want to insert an excel file into Impress??? The former is a spreadsheet, the latter is a presentation.
_________________
--
GNU/Linux (Ubuntu)
Back to top
View user's profile Send private message
faithima
General User
General User


Joined: 21 Mar 2011
Posts: 22
Location: Philippines

PostPosted: Tue Mar 22, 2011 4:21 pm    Post subject: Reply with quote

Thanks for the reply Mr. Moderator,
anyways, because the needed file is in xls format.
They have to insert it and present it in impress form.
In Powerpoint, as soon as you insert the excel format,
you just have to double click the excel, then make any changes
then save it, then automatically, updated in powerpoint.
but in OOo, double click the spreadsheet, then another window for the
spreadsheet, then that's it. you have to insert it again
every now and then as you made changes in spreadsheet.
_________________
**********************************************************
"It's not a BUG, it's an undocumented feature."
**********************************************************
Back to top
View user's profile Send private message
ftack
Moderator
Moderator


Joined: 27 Jan 2003
Posts: 3102
Location: Belgium

PostPosted: Wed Mar 23, 2011 12:53 am    Post subject: Reply with quote

You are referring to an embedded object indeed. This should also work with Impress through Copy - Paste Special.

Just a "Copy - Paste" will probably insert the data as an Impress table. Instead, use "Copy - Paste special". Under "selection" select the appropriate format. If I copy-paste from Calc (cannot test with Excel here), I see an option "calc". Clicking that, then "OK" will insert the copied data as an OLE object into the presentation.

This object can be edited "in place" by double clicking. If you right-click the object, you will find the commands "Ole object", which also will allow this "in place" editing. Fortunately, in recent versions, a "Outplace OLE object" command has been added, allowing to edit the object in a separate window.

For an excel object, there probably will be no "in-place" editing. The object will be opened in a separate Excel window.

Another option to insert an ole object, rather than copy - paste special, is to use Insert - Object - OLE object.
_________________
--
GNU/Linux (Ubuntu)
Back to top
View user's profile Send private message
faithima
General User
General User


Joined: 21 Mar 2011
Posts: 22
Location: Philippines

PostPosted: Wed Mar 23, 2011 1:13 am    Post subject: Thank You :D Reply with quote

Woah! Great! I got it already.. Very Happy
Thanks! That was really helpful.
The reason why I have to know this,
is because i'm going to present pointers, advantages
and different things about OpenOffice overpowering MSOffice.
(which is possible to happen..right??? Razz )

Many thanks to you.. Very Happy
_________________
**********************************************************
"It's not a BUG, it's an undocumented feature."
**********************************************************
Back to top
View user's profile Send private message
faithima
General User
General User


Joined: 21 Mar 2011
Posts: 22
Location: Philippines

PostPosted: Mon Apr 04, 2011 9:34 pm    Post subject: Reply with quote

Hi there!
My issue is not yet solved..
Sad
Those former solutions only works in version 2.3.. Sad
What about in higher version? Please help. Thanks!
_________________
**********************************************************
"It's not a BUG, it's an undocumented feature."
**********************************************************
Back to top
View user's profile Send private message
faithima
General User
General User


Joined: 21 Mar 2011
Posts: 22
Location: Philippines

PostPosted: Mon Apr 04, 2011 10:17 pm    Post subject: Reply with quote

Hi There again!
I'm sorry for bothersome.
Problem Solved.. Very Happy
_________________
**********************************************************
"It's not a BUG, it's an undocumented feature."
**********************************************************
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Impress 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