Re: [users] RE: Open Suse - 11.3_X64 Running OOO 3.2.1 - Running Painfully Slow in Comparison
On 12/19/2010 02:42 AM, Aphofis Scott wrote: Clayton Thanks for the reply. Indeed I have been very suspicious about possible Kernel Faults as I know there are many many issues with the released X_64 Kernel. I have maintained the suspicion that past and current Kernel Releases never allocate sufficient Cache buffers despite how much RAM is available. I have 8GIG and less than 30% is ever allocated to cache buffers and the flush of dirty cache buggers is far far fat too quickI could go onbut what would a user know??? This has absolutely nothing at all to do with OOo and the issue you're experiencing. Can you confirm that OOO really is a 64bit App?? Ask on the openSUSE mailing list. The version of OOo you're using is not the one from the OOo website it is the one built by the openSUSE guys (and yes, if you've got a 74 bit openSUSE install, you've got a 64 bit OOo version). The fact it's 64 bit or 32 bit has exactly zero impact on the issue you're having. 32 bit apps run just fine in 64 bit Linux installs. Anyway, please take this to the right place... the problem you're having is specific to openSUSE 11.3 and nothing at all to do with OOo. C. (I had the same problem with my openSUSE 11.3 install and resolved it as described in my first reply) -- Clayton Cornell ccorn...@openoffice.org OpenOffice.org Documentation Project co-lead - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] RE: Open Suse - 11.3_X64 Running OOO 3.2.1 - Running Painfully Slow in Comparison
On 12/19/2010 02:56 AM, Aphofis Scott wrote: The OOO version native to the Suse Linux Release is not bastardised, it just comes with 11 or very typical extensions that come from Sun Micro and Oracle - Nothing more nothing less...:-) Actually is is quite a lot different. The OOo version you get from the openSUSE repository is based on the Go-OO build of OOo. This version has, as you pointed out several extensions included, but in addition to that, it also has a long list of patches and changes applied which are not included in the core OOo. These differences include things like different interface features different/additional file import/export filters, different VBA support, different way of handling password protected spreadsheets, and a whole bunch of other things. It is a lot more than the 11 extensions you referenced, and as a result does behave differently. Sometimes bugs pop up that are very specific to this build of OOo that do not affect the core OOo... that is why Ariel asked the very legitimate question about trying the version from the OOo website C. -- Clayton Cornell ccorn...@openoffice.org OpenOffice.org Documentation Project co-lead - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] RE: Open Suse - 11.3_X64 Running OOO 3.2.1 - Running Painfully Slow in Comparison
Dear Clayton: No, I am not using 64 bits, I do have it, but I did not installed, because does not work well with the games. I am using Windows XP professional in 32 bits. But in the other hand.I just had a crash, and reinstalled the application and I did not had time to see if Office.org application correct the anomaly. Tomorrow, let you know about it. Thank you for your time. Have great Holidays and a Happy New Year you and your whole family. Me. ---Original Message--- From: Clayton Date: 12/18/2010 11:57:53 PM To: users@openoffice.org Subject: Re: [users] RE: Open Suse - 11.3_X64 Running OOO 3.2.1 - Running Painfully Slow in Comparison On 12/19/2010 02:42 AM, Aphofis Scott wrote: Clayton Thanks for the reply. Indeed I have been very suspicious about possible Kernel Faults as I know there are many many issues with the released X_64 Kernel. I have maintained the suspicion that past and current Kernel Releases never allocate sufficient Cache buffers despite how much RAM is available. I have 8GIG and less than 30% is ever allocated to cache buffers and the flush of dirty cache buggers is far far fat too quickI could go onbut what would a user know??? This has absolutely nothing at all to do with OOo and the issue you're experiencing. Can you confirm that OOO really is a 64bit App?? Ask on the openSUSE mailing list. The version of OOo you're using is not the one from the OOo website it is the one built by the openSUSE guys (and yes, if you've got a 74 bit openSUSE install, you've got a 64 bit OOo version). The fact it's 64 bit or 32 bit has exactly zero impact on the issue you're having. 32 bit apps run just fine in 64 bit Linux installs. Anyway, please take this to the right place... the problem you're having is specific to openSUSE 11.3 and nothing at all to do with OOo. C. (I had the same problem with my openSUSE 11.3 install and resolved it as described in my first reply) -- Clayton Cornell ccorn...@openoffice.org OpenOffice.org Documentation Project co-lead - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Shift+F5 does not work consistently
Good evening I am using OO3.2 on two Windows XP and one Ubuntu 10.04 machines (the latter only rarely, so I have not checked here). There is supposed to be a funktion - Shift+F5 - that will take you back to the last (cursor) postion when the document was saved. It does do so in some cases, but more often than not it does not work. Either the cursor does not move at all, or it jumps to a location I definitely did not use the last time I saved the document. Sometimes, the cursor jumps back to the last position, when I close the document and then reopen it, but then never again once I am in the document. I can have the cursor in a different position, save the document and try Shift+F5, but it always jumps back to the position when the document was last CLOSED, and not the last time it was saved. I checked also online: http://user.services.openoffice.org/en/forum/viewtopic.php?f=6t=14794 (problem solved) where someone said: AFAIK the last working position is maintained on a per user basis. Well, I DO have my personal information entered. And reentered. So, did I check, reenter the key combination Shift+F5 under Tools-customize. Is there any intelligle reason, why this function works in some documents but not in others and within the same document depending on its mood (this think is like the weather: unpredictable). More important, is there any way to correct this erratic behavior? Thank you in advance for your help. Thomas - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Re: PDF Conversion
In article aanlktinssvik7erg7kfkd1xkmbybsbfixtan7r7pv...@mail.gmail.com, hwfa.openoff...@googlemail.com (Harold Fuchs) wrote: *From:* Harold Fuchs hwfa.openoff...@googlemail.com *To:* users@openoffice.org *Date:* Thu, 16 Dec 2010 10:49:18 + On 16 December 2010 10:41, Marcello Romani mrom...@ottotecnica.com wrote: Il 16/12/2010 11:08, Harold Fuchs ha scritto: On 16 December 2010 07:15, Marcello Romanimrom...@ottotecnica.com wrote: snip PDF is not meant for editing. Period. snip So you are saying that after first saving my PDF document (which I made using Acrobat) it's cast in stone and I can't edit it or send it to my colleague (who also has Acrobat) for review/edit. Not sure about that ... No, I'm saying PDF was not /designed/ to be edited. The fact that one can edit a PDF is to be taken as an unintended feature. Why bother to write the Acrobat software if PDF is not *designed* to be edited? Under your assumption a pseudo printer would be all that was necessary. -- Harold Fuchs London, England Please reply *only* to users@openoffice.org The purpose of producing a pdf is twofold: to generate a platform independent document; and to produce one that can be circulated but one that is not subject to editing by other hands, so that the receiver gets a document that can be relied on to be in the form that the originator intended. Niall Martin - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] OOo Write - Letterhead for my Business Template
That is a nice idea, but I need the frame to be positioned around the main text body area. Isn't there a way to edit the default style for a page to include a frame by default on every page, similar to the Header / Footer ? Thanks! Amichai. On Sat, Dec 18, 2010 at 21:47, Barbara Duprey b...@onr.com wrote: On 12/18/2010 9:52 AM, Amichai Rotman wrote: Hello all, I am trying to create a template for my private business to serve me as a letterhead. I would like to have it on my Ubuntu box and write the documents using it as a template, as opposed to sending it to a print shop and have to find room to keep thousands of papers I was finally able to figure out how to use the shapes to create a rounded frame around the body of the document (chose the rectangle with the rounded edges, pulled it over the entire area, set the color as invisible, wrapped it to the page and set it as background). It all worked well, except when I start a new page, it comes without the frame... Is there a way I can set a page frame with rounded edges and make it behave as the page itself (save it as a style or some such)? Thanks! You should be able to anchor the frame in a header or footer to make it repeat on each page. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Re: Link to External Data *.csv file?
At 03:38 19/12/2010 +, Mark Knecht wrote: Brian Barker b.m.barker at btinternet.com writes: At 20:11 18/12/2010 +, Mark Knecht wrote: Is it possible to link two Sheets in a Calc spreadsheet to two external CSV files? [SNIP] Is there a way to do this? Yes. Use Insert | Sheet from File..., browse to the .csv file, and tick the Link box in the Insert Sheet dialogue. You'll want two sheets linked to your two data files and a third sheet (probably in front) in which to perform the comparison. I trust this helps. I think it does. I'll try it when I get back to that machine tomorrow. Let me double check one thing. If I use Insert | Sheet from File as you suggest, then is this spreadsheet updated with new data from the file anytime this spreadsheet is opened? Er, yes. If not, it wouldn't help with your problem! When you open the spreadsheet, you will see a dialogue asking if links to other files should be updated. If you wish to perform the update with the spreadsheet open, you can go to File | Reload (after saving any changes to the spreadsheet, of course) - which will stimulate the same dialogue. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] OOo Write - Letterhead for my Business Template
You can adjust the size and position of the frame regardless of where it's anchored, it doesn't need to be contained physically within the header. You'll want the wrap set to in background too, of course, so it doesn't affect text placement. The only way I know to have something on every page is to have it associated with the header or footer; text area content can't be made part of the page style, I don't think. On 12/19/2010 10:07 AM, Amichai Rotman wrote: That is a nice idea, but I need the frame to be positioned around the main text body area. Isn't there a way to edit the default style for a page to include a frame by default on every page, similar to the Header / Footer ? Thanks! Amichai. On Sat, Dec 18, 2010 at 21:47, Barbara Dupreyb...@onr.com wrote: On 12/18/2010 9:52 AM, Amichai Rotman wrote: Hello all, I am trying to create a template for my private business to serve me as a letterhead. I would like to have it on my Ubuntu box and write the documents using it as a template, as opposed to sending it to a print shop and have to find room to keep thousands of papers I was finally able to figure out how to use the shapes to create a rounded frame around the body of the document (chose the rectangle with the rounded edges, pulled it over the entire area, set the color as invisible, wrapped it to the page and set it as background). It all worked well, except when I start a new page, it comes without the frame... Is there a way I can set a page frame with rounded edges and make it behave as the page itself (save it as a style or some such)? Thanks! You should be able to anchor the frame in a header or footer to make it repeat on each page. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Turning off mute in videos inserted into an impress presentation.
Hi, When I insert videos in a presentation slide show, the sound is muted. When I click on the mute button, the mute icon stays on and the sound does not work. Could you tell me how to put the sound on? Thanks. Charlie Hunter
[users] Disappeared document
Dear sir/madam, I am an user of Open Office and with great pleasure, but now I have a problem: This morning I wanted to open a document in Recently opened documents, and to my surprise, the box was empty, while yesterday-evening, when closing down my computer, it was full. So far, that is inconveniant, but no harm done, you just start te document by selecting Opening Document. However the most important document I use, however still in the Document box on my computer, I cannot open the document any longer. All other documents can be openend, but that one. Can you please help? With kind regards, Kees Suijkerbuijk, Hoogerheide, The Netherlands
[users] Missing stuff on a Mac
I am having trouble using open office on a mac. I've looked through the help and FAQ but can't find an answer to my questions. I swear I'm missing buttons on the tool bar. I even went to customize it and options like format or tools for footnotes that are referred to in help answers just aren't there. When I'm in open office, my Mac toolbar (meaning not the one on the word document but the one that is always at the top of the screen on a mac) disappears. I'm guessing that's the problem and am wondering if anyone knows how to fix it. Thanks. Whitney P.S. Would appreciate having any answers explained very simply. I'm an anthropologist (recently studied OS software and think it's great) but not a computer expert. :)
[users] error 4960
Hi, i was trying to install the openoffice on my new mac pro. I dragged the icon to the applications but i can't install it. It says that i can't open this image and indicates error 4960. How can i fix this? Thanks, Julia Zaharieva
Re: [users] Disappeared document
Den 2010-12-18 12:08:44 skrev cmsuijkerbu...@gmail.com: Dear sir/madam, I am an user of Open Office and with great pleasure, but now I have a problem: This morning I wanted to open a document in Recently opened documents, and to my surprise, the box was empty, while yesterday-evening, when closing down my computer, it was full. So far, that is inconveniant, but no harm done, you just start te document by selecting Opening Document. However the most important document I use, however still in the Document box on my computer, I cannot open the document any longer. All other documents can be openend, but that one. Can you please help? With kind regards, Kees Suijkerbuijk, Hoogerheide, The Netherlands Maybe you moved the file to another folder? -- Kind regards Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Turning off mute in videos inserted into an impress presentation.
plug it in turn on high! - Original Message - From: Charlie Hunter cwhunt...@hotmail.com To: Open Office users@openoffice.org Sent: Saturday, December 18, 2010 11:16 AM Subject: [users] Turning off mute in videos inserted into an impress presentation. Hi, When I insert videos in a presentation slide show, the sound is muted. When I click on the mute button, the mute icon stays on and the sound does not work. Could you tell me how to put the sound on? Thanks. Charlie Hunter - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Missing stuff on a Mac
Whitney, You'll have to be more specific about what you are seeing. As a Mac user, I have never had the Mac menubar (not toolbar) disappear. It has the application-specific items for the active window in all applications, including Ooo on my machines. Jomali On Fri, Dec 17, 2010 at 12:02 PM, Whitney Russell whitney.lr...@gmail.comwrote: I am having trouble using open office on a mac. I've looked through the help and FAQ but can't find an answer to my questions. I swear I'm missing buttons on the tool bar. I even went to customize it and options like format or tools for footnotes that are referred to in help answers just aren't there. When I'm in open office, my Mac toolbar (meaning not the one on the word document but the one that is always at the top of the screen on a mac) disappears. I'm guessing that's the problem and am wondering if anyone knows how to fix it. Thanks. Whitney P.S. Would appreciate having any answers explained very simply. I'm an anthropologist (recently studied OS software and think it's great) but not a computer expert. :)
Re: [users] Disappeared document
On 12/18/2010 5:08 AM, cmsuijkerbu...@gmail.com wrote: Dear sir/madam, I am an user of Open Office and with great pleasure, but now I have a problem: This morning I wanted to open a document in Recently opened documents, and to my surprise, the box was empty, while yesterday-evening, when closing down my computer, it was full. So far, that is inconveniant, but no harm done, you just start te document by selecting Opening Document. However the most important document I use, however still in the Document box on my computer, I cannot open the document any longer. All other documents can be openend, but that one. Can you please help? With kind regards, Kees Suijkerbuijk, Hoogerheide, The Netherlands [Kees (cmsuijkerbu...@gmail.com) is not subscribed and will probably not see responses unless directly copied.] The document still is in your Documents folder, but when you double-click it, it doesn't open -- is that right? What happens instead? If there is an error message, please tell us what it is. If it just silently does nothing, you may have a leftover copy of OOo that is confusing Windows (assuming that's what you are running -- it would help to know what version, and also what version of OOo). In that case, you can use Task Manager to end any soffice.bin process that is running and then try again. By the way, we're just other users of OOo who try to help each other using this mailing list. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Missing stuff on a Mac
Please do not send me any more messages. I do not know what you're talking about! Thanks - Original Message - From: jomali jomali3...@gmail.com To: users@openoffice.org Sent: Sunday, December 19, 2010 2:12 PM Subject: Re: [users] Missing stuff on a Mac Whitney, You'll have to be more specific about what you are seeing. As a Mac user, I have never had the Mac menubar (not toolbar) disappear. It has the application-specific items for the active window in all applications, including Ooo on my machines. Jomali On Fri, Dec 17, 2010 at 12:02 PM, Whitney Russell whitney.lr...@gmail.comwrote: I am having trouble using open office on a mac. I've looked through the help and FAQ but can't find an answer to my questions. I swear I'm missing buttons on the tool bar. I even went to customize it and options like format or tools for footnotes that are referred to in help answers just aren't there. When I'm in open office, my Mac toolbar (meaning not the one on the word document but the one that is always at the top of the screen on a mac) disappears. I'm guessing that's the problem and am wondering if anyone knows how to fix it. Thanks. Whitney P.S. Would appreciate having any answers explained very simply. I'm an anthropologist (recently studied OS software and think it's great) but not a computer expert. :) - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] RE: Open Suse - 11.3_X64 Running OOO 3.2.1 - Running Painfully Slow in Comparison
---Original Message--- From: Clayton Date: 12/19/2010 12:08:59 AM To: users@openoffice.org Subject: Re: [users] RE: Open Suse - 11.3_X64 Running OOO 3.2.1 - Running Painfully Slow in Comparison On 12/19/2010 02:56 AM, Aphofis Scott wrote: The OOO version native to the Suse Linux Release is not bastardised, it just comes with 11 or very typical extensions that come from Sun Micro and Oracle - Nothing more nothing less...:-) Actually is is quite a lot different. The OOo version you get from the openSUSE repository is based on the Go-OO build of OOo. This version has, as you pointed out several extensions included, but in addition to that, it also has a long list of patches and changes applied which are not included in the core OOo. These differences include things like different interface features different/additional file import/export filters, different VBA support, different way of handling password protected spreadsheets, and a whole bunch of other things. It is a lot more than the 11 extensions you referenced, and as a result does behave differently. Sometimes bugs pop up that are very specific to this build of OOo that do not affect the core OOo... that is why Ariel asked the very legitimate question about trying the version from the OOo website C. -- Clayton Cornell ccorn...@openoffice.org OpenOffice.org Documentation Project co-lead - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Shift+F5 does not work consistently
---Original Message--- From: Thomas Blasejewicz Date: 12/19/2010 2:14:00 AM To: users@openoffice.org Subject: [users] Shift+F5 does not work consistently Good evening I am using OO3.2 on two Windows XP and one Ubuntu 10.04 machines (the latter only rarely, so I have not checked here). There is supposed to be a funktion - Shift+F5 - that will take you back to the last (cursor) postion when the document was saved. It does do so in some cases, but more often than not it does not work. Either the cursor does not move at all, or it jumps to a location I definitely did not use the last time I saved the document. Sometimes, the cursor jumps back to the last position, when I close the document and then reopen it, but then never again once I am in the document. I can have the cursor in a different position, save the document and try Shift+F5, but it always jumps back to the position when the document was last CLOSED, and not the last time it was saved. I checked also online: http://user.services.openoffice.org/en/forum/viewtopic.php?f=6t=14794 (problem solved) where someone said: AFAIK the last working position is maintained on a per user basis. Well, I DO have my personal information entered. And reentered. So, did I check, reenter the key combination Shift+F5 under Tools-customize. Is there any intelligle reason, why this function works in some documents but not in others and within the same document depending on its mood (this think is like the weather: unpredictable). More important, is there any way to correct this erratic behavior? Thank you in advance for your help. Thomas - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Re: PDF Conversion
---Original Message--- From: R N D Martin Date: 12/19/2010 2:23:45 AM To: users@openoffice.org Subject: [users] Re: PDF Conversion In article aanlktinssvik7erg7kfkd1xkmbybsbfixtan7r7pv...@mail.gmail.com, hwfa.openoff...@googlemail.com (Harold Fuchs) wrote: *From:* Harold Fuchs hwfa.openoff...@googlemail.com *To:* users@openoffice.org *Date:* Thu, 16 Dec 2010 10:49:18 + On 16 December 2010 10:41, Marcello Romani mrom...@ottotecnica.com wrote: Il 16/12/2010 11:08, Harold Fuchs ha scritto: On 16 December 2010 07:15, Marcello Romanimrom...@ottotecnica.com wrote: snip PDF is not meant for editing. Period. snip So you are saying that after first saving my PDF document (which I made using Acrobat) it's cast in stone and I can't edit it or send it to my colleague (who also has Acrobat) for review/edit. Not sure about that ... No, I'm saying PDF was not /designed/ to be edited. The fact that one can edit a PDF is to be taken as an unintended feature. Why bother to write the Acrobat software if PDF is not *designed* to be edited? Under your assumption a pseudo printer would be all that was necessary. -- Harold Fuchs London, England Please reply *only* to users@openoffice.org The purpose of producing a pdf is twofold: to generate a platform independent document; and to produce one that can be circulated but one that is not subject to editing by other hands, so that the receiver gets a document that can be relied on to be in the form that the originator intended. Niall Martin - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] error 4960
2010/12/17 Julia Zaharieva jula...@yahoo.com: Hi, i was trying to install the openoffice on my new mac pro. I dragged the icon to the applications but i can't install it. It says that i can't open this image and indicates error 4960. How can i fix this? Thanks, Julia Zaharieva Hello Julia, never encountered an error 4960...What I found is: faulty download dmg. I would throw away the download and try again. Tell us what happens... -- Guy using LibO and OOo 3.3.0 on a iMac Intel DualCore Snow Leopard -- please reply only to us...@libreoffice.org -- Dodoes can't afford to have headaches - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Re: Missing stuff on a Mac
On 2010/12/17 11:02 AM Whitney Russell wrote concerning Missing stuff on a Mac: When I'm in open office, my Mac toolbar (meaning not the one on the word document but the one that is always at the top of the screen on a mac) disappears. I'm guessing that's the problem and am wondering if anyone knows how to fix it. Are you in full screen mode? To go back to regular mode press Shift/Command/J or press the esc key. -- As a courtesy I have sent a copy of this reply to you as well as to the mailing list. Do Not reply to me personally but just to the list at users@openoffice.org - replies to my personal email address will be ignored. Since you are not subscribed to this list you may not see all the replies to your query.To subscribe send an email to users-subscr...@openoffice.org -- _ Larry I. Gusaas *Moose Jaw, Saskatchewan Canada Website: http://larry-gusaas.com An artist is never ahead of his time but most people are far behind theirs. - Edgard Varese * - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Re: Link to External Data *.csv file?
Unsubscribe me. Thank you. ---Original Message--- From: Brian Barker Date: 12/19/2010 9:47:56 AM To: users@openoffice.org Subject: Re: [users] Re: Link to External Data *.csv file? At 03:38 19/12/2010 +, Mark Knecht wrote: Brian Barker b.m.barker at btinternet.com writes: At 20:11 18/12/2010 +, Mark Knecht wrote: Is it possible to link two Sheets in a Calc spreadsheet to two external CSV files? [SNIP] Is there a way to do this? Yes. Use Insert | Sheet from File..., browse to the .csv file, and tick the Link box in the Insert Sheet dialogue. You'll want two sheets linked to your two data files and a third sheet (probably in front) in which to perform the comparison. I trust this helps. I think it does. I'll try it when I get back to that machine tomorrow. Let me double check one thing. If I use Insert | Sheet from File as you suggest, then is this spreadsheet updated with new data from the file anytime this spreadsheet is opened? Er, yes. If not, it wouldn't help with your problem! When you open the spreadsheet, you will see a dialogue asking if links to other files should be updated. If you wish to perform the update with the spreadsheet open, you can go to File | Reload (after saving any changes to the spreadsheet, of course) - which will stimulate the same dialogue. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Re: Link to External Data *.csv file?
Raul I. Sais wrote: Unsubscribe me. Thank you. /---Original Message---/ /*From:*/ Brian Barker mailto:b.m.bar...@btinternet.com /*Date:*/ 12/19/2010 9:47:56 AM /*To:*/ users@openoffice.org mailto:users@openoffice.org /*Subject:*/ Re: [users] Re: Link to External Data *.csv file? At 03:38 19/12/2010 +, Mark Knecht wrote: Brian Barker b.m.barker at btinternet.com writes: At 20:11 18/12/2010 +, Mark Knecht wrote: Is it possible to link two Sheets in a Calc spreadsheet to two external CSV files? [SNIP] Is there a way to do this? Yes. Use Insert | Sheet from File..., browse to the .csv file, and tick the Link box in the Insert Sheet dialogue. You'll want two sheets linked to your two data files and a third sheet (probably in front) in which to perform the comparison. I trust this helps. I think it does. I'll try it when I get back to that machine tomorrow. Let me double check one thing. If I use Insert | Sheet from File as you suggest, then is this spreadsheet updated with new data from the file anytime this spreadsheet is opened? Er, yes. If not, it wouldn't help with your problem! When you open the spreadsheet, you will see a dialogue asking if links to other files should be updated. If you wish to perform the update with the spreadsheet open, you can go to File | Reload (after saving any changes to the spreadsheet, of course) - which will stimulate the same dialogue. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.org mailto:users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org mailto:users-h...@openoffice.org Just above my comment is a link to click to unsubscribe yourself. Send the email created without adding anything. When you receive an email verifying that you wish to unsubscribe, reply to it without adding anything. Dan
[users] Re: Link to External Data *.csv file?
On 2010/12/19 4:26 PM Raul I. Sais wrote: Unsubscribe me. Thank you. You have to unsubscribe yourself. To unsubscribe, e-mail: users-unsubscr...@openoffice.org mailto:users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org mailto:users-h...@openoffice.org -- _ Larry I. Gusaas *Moose Jaw, Saskatchewan Canada Website: http://larry-gusaas.com An artist is never ahead of his time but most people are far behind theirs. - Edgard Varese * - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org