[users] Calc Lack of Printer Options and Write FAX pdf file name.
Hello. My system is MacOS X 10.5.5, OpenOffice 3.0.0 OOO300m9 (Build:9358) My problem(s). No1: Working with a spreadsheet I do mark an area that I want to be printed instead of the whole sheet. I do not get the chance to select Print Marked Area Only That option did show up before I had installed a printer, after installing the printer I can not find the option to print Print Marked Area Only. Anyone have a suggestion? No2: Using the printer option to send a pdf by fax using the Mac system a Write document is faxed, BUT the statistics of sent faxes displayes the document with no file name in the fax list. This is a problem as I then do not know what document has been faxed. Using MS Word however the file name of the document is displayed in the sent fax list. I assume this is a problem to be solved by the developers. Best regards, /Hans. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Open Office 3.0
Hallo OpenOffice- Team, kann es Euch anbieten mit High Speed- download die Version 3 in German zum download mit zur Verfügung zu stellen. Viele Grüsse, Uwe Jonescheit
[users] SUBSCRIPTION
I would like to subscribe to this list but I can't find any form to fill in. I enclose my personals: Mr. Johnny Mansson Street: Prytzgatan 6 C Zip: 43131 Town: Molndal Country: Sweden No virus found in this outgoing message. Checked by AVG - http://www.avg.com Version: 8.0.175 / Virus Database: 270.8.5/1764 - Release Date: 2008-11-03 07:46 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Auto Spell check bug
On Thursday 30 October 2008 11:21:02 you wrote: Hi, On Thu, Oct 30, 2008 at 18:52, Harold Fuchs wrote: On 29/10/2008 17:41, Juan Ortega wrote: snip When checking the paragraph style on the font tab, the language next to English(USA) doesn't have ABC (checkmark) does that mean the dictionary is not installed? Yes. ... in addition ... {...] I tried all that, and every extention I try to add an error comes up saying bad transfer url Could you please specify this error message? ... and please remember - you had a look at this link? - quote Hello Juan, maybe this tutorial can help: http://user.services.openoffice.org/en/forum/viewtopic.php?f=7t=67 Guy /quote (1) Please check your installed dictionaries. The default dictionaries for the en-US version should be: en - fr - es ... (2) ... there is explained how it should work - Software Specification Document - Set Language Attribute for Text http://specs.openoffice.org/appwide/linguistic/Set_Language_Attribute_for_ Text.odt (3) ... and there are some test case - OpenOffice.org - Testcase specification Testname: Set Language Attribute for Text http://qa.openoffice.org/ooQAReloaded/TestcaseSpecifications/OpenOffice.or g_2.4/Word_Processor/Set_Language_Attribute_for_Text.html Manfred I haven't noticed before but when I start the program in xterm this comes up I18N: Operating system doesn't support locale en_US The OS (FreeBSD) can't find the dictionary? or it's not supported? - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] open office 3.0.0 beta
Guten Tag Mein System: Mac OS 10.4.11.Miuss die Beta-Version 3.0.0 auf meinem Mac aktualisiert werden? Wenn ja, womit? Sollte gegebenenfalls vor einem Download die Beta-Version entfernt werden? Vielen Dank für die Unterstützung. Gruss Martin Graedel-Jaddou Pfrundstrassse 28 3176 Neuenegg Tel./AB: 031 741 41 22
[users] Questions on product
To whom it may concern, I have a new laptop computer and included with it is a ``trial`` Microsoft Office software that I can open so many times before I am asked for the product key. I would like to know if I need to remove this ``trial`` software before I download your product. If I don't remove it can they interfere with one another? Thank you. Suzanne Guitor _
[users] pricelist for open office license
Dear all, We are a company with 120 - 150 employees. For some employees (5-10) we need to have open office portable. Can you send us a pricelist for license, please? Best regards, Dirk Fritzen - MIS Administrator - QCG COMPUTER GMBH Neuenhofstr. 191 52078 Aachen [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Tel: 0241 55930-54 Fax: 0241 55930-19
[users] regarding open office
Hello I would like to distribute open office on burned discs. Is this possible or illegal? I sell laptops and would like to deliver them with openoffice for free. OK? or not? Best regards
[users] Pls help, Data type changed when use Openoffice Spreadsheet
Dear sir/madam, I have a question about using open office spread sheet. I used google to find out the answer but I can't. And I find your website, so please help me in this situation. My question is very simple, but I don't know how to fix it. It is when I type, for example, 3.3.3 into one cell of a sheet, it changed into 03/03/03 (mean March 03rd 2003). I tried many ways to change it to 3.3.3 but I can't. So please help me about this, I thank you very much for your consideration. Thuy Ta - From VietNam.
[users] What is open office?
I do not remember joining open office. How did this come about? I am clearing icons off of my desktop and open office was one of them. Can you be of help? Thank You, Phyllis M
[users] Question about Calc
Thanks for the answer to my question about Calc - this did the trick In answer to Steve's question about why I should want to do this, I think it was partly answered but the specific cases I wanted it for were: 1. I'd got some invoices to do and in many cases the only change from last year was replace some line items with =ROUND(last_years_price * (1 + inflation_rate);2) The trouble is I did that last year and the formula started to look ridiculous, besides which inflation_rate was different. I suppose I could have done it by making inflation_rate some cumulative value but it seemed easiest to start from plain numbers. Or I could have had last year's invoice on one worksheet with a reference to the line item for that in another worksheet. 2. I had to make some high-level adjustments to our accounts for end of year audit and in some cases I had to move sums between the debit and credit column, so for example row A had X subtracted from the debit column row B had Y added to the debit column and row C had X-Y subtracted from the credit column. I wanted the values to be the correct final values not a whole string of corrections especially as the formulae involved plain numbers and no cell references. 3. Same task - we have most accounts in GBP, some in USD and some in Euro. When conversions have been done at certain points of the year, the rate that applied on that day rather than the rate at the end end of the year had to be used. In all cases the easiest thing seemed to me to be to just replace the column with the numeric value once I was happy it was right. I could have probably done it by having a considerably more complicated spreadsheet in each case but it seemed pointless in the circumstances. John Collins Xi Software Ltd www.xisl.com
Re: [users] SUBSCRIPTION
2008/11/3 njm [EMAIL PROTECTED] I would like to subscribe to this list but I can't find any form to fill in. I enclose my personals: Mr. Johnny Mansson Hello Johnny, To subscribe send a mail (may be empty, no subject needed) to [EMAIL PROTECTED] [EMAIL PROTECTED] and reply to the automatic response you'll receive. It may be wise to create a separate email account for this list, since you'll receive 20, 30 or more mails per day. I have a (free) gmail account for all things about OpenOffice.org and other list like this. It gives you lots of space, so you don't aven have to throw away OOo help that might be useful later. -- Guy using dutch OOo Aqua 3.0.0 on a iMac Intel DualCore Tiger and brazilian OOo Aqua 3.0.0 on an Intel MacBook Pro Leopard -- please reply only to users@openoffice.org -- Dodoes can't afford to have headaches
Re: [users] What is open office?
2008/11/6 Phyllis Myers [EMAIL PROTECTED] I do not remember joining open office. How did this come about? I am clearing icons off of my desktop and open office was one of them. Can you be of help? Thank You, Phyllis M Hello Phyllis, You don't have to join OpenOffice.org. OpenOffice.org is a complete office suite with text manipulation, spreadsheet, presentation program, database program etc. It is an Open Source program, which makes it free of charge, free to distribute and to use. You can find all relevant information at www.openoffice.org I don't know how OpenOffice.org got onto your computer. Maybe the shop you got it from installed it, since it's free and a good substitute for expensive proprietary office suites like MS Office. Why not give it a try before throwing it into the trashbin? You can always get help on this list. -- Guy using dutch OOo Aqua 3.0.0 on a iMac Intel DualCore Tiger and brazilian OOo Aqua 3.0.0 on an Intel MacBook Pro Leopard -- please reply only to users@openoffice.org -- Dodoes can't afford to have headaches
Re: [users] Pls help, Data type changed when use Openoffice Spreadsheet
ta thuy wrote: Dear sir/madam, I have a question about using open office spread sheet. I used google to find out the answer but I can't. And I find your website, so please help me in this situation. My question is very simple, but I don't know how to fix it. It is when I type, for example, 3.3.3 into one cell of a sheet, it changed into 03/03/03 (mean March 03rd 2003). I tried many ways to change it to 3.3.3 but I can't. So please help me about this, I thank you very much for your consideration. Thuy Ta - From VietNam. Hi Thuy Ta The answer is simple, this is an automatic feature within spreadsheets to try and detect the difference between dates, pure numbers and character strings. My recommendation would be to type this string as '3.3.3 as the ' (a single quote mark) tells a spreadsheet program that what follows is a string of characters and not a number. I hope that helps Rob - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Install dictionaries in Ooo 3.0
Hi, ANDIS I have visited the link for extensions.services...etc and I didn´t fine a Spanish dictionary with thesuarus and synonims att all. Do you know where I can fine them? Many thanks Carlos. - Original Message - From: Andis [EMAIL PROTECTED] To: users@openoffice.org Sent: Sunday, October 19, 2008 12:17 PM Subject: Re: [users] Install dictionaries in Ooo 3.0 Hi! You have to go to http://extensions.services.openoffice.org/taxonomy/term/231 and download appropriate directory. In windows it might be associated with Openoffice.org extension manager, thus you just need to confirm installation during download. Other way is to save dictionary file on your computer hard disk drive and then open it through Openoffice.org Tools menu (Tools -- Extension manager... -- Add...) and browse to location, where you saved dictionary file. Andis Carlos Martinez wrote: Dear friends, after I hade made the uppdate of Ooo 2.0.3 to Ooo 3. I loosed the dictionaries I´ve installed in the older version. I´m running Ooo 3 (In Swedish). under Windows XP. But..When I tryto use the installer DicOOo found in http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/dicooo/DicOOo.sxw , it works with the older versions, but not with 3.0. If there are somebody who knows How I could install a Spanish dictionary in the Swedish version of Ooo 3.0 I´d appreciate this help. Sincerelly Carlos. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Saving dta on a samba-share
We are using staroffice 8 and openoffice 2 since 2006 on about 300 pc in my school. The users are saving their data on their personal samba-share. Now we want to change to OO-3 and have the problem, that no user is able to save data in his/her home-share. Cause is the new behaviour of open office, to create a temporary file like .lockFilename. .Filename-files are vorbidden (veto file statement in the smb.conf ) for this share. Is there any possibility to change the standard name for the temporary files (they should not begin with a dot) ? Is it possibe to change the path for the temporary files without changing the path to the working directory ? Dieter Powered by Open-Xchange.com - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] regarding open office
2008/11/5 André Lövgren [EMAIL PROTECTED] Hello I would like to distribute open office on burned discs. Is this possible or illegal? I sell laptops and would like to deliver them with openoffice for free. OK? or not? Best regards Hello André, It's perfectly legal and even encouraged to distribute OpenOffice.org, either on CD or already installed on computers. Read the licence info here: http://www.openoffice.org/license.html -- Guy using dutch OOo Aqua 3.0.0 on a iMac Intel DualCore Tiger and brazilian OOo Aqua 3.0.0 on an Intel MacBook Pro Leopard -- please reply only to users@openoffice.org -- Dodoes can't afford to have headaches
Re: [users] Questions on product
suzanne guitor wrote: To whom it may concern, I have a new laptop computer and included with it is a ``trial`` Microsoft Office software that I can open so many times before I am asked for the product key. I would like to know if I need to remove this ``trial`` software before I download your product. If I don't remove it can they interfere with one another? Thank you. No, you don't need to remove it, as you can run both on the same computer. However, unless you're planning on paying for it, you might as well remove it. Just make sure you can open your documents in OpenOffice first. You may have to save them in an older format. -- Use OpenOffice.org http://www.openoffice.org - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] pricelist for open office license
Dirk Fritzen wrote: Dear all, We are a company with 120 - 150 employees. For some employees (5-10) we need to have open office portable. Can you send us a pricelist for license, please? Here's the price list. $0. There is no charge for using OpenOffice.org on as many computers as you wish. You can even pass it around to friends and family. Incidentally, the portable version, available from portableapps.com, is a separate project, based on OpenOffice.org. However, it's the same license and also free. While both OpenOffice.org and the portableapps version are free of charge, donations are always welcome. -- Use OpenOffice.org http://www.openoffice.org - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Bulleting in OOo3 broken?
Andrew Douglas Pitonyak wrote: A reference implementation is used as a definitive interpretation for that specification. This helps to discover errors and ambiguities in the specification. It is very difficult to fully specify anything, and at least with a reference implementation, you know who is correct. I frequently see web pages rendered differently depending on the web browser used. Which one is correct and accurate? A reference implementation would answer that question immediately. It is clearly important to have a fully and correctly specified system, but that does not remove the helpfulness of a reference implementation. I only vaguely remember the precise behavior that you use to claim that a destructive edit exists. Did I consider it a bug? Yes! Now, which behavior is correct? In this context, however, the first issue of discussion seems to be the ODF file format and how it should be rendered. We only care that it is always and consistently rendered exactly the same. If I save a file, reopen the file, and the rendering has changed, well, where is the bug? Is the data properly rendered? Was the data changed on write? A reference implementation would help sort that out. I feel that my point has been missed. With regards to two web pages that are rendered differently, assuming that the markup is valid and to spec, the answer to the question regarding which is correct is both of them. My point is that the ODF spec should be like proper use of XHTML strict; a rigid and well-defined set of semantic rules with a 1:1 mapping to document elements. Were that the case, it wouldn't matter at all if the documents were *rendered* differently, as editing them in different apps would not result in any semantic irregularities. If I were working on a document in OOo and my colleague was working on the same document in Abiword, if the ODF specification was properly abstracted, neither of us would be any the wiser that the document was rendered differently to the other. - Naz. -- السلام عليكم Web: www.mrnaz.com Ph: +61 400 460 662 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] regarding open office
André Lövgren wrote: Hello I would like to distribute open office on burned discs. Is this possible or illegal? I sell laptops and would like to deliver them with openoffice for free. OK? or not? Best regards Yes, you can do that. You can find the ISO files here: http://distribution.openoffice.org/cdrom/iso_downoad.html -- Use OpenOffice.org http://www.openoffice.org - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Install dictionaries in Ooo 3.0
2008/11/6 Carlos Martinez [EMAIL PROTECTED] Hi, ANDIS I have visited the link for extensions.services...etc and I didn´t fine a Spanish dictionary with thesuarus and synonims att all. Do you know where I can fine them? Many thanks Carlos. Indeed, Carlos, I only find Argentinian and Mexican blends of Spanish, no Spanish from Spain... I have the Spanish word list in my OOo, but I can't find the extension of it! -- Guy using dutch OOo Aqua 3.0.0 on a iMac Intel DualCore Tiger and brazilian OOo Aqua 3.0.0 on an Intel MacBook Pro Leopard -- please reply only to users@openoffice.org -- Dodoes can't afford to have headaches
Re: [users] Saving data on a samba-share
At 12:08 06/11/2008 +0100, Dieter Treichel wrote: We are using staroffice 8 and openoffice 2 since 2006 on about 300 pc in my school. The users are saving their data on their personal samba-share. Now we want to change to OO-3 and have the problem, that no user is able to save data in his/her home-share. Cause is the new behaviour of open office, to create a temporary file like .lockFilename. .Filename-files are forbidden (veto file statement in the smb.conf ) for this share. Is there any possibility to change the standard name for the temporary files (they should not begin with a dot) ? Is it possible to change the path for the temporary files without changing the path to the working directory ? I don't know the answer to this, but I can mention another disadvantage with the new arrangement. If I open an OpenOffice document to read it or perhaps to copy material from it and then close the document without making changes or saving it, the modification date and time on the file are not changed. This is correct. But the modification date and time on the containing folder *are* changed, because two changes have been made to it - the creation and then deletion of the lock file. The folder and its contents, though, are just as they were. This is perhaps unhelpful, and could be avoided if the lock files were saved somewhere else - perhaps in a common location, as suggested above. Brian Barker - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] What is open office?
Phyllis Myers wrote: I do not remember joining open office. How did this come about? I am clearing icons off of my desktop and open office was one of them. Can you be of help? Thank You, Phyllis M You do not appear to be subscribed to this mail list, so I'm not sure what you joined. OpenOffice is an office suite, comparable to and compatible with Microsoft Office. It includes word processor and spreadsheet components, among others. If it is of no use to you, you can uninstall it in the same manner as you would uninstall any other application. In Windows, there's an Add/Remove software utility in the Control Panel. You'd use that to uninstall it. -- Use OpenOffice.org http://www.openoffice.org - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Saving data on a samba-share
Brian Barker wrote: At 12:08 06/11/2008 +0100, Dieter Treichel wrote: We are using staroffice 8 and openoffice 2 since 2006 on about 300 pc in my school. The users are saving their data on their personal samba-share. Now we want to change to OO-3 and have the problem, that no user is able to save data in his/her home-share. Cause is the new behaviour of open office, to create a temporary file like .lockFilename. .Filename-files are forbidden (veto file statement in the smb.conf ) for this share. Is there any possibility to change the standard name for the temporary files (they should not begin with a dot) ? Is it possible to change the path for the temporary files without changing the path to the working directory ? I don't know the answer to this, but I can mention another disadvantage with the new arrangement. If I open an OpenOffice document to read it or perhaps to copy material from it and then close the document without making changes or saving it, the modification date and time on the file are not changed. This is correct. But the modification date and time on the containing folder *are* changed, because two changes have been made to it - the creation and then deletion of the lock file. The folder and its contents, though, are just as they were. This is perhaps unhelpful, and could be avoided if the lock files were saved somewhere else - perhaps in a common location, as suggested above. I beg to differ: I don't think that's at all unreasonable behaviour. Even if you open a file in OOo just to read it, it is nevertheless opened in r/w mode, and it therefore needs to be locked because the system can't read the user's mind -- it might be helpful if there were an open-read-only facility if this is an issue. So the date changes are correct. Lock files have to exist alongside the original if they're to be any use in a networked environment - different machines may have different ideas of the suggested common location. I think the OP needs to get his samba config changed - that seems to me to be the real issue. I wasn't actually aware 'dot' files could be prohibited under samba - and my own OOo v3 running under XP works very happily using a samba share. BTW 'dot' files do seem to be a general windows issue: try using R-click and New|Text File under explorer to create a file called .xyzzy - it won't do it (file name needed or some such). I will try to explain my problem with the dot-Files: The server is set up to supply windows- and linux-clients. The linux-clients needs a lot of dot-files in the homes of the user. These files should not be visible using the windows-clients. For this purpose there is the Veto-file-statement in the smb.conf-file. It has never been a problem before. I would be glad to get a change in the behaviour of OOo-3. thanks Dieter Powered by Open-Xchange.com - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Pls help, Data type changed when use Openoffice Spreadsheet
At 17:25 04/11/2008 -0800, Thuy Ta wrote: I have a question about using open office spread sheet. [...] It is when I type, for example, 3.3.3 into one cell of a sheet, it changed into 03/03/03 (mean March 03rd 2003). I tried many ways to change it to 3.3.3 but I can't. There are two ways to avoid this. Either: o Format the cells as Text before entering the values. (Go to Format | Cells... .) o Enter an apostrophe before typing the data. The apostrophe does not appear in the cell, but just indicates that the data should be interpreted as text and suppresses the automatic recognition of dates. Note that if you have Custom Quotes set up, the apostrophe will itself be corrected into a smart quote and this will prevent it being recognised properly. To avoid this, either press Ctrl+Z (or go to Edit | Undo) immediately after typing the apostrophe each time (which undoes the correction to smart quote but does not remove the apostrophe) or go to Tools | AutoCorrect... | Custom Quotes and remove the tick from Replace under Single quotes once (which suppresses the unwanted correction). I trust this helps. Brian Barker - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Open Office 3.0
Uwe Jonescheit schrieb: Hallo OpenOffice- Team, kann es Euch anbieten mit High Speed- download die Version 3 in German zum download mit zur Verfügung zu stellen. Viele Grüsse, Uwe Jonescheit Hi, wäre sinnvoller in Englisch zu schreiben, da es die englische bzw. internationale Newsgroup ist. Sonst kann sein, dass dir keiner antwortet. Gruß, Spiderman - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] SUBSCRIPTION
Hej Johnny, om du följer länken till http://support.openoffice.org/. du kommer att få en sida där du hittar en rubrik Free Community Support och där efter a.. Users Mail List (Subscribe / Archives) OpenOffice.org Project community support provided by a network of hundreds of experienced users. You must be subscribed to post messages. Skicka en mail dit med och skriv vid Ämne SUBSCRIBE.sned e-mailen och där efter du kommer att få en mail för att konfirmera din e-mail addres, svara denna mail och njut av allt post som hamnar i din brevlåda. Hälsningar från Västerbotten Carlos Martinez - Original Message - From: njm [EMAIL PROTECTED] To: users@openoffice.org Sent: Monday, November 03, 2008 10:07 PM Subject: [users] SUBSCRIPTION I would like to subscribe to this list but I can't find any form to fill in. I enclose my personals: Mr. Johnny Mansson Street: Prytzgatan 6 C Zip: 43131 Town: Molndal Country: Sweden No virus found in this outgoing message. Checked by AVG - http://www.avg.com Version: 8.0.175 / Virus Database: 270.8.5/1764 - Release Date: 2008-11-03 07:46 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Saving data on a samba-share
Brian Barker wrote: At 12:08 06/11/2008 +0100, Dieter Treichel wrote: We are using staroffice 8 and openoffice 2 since 2006 on about 300 pc in my school. The users are saving their data on their personal samba-share. Now we want to change to OO-3 and have the problem, that no user is able to save data in his/her home-share. Cause is the new behaviour of open office, to create a temporary file like .lockFilename. .Filename-files are forbidden (veto file statement in the smb.conf ) for this share. Is there any possibility to change the standard name for the temporary files (they should not begin with a dot) ? Is it possible to change the path for the temporary files without changing the path to the working directory ? I don't know the answer to this, but I can mention another disadvantage with the new arrangement. If I open an OpenOffice document to read it or perhaps to copy material from it and then close the document without making changes or saving it, the modification date and time on the file are not changed. This is correct. But the modification date and time on the containing folder *are* changed, because two changes have been made to it - the creation and then deletion of the lock file. The folder and its contents, though, are just as they were. This is perhaps unhelpful, and could be avoided if the lock files were saved somewhere else - perhaps in a common location, as suggested above. I beg to differ: I don't think that's at all unreasonable behaviour. Even if you open a file in OOo just to read it, it is nevertheless opened in r/w mode, and it therefore needs to be locked because the system can't read the user's mind -- it might be helpful if there were an open-read-only facility if this is an issue. So the date changes are correct. Lock files have to exist alongside the original if they're to be any use in a networked environment - different machines may have different ideas of the suggested common location. I think the OP needs to get his samba config changed - that seems to me to be the real issue. I wasn't actually aware 'dot' files could be prohibited under samba - and my own OOo v3 running under XP works very happily using a samba share. BTW 'dot' files do seem to be a general windows issue: try using R-click and New|Text File under explorer to create a file called .xyzzy - it won't do it (file name needed or some such). -- Mike Scott Harlow Essex England.(mike -a-t- scottsonline.org.uk) (Processing of this email by 3rd parties in relation to advertising services is forbidden.) - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: open office 3.0.0 beta
Martin Graedel schrieb: Guten Tag Mein System: Mac OS 10.4.11.Miuss die Beta-Version 3.0.0 auf meinem Mac aktualisiert werden? Wenn ja, womit? Sollte gegebenenfalls vor einem Download die Beta-Version entfernt werden? Vielen Dank für die Unterstützung. Gruss Martin Graedel-Jaddou Pfrundstrassse 28 3176 Neuenegg Tel./AB: 031 741 41 22 Hi, es wäre sinnvoll die Beta durch die finale Ausgabe zu ersetzen. Eleganter is es die Beta vorher zu deinstallieren, aber man kann einfach die alte Beta mit der neuen überschreiben bzw. drüber installieren. Ich mache das meistens so und hatte bis jetzt keine Probleme. Die stabile finale Version wird irgendwo im Downloadbereich von http://de.openoffice.org sein. Schau mal hier: http://de.openoffice.org/downloads/quick.html Und nicht vergessen JavaScript zu aktiviren, sonst kann man da nichts zu download auswählen. Gruß, Spiderman - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Questions on product
2008/11/6 James Knott [EMAIL PROTECTED] suzanne guitor wrote: To whom it may concern, I have a new laptop computer and included with it is a ``trial`` Microsoft Office software that I can open so many times before I am asked for the product key. I would like to know if I need to remove this ``trial`` software before I download your product. If I don't remove it can they interfere with one another? Thank you. No, you don't need to remove it, as you can run both on the same computer. However, unless you're planning on paying for it, you might as well remove it. Just make sure you can open your documents in OpenOffice first. You may have to save them in an older format. Hello, OpenOffice.org 3.0.0 (download from www.openoffice.org) can now read the newer docx, xlsx and pptx files, and it can save in Open Document format (odt, ods, odp) as well as in MS Office format (and many others). -- Guy using dutch OOo Aqua 3.0.0 on a iMac Intel DualCore Tiger and brazilian OOo Aqua 3.0.0 on an Intel MacBook Pro Leopard -- please reply only to users@openoffice.org -- Dodoes can't afford to have headaches
Re: [users] Saving data on a samba-share
Dieter Treichel wrote: ... I think the OP needs to get his samba config changed - that seems to me to be the real issue. I wasn't actually aware 'dot' files could be prohibited under samba - and my own OOo v3 running under XP works very happily using a samba share. ... I will try to explain my problem with the dot-Files: The server is set up to supply windows- and linux-clients. The linux-clients needs a lot of dot-files in the homes of the user. These files should not be visible using the windows-clients. For this purpose there is the Veto-file-statement in the smb.conf-file. It has never been a problem before. I would be glad to get a change in the behaviour of OOo-3. I see the problem, but you're IMO still tackling the wrong issue. I agree dot files are a pain when looking at a samba share - but they are classed as hidden files when accessed via samba (at least from XP) - so aren't visible unless explorer is showing these. For most users, showing hidden files is a bad idea anyway, so explorer should be thus set up. In which case it becomes a non-issue. -- Mike Scott Harlow Essex England.(mike -a-t- scottsonline.org.uk) (Processing of this email by 3rd parties in relation to advertising services is forbidden.) - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Saving data on a samba-share
At 13:44 06/11/2008 +, Mike Scott wrote: I beg to differ: I don't think that's at all unreasonable behaviour. Even if you open a file in OOo just to read it, it is nevertheless opened in r/w mode, and it therefore needs to be locked because the system can't read the user's mind -- it might be helpful if there were an open-read-only facility if this is an issue. So the date changes are correct. Sorry, but I think you are missing my point. o Of course I realise that the file will be opened in edit mode and will be locked and that no software can guess whether I intend to edit any file. (I may not even know!) I said nothing that could possibly have given you the idea that I thought otherwise. o You talk about the document file and say the date changes are correct. But - as I explained - there are no changes to the modification date of the document file in this case. A change that doesn't exist cannot be called correct. And it would not be correct to show any change in modification date when the file had not been modified: that much is obvious. OpenOffice 3 gets this right by *not* making any changes, of course. o My point was about the change to the modification date of the *containing folder*. There is no net change to this folder after the process, but because an understandable, possibly hidden, temporary change has taken place - indeed, as it transpires, unnecessarily - in creating and deleting the lock file, the modification date of the folder suggests that there has been a change. This is hardly likely to be helpful to users - and very probably confusing. o If any such changes were deemed correct, you would want all software to make them - and other software doesn't. In particular, you would have been complaining that earlier versions of OpenOffice did not do this (irrespective of the reason for it and your understanding of this). Lock files have to exist alongside the original if they're to be any use in a networked environment - different machines may have different ideas of the suggested common location. Hmm: yes - very likely! I rest my case. BTW 'dot' files do seem to be a general windows issue: try using R-click and New|Text File under explorer to create a file called .xyzzy - it won't do it (file name needed or some such). That's because of Windows' continuing interest in file extensions, of course: it sees .something as a file with an extension of something but no actual file name. Brian Barker - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] open office 3.0.0 beta
Martin Graedel wrote: Guten Tag Mein System: Mac OS 10.4.11.Miuss die Beta-Version 3.0.0 auf meinem Mac aktualisiert werden? Wenn ja, womit? Sollte gegebenenfalls vor einem Download die Beta-Version entfernt werden? Vielen Dank für die Unterstützung. Gruss Martin Graedel-Jaddou Pfrundstrassse 28 3176 Neuenegg Tel./AB: 031 741 41 22 Dear Martin: Diese Liste ist für englischsprachige Auskunft gedacht. Für deutschsprachige Auskunft schreibst Du am besten an [EMAIL PROTECTED]
Re: [users] Open Office 3.0
Dear Uwe: Diese Liste ist für englischsprachige Auskunft gedacht. Für deutschsprachige Auskunft schreibst Du am besten an [EMAIL PROTECTED] Uwe Jonescheit wrote: Hallo OpenOffice- Team, kann es Euch anbieten mit High Speed- download die Version 3 in German zum download mit zur Verfügung zu stellen. Viele Grüsse, Uwe Jonescheit
Re: [users] Install dictionaries in Ooo 3.0
Guy Voets escribió: Indeed, Carlos, I only find Argentinian and Mexican blends of Spanish, no Spanish from Spain... I have the Spanish word list in my OOo, but I can't find the extension of it! You can find an user created extension containing some Spanish Spanish dictionaries here: http://ricardo.berlasso.googlepages.com/ooo3 Javier. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] made her day, gave her OOo
Yesterday I met a lady visiting her parents in New York State. She has been living in Israel for the past 20 years. She loved recieving a copy of the English version of OpenOffice.org, that I carry around. She loved the fact that she could get a free Hebrew version as well. She worked in the communication and media field and I believe that she would spread the word, once she gets home and tries the English and Hebrew version of 3.0. Folks. This is why you should alwayd carry a copy of OpenOffice.org with you as you go about you life outside you home. You never know who you will meet and talk about OpenOffice.org to. The facts are, if you give someone great free software, and they like/love it, they will tell others about it, and so on, and so on. Word of mouth is how this project gets more users. Spread the word. Spread the CDs [She also loved the fact that I would not take money for the CD I gave her.]
Re: [users] Saving dta on a samba-share
I have seen several replies to this question. But none seem to address the original issue of the creation of the file itself. It has been my long understanding that file locking semantics are _NOT_ part of any data application program to start with.So any file for the purpose of file locking is totally unwarranted and undesirable. It is the responsibility of the OS that is providing the file share service to adequately protect the file from operations that could cause any form of data loss or undesirable results. My two cents worth. James On Thursday 06 November 2008, Dieter Treichel wrote: We are using staroffice 8 and openoffice 2 since 2006 on about 300 pc in my school. The users are saving their data on their personal samba-share. Now we want to change to OO-3 and have the problem, that no user is able to save data in his/her home-share. Cause is the new behaviour of open office, to create a temporary file like .lockFilename. .Filename-files are vorbidden (veto file statement in the smb.conf ) for this share. Is there any possibility to change the standard name for the temporary files (they should not begin with a dot) ? Is it possibe to change the path for the temporary files without changing the path to the working directory ? Dieter Powered by Open-Xchange.com - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Saving data on a samba-share
Brian Barker wrote: At 13:44 06/11/2008 +, Mike Scott wrote: I beg to differ: I don't think that's at all unreasonable behaviour. Even if you open a file in OOo just to read it, it is nevertheless opened in r/w mode, and it therefore needs to be locked because the system can't read the user's mind -- it might be helpful if there were an open-read-only facility if this is an issue. So the date changes are correct. Sorry, but I think you are missing my point. o Of course I realise that the file will be opened in edit mode and will be locked and that no software can guess whether I intend to edit any file. (I may not even know!) I said nothing that could possibly have given you the idea that I thought otherwise. o You talk about the document file and say the date changes are correct. But - as I explained - there are no changes to the Mmmm. That's not what I intended, apologies if I was unclear: I /meant/ my comment to refer to date changes on the directory, not the document. modification date of the document file in this case. A change that doesn't exist cannot be called correct. And it would not be correct to show any change in modification date when the file had not been modified: that much is obvious. OpenOffice 3 gets this right by *not* making any changes, of course. o My point was about the change to the modification date of the *containing folder*. There is no net change to this folder after the process, but because an understandable, possibly hidden, temporary change has taken place - indeed, as it transpires, unnecessarily - in creating and deleting the lock file, the modification date of the folder suggests that there has been a change. This is hardly likely to be helpful to users - and very probably confusing. Directories can change date for other reasons; I rather doubt anyway that most users ever bother to check them, as opposed to /document/ dates. o If any such changes were deemed correct, you would want all software to make them - and other software doesn't. In particular, you would have been complaining that earlier versions of OpenOffice did not do this (irrespective of the reason for it and your understanding of this). Only if I'd noticed :-) Lock files have to exist alongside the original if they're to be any use in a networked environment - different machines may have different ideas of the suggested common location. Hmm: yes - very likely! I rest my case. BTW 'dot' files do seem to be a general windows issue: try using R-click and New|Text File under explorer to create a file called .xyzzy - it won't do it (file name needed or some such). That's because of Windows' continuing interest in file extensions, of course: it sees .something as a file with an extension of something but no actual file name. One could argue forever over the rights and wrongs of that. I dislike XP's approach - because for one thing I can't create a new (unix) dot file on the samba share - although, inconsistently, XP will let me open an existing one. There's a sure cure though, not so far off now :-) -- Mike Scott Harlow Essex England.(mike -a-t- scottsonline.org.uk) (Processing of this email by 3rd parties in relation to advertising services is forbidden.) - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Quickstarter in OOo 3.0.0
Is there a way to stop Quickstarter from loading itself into the system tray everytime I open swriter? I Primarily use swriter and do not like any quickstarters running in the background using resources unnecessarily. I have looked for the way to do this but have, obviously, been unsuccessful. -- Gene Young [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] regarding open office
2008/11/6 André Lövgren [EMAIL PROTECTED] Hello Do you know if there is any posibility, when installing a laptop and disc 1 is ready the machines asks for do you have an aplikation disc -put it in now or just restart. If we can get an open office application disc we will install all units with open office. But we can not enter and register the laptops and thats why we need an special aplication disc that will be installed during the re-installation of the vista. Do you understand hehe? Hard to explain. We distribute 2000 laptops a year in Sweden Best regards André 2008/11/6 Guy Voets [EMAIL PROTECTED] 2008/11/5 André Lövgren [EMAIL PROTECTED] Hello I would like to distribute open office on burned discs. Is this possible or illegal? I sell laptops and would like to deliver them with openoffice for free. OK? or not? Best regards Hello André, It's perfectly legal and even encouraged to distribute OpenOffice.org, either on CD or already installed on computers. Read the licence info here: http://www.openoffice.org/license.html -- Guy Hello again, Please reply _only_ to users@openoffice.org As James pointed out, you can get the ISO files directly from the www.openoffice.org website. If you install these on a cd, and have cd1 ask for this cd, I think it will be OK. You don't need to register OOo, so why not install it already on the laptop? -- Guy using dutch OOo Aqua 3.0.0 on a iMac Intel DualCore Tiger and brazilian OOo Aqua 3.0.0 on an Intel MacBook Pro Leopard -- please reply only to users@openoffice.org -- Dodoes can't afford to have headaches
Re: [users] Quickstarter in OOo 3.0.0
Gene Young wrote: Is there a way to stop Quickstarter from loading itself into the system tray everytime I open swriter? I Primarily use swriter and do not like any quickstarters running in the background using resources unnecessarily. I have looked for the way to do this but have, obviously, been unsuccessful. Never mind. I finally found it by accident. When I unchecked load at startup it stopped loading on opening swriter. Thanks anyway. -- Gene Young [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Quickstarter in OOo 3.0.0
Gene, Have a look under Extra/Options/Memory. You'll see a tickbox to activate the quickstarter. Untick it and it won't start anymore. Arnold Huzen Gene Young schreef: Is there a way to stop Quickstarter from loading itself into the system tray everytime I open swriter? I Primarily use swriter and do not like any quickstarters running in the background using resources unnecessarily. I have looked for the way to do this but have, obviously, been unsuccessful. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Install dictionaries in Ooo 3.0
Hi, On Thu, Nov 6, 2008 at 15:59, Javier Rivera wrote: [...] You can find an user created extension containing some Spanish Spanish dictionaries here: http://ricardo.berlasso.googlepages.com/ooo3 Javier. Great - Diccionario español, sinónimos y silábico dict-es_ES.oxt is working fine ... :-) ¡muchas gracias! - Manfred -- LanguageTool 0.9.5 by dnaber http://extensions.services.openoffice.org/node/155/release
[users] Multiple libraries with OOo Base AS 400 ?
Hi, I'm using OpenOffice Base to connect to our AS400 server through JDBC. It works fine, but there's only one problem : We have three libraries (databases) and in the connection string, I have to specify one of them. Current library is displayed and I can access the other two using some text requests. What I would like, is to have all three databases shown in Base GUI, to be able to select tables from any of the libraries using the common interface. So basically, I'm using three separate OOBase files to show each library structure. Is it possible to have all libraries displayed ? I thought of specifying my three libraries in the connection string, but I don't know if it's possible and what the syntax is. Anyone an idea ? Thx B. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Saving dta on a samba-share
James Finnall wrote: I have seen several replies to this question. But none seem to address the original issue of the creation of the file itself. It has been my long understanding that file locking semantics are _NOT_ part of any data application program to start with.So any file for the purpose of file locking is totally unwarranted and undesirable. It is the responsibility of the OS that is providing the file share service to adequately protect the file from operations that could cause any form of data loss or undesirable results. A nice idea. But given the way it's been done, I suspect the developers had networked machines in mind. I'm pretty sure there's no locking mechanism that will work across windows, mac, and assorted flavours of un*x on a network - other than a crude lockfile. It would probably have been better though if the file had been named something different. My two cents worth. James -- Mike Scott Harlow Essex England.(mike -a-t- scottsonline.org.uk) (Processing of this email by 3rd parties in relation to advertising services is forbidden.) - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Saving dta on a samba-share
James Finnall wrote: I have seen several replies to this question. But none seem to address the original issue of the creation of the file itself. It has been my long understanding that file locking semantics are _NOT_ part of any data application program to start with.So any file for the purpose of file locking is totally unwarranted and undesirable. It is the responsibility of the OS that is providing the file share service to adequately protect the file from operations that could cause any form of data loss or undesirable results. My two cents worth. James On Thursday 06 November 2008, Dieter Treichel wrote: We are using staroffice 8 and openoffice 2 since 2006 on about 300 pc in my school. The users are saving their data on their personal samba-share. Now we want to change to OO-3 and have the problem, that no user is able to save data in his/her home-share. Cause is the new behaviour of open office, to create a temporary file like .lockFilename. .Filename-files are vorbidden (veto file statement in the smb.conf ) for this share. Is there any possibility to change the standard name for the temporary files (they should not begin with a dot) ? Is it possibe to change the path for the temporary files without changing the path to the working directory ? There are two issues here. The OS should be doing locking controls but that can be problematic when there are applications that allow concurrent editting. If the OS does all locking then the applications may not work. Application locking allows finer control of file access. If the file is opened read-only then there is no need for a lock file. Now is there an option that can be set to enable/disable this feature. Yes I call it a feature when using shared document folders to protect the documents. I thought I read about a setting for locking files but I could be confused with a different application. -- Robin Laing - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Problems with Vertical (Portrait) screen orientation
OpenOffice 3.x is a very interesting product --- which I cannot use. I prefer to use a vertical, or portrait, screen orientation. OpenOffice does not display properly on such a screen - the WP documents are stretched vertically and compressed horizontally - the latter to the extent that typed in letters overlap. Other OO function displays are similarly distorted. All my other software handles the vertical screen with aplomb -- including NeoOffice. I have gone through everything in the Help and Preferences screens and found no solutions. Are there any cures or do I go back to NeoOffice and Pages? Thanks, Al Revzin - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Problems with Vertical (Portrait) screen orientation
At 10:39 06/11/2008 -0700, Alvin Revzin wrote: OpenOffice 3.x is a very interesting product --- which I cannot use. I prefer to use a vertical, or portrait, screen orientation. OpenOffice does not display properly on such a screen - the WP documents are stretched vertically and compressed horizontally - the latter to the extent that typed in letters overlap. Other OO function displays are similarly distorted. All my other software handles the vertical screen with aplomb -- including NeoOffice. I have gone through everything in the Help and Preferences screens and found no solutions. Are there any cures or do I go back to NeoOffice and Pages? You appear to be using a Mac. There are existing reports of similar issues: http://www.openoffice.org/issues/show_bug.cgi?id=89320 http://www.openoffice.org/issues/show_bug.cgi?id=94377 You may wish to vote for or to add detail to these. I trust this helps. Brian Barker - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] made her day, gave her OOo
web at work wrote: Yesterday I met a lady visiting her parents in New York State. She has been living in Israel for the past 20 years. She loved recieving a copy of the English version of OpenOffice.org, that I carry around. She loved the fact that she could get a free Hebrew version as well. She worked in the communication and media field and I believe that she would spread the word, once she gets home and tries the English and Hebrew version of 3.0. Folks. This is why you should alwayd carry a copy of OpenOffice.org with you as you go about you life outside you home. You never know who you will meet and talk about OpenOffice.org to. The facts are, if you give someone great free software, and they like/love it, they will tell others about it, and so on, and so on. Word of mouth is how this project gets more users. Spread the word. Spread the CDs [She also loved the fact that I would not take money for the CD I gave her.] I carry a copy of OpenOffice, along with a few other apps, on a pen drive that I always carry in my pocket. I also carry a pen drive with the portable apps version installed on it. -- Use OpenOffice.org http://www.openoffice.org - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Quickstarter in OOo 3.0.0
Gene Young wrote: Is there a way to stop Quickstarter from loading itself into the system tray everytime I open swriter? I Primarily use swriter and do not like any quickstarters running in the background using resources unnecessarily. I have looked for the way to do this but have, obviously, been unsuccessful. Click on Tools Options. Select OpenOffice.org Memory and then turn off the quickstarter. -- Use OpenOffice.org http://www.openoffice.org - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Install dictionaries in Ooo 3.0
Guy Voets wrote: 2008/11/6 Carlos Martinez [EMAIL PROTECTED] Hi, ANDIS I have visited the link for extensions.services...etc and I didn´t fine a Spanish dictionary with thesuarus and synonims att all. Do you know where I can fine them? Many thanks Carlos. Indeed, Carlos, I only find Argentinian and Mexican blends of Spanish, no Spanish from Spain... I have the Spanish word list in my OOo, but I can't find the extension of it! I have the US English version of OO.o 3.0. It came with a Spanish dictionary. Also with French as well as US, GB and ZA versions of English dictionaries. -- 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Updating ranges after inserting line
Hi, people! I have a spreadsheet with a list of values, let's say, at the interval B2:B8. At B9, I have the formula =SUM(B2:B8). If I insert a new row between B8 and B9, the formula at the now B10 cell is not updated. Is there a simple way to make this formula automatically update itself? I'm leaving a blank row between the last value and the sum cell; I believe I could do some black magic with info functions and such; also, I know I could use macros, but I'm looking for something easier, since I'm going to teach it. Thanks in advance! -- Adam Victor Nazareth Brandizzi http://brandizzi.googlepages.com/ - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Updating ranges after inserting line
I usually keep an empty row or column between the data and the cell containing the formula if I expect that I wil insert rows or columns in the future. In the formula I include the empty cell. If I then need to insert a new cell in the range it will also extend the formula. In your example I would have the data in B2:B8, leave B9 blank and put the formula =SUM(B2:B9) in B10. As you do this you must keep in mind what the formula does that you use. In the above example it works just fine, because an empty cell makes no difference to the result. But in other functions that might be different. Arnold Huzen Adam Victor Nazareth Brandizzi schreef: Hi, people! I have a spreadsheet with a list of values, let's say, at the interval B2:B8. At B9, I have the formula =SUM(B2:B8). If I insert a new row between B8 and B9, the formula at the now B10 cell is not updated. Is there a simple way to make this formula automatically update itself? I'm leaving a blank row between the last value and the sum cell; I believe I could do some black magic with info functions and such; also, I know I could use macros, but I'm looking for something easier, since I'm going to teach it. Thanks in advance! - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: [users] Updating ranges after inserting line
Hi Adam, If you add the row between b7 and b8, then the formula will update the range. If you plan to add rows, set up the sum with an empty row at the bottom and include it in the sum range. Adding rows above the empty row will cause the formula range to change. tc Date: Thu, 6 Nov 2008 18:12:53 -0200 From: [EMAIL PROTECTED] To: users@openoffice.org Subject: [users] Updating ranges after inserting line Hi, people! I have a spreadsheet with a list of values, let's say, at the interval B2:B8. At B9, I have the formula =SUM(B2:B8). If I insert a new row between B8 and B9, the formula at the now B10 cell is not updated. Is there a simple way to make this formula automatically update itself? I'm leaving a blank row between the last value and the sum cell; I believe I could do some black magic with info functions and such; also, I know I could use macros, but I'm looking for something easier, since I'm going to teach it. Thanks in advance! -- Adam Victor Nazareth Brandizzi http://brandizzi.googlepages.com/ - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] _
[users] Re: What is open office?
Phyllis Myers wrote: I do not remember joining open office. How did this come about? I am clearing icons off of my desktop and open office was one of them. Can you be of help? Thank You, Phyllis M You do not appear to be subscribed to this mail list, so I'm not sure what you joined. OpenOffice is an office suite, comparable to and compatible with Microsoft Office. It includes word processor and spreadsheet components, among others. If it is of no use to you, you can uninstall it in the same manner as you would uninstall any other application. In Windows, there's an Add/Remove software utility in the Control Panel. You'd use that to uninstall it. IF it's installed. Since it's on the desktop, it might only the long forgotten install files. Control Panel's Add or Remove Programs should show it as Open Office if it was installed. If it is not there then it likely was never installed. Check Start; Programs - if it's not there either, it's pretty surely not installed, in which case all that needs to be done is to delete those files on the desktop. Right James/Guy? Or did I miss something? Just thought I'd add my 2 ¢ because I recently came across an almost identical question from a neighbor; it was downloaded but never installed and then forgotten for awhile. Regrards. Twayne - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Updating ranges after inserting line
I handle this problem by filling the empty row with dashes or equal signs to remind me that the row is a non-data row. Then I name the range from the head of the column to the dashed line based on the type of data in the column (e.g., Miles) and then make the formula in the sum line =SUM(Miles). When I need to add a new row of data, I just add the row above the dashed line and the named range automatically updates itself. I hope this helps. On Thu, Nov 6, 2008 at 3:12 PM, Adam Victor Nazareth Brandizzi [EMAIL PROTECTED] wrote: Hi, people! I have a spreadsheet with a list of values, let's say, at the interval B2:B8. At B9, I have the formula =SUM(B2:B8). If I insert a new row between B8 and B9, the formula at the now B10 cell is not updated. Is there a simple way to make this formula automatically update itself? I'm leaving a blank row between the last value and the sum cell; I believe I could do some black magic with info functions and such; also, I know I could use macros, but I'm looking for something easier, since I'm going to teach it. Thanks in advance! -- Adam Victor Nazareth Brandizzi http://brandizzi.googlepages.com/ - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Updating ranges after inserting line
Thanks all for the responses! On Thu, Nov 6, 2008 at 6:41 PM, Arnold Huzen [EMAIL PROTECTED] wrote: I usually keep an empty row or column between the data and the cell containing the formula if I expect that I wil insert rows or columns in the future. In the formula I include the empty cell. If I then need to insert a new cell in the range it will also extend the formula. In your example I would have the data in B2:B8, leave B9 blank and put the formula =SUM(B2:B9) in B10. As you do this you must keep in mind what the formula does that you use. In the above example it works just fine, because an empty cell makes no difference to the result. But in other functions that might be different. Yes, I do it, too. The great problem is exatly other functions, like MEAN(). I'd like to do not need to do it. Well, if there is no such thing, I'll have to deal with the workaround :) Again, thanks you all! Arnold Huzen Adam Victor Nazareth Brandizzi schreef: Hi, people! I have a spreadsheet with a list of values, let's say, at the interval B2:B8. At B9, I have the formula =SUM(B2:B8). If I insert a new row between B8 and B9, the formula at the now B10 cell is not updated. Is there a simple way to make this formula automatically update itself? I'm leaving a blank row between the last value and the sum cell; I believe I could do some black magic with info functions and such; also, I know I could use macros, but I'm looking for something easier, since I'm going to teach it. Thanks in advance! - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] -- Adam Victor Nazareth Brandizzi http://brandizzi.googlepages.com/ - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Updating ranges after inserting line
Thanks all for the responses! On Thu, Nov 6, 2008 at 8:43 PM, John Mary Linge [EMAIL PROTECTED] wrote: I handle this problem by filling the empty row with dashes or equal signs to remind me that the row is a non-data row. Then I name the range from the head of the column to the dashed line based on the type of data in the column (e.g., Miles) and then make the formula in the sum line =SUM(Miles). When I need to add a new row of data, I just add the row above the dashed line and the named range automatically updates itself. I hope this helps. Yes, I actually On Thu, Nov 6, 2008 at 3:12 PM, Adam Victor Nazareth Brandizzi [EMAIL PROTECTED] wrote: Hi, people! I have a spreadsheet with a list of values, let's say, at the interval B2:B8. At B9, I have the formula =SUM(B2:B8). If I insert a new row between B8 and B9, the formula at the now B10 cell is not updated. Is there a simple way to make this formula automatically update itself? I'm leaving a blank row between the last value and the sum cell; I believe I could do some black magic with info functions and such; also, I know I could use macros, but I'm looking for something easier, since I'm going to teach it. Thanks in advance! -- Adam Victor Nazareth Brandizzi http://brandizzi.googlepages.com/ - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] -- Adam Victor Nazareth Brandizzi http://brandizzi.googlepages.com/ - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: regarding open office
On 11/06/2008 04:34 AM, James Knott wrote: André Lövgren wrote: Hello I would like to distribute open office on burned discs. Is this possible or illegal? I sell laptops and would like to deliver them with openoffice for free. OK? or not? Best regards Yes, you can do that. You can find the ISO files here: http://distribution.openoffice.org/cdrom/iso_downoad.html Please consider before you promote that link this example: http://openoffice.cs.utah.edu/extended/iso/en/ This is typical of _all_ the iso's: they are 2.4.0 and are out of date. It will be a complete waste of time for André Lövgren to download and distribute those iso's. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] regarding open office
James Knott wrote: André Lövgren wrote: Hello I would like to distribute open office on burned discs. Is this possible or illegal? I sell laptops and would like to deliver them with openoffice for free. OK? or not? Best regards Yes, you can do that. You can find the ISO files here: http://distribution.openoffice.org/cdrom/iso_downoad.html Upon checking that link, it appears those ISOs are out of date. I guess you'll just have to download the install package from www.openoffice.org. -- Use OpenOffice.org http://www.openoffice.org - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Two different OOorg versions on same Linux machine
On 11/05/2008 11:23 PM, john d. herron wrote: Thanks to Drew and NoOp for responding. Using NoOp's instructions I installed OOo_3 from OOo_3.0.0_LinuxIntel_install_en-US_deb.tar.gz. As predicted, now there's stuff in /opt/openoffice.org3/ and in /home/xxx/.openoffice.org/3/user (where I apparently find my OOo_2.2 macros and templates). I create the launcher entry as instructed in the installer webpage, then close the menu editor. When I click on the OOo_3.0 menu entry I get a registration wizard. I fill out the dialogs and when I click 'Finish' the wizard closes and a splash form appears for two seconds, then disappears. Nothing else happens. What am I doing wrong? (By the way: OOo_2.2 still works as it did before). Any suggestions? john herron _ **kubuntu 7.04 on Intel P4 w/ 512 MB Ram** What happens if you do this from a terminal? /opt/openoffice.org3/program/soffice ? - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Saving dta on a samba-share
On 11/06/2008 03:08 AM, Dieter Treichel wrote: We are using staroffice 8 and openoffice 2 since 2006 on about 300 pc in my school. The users are saving their data on their personal samba-share. Now we want to change to OO-3 and have the problem, that no user is able to save data in his/her home-share. Cause is the new behaviour of open office, to create a temporary file like .lockFilename. .Filename-files are vorbidden (veto file statement in the smb.conf ) for this share. Is there any possibility to change the standard name for the temporary files (they should not begin with a dot) ? Is it possibe to change the path for the temporary files without changing the path to the working directory ? OOo 3.0 made some significant changes to how file locking is implemented - see: http://www.openoffice.org/issues/show_bug.cgi?id=91015 [data loss using concurently OOo3 and another editor in the same network] http://www.openoffice.org/issues/show_bug.cgi?id=95528 [Let OOo use lock file mechanics for alien formats as well.] http://www.openoffice.org/issues/show_bug.cgi?id=95530 [Notify on closing/saving if the file was changed by other application.] There is considerable discussion regarding this on the release and development lists 3.0.1 is supposed to address _some_ of the issues. You may want to read those bug/issue reports participate in testing/commenting. In the interim, I'd recommend that you stay with 2.4.2 for the time being until the issue(s) is resolved. Also, note that StarOffice 9 (yet to be fully released) may have the same issues. However, generally Sun/SO tend to use OOo as a testing ground (hence the delay in releasing SO9), so perhaps they will have addressed the problem by the time they release. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Re: Two different OOorg versions on same Linux machine
NoOp wrote: On 11/05/2008 11:23 PM, john d. herron wrote: Thanks to Drew and NoOp for responding. Using NoOp's instructions I installed OOo_3 from OOo_3.0.0_LinuxIntel_install_en-US_deb.tar.gz. As predicted, now there's stuff in /opt/openoffice.org3/ and in /home/xxx/.openoffice.org/3/user (where I apparently find my OOo_2.2 macros and templates). I create the launcher entry as instructed in the installer webpage, then close the menu editor. When I click on the OOo_3.0 menu entry I get a registration wizard. I fill out the dialogs and when I click 'Finish' the wizard closes and a splash form appears for two seconds, then disappears. Nothing else happens. What am I doing wrong? (By the way: OOo_2.2 still works as it did before). Any suggestions? john herron What happens if you do this from a terminal? /opt/openoffice.org3/program/soffice? Here's the output from terminal: ~$ /opt/openoffice.org3/program/soffice X Error: BadDevice, invalid or uninitialized input device 169 Major opcode: 145 Minor opcode: 3 Resource id: 0x0 Failed to open device X Error: BadDevice, invalid or uninitialized input device 169 Major opcode: 145 Minor opcode: 3 Resource id: 0x0 Failed to open device [Java framework]sunjavaplugin.so could not load Java runtime library: file:///usr/lib/../lib/gcj-4.1/libjvm.so. ~$
[users] Impress: Sequential numbers when slides hidden
Hi, Does anyone know if it's possible to have slide page numbers be kept in sequence when slides are hidden. When I do that, I get slide numbers like 1-2-3-5-6-9. Looks kinda weird L -- Get free public speaking and communication tips by registering at http://www.duperval.com Bring out the speaker in you! - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]