Re: [users] OpenOffice 3.2 upgrade
Reinstalling is the only way, however you will not lost your profile information after reinstalling. I guess update function will also call for reinstalling. So, it's generally the same. Andis Klark Ooi wrote: OO RC3 is out. Any idea how to upgrade from RC1? I tried the help > check for updates...failed. Any idea and do not need to re-install? thanks. Warmest regards, Klark -Original Message- From: Klark Ooi Reply-to: users@openoffice.org To: users@openoffice.org Subject: Re: [users] OpenOffice 3.2 Date: Tue, 19 Jan 2010 17:38:24 +0800 Any idea why this version takes so much memory? I have an instance consuming 1GB memory with less than 3MB file opened. Warmest regards, Klark -Original Message- From: Klark Ooi Reply-to: users@openoffice.org To: users@openoffice.org Subject: [users] OpenOffice 3.2 Date: Sun, 17 Jan 2010 16:45:43 +0800 Hi, Just wish to share my experience so far on this version. Very stable, hardly crash in Fedora 12. but the performance is not very good, quite slow. Warmest regards, Klark - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Export data from chart data table (sorry for double posting)
Hello everybody! How can I copy/extract/export whole chart data table from openoffice.org writer document. I would be happy for any solution, because I don't see any way to do it except to copy/paste all records one by one, which is useless with large charts. I think there was discussion about this topic some years ago, but I can't find it. Regards, Andis - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Export data from chart data table
Sorry for repeated post. Hello everybody! How can I copy/extract/export whole chart data table from openoffice.org writer document. I would be happy for any solution, because I don't see any way to do it except to copy/paste all records one by one, which is useless with large charts. I think there was discussion about this topic some years ago, but I can't find it. Regards, Andis -- LVMI "SILAVA" Riga street 111 Salaspils, LV-2169 Phone: +37126595586 Fax: +37167901359 E-mail: andis.lazd...@silava.lv - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Export data from chart data table
Hello everybody! How can I copy/extract/export whole chart data table from openoffice.org writer document. I would be happy for any solution, because I don't see any way to do it except to copy/paste all records one by one, which is useless with large charts. I think there was discussion about this topic some years ago, but I can't find it. Regards, Andis - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Multiple replace 'comma' to 'dot' as decimal separator in text documents
Thank you a lot!!! You saved tens of my working hours. Best regards Andis Brian Barker wrote: At 13:20 07/02/2009 +0200, Andis Noname wrote: In Latvian we are using 'comma' as standard decimal separator, but when I have to prepare scientific publication, even in local language, I usually have to change 'comma' to 'dot' in numbers and it's quite time consuming operation. At 15:43 07/02/2009 +0200, Andis Noname wrote: I spent some time with regular expressions, but it seems I'm too stupid for that. I doubt you are stupid, but it may be that you happen not to know how to solve this problem. Do you have any suggestions, what I have to write in field 'Replace with'. In the field 'Search for' I can write something like [0123456789],[0123456789]. That's close. Try searching for ([0-9]),([0-9]) and replacing with $1.$2 The [0-9] string represents a digit, but yes: you could use your [0123456789] or [:digit:] instead. The two sets of (round) parentheses define those substrings as references. This is so that you can refer to each numeric part in the "Replace with" string as $1 and $2. Note that this search will not find any numbers that start with the fractional separator and do not have a leading zero - but you may have been careful not to include any of those. I trust this helps. Brian Barker - 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
Re: [users] Multiple replace 'comma' to 'dot' as decimal separator in text documents
Thank you for response! I spent some time with regular expressions, but it seems I'm too stupid for that. Do you have any suggestions, what I have to write in field 'Replace with'. In the field 'Search for' I can write something like [0123456789],[0123456789]. Andis Mike Dawe wrote: Andis wrote: In Latvian we are using 'comma' as standard decimal separator, but when I have to prepare scientific publication, even in local language, I usually have to change 'comma' to 'dot' in numbers and it's quite time consuming operation. Some 10 years ago I wrote visual basic macro to do mass change of 'comma' to 'dot' and vice versa in Word, but unfortunately I lost it. Is there any easy way to do this operation in Writer, using macros or Find and replace function? Hello. For me (OOo 3.0.1 PPC), it is under "Edit" menu, "Find & Replace..." sub-menu. In the Find & Replace dialog, there is also an "options" button giving you more choices, such as regular expressions, etc. HTH.
[users] Multiple replace 'comma' to 'dot' as decimal separator in text documents
Hello! In Latvian we are using 'comma' as standard decimal separator, but when I have to prepare scientific publication, even in local language, I usually have to change 'comma' to 'dot' in numbers and it's quite time consuming operation. Some 10 years ago I wrote visual basic macro to do mass change of 'comma' to 'dot' and vice versa in Word, but unfortunately I lost it. Is there any easy way to do this operation in Writer, using macros or Find and replace function? Greetings, Andis - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] open office 3.0 and partitions
Hello! Are you using openoffice.org open/save dialogues? I would recommend to uncheck this option and to use gnome dialogues if you are in Ubuntu. There should not be problems to reach partitions which are mounted under grome, except strange problem, that openoffice.org doesn't open files from gnome mounted samba shares with one of the last kernel updates. But it seems, that this problem is also gone now with the latest updates. Andis Fehmi YAZICI wrote: I have downloaded openoffice 3.01 and installed with the desktop-integration. When I go to "open" or "save as" I can see only Ubuntu partition. I have to go to other partitions via "/mnt" or" media". With open office 2.4, we were able to directly see the other partitions when we go to "open" or "save as" functions. is there any solution for this problem or do we have to wait Ubuntu Jaunty? System: Ubuntu 8.10, Kernel linux: 2.6.27-11, GNOME: 2.24.1 Tahnks F. YAZICI - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Re: How to change the date/time format to 2006/07/09 23:55:55
Hi! When necessary cells selected press Format -> Cells... -> Numbers, then select Date (or anything else) and in 'Format code' write something like /MM/DD and press green button (in my case) to add. It will now be available in User-defined number formats. Similar approach should be used in case of time, but the 'Format code' is HH:MM:SS. By the way, this is already available in the list of default number formats under Time. Andis S P Arif Sahari Wibowo wrote: Hi! On Sun, 9 Jul 2006, S P Arif Sahari Wibowo wrote: I need to change the default date format to 2006/07/09 and the time format to 24 hour 23:55:55. Well, after more thank 2 years, what is current state of OpenOffice.org ability in doing the date / time default format setup as above? Thanks! - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] How to let writer remember separator when inserting caption of an illustration
Thank you for this topic! It was very useful for me. I just realised, that it is possible now to chose number or category comes first in captions (Table 1 or 1. (first) Table) through this dialogue. I don't know, when it was implemented, but now I can enter captions in proper Latvian language :) This is long waited feature and makes openoffice.org writer much better than ms word (at least earlier versions) for Latvian users. Sincerely, Andis or Writer: Tools -> Options -> OpenOffice.org Writer -> AutoCaption -> [X] OpenOffice.org Writer Picture -> Separator Now change ":" ... Manfred
Re: [users] Re: What the [deleted] is wrong with autosave on ver3
Hi! The broken auto recovery function is the worst thing with openoffice.org 3 version. In a company where small unit is testing openoffice.org, like in my case, it is very strong argument against broader use of the program. I made a small instruction, how to avoid data losses at least temporarily. The main point is not to allow auto-recovery process, but to copy the last version of document from temporary folder somewhere else and to rename it to writer or whatever document, otherwise it will be deleted during recovery. This will be the last auto-recovery version. Auto-recovery file can be taken a bit later also from backup folder, if the problem is crash of program, not a hardware failure. Sincerely, Andis Rob Clement wrote: Larry Gusaas wrote: Rob Clement wrote: I did. He had a power failure. He lost data because AutoRecovery in OO.o 3 is broken. The problem in OO.o 3.0 was caused by a regression. It has been located and fixed and will be in the next release. We should all be thankful that this problem has been reported so we can remember to manually save very frequently since we now know that AutoRecovery does not work. Now why don't you quit sounding like the defence lawyer for a rapist who is constantly trying to blame the victim. Larry Which is quicker - to fix a local problem with power to your pc or to fix OOo? That is my point - speed of response. Rob - 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] How to copy content of tables from calc to writer?
Thank you! I voted for that. It sounds promising, if this feature will be implemented in 3.1 Andis Kirill Palagin wrote: Not really an answer to your problem, but please vote for this http://www.openoffice.org/issues/show_bug.cgi?id=24500 enhancement so that it gets implemented faster. You need to register before you can cast your votes. Regards, K - 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] How to copy content of tables from calc to writer?
Good morning! I should have thought that any such problems were small compared with the ones that this technique solves. You may just need to be systematic about where you keep your documents. We are backing up files to another location, when the project is over. As an engineering company we are used to Autocad and to ability to store all linked files in one directory without taking care about movement of the whole project directory. But, of course, it's small problem. This is odd. Your original problem was that the source formatting *was* carried over, replacing any formatting in the target document - which you didn't want to happen. Now you say that the problem is that it isn't! And I don't understand you remark about m³ anyway. If you created the superscript 3 using character formatting in the spreadsheet, I could understand it being carried over into your text report document as a plain 3, which wouldn't do. But if you use the superscript 3 special character - as you have indeed done in your e-mail message! - then there is no way that it can fail to transfer properly into your report, is there? If there are any problems, they must be with the particular fonts you are using, I suspect. I certainly see none. Unfortunately, here I couldn't find any solution. I'm not writing originally in English and we have some funny letters in our language (like ā, ī, š, ž). All of then disappears or are displayed wrong in DDE links, as well as special characters and thousand separators in numbers. For instance instead of 'Kopā aizņēmumi' DDE link displays 'KopÄ aizņēmumi' and insted of m³ I have mij. It happens with no respect to fonts in source or recipient file and this persists since first versions of writer. If there are solution, please, let me know. (I have ubuntu 8.04 and openoffice.org 3.0, but on windows there were the same problems with DDE links some time ago.) Sincerely, Andis - 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] Another question about tables in writer and paste function
Hi! Really funny, but when I opened the file I send to the list, copy - > paste was ok. So, we can forget about this example. But it really happens very often. I suppose if you see nothing happen, then the most likely explanation is with the copy operation having failed rather than with any problem with the paste. What happens if you instead paste into an open area of the document - not in a table, that is? Does that confirm that the copy was successful? I tried different options. I could paste outside table and I could paste inside table, if I delete one or another column before. For some reason I could paste also in the first column of the table with merged cells, but not in second or third column. Tables originally comes from calc using paste special ... as rtf. You may want to say what version of OpenOffice you are using - and what platform. (I think you may be working on a Mac.) Ubuntu 8.04 Openoffice.org 3.0, but this happened a few years ago on windows xp as well. Sincerely, Andis - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] How to copy content of tables from calc to writer?
Thank you for the message! I tried this approach some time ago. There were several problems with DDE links. First of all links are stored as absolute paths, so I can't move source file or I have to edit path every time. It could be nice if writer would look for linked files in the directory, where the text file is located, if it can't found linked file according to the absolute path (this is implemented in autocad). Another problem is that DDE links doesn't recognize source formatting and special characters are displayed in wrong way. If I have m³ in every table, it's useless if I can't keep them. But, in general, I testing if those DDE links are working in good way with every new ooo version, it's promising function :) Sincerely, Andis Brian Barker wrote: At 19:31 02/11/2008 +0200, Andis Noname wrote: I have water supply feasibility study model in calc with about 40 reporting tables, which I have to copy to writer document, which is actually feasibility study report. At the moment the only reasonable way for me is to copy -> paste table by table from calc to writer template with paste special -> rtf or html and to apply text and table formatting elements to every table separately. It is very time consuming. Is there any way to copy content of cells in calc to existing tables in writer, like in ms excel -> word, keeping formatting elements of the writer tables? No: I cannot see any easy way to do what you ask. But I can tell you how to achieve what you need. Instead of creating tables in your text document, simply copy the relevant areas from your spreadsheet and then use Edit | Paste Special... (or Ctrl+Shift+V) in Writer, selecting "DDE link" from the available options. This will create the required tables for you. Format the resulting tables in the text document only when you have done this. Now, when you modify the spreadsheet, your report will update appropriately, keeping the formatting that you have applied in the report. If you have both documents open and the report happens not to update, you can force it to by going to Tools | Update> | Links. Creating reports from spreadsheets in this way is exactly what linking documents is useful for. If you wish to preserve a version of the report before you make further changes to the spreadsheet, save a copy of the report and then go to Edit | Links... and click Break Link for each relevant link *in that saved copy*. This preserves the current values but breaks the connection to the spreadsheet. I trust this helps. Brian Barker - 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] Another question about tables in writer and paste function
Hi! It's rather common problem, that I can't copy -> paste content from one writer table to another, like in example in attachment. When I copy all cells from the first table and push paste button, for instance, in the second row (next one after heading row) of third column, nothing happens. What can be a reason for that and is there any easy way to solve this? Sincerely, Andis noname.odt Description: application/vnd.oasis.opendocument.text - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] How to copy content of tables from calc to writer?
Hello! I have water supply feasibility study model in calc with about 40 reporting tables, which I have to copy to writer document, which is actually feasibility study report. At the moment the only reasonable way for me is to copy -> paste table by table from calc to writer template with paste special -> rtf or html and to apply text and table formatting elements to every table separately. It is very time consuming. Is there any way to copy content of cells in calc to existing tables in writer, like in ms excel -> word, keeping formatting elements of the writer tables? Sincerely, Andis - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Problems with bullets in indented text styles in openoffice.org 3.0 writer
Thank you lot! Both workarounds are working and can be easily implemented in text style. Sincerely, Andis Brian Barker wrote: At 07:46 20/10/2008 +0300, Andis Noname wrote: I used to have indented text styles (for example all 'Text body' has 2 cm from the left border). Earlier (in 2.x versions) there was no problems, when I inserted bullets in those indented styles, but in 3.0 version outlined text is not aligned from the left, but disordered (first line has larger indent than further lines) and some changes happens in paragraph styles. There are no problems with text styles, which aren't indented initially. I attached and example, but I don't know will it go through. At the moment I solve this by coping outlined text from older documents created with 2.x and applying styles from the old fashion outlined text to the new one, but I hope that it can be solved somehow directly in 3.0 writer documents. Has anybody solution for that? I can see the problem. Your header line has the margin at 2 cm in from the text boundary, as you would expect. But in the bulleted paragraphs, the margins are left behind at the positions that you would expect without this indent. (You you can see this from the positions of the triangular markers in the horizontal ruler.) The first line of each bulleted item is allowed to land on a default tab stop instead of at a defined position. Subsequent lines work correctly. I can see solutions - or are they workarounds? o Go to right-click | Edit Paragraph Style... . o In your modified "Text body" paragraph style, as well as setting the 2-cm indent, go to the Tabs tab and set a Left tab at 2 cm. Alternatively, o Go to Format | Bullets and Numbering... | Position (or right-click | Numbering/Bullets... | Position. o Increase the value for "Numbering followed by at" from 1.27cm to 3.27cm - to account for your extra 2-cm indent. I'll leave others to explain (1) if there are better ways of doing this, and (2) whether this is a bug or a feature! I trust this helps. Brian Barker - 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] Problems with bullets in indented text styles in openoffice.org 3.0 writer
Hello! I used to have indented text styles (for example all 'Text body' has 2 cm from the left border). Earlier (in 2.x versions) there was no problems, when I inserted bullets in those indented styles, but in 3.0 version outlined text is not aligned from the left, but disordered (first line has larger indent than further lines) and some changes happens in paragraph styles. There are no problems with text styles, which aren't indented initially. I attached and example, but I don't know will it go through. At the moment I solve this by coping outlined text from older documents created with 2.x and applying styles from the old fashion outlined text to the new one, but I hope that it can be solved somehow directly in 3.0 writer documents. Has anybody solution for that? Sincerely, Andis bulleting.odt Description: application/vnd.oasis.opendocument.text - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
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]
[users] Removing of residual Excel cell styles
Hello! I have lot of Excel spreadsheets with tens of automatically generated cell styles, which are automatically exported to Calc. Is there easy option to remove unnecessary cell styles generated by Excel program at once or at least no one by one. Sincerely, Andis -- LVMI "SILAVA" Riga street 111 Salaspils, LV-2169 Phone: +37126595586 Fax: +37167901359 E-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Is there Calc function to chose variable from the table on the base of 2 search criteria in the first row and the column?
Thank you a lot! This really helped. I got error result at the beginning using this advice because I have different locale settings and instead of 'FALSE' I have to write 'APLAMS'. Is there also solution for random values in table to chose variable directly on the base of values in the table header and not a number of row? Sincerely, Andis Brian Barker wrote: At 23:04 28/09/2008 +0300, Andis Noname wrote: I'm looking if there is easy possibility to chose variable from the table, like in example below, to use in calculations is another table. I have table like this, but much longer, to chose variables from: *Average height (m)* *Aspen* *Grey alder* *Birch* 1 200020002000 2 180018001800 3 160016001600 4 160016001600 5 160016001600 6 160016001600 7 150016001500 8 140015001400 9 130015001300 10 120015001200 11 110013001100 And I have another table with the results of forest inventory, which contains columns specie and average height, besides other 245 variables. I need additional column with some kind of lookup field, where according to a specie and average tree height I can see regulatory numbers of trees (values in the first table). For instance if the main specie is Aspen and average height of trees is 10 m, regulatory number of trees should be 1200. What are the options to do it, preferably using array functions? I don't think you need an array function here, in fact. Your problem is made easier by the fact that the first column is a regular sequence, not random values. You can use the HLOOKUP() function to search the column headers for the correct species and then use the average height directly to choose the row from which the result should be taken. Suppose that your data table in is cells A1 to D12 and that the species, average height, and your required number in the other table are in columns G, H, and I. In I1, put: =HLOOKUP(G1;B$1:D$12;H1+1;FALSE) Here, B1:D12 is the array of values in your table, G1 is the species value you are looking for - Aspen in your example - and H1 is the average height value. The function searches the first row - the column headers - for your required species, and then returns the value in the specified row of that column. Since your average heights have 1 in row 2, 2 in row 3, and so on, you need H1+1 to specify the required row: 10 in H1 gives 11 as the required row. The final "FALSE" is necessary to indicate that the column headers are not sorted. The two $ signs are not necessary for the formula to work, but will be - to prevent the table reference changing - if you wish to copy the formula down the relevant column (I). A good alternative is to give your data table a name and reference it by that rather than actual cell identifiers. Oh, and I found that column names with asterisks confused the function, so you'd be better off without these. I trust this helps. Brian Barker - 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] Is there Calc function to chose variable from the table on the base of 2 search criteria in the first row and the column?
Hello! I'm looking if there is easy possibility to chose variable from the table, like in example below, to use in calculations is another table. I have table like this, but much longer, to chose variables from: *Average height (m)**Aspen* *Grey alder * *Birch* 1 200020002000 2 180018001800 3 160016001600 4 160016001600 5 160016001600 6 160016001600 7 150016001500 8 140015001400 9 130015001300 10 120015001200 11 110013001100 And I have another table with the results of forest inventory, which contains columns specie and average height, besides other 245 variables. I need additional column with some kind of lookup field, where according to a specie and average tree height I can see regulatory numbers of trees (values in the first table). For instance if the main specie is Aspen and average height of trees is 10 m, regulatory number of trees should be 1200. What are the options to do it, preferably using array functions? Sincerely, Andis
Re: [users] Re: OOo needs an email client, Pegasus needs a sponsor and a text editing component
Hello! For linux users too it's useful to have integrated office suite, like koffice. I can't say about others, but I like a lot concept of koffice as well as microsoft office and I like functionality of openoffice.org un Thunderbird. I'm sure that the question is not just about another openoffice.org style icon in menu bar, but integration of different office components, like attaching documents and e-mails to certain tasks or events, sending events by e-mail, organizing notes and doing lot of other useful and time saving things. I don't see any reason to include Thunderbird with Lightning into openoffice.org package as they are, because it will not change anything in functionality. I'm sure that the right direction is to provide much better integration with Thunderbird + Lightning, Evolution and may be other calendar + e-mail applications. Andis Jerry Feldman wrote: The problem is not, as Fred mentions, Microsoft domination, it is expectation. Linux users do not expect a fully integrated product, but Windows users do, and that is the current reality. I have more to say on this, but no time, just a few thoughts. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Printer administration can't remove or add printers
Thank you! I didn't catch, when this change happened. My problem is that network printer (HP 1220C on Ubuntu Gutsy) prints from middle of page from openoffice or when I try to print test page, but, for instance, when I print from Thunderbird, everything is in right positions. It seems to be ubuntu list question. Andis Robin Laing wrote: Andis wrote: Hello! I tried to remove HP1220C printer from the list of printers in Printer administration window running it as root, but I found that Remove... button is greyed out and it don't work for any printer. Add printer button let me only to add fax or pdf device. What can be the reason and how to get printer administration to work. Ubuntu Gutsy, Openoffice.org 2.4 Sincerely, Andis If the printer is under CUPS administration, then it will be controlled by CUPS, not OOo. Printers at work come and go on my available printers, just depending on which ones CUPS finds. I see the same issue on all my computers. You will have to use the cups administration if you want to remove the printer. Or the Ubuntu printer add/remove utility. http://localhost:631/ - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Printer administration can't remove or add printers
Hello! I tried to remove HP1220C printer from the list of printers in Printer administration window running it as root, but I found that Remove... button is greyed out and it don't work for any printer. Add printer button let me only to add fax or pdf device. What can be the reason and how to get printer administration to work. Ubuntu Gutsy, Openoffice.org 2.4 Sincerely, Andis - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Using Calc for inventory control & production time management
Hello! This macro should help you to insert date and time stamp as a text string. Assign it to a certain key combination or add to tool bar as a button. I use this approach for time studies in forestry. There are also other similar macros available in the internet. I don't remember, where I took this one. Andis REM * BASIC * Sub InsertNowString 'inserts the present value of now() as a string and applies appropriate style Dim oDoc as Object, oCell as Object oDoc = ThisComponent : oCell = oDoc.CurrentSelection If NOT oCell.supportsService( "com.sun.star.sheet.SheetCell" ) Then : Exit Sub : End If oCell.FormulaLocal = cStr( Now() ) If oDoc.StyleFamilies.CellStyles.hasByName( "Time" ) Then oCell.CellStyle = "Time" : End If End Sub George Ekman wrote: I am using Openoffice 2.3.1. I need to be able to load, save and calculate part of a spread sheet, also I need to be able to put time stamps from the computer clock in cells. Both start time and finish time, then calculate time spent on a project, also time for the day for each employee. How do I do this or can Calc be made to do this? If you need a sample of my spread sheet please feel free to ask. George Ekman - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Headings alignment problem in Writer
Hello! Did you check tabs section of heading paragraph format? Another possibility is that you have residuals of heading numbering. Andis [EMAIL PROTECTED] wrote: I am having a problem with the formatting of headings in the text of a Writer document. I am using the heading 1 though 4 styles to define the section titles on my document. All are either left or center aligned, with no indentation of any kind set. The problem is that they are all indented 2.5 inches from the left margin. There is nothing I can see in the configuration that would cause this, and all other styles are displayed correctly. There are no whitespace characters between the margin and the first character of the heading. It is just the heading styles that are doing this. All others are being displayed correctly. Thanks in advanced for any help. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Vlookup problem in calc OpenOffice.org. 2.0
Hello! Check Help section about lookup function. I think the problem in your case is that range should be in alphabetical order, otherwise nothing or just something will work. Andis Warren Griffin wrote: I will try that, although the list is in order of the indicator, i.e. 1 through 7 in that order. I'm trying to find a place I can put the file that others can have access to it and see the equations/functions I used. Do you know any places where I could post this and send out a shortcut? I do have a Yahoo account, but don't know if they have that capability. (I'm a lot more comfortable with simple programming than I am with anything to do with the internet, other than e-mail and simple searches.) Warren Anthony Chilco <[EMAIL PROTECTED]> wrote: Hi Warren, Most attachments don't make it through to the list. I can take a guess that you need to add a fourth parameter to your vlookup function. This one tells the function that the list is not sorted. The default is a sorted list. = vlookup(a1;b5:c55;2,false) If this is not the problem, paste the formalae that you're using into your reply. tc You appear not to be subscribed to the users' mailing list. You could miss many of the replies to your post unless you do subscribe. Just send a blank message addressed to using the e-mail account through which you want to receive it. You will receive a message asking you to confirm your subscription by replying to it. See http://support.openoffice.org/index.html for more options. Subscribing is optional. Be aware that after subscribing, you may receive many messages from the list. Be prepared to set up mail filters in your email client in order to deal with them. Warren Griffin wrote: The problem is explained in the first sheet of the attached file, but I have included a brief description below. I am using a lookup table in one sheet in a logical statement in the next sheet. The logical statement uses a value from the first sheet and the lookup table to find a day of the week to check against a day of the week in the second sheet. If they match, it assigns the value 1 to the cell. I can see the value on the first sheet corresponding to a particular day of the week and yet the lookup table returns the previous day (as though the index number had been decreased by 1). This doesn't happen for any particular day of the week, or sequence of days of the week, as near as I can tell. Any ideas? - 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] any one help me
Hi! I had the same problem, when I tried to to use base database with external data source (spreadsheet) through samba network. May be I'm wrong, but it seems that base uses absolute paths and even those resources which are in the same folder aren't accessible from other computers. Some time ago Autocad had the same problem with linked graphics, now it's enough to move all linked graphics to the same folder where drawing is located and everything is visible again. Andis ayat ahmed wrote: Dan Lewis <[EMAIL PROTECTED]> wrote: On Monday June 11 2007 8:05 am, ayat ahmed wrote: hi all i did database on the open office program and create the forms i share the database but have error the forms can not reach to the tables i want to do this database work on the network and active it through the network if any one know this problem and solve it thanks for your time How did you create the tables? Does each table have a Primary key? Dan i create table in design view(write on it all the fields) and all tables have a primary key when i put the database on network and click on the table i found the table is hidden and output message say the connection to the data source "database name" could not be established file input/output error\\path of the database (note : the database work on my computer only and not active with other computers(not active with network)) please reply today thanks for your time - Get the free Yahoo! toolbar and rest assured with the added security of spyware protection. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Problem with printing capitalized fonts
Hello! I have problem with printing Latvian language specific letters ,like ĀŪĪĒ, in certain fonts (Verdana, Humnst777 and others) when they are capitalized. Instead of ĀŪĪĒ I receive AUIE on paper. On screen and print preview everything is fine, as well as if I convert document to pdf and print it from pdf reader. Some fonts (Albany, Times New Roman) don't have this problem. I have similar results with Samsung ML1210 and HP Deskjet 1220C printers with original Ubuntu Edgy drivers. When printing from Windows XP, everything is fine with all fonts. System: Ubuntu Edgy, Openoffice.org 2.2.0. Andis - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Calc: How do I add up cumulative time (hour/min) values?
Hi! I'm not sure that I understood question right, but to calculate sum of hours in worksheets, you should set time format [HH]:MM in the same place where you set cell number format. Andis David M wrote: I'm trying to create a timesheet in Calc where I enter my start and end times for each day of work (in 24-hour format to avoid tying myself in knots with the 12-hour time format), and then have Calc show the amount of time worked for each day (ie, calculate the difference between the two times, and also subtract my lunch break), and then add up those daily values for weekly totals. I defined the format of the appropriate cells as "Time", and so far, so good ..apart from when I work more than 24 hours in a week (my level of work varies) and then my attempted weekly total Does The Wrong Thing and carries away 24 hours-worth [1], leaving only the "remainder", and so displaying the wrong answer. [1] to who knows where.. I presume, therefore, that Time is strictly a time-of-day format, rather than that to be used for performing calculations on hour:minute values? Is it possible to set an appropriate cell format that will allow me to add up these time values to get the correct cumulative total? The only solution that springs immediately to mind would be just to use normal decimal numbers (and to enter the time in decimal format, ie, 18:30 -> 18.5, fortunately I don't require greater than quarter-hour accuracy and can avoid too-messy fractions), but that would still be seriously ugly, and I just /know/ I'd end up typing (eg) 18.30 without thinking, half the time.. :-( Thanks in advance for any advice, David. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Use of Open Office
Please, sent name of file you downloaded. It should have .exe extension, then it's the right one. The rest is not so important. Andis Edward J. Hernandez wrote: For some reason I do seem to be able to open the program. To be honest, I am not sure if I have downloaded the right version. I have Windows XP as my operating system. I tried to open but it said I had wrong OS version. Please advise what is exactly right one to download and can I go to site to do this. Did I possibly lose my money by possibly downloading the wrong one? My cell is 262-672-1949. I have dial-up service. Please call or send e-mail as soon as possible. Thank you for your help. Edward J. Hernandez - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Open office Calc
Hi! That is painful problem for me too, even when I try to open Excel files with values similar somehow to dates. If the file is small I do it in terrible (but the only I know) way. I copy (or open) it before to writer and then from writer to calc. Then calc recognize content of cells as text. I would like to have better solution. May be you can try to change number format in default style to text and then paste information from text file to calc and then change number styles to what you need in certain columns. Andis Bengt Sebring wrote: Vår/Our ref: BS E7065927 May 2007 When I try to import a txt-file into Open Office Calc some columns set themselves to date-format and it seem impossible to get back to the original numbers. The numbers are like 30.1 becomes 30-01-01. It seem to be the single decimal numbers that turn into date, not the double decimal numbers like 30.54. I am using a dos-format for the import, Nordic Dos. The problem makes it impossible to use Open Office Calc. I have to use MS Exel. Vänliga hälsningar/Best regards *Bengt Sebring *Försäljningschef/Sales Manager *CHS Controls AB *Florettgatan 33 SE-254 67 Helsingborg, Sweden Tel dir +46 42 386102, Swb +46 42 386100 Fax +46 42 386129, Mobile +46 705 151282 [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> www.chscontrols.se <http://www.chscontrols.se/> BEGIN:VCARD VERSION:2.1 X-GWTYPE:USER FN:Bengt Sebring TEL;FAX:+46 42 386129 TEL;WORK:+46 42 386102 TEL;PREF;FAX:+46 42 386129 EMAIL;WORK;PREF;NGW:[EMAIL PROTECTED] N:Sebring;Bengt TITLE:Sales Manager ADR;INTL;WORK;PARCEL;POSTAL:;;Florettgatan 33;HELSINGBORG;;SE-254 67;Sweden LABEL;INTL;WORK;PARCEL;POSTAL;ENCODING=QUOTED-PRINTABLE:Bengt Sebring=0A= Florettgatan 33=0A= HELSINGBORG SE-254 67=0A= Sweden LABEL;DOM;WORK;PARCEL;POSTAL;ENCODING=QUOTED-PRINTABLE:Bengt Sebring=0A= Florettgatan 33=0A= HELSINGBORG SE-254 67 TEL;CELL:+46 705 151282 TEL;PREF:+46 42 386102 URL;WORK:http://www.chscontrols.se ORG:CHS Controls AB END:VCARD - 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] Calc Note Editing
Hi! It should be easy, just a bit confusing. Just enter the cell containing note you want to edit, right click and chose show note, then double click in the body of note and as soon as you will write any character note text will be visible again. Andis Mousel, Lane G wrote: I have just started using Open Office Calc and am having a problem editing notes in cells. I am mainly using files originally created in Excel and am going back and forth between Open Office and Excel with the files (home and office). The Open Office guidance says to use the Insert > Note command to edit a note as well as create one. When I try to edit a note in this way, I don't see the text that is already in the note. If I escape, and display the note, the text is there but I just can't see it while editing. Any ideas? Thanks very much. Lane M. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] OOo 2.2 on Ubuntu Feisty very broken
Hi! I would recommend to remove completely openoffice.org 2.0 provided in Ubuntu repositories and install original version using Alien. You can find several how-tos about installation of openoffice.org in this list. Version included in Ubuntu repositories contains many bugs especially in base and related components. Andis John Jason Jordan wrote: In an attempt to fix various problems in OOo I searched in Synaptic on "openoffice" did a complete removal of everything installed. I also did a complete removal of everything Synaptic showed as residual. Then I deleted the .opernoffice.org2 folder in my home folder. My plan was to eliminate any vestiges of OOo so that a new, fresh install would start out without hangups. Then I installed OOo 2.2 (using the metapackage in Synaptic), plus the hyphenation and help files. When I launched it two things occurred: 1) It opened in the same window size that I had used before. The Styles toolbar was floating off to the right, as I had used it before. 2) All the text in the menus appeared in some kind of symbol font So the questions are: 1) If I want all vestiges of it to be gone, what do I have to delete besides the ~/.openoffice.org2 folder? 2) Where did that symbol font come from and what possessed OOo to think I would be able to read it? - 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] Stupid question about numeric values of time and date
Thank you for the idea! A1*24 gives wrong result, but A1*24*60 is correct. Andis Assuming that 00:16:42 is hours, minutes, seconds (HH:MM:SS) you want to convert it to decimal hours if A1 contains the time, then use A1*24 which will give you 0.2811 in decimal hours then multiply by the hourly rate (50 euros) 50*a1*24 to get the cost. I'm not sure where you get the 0.01160 from. Hope this helps, Klaas Visser - 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] Security with Thunderbird
I prefer Thunderbird as it has more useful Extensions than Seamonkey and I used to Firefox with set of another useful extensions. May be most of these extensions are compatible with Seamonkey too, I don't know. I don't need chat and web editor components. Some people say that Seamonkey consumes less memory and loads faster than Thunderbird + Firefox. Anyway, you can try both, share mail folders, calendars and address book. Andis WJ Seidl wrote: I know that this is perhaps not the forum to ask, but you all have been so helpful suggesting Outlook replacements to other new users (myself being one); so I will pose the question here. If there is a better place to ask, please let me know? I have heard of issues with security/spam/phishing and Thunderbird in the past on other groups to which I belong. Before I migrate from MS Outlook, I am considering both Seamonkey and Thunderbird. I have to admit, I like the way Thunderbird functions, while Seamonkey reminded me of an older version of Netscape I used years ago, but is (according to their online literature) a "complete internet suite". If anyone has a comment or two on their use of Thunderbird or Seamonkey or why they prefer one to the other, I would appreciate hearing them. You can contact me offlist if you prefer. Many Thanks WJ Seidl wjsvt AT sover DOT net (convert at to @ and DOT to .) - 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] Writer not checking spelling
Hi! I'm not sure about Spanish version, but in English version solution is using of File --> Wizards --> Install new dictionaries... Anyway you should reinstall spell checker if you are upgrade or downgrade openoffice.org. Your exceptions and user dictionaries will be available in your personal folder and will not be affected by upgrade or downgrade. Andis María Ángela Guzmán wrote: I am using OpenOffice 2.1. The Writer checked spelling normally but I uninstalled it to install 2.2 version. I uninstalled 2.2 version when I found out that it didn't come in Spanish and then I installed version 2.1 again. Since then, Writer is not checking spelling mistakes. I already chose the spanish dictionary but it still won't work. Thank you! Ángela [EMAIL PROTECTED] Alguien no quiere que leamos esto http://irrepressible.info __ Kennt man wirklich jeden über 3 Ecken? Die Antworten gibt's bei Yahoo! Clever. www.yahoo.de/clever - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Stupid question about numeric values of time and date
Hello! I have rather simple problem. I calculate machinery cost per hour, for instance, 50 EUR, and I calculate time spent for certain operation, for instance 00:16:42 (numeric value 0,01160..). Now I have to calculate actual cost of operation. I found that I can't understand, how calc calculates numeric value and I can't implement this simple task. I tried to found principle, how calc calculates numeric values of time functions in help section and user forums, but there is huge load of irrelevant information. May be someone can send simple solution. Sincerely, Andis - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Using calc in time studies
Thank you! Address for insert time extension is http://www.ooomacros.org/user.php#128899 (unfortunately I couldn't find how to get it to work under OOO2.2 Linux). Address for insert time as text string macro is http://www.oooforum.org/forum/viewtopic.phtml?t=53133&highlight=string. The last question is how to convert this macro to function to use in formula, for instance, =if (A1;"";"";textstringnow)? Andis One other way would be to use script which enters NOW() as a string value. Such script has been published on the forum ( www.oooforum.org ***) and there is also a DATE/TIME tool on www.ooomacros.org . *** Search in the Calc forum. If not found there, try Macros & API or Code Snippets. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Using calc in time studies
If it would be so simply, than commercial data logging software
developers would bankrupt. Time frame to start and finish operation
sometimes is 1 or 2 seconds, so there no time for pressing copy and
paste special. I need fixed starting time in time cell as soon as I
write number of operation in operation cell.
I tried to write new function using macro recorder: enter current time
than copy --> paste special as text, but without any success, because I
don't have programming experience.
Can anyone give advice about structure and content of such macro?
Thank you for response anyway!
Andis
Brian Barker wrote:
At 08:47 13/04/2007 +0300, Andis Lazdinsh wrote:
I'm planning to use openoffice.calc in time studies of forest
harvesting, forwarding and other operations. I'm working on the
model, where I can insert number of operation (1, 2, 3, ...20) in one
column, starting time in second column and finishing time in third
column. As some operations occur at the same time, I need separate
column, where I mark, that operation is finished, so I have four
columns for data entering and fifth column for comments.
My problem is how to insert fixed time (HH:MM:SS) in time columns as
soon as I enter number of operation and mark that operation is
finished. Please, give me advice, how to do it using macros or
combination of build in functions and macros. The main point is to
have fixed time.
Your finishing times are in the third column and your finishing marks
in the fourth, so let's suppose these are columns C and D
respectively. So you want to be able to insert the mark in column D
and see the time when you did this appear magically in the
corresponding cell in column C. Do I understand correctly?
The formula you need for C1 would be:
=IF(ISBLANK(D1);"";NOW())
This tests D1 to see if it is blank (that is, empty). If it is, C1
remains empty; if it is not, then the current time ("NOW") is inserted
in C1. So when you enter something into D1, the time magically
appears in C1.
Note:
1. The default time format includes the date as well as the time, so
you will have to format column C as HH:MM:SS to achieve what you want.
2. Although you will get the correct time in C when you enter
something in D, all these times will be recalculated when you make
other changes. So after you have entered the value in D, you must
freeze the time in C before you do anything else. To do this, copy
the contents of just the relevant cell in column C, and then paste it
straight back in, but using "Paste Special" instead of "Paste".
("Copy" and "Paste Special" are both available from right-click in the
context menu.) In the Paste Special dialogue box, first remove the
tick from "Paste all" if necessary. Then make sure that "Numbers" is
ticked and "Formulae" is *not* ticked. Now you have the finishing
time as a constant rather than as a formula, and it won't change when
you make other alterations or additions.
Unless anyone knows a neater method ...
Brian Barker
-
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] Using calc in time studies
Hello! I'm planning to use openoffice.calc in time studies of forest harvesting, forwarding and other operations. I'm working on the model, where I can insert number of operation (1, 2, 3, ...20) in one column, starting time in second column and finishing time in third column. As some operations occur at the same time, I need separate column, where I mark, that operation is finished, so I have four columns for data entering and fifth column for comments. My problem is how to insert fixed time (HH:MM:SS) in time columns as soon as I enter number of operation and mark that operation is finished. Please, give me advice, how to do it using macros or combination of build in functions and macros. The main point is to have fixed time. Sincerely, Andis - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Dumb e-mail question??
I agree that many programs can use .dxf files, but it's not so simple as it looks. First of all conversion of native autocad or microstation files, especially if they are not properly edited, breaks layers and engineer should spend hours and hours to restore layer structure. That happen even if we need to open drawings created by older versions of autocad, so we keep most of them starting from nineteenths to be sure that what we see is what we should see, especially if we take in account special character tables used in our language in different times. Conversion from microstation to autocad is another painful thing. I don't know any opensource user friendly 3D cad drawing application for linux which supports scripting and macros. I think the only way is porting of autocad to linux, not development of linux alternatives. There was interesting discussion about CAD applications in Ubuntu forum at the beginning of this year. Mistakes in engineering drawings can be much more painful (or at least costly) than mistakes in text documents... Greetings, Andis Renaud (Ron) OLGIATI wrote: On Thursday 12 April 2007 06:42, my mailbox was graced by a missive from Andis Lazdinsh <[EMAIL PROTECTED]> who wrote: but, for instance, most of engineering companies (like my company) should use windows, because they need to work with microstation, autocad and other propriety cad software documents. In one word: Rubbish. Theere are plenty CAD progs out there that use the open format .dxf files, into which ISTR that Autocad and other proprietary CAD progs can export, to make this argument as ridiculous as "We must have Windows, because we use .doc documents". Cheers, Ron. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Dumb e-mail question??
Hi! Switching to linux of course sounds interesting, if you don't need to use any special programs, but, for instance, most of engineering companies (like my company) should use windows, because they need to work with microstation, autocad and other propriety cad software documents. In this case, factor limiting switching to openoffice.org, is lack of reliable PIM application. I tried most of applications listed in this discussion and Evolution is only which at least under linux is more or less useful and similar to outlook (which also is vary important to painless switching), but porting to windows seems stopped. So, I'm still with Thunderbird and "memory eater" Sunbird, other colleges - with outlook. Andis [EMAIL PROTECTED] wrote: On Wednesday 11 April 2007, Johnny Andersson wrote: So what are we all doing wrong that makes people think that? How can we make people understand? Isn't there enough information on the web site? Or is it written in a way that's hard to understand for common users? Maybe there should be a link in big capitals on the web site, saying something like "WHAT IS OPENOFFICE.ORG ?" and another one saying "FAQ about OpenOffice.org". On the other hand, there actually IS a link saying "New user & general info". That should be enough, but obviously it's not. Maybe it just doesn't matter what is written on the web site, people will probably always think it's easier to get answers by asking questions, no matter how many people asked the same questions before. Besides, Windows users are often incredibly stupid. Like me for instance, I have been using windows since 1994 I think. I have been hating it since the same year and I still use the damn thing. Is that stupid or what? But I promise that will change before the summer! Or something like that. Here is your opportunity to change now! http://fedoraproject.org/wiki/ http://www.centos.org/ http://www.mandriva.com/en/download http://www.knoppix.org/ http://www.kubuntu.org/ - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Re: Dumb e-mail question??
Hi! It sounds a bit undelievable, that someone can be happy running seamonkey or any other mozilla product with calendar extension or sunbird on old computer. Sunbird is slow even on modern computers. May be I'm too nervous, but it makes me sick that useless calendaring program consumes more memory and time to load than any office application. And I think these discussions are useless. The question about PIM or email program is the most often repeated in ooo user list since it was dropped in first versions. I have feeling that most of programmers simply don't understand what means personal information managers. (At least in our company programmers still use Eudora mail - software which even doesn't support common Latvian language character encoding tables.) Andis A friend of mine is one of those. She had "obtained" MS Office from a friend, but she had a licenced copy of XP, because she'd upgraded her computer from W98. When she had a hard drive failure, I re-installed XP for her. She then asked where MS Office was. I explained to her that she didn't have it to install, but if she wanted to buy MS Office, I could install it for her. She is now running OpenOffice and Seamonkey for her office and email needs. She's now thinking about getting a new computer and I'm strongly advising her to go Linux or Mac. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Open Office 2.0
May be you open document from the location where you don't have write permission. Try press save as.. and save document somewhere, for instance your home folder and then open it again. If you can edit document now, you should change writing permissions for initial location or ask system administrator to do it. Andis Johnny Andersson wrote: There is a button looking like a paper and a pencil. It turns editing mode on and off. Try it. Does it help? Johnny Andersson 2007/3/27, BRIAN LILLICO <[EMAIL PROTECTED]>:
Re: [users] CPU > 50% (MS Explorer)
Try to check your system for viruses and trojans and address this problem to ms windows support site. I think it's discussed several times there, at least for win 98 and win 2k Another suggestion is to switch to another file manager, for instance Total commander. Explorer consumes nearly as much memory as Thunderbird or Firefox even if it working just in background. Andis Pat Smith wrote: Sir, I've been experiencing CPU problems since installing open office. My CPU goes to ~ 50% usage MS explorer is at 48 to 52% CPU capacity This happens every time I'm searching my computer for files. Explorer stars out OK but then pretty much locks up. Also what is the "python" and is it supposed to be part of openoffice ? Thank you, Pat Patrick Smith Mikron Valve 10537 Crosby Circle Cranesville, PA 16410 phone: (814)756-4858 fax: (814)756-5252 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Re: Evolution Address Bk access??
Thank you for response! I'm coming from windows community so linux installation approach always makes me a bit confused. I have already uninstalled ubuntu-desktop, because I uninstalled before Evolution. I tried just as experiment paste command sudo apt-get remove ubuntu-desktop, but besides information, that I don't have this package installed apt-get send me this message. I don't know, is it reasonable to follow these recommendations. Package ubuntu-desktop is not installed, so not removed The following packages were automatically installed and are no longer required: libwxgtk2.4-1-contrib libgfortran1 libkexif1 libshp1 libcln4 zlib-bin blt python-tk samba-doc tcllib libt1-5 lesstif2 samba netpbm libcrypto++5.2c2a atlas3-base tcl8.4 tk8.4 libssl0.9.7 libnetpbm10 libkdeedu3 xaw3dg libg2c0 libimlib2 libjpeg-progs liblockfile1 libungif4g By the way, I used for several years Mandrake --> Mandriva distributions and installation of OS, programs and user profiles usually consumed less than 2 GB. In Ubuntu OS, programs and profiles already took 4,5 GB within few months. What is the reason and is there easy way to avoid this? Andis NoOp wrote: sudo apt-get remove ubuntu-desktop You can reinstall if you find this creates any problems. However, I multiple machines without the ubuntu-desktop without any problems. One other point: Morgan resolved his problem with the missing Evolution address' - info is on the db.users list & I'm now looking at how to do the same for the mozilla bits. If you are not subscribed to the db list, here is the msg: Thanks for coming back so quick! Yup, that worked. In /share/registry/data/org/openoffice/Office/DataAccess.xcu swapped: /usr/share/evolution/*/evolution-addressbook-export for: /usr/libexec/evolution/2.6/evolution-addressbook-export Now I have my full quota of address book sources as per Gary's "official" install: - Evolution - Groupwise - Evolution LDAP - Mozilla / Netscape - Thunderbird - KDE address book - LDAP address book - Other external data source Shame Evolution can't export that variable location some how? And, in general, I thought my issues seemed sufficiently similar to Gary's and others to suspect something generic going on. But, on inspecting DataAccess.xcu I see that different sources don't export in a generic way. Regards, Morgan. Frank Schönheit - Sun Microsystems Germany wrote: Hi Morgan, This is a follow on from a couple of threads on the users list. - Simple Q: how do I get access to Evolution address book sources on a OOo stock install of v2.1 on fedora? First, you need to have the libevo* libraries in your program folder. This should be the case for the "stock" version of OOo, as there the lib is included in the download packager. I don't know whether this holds for distro-specific versions of OOo. Second, the driver uses a program called "evolution-addressbook-export", which is a Evolution-provided script for, well, exporting address books. This script needs to be in your PATH. Alternatively, the complete path to it must be in the configuration - you can look up the current value in /share/registry/data/org/openoffice/Office/DataAccess.xcu. If both isn't the case, then i.e. the script cannot be found, then the driver will not offer its functionality, and the UI will honor this by not offering the respective options. - Complex Q: what's going on with address book access?... ... And, what's going on with address book access in general? Hmm, what exactly do you want to know here? Ciao Frank - 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] Re: Evolution Address Bk access??
Hi! Thank you for suggestions! When I tried to uninstall openoffice using Synaptic, I received following error message: E: Error, pkgProblemResolver::Resolve generated breaks, this may be caused by held packages. E: Error, pkgProblemResolver::Resolve generated breaks, this may be caused by held packages. E: Unable to correct dependencies E: Error, pkgProblemResolver::Resolve generated breaks, this may be caused by held packages. E: Error, pkgProblemResolver::Resolve generated breaks, this may be caused by held packages. E: Unable to correct dependencies E: Unable to lock the download directory I tried different orders to uninstall openoffice, but this appears, when I try to uninstall core package. Andis For Andis on Ubuntu: 1. Download the linux code from OOo directly. 2. Uninstall the Ubuntu 2.1 OOo applications (Synaptic works well for this). I also uninstall the ubuntu-desktop, but you might want to keep yours. However w/unbuntu-desktop you will not be able to install the OOo desktop-integration .deb so you'll need to manually add the OOo applications to the Applications|Office menus. 2. Unarchive the OOo code using the archive manager & allow it to extract to it's own directory. Change the directory name to something simple; OOo2.1 3. From a terminal window: sudo apt-get install build-essential sudo apt-get install alien cd OOo2.1 cd RPMS sudo alien -v -k *.rpm [this will take awhile on a slow computer, be patient] sudo dpkg -i *.deb cd desktop-integration sudo dpkg -i openoffice.org-debian-menus_2.1.5_all.deb [note: this last only works if ubuntu-desktop is uninstalled first] You now should be able to: Applications|Office and see your installed OOo. Open Writer, follow the registration etc prompts, then try your address book access & they all should be there. If you choose not to uninstall the ubuntu-desktop, skip the: sudo dpkg -i openoffice.org-debian-menus_2.1.5_all.deb step and instead: 1. Right click Applications 2. Choose Edit Menus 3. Click on Office 4. New Item 5. Name: OOo 2.1 Writer 6. Command: - Browse & browse to /opt/openoffice.org2.1/program/swriter Repeat for Calc (scalc), etc. If you have problems drop me a line off-list. Morgan: I don't know anything about FC, but you might want to explore installing directly as well. - 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] Re: Evolution Address Bk access??
Hi! I asked similar question in Ubuntu user list regarding Thunderbird, as I use openoffice.org version taken from Ubuntu repositories. Now I see it's a common problem. In my case I can't access any address data sources, first of all because I uninstall Evolution and all it's components (Evolution address book was at least visible in wizard window). I didn't see Thunderbird address book as data source from the beginning. There are no problem to establish connection with Thunderbird address book under windows XP. But when I try to open that address book under linux I receive error messages described in previous posts. Andis James Mckenzie wrote: From: Morgan Read <[EMAIL PROTECTED]> Sent: Mar 19, 2007 12:15 AM To: users@openoffice.org Subject: [users] Re: Evolution Address Bk access?? James Mckenzie wrote: Here is something interesting: I get a no SDBC errorUnder the Mac port. I guess I will have to look for the issue. YES! James, thanks. You are welcome. [Lengthy description of problem deleted] SO! Any ideas what's going on?! Any way to access a "data source URL" directly - to try to input sdbc:address:evolution:local directly? My error is sdbc:address:thunderbird Anything that might need installing to access those mysterious missing data types? And, do you use Evolution on a Mac?! No, Thunderbird. I don't know if Evolution exists for the Mac. Can you open an issue on this? This should affect both UNIX and Windows systems. It appears that the Fedora project is building their own version of OpenOffice.org that will read the Evolution address book and create a database object that can be used for several different purposes. James McKenzie - 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] Outlook type product
Hello again! I was too optimistic. After restarting Sunbird 0.3.1 went back to 50 MB of memory. Removing of all add-ons didn't help. On my Ubuntu 6.10 system it's the most memory consuming component. It seems that there is still something to do... Andis George Wolf wrote: Andis Lazdinsh wrote: Now, when the process is sleeping Sunbird takes 45 MB of memory. I just checked my system. Sunbird occupies just over 29 MB. I'm running with 1 gig and I've never had substantial delays of the type you mention -- even when I was running with 512 MB. However, you may be using Sunbird more intensively than I am. Also, are you using version 0.3.1? George Wolf - 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] Outlook type product
Just upgraded to 0.3.1 and consumption of memory looks much better (30 MB). About 30% less than before, but opening of new event window still takes 3-5 sec. If each next version will reduce memory use for 30%, then outlook and evolution will have nothing to do in this market. Andis George Wolf wrote: Andis Lazdinsh wrote: Now, when the process is sleeping Sunbird takes 45 MB of memory. I just checked my system. Sunbird occupies just over 29 MB. I'm running with 1 gig and I've never had substantial delays of the type you mention -- even when I was running with 512 MB. However, you may be using Sunbird more intensively than I am. Also, are you using version 0.3.1? George Wolf - 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] Outlook type product
Hello! If you are Windows user there really not so many alternatives. I used calendar extension for Thuderbird from the first versions, now I use Sunbird. But the worst thing, at least for me, is that it consumes huge amount of memory. Now, when the process is sleeping Sunbird takes 45 MB of memory. Thunderbird, for instance, takes 34 MB, Firefox 26 MB. It makes me sick to wait 5-15 sec while new event window comes up. Bonus for Thunderbird + Lightning is that is the most often mentioned calendaring application in ooo conference developers presentations, so that might be right choice for the future. Andis George Wolf wrote: To add to what has been said; There are at least three open source calendar applications that I know of if you use Windows. Mozilla makes Sunbird and Lightning. The former is a standalone calendar program and the latter is an add-on for Mozilla Thunderbird, meaning that after you download and install it, you call it up from inside Thunderbird, just as you call up calendar functions from inside Outlook. The advantage of having Lightning inside Thunderbird is that it has slightly better functionality for interactions with other calendars over a network or the Internet. Sunbird has more calendar options (at least in what I have). Go to http://www.mozilla.org/projects/calendar/ For more information There is another open source project called Chandler at: http://chandler.osafoundation.org/ At the moment it has a slicker user interface than either Sunbird or Lightning The good thing about all of the above calendar programs is that they are free. The bad thing is that although they are stable, none of them are fully developed yet, although Sunbird does everything that I've asked of it so far...! George Wolf - 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] Is it possible to exclude tables from the table list
Hi! What do you mean with Table list? Is it Table index or Table list in Navigator window? In case of Table index you should try different Caption paragraph styles for different kind of tables, and insert User-defined index based on certain paragraph styles. In case of Navigator window, I don't think it's possible and reasonable. Andis Richard Bos wrote: I have a document with many tables. Only some of those tables are relevant for a tables list. Is it therefor possible to mark certain tables to be excluded from the table list. Or vice versa, is it possible to mark the tables that should make up the table list? - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Removing formatting marks from Calc cells
Hi! May be try to copy that character directly from cell content and paste it into find field, leave replace field empty. It's always helps, at least for me. Andis Terry Allen wrote: I hope I can explain this clearly: I use Calc (OOo 2.1, Windows XP Home, SP2) to open an .xls file created by a FoxPro 2.4 (DOS) application. Don't ask why, it would take too long. Some fields contain a ' (single quote or tick) at the beginning of the content. From memory, this is how Lotus 123 indicated that what followed should be treated as text, rather than a numerical value. I need to remove these formatting marks so that dates are treated as dates and numbers as numbers. I have tried Search and Replace, copying the ' and pasting it into the "Search" field, but I receive a disheartening beep and "Search string not found". I can manually remove then by using F2,Home,Delete,, but that's a bit pedestrian. I've also tried recording a macro to automate these keystrokes, but that simply replaces the content of every cell with the content of the one I used to make the recording. Can it be done, and if so, how? Terry - 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] Decorative Borders on Writer
Hi! You can try Format --> Page --> Borders, but I'm not sure is it what you mean with decorative borders. You can variate with some types of lines, colors and distance to text. Another approach is to use background picture with decorative borders also through Format --> Page --> Background dialog. Andis John & Sue Cowdery wrote: I'm new to OpenOffice and am most impressed with the whole system. But PLEASE where are the Decorative Borders in Writer? I see from the Mail List that I'm not the first to ask this question. Unfortunately though I can't find any answers or responses. Can anybody help? John Cowdery - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] How to insert Title to Secondary Y Axis in openoffice.org 2.0 Chart?
Hello! I need to insert Title to Secondary Y Axis in Chart inserted into openoffice.org spreadsheet application. I think it should be possible, but unfortunately I can't find how to do it. Any suggestions? Andis - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] [moderated] help
I'm not expert in the field of databases, but may be it's better to try to start from another side and use mysql database instead of openoffice.org native format. There should be lot of documentation and templates for your needs in developer sites like sourceforge.net. It should be also possible to reach and manage mysql databases from openoffice.org. But it's only my personal suggestion... Andis Ron Ferguson wrote: Andis wrote: Surely, Andis, that cannot be correct. I have created a data base comprising what may be described as Customer Details (addresses etc), Products, Orders, and despatch. I can produce any report I wish. However I wish to do two things more: 1. Create a cvs file so I can select from the Customer details the records which I can import into my email program either Thunderbird or OE 2. Create an integrated Mailing List, again from the Customer Details. Without these to facilities the use of the DB for other than playing with is very, very, limited. Ron Ferguson - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] [moderated] help
For the first question. It is not vary describing, but I'm sure you will find answer, when you will read openoffice.org help section - spreadsheets --> printing For second. I'm not sure is there option to buy any mailing list (or may be address list?!) in openoffice.org. Simple database can be created simple by pressing file --> new --> database. Following instructions can be found in help section. But if you have problems creating database, using guide available in help section, I assume you should stay with spreadsheet to keep your list of addresses (if this is what you mean with 'mailing information'). Andis Legacy Mortgage wrote: ALoha I have two questions The first one I am asking on behalf of over a dozen people, including my computer tech. With all your wonderful upgrades, why can I / We /Anyone not print landscape format?? This is a real drag now that it is tax season and everyone I know is calling me asking me how to print their spreadsheets onto one page or viewable on a page rather than in pieces? You know the readable kind with headers and footers. I would like to print my spreadsheet with all of the columns but not onto hundrend pages extra large size. The other is your data base. How in the world, if I can, can I just make a simple data base with mailing information? Your help is useless I'm sorry to say. You only have options to purchase existing mailing lists? this does not help my marketing any. Mahalo Jo Jo King Branch Owner 808-651-7009 Lihue 808-338-0733 Waimea 808-338-0730 Fax 808-334-0733 Kona 808-935-0733 Hilo
Re: [users] Upgrade Fails from 2.0 to 2.1
If you are looking for version 2.0.4, than you can get it, for instance, here ftp://sunsite.informatik.rwth-aachen.de/pub/mirror/OpenOffice/stable/2.0.4 If you have version 2.0.0, you can try direct connect, e-mule or other p2p network search. May be this link is still valid http://www.nextgen6.net/source/openoffice/OOo_2.0.0_Win32Intel_install.exe.torrent Andis Evan Wilner wrote: On Windows XP, it's proven impossible to upgrade from OO2.0 to OO2.1 due to missing installation and setup/remove files. OpenOfficeorg20.msi file was erased as was the setup file. Anyone have a solution? Are the missing files available for download and proper placement? Evan Wilner
Re: [users] Is it just me? (People asking for e-mail clients)
Two suggestions regarding publisher and e-mail client (or actually personal information manager). May be a bit out of context of previous posts. First regarding importance of personal information manager. My boss (as many boses), which are decision makers, when we are speaking about bying new software or switching to something else than Microsoft office use generally Outlook (no excel or word, or powerpoint). So it's the first thing he looked for, when I propose to switch to openoffice.org, is something like outlook and not other applications, which are actually vary similar in all available office suites. I think it's more marketing, not programming issue, because it's impossible to return back into past and to start, for instance, development of dropped staroffice 5.2 personal information manager. It should be ready to use, mature product, like Thunderbird with Sundird. Second suggestion. May be it's reasonable to extend existing registration form or to publisdh user questionaire to find what PIM and publishing software actually are the most used together with openoffice.org in linux and windows environment. That would be great source of information for FAQ and also guide to new openoffice.org users to avoid endless decision making process about what to use. Andis Fred A. Miller wrote: James Mckenzie wrote: James, I'm willing to rewrite the readme, PROVIDING I don't have to do it "now." ;) I'll have to squeeze it in somewhere and will do it as soon as I can. Once done, who do I send it to? Fred - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Is it just me? (People asking for e-mail clients)
Hello! You have to check Mozilla Thunderbird Lightning extension developer pages. It's second more or less official attempt to re-introduce or at least to support integration of e-mail client and personal information manager into openoffice.org. I'm not sure, how serious it is and when Lightning will be ready to every day use, so I suggest to try Thunderbird + standalone Sunbird, if your computers have enough memory to run these programs, but may be it's time to switch to koffice with kontact to avoid painful chosing between different available e-mail clients and pim managers. Andis John Meyer wrote: Is it just me, or do more and more people seem to be asking if Open Office has or will have an e-mail client? I seem to recall a discussion about this issue we had a few months ago, or I think I recall it happening. - 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] Re: Disappearing Pictures
Hi! Seems to be hard case. Really, only way to see what and why happen is to go through that document. Long time ago our company has ms word template (roots goes to word 6.0) to write business plans. We used and improved it (everybody who worked with that document added his own formatting elements) up to version word 2k. Documents created on the base of this template started to crash more and more often and finally I rewrite text using paste as text function, removing every formatting element and newly created styles and finally rewrite it again in ooo writer. Later I added formatting elements vary carefully. There no problems now with TOC, blank pages and pagination, except that windows and linux versions of documents always differs by letter size, but it also isn't real problem, because I can change a bit default fonts and everything will be fine. I think the biggest problem is that people are trying to use writer as publishing software. One reason for insertion blank pages is conflicting page or paragraph styles. Another, more realistic, are pictures and frames anchored to page not as character. At least I found it in several documents created by my colleges. This problem is vary common also in ms word documents up to the latest versions. This could be the reason also for strange TOC behavior. Andis Rick Bilonick wrote: I've read the thread (tables et al) and decided to try the same. I only inserted a few pics into the frames, saved (odt), exported to PDF etc. All worked fine (2.1 linux from OOo site). So it could be a memory issue OOo memory problem? You might check Options|OpenOffice.org|Memory & try changing the cache settings. Also, I did also test the saving to a MS Word doc; if the graphic is inserted directly on the page, the graphic comes back in the Word doc, but is resized to a single line in the left side of the graphic frame. It can be stretched back to size in the *graphic* frame, but it seems odd that it would get shrunk like that. The graphic inserted into the frame (your method) has dissapeared completely. The frame is still there, the caption is still there (although it needs to be reoriented in the frame), but the graphic is gone. That appears to be the http://qa.openoffice.org/issues/show_bug.cgi?id=25756 bug also showing up in linux OOo as well. However, if the graphic inserted into the frame is anchored "As Character", the graphic *is* preserved in the frame when saved as a MS Word document. Unfortunately it gets shrunk down to a single line size the same as the directly inserted graphic does so you have to go and resize them all. I did note something that seems odd (to me); when I reopened the saved odt doc, the graphic in the frame could be moved outside of the frame even though the graphic is anchored to the frame. Now technically the graphic *is* anchored to the frame, because I can move the frame and the graphic located *outside* the frame moves with it. So, I'm wondering if perhaps when you move the frame, the graphic is not moving with it. Try anchoring as a character instead. I also note that inserting a graphic into a table seems to have it's own problems as well... While the graphic can be easily put into the table, you can't drag a table around the document to position or move it like you can a frame or a inserted graphic. Perhaps the safest method is to link to the graphic as Tim Wescott suggests. I did not have these problems with documents under 125 pages. The document I'm having problems with is about 350 pages with about 90 frames/pics (and a huge number of tables, some in frames, and a large number of listings [text in frames]). I just discovered the memory controls so I've greatly increased these. I also installed OOo 2.1 (from the OOo website) onto a dual Opteron 64-bit system with 2gb of memory (and 2gb of swap). I increased OOo's memory usage for graphics. Still I see several pics disappearing BUT now if I resize or something similar they re-appear. But another problem arises - if I do a preview, the number of pages changes - blank pages are inserted (even though I disabled blank page insertion everywhere I can). If I preview, then do nothing to the document and preview again, the number of blank pages increases further. (Another problem I've found not with just this document but any document that has a TOC is that for some strange reason PDF export does not work correctly - the type/fonts looks funny/distorted/badly kerned in numerous places (for example, the periods are misaligned in the TOC - the ones that run from the headings to the page numbers and the periods also run into the page numbers. To get around this problem (and the unstoppable insertion of blank pages) one I have the document ready I print it to a postscript file (printing does not seem to trigger re-pagination). Then I use ps2pdf to create a pdf - all the text looks like it should. I can't s
Re: [users] Fwd: Ms Outlook counterpart
Hi! Evolution (part of gnome) is something more like outlook in measures of functionality, if you are staying with Linux. Koffice has vary nice PIM manager which is integrated with KDE. Both projects are starting windows porting. Under windows there are not so many alternatives. Thunderbird + Sunbird seems to be more promising, if you are looking for desktop applications. Andis Pieter Louw wrote: Pieter Louw <[EMAIL PROTECTED]> wrote: Date: Mon, 5 Feb 2007 18:53:57 + (GMT) From: Pieter Louw <[EMAIL PROTECTED]> Subject: Ms Outlook counterpart To: [EMAIL PROTECTED] Hi We envisage installing Linux only on our new IT system - we are a new startup company with around 5 staff but we will grow fairly fast. We need a server and 5 users PC's, plus 2 users whom will log in from anywhere in the world. We need Outlook functionality but prefer not to do Microsoft, mainly for security considerations. We were thinking of OpenOffice 2.1 but the diary system cum personal organiser is still missing. What is available in the Linux enviro and how do we get it to test? Thanks for your response. Kind regards Pieter Louw - The all-new Yahoo! Mail goes wherever you go - free your email address from your Internet provider. Kind regards Pieter Louw - Now you can scan emails quickly with a reading pane. Get the new Yahoo! Mail. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Querry regarding .cdr file
Hi It seems to be coreldraw file, which can't be opened directly by openoffice.org, but you can internet for free cdr viewers. There should be several choices. Andis Mandar Sherbet wrote: I wish to know whether any of the Open Office softwares can help me access a CDR File, (i.e. with .cdr extension). Kindly let me know if I have any other alternatives. Thanking You. Mandar Sherbet. Mandar Sherbet - Here’s a new way to find what you're looking for - Yahoo! Answers - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Large spreadsheets
Hi! I have the same experience with large spreadsheets. If it comes close to 1 Mb (some 50 Mb in .xls), than it's impossible to work with calc. I'm linux user at work, so my solution is to break large spreadsheets into smaller ones and connect them with links, and of course delete every piece of text, which is not absolutely necessary. I don't have any experience with gnumeric and koffice. Andis Kirill S. Palagin wrote: -Original Message- From: Will Kramer [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 06, 2007 3:37 AM Is it practical to have a spreadsheet with more than say a million cells (on a fast computer with 256 mb of ram)? I have 3 rows by 40 columns of data that I want to do a couple of calculations for on each row and then sort the rows. Is one of calc, gnumeric, excel more efficient at this? (I probably will be linched for that, but here it goes) In my experience Excel generally is faster, except maybe in certain cases. But you should try all 3 spreadrsheet apps. - 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] Disappearing Pictures
Hi! First of all it's problem when you sometimes need to send your writer documents to ms word user with .doc exension. I think every user of openoffice.org writer sometimes should do it. Second, also related to other formats, is saving to html. Placement of pictures also will be changed in html if frames are used instead of tables. And third, may be personal, I don't understand why to introduce text formatting element which don't have any functions, which can't be easily replaced by other commonly used formatting elements. But it is really interesting for me, from were comes graphics in frames tradition. When using Insert --> Caption function frame is generated by default in openoffice.org and I should spend time to avoid this. Graphics in frames wasn't in staroffice, it isn't used in msoffice. This "new feature" disappointed me, when it was introduced in staroffice. Sincerely Andis (staroffice/openoffice from 1996) Ron Ferguson wrote: Why is it not a good idea? Ron Ferguson Andis Lazdinsh wrote: Hi! I don't know from where comes idea to insert pictures into frames, but I think it's definetly not good idea. > I hope this will help! Andis - 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] Disappearing Pictures
I agree that it's better to anchor as character and to use table parameters for right placement, and it's better to embed graphics. Than you will be able to move this file from one machine to another without loosing information. Linked graphics can be easily copied into file using Edit --> Links... --> Break links (or something like this). For 80 pictures it will take some time. Andis Hagar de l'Est wrote: Rick Bilonick wrote: I'm not inserting pics into two frames - just one. I caption the frame. You're right, inserting a caption to a frame doesn't create an additional frame. Perhaps the problem come from the anchoring. I would trust 'As Character' the most because it's less volatile than to a paragraph or page. Rick Bilonick wrote: Do you think it's better to embed the graphics or link them? I think that embedding is better (never had such problems but I don't use frames) but just personal opinion. Hagar. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Disappearing Pictures
Hi! I remember that problem from first versions of writer as well as word up to version 2k, when I leave it. That problem was caused by large amount of graphics, small amount of computer memory and use of complicated graphics formatting and placement elements, like those you mentioned. I don't know from where comes idea to insert pictures into frames, but I think it's definetly not good idea. From your description I also understand that you are using frame in frame for every picture, if your are using build in function auto caption or Insert --> caption. You should give a try to insert pictures in tables (without frames) and add captions to tables (without frames, too), if you need advanced placement of pictures or insert captions manually using Insert --> Field (F2) function (also without frames). This is described earlier in this list. Another suggestion is to read help section, where inserting graphics is described and to use that method which is recommended by developers. I hope this will help! Andis Rick Bilonick wrote: On Sun, 2007-02-04 at 21:52 +0100, Hagar de l'Est wrote: Thanks for the info. However, I'm not placing the pics in a frame and then in another frame. Each pic is inserted into one frame. Then I caption the frame. The pic is anchored to the frame. I do this manually. What do you mean exactly by 'manually' ? If you right click, then select Caption, OOo DOES insert a frame to place the caption. I've never heard of inserting pics into a table (I guess you mean a 1x1 table. Is this the officially recommended way of handling pictures with captions? Personally, I insert a table, 2 rows : one for the picture, the other for the 'caption'. If I need a numbered caption, I use an AutoText, inserting both the table, and the caption text with the automatic numbering. I believe a frame is only inserted around a pic if you use autocaption. If you don't use autocaption I believe it justs places a caption above or below the pic. Same behavior for AutoCaption or context menu. Hagar. By "manually" I mean I first create a frame, then I insert the pic into the frame and anchor it to the frame. Then I caption the FRAME (not the pic). I can see how a table could work. But it may not stop the pics from disappearing (although maybe it would). Someone else said they worked around the disappearance problem (in an earlier version) by using links instead of embedding. I'm considering doing this for all 90 pics (but with my luck I can imagine the links disappearing). Either way, I have to handle 90 pics. Thanks for your input. Rick - 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] Fonts: Linux vs. Windows
Hi! I have the same problem, in spite I use the same fonts in Ubuntu Linux and winxp. At the moment I just slightly resize fonts in default style so the text fits into page. Of course, this is not the best solution. Andis Tim Wescott wrote: On my Windows XP box, OOo shows "Times New Roman" font as being somewhat smaller than "Bitstream Vera Sans". On my nice new I'm-going-overboard-with-this-open-software-stuff Debian (etch) box, the two fonts are about the same size -- which has messed up some presentations. Luckily, I'll probably be giving the presentations on a Windows laptop, and if not I'll have time to change things around. But: Does anyone know why? Is there a way that I can find a list of the fonts that I can trust not to change size on me when I use GNU/Linux instead of Windows? Thanks. - 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] защита ячеек в OO.calc
Eto delajetsja takze kak v programme Excel. Po umolcaniju vse jaceiki zascisceni, tojestj, nazav Tools --> Protect Document (Sheet ili Document) budet nevozmoznim izmenenije vseh jacejek. Ctobi pozvolitj dostup k otdelnim jaceikam pered etim nado v sootvetstvujustih jaceikah sdelatj tak - Tools --> Format Cells --> Cell Protection --> i otmenajem Protected. A potom stavim Protect Document. Ne predstavljaju, kak eto vigljadit v russkoi versiji. Andis [EMAIL PROTECTED] wrote: Hello В OO.calc (v 2.1) я не нашел способа защитить отдельные ячейки на одном из листов без защиты листа. Или это невозможно? Мне необходимо иметь на листе (без защиты) часть ячеек, которые защищены. Best regards Gennady - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Import PDF table
Hi! I'm looking for the same thing. At the moment I found only Acrobat itself can copy pdf tables and reach format text. If you found such utility, please let me (and others) know about it. Andis Victor Chapman wrote: I receive a number of PDF documents that contain tables. Is there anyway to import a table directly into Writer or Calc? TIA - 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] Extended SQRT function in Calc
Thank you vary much. It works! It seems that our books about mathematics differs from yours. It would be nice to introduce something like =root(x;y) into calc to make such estimations easier Andis Henrik Sundberg wrote: Ahh typing error Sqrt(X) is X^(1/2). I.e. X^(1/2)*X^(1/2) = X^(1/2+1/2) = X^1 = X. 2007/1/29, Henrik Sundberg <[EMAIL PROTECTED]>: X^-2 is 1/X^2 Sqrt(X) is X^(1/2). I.e. X^(1/2) = X^(1/2+1/2) = X^1 = X. The third root is X^(1/3). I.e. X^(1/3) * X^(1/3) * X^(1/3) = X^(1/3+1/3+1/3) = X^1 = X. HTH /$ 2007/1/29, arnold huzen <[EMAIL PROTECTED]>: > The answer you're getting is correct. When you instruct 3^-3, then you're instructing to devide. So it's 3/3=1/3=0,037 > > If you want the outcome to be a negative value of -27 then you must instruct -3^3. > > Arnold Huzen > > > > > > van: Andis Lazdinsh <[EMAIL PROTECTED]> > > datum: 2007/01/29 Mon AM 11:15:39 CET > > aan: users@openoffice.org > > onderwerp: Re: [users] Extended SQRT function in Calc > > > > Thank you for suggestion, but this doesn't work. > > For instance, if I write 27^-3 or A2^-B2 (A2=27 and B2=3), I receive > > 0,508..., but should be 3 (3x3=9x3=27). > > > > I found name of function I need. In Qualculate it's called nth root and > > multiple root. > > > > So, any other recommendations? > > > > Andis > > > > > > For instance > > > > Andi Permadi wrote: > > > Just change the x & y with Cell Address > > > You have value of X in A2 > > > and value ofY in B2 > > > for the x^-y result just write = A2^-B2 > > > it will result the value You need. > > > > > > On 29/01/07, Andis Lazdinsh <[EMAIL PROTECTED]> wrote: > > >> Hello! > > >> > > >> I need to calculate x ordinal square root in calc. I'm not sure, is this > > >> translation to English is right, but the formula could be =x^-y (this > > >> formula results in mistakeous number). I know this can be calculated > > >> easily with mathcad, but I think it should be possible to do this with > > >> calc, too. > > >> > > >> Any suggestions, how to do this calculation? > > >> > > >> Andis > > >> > > >> -- > > >> LVMI "SILAVA" > > >> Riga street 111 > > >> Salaspils, LV-2169 > > >> > > >> Phone: +37126595586 > > >> Fax: +3717901359 > > >> E-mail: [EMAIL PROTECTED] > > >> > > >> - > > >> 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] > > > > - > > 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] > > - 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] Extended SQRT function in Calc
Thank you for suggestion, but this doesn't work. For instance, if I write 27^-3 or A2^-B2 (A2=27 and B2=3), I receive 0,508..., but should be 3 (3x3=9x3=27). I found name of function I need. In Qualculate it's called nth root and multiple root. So, any other recommendations? Andis For instance Andi Permadi wrote: Just change the x & y with Cell Address You have value of X in A2 and value ofY in B2 for the x^-y result just write = A2^-B2 it will result the value You need. On 29/01/07, Andis Lazdinsh <[EMAIL PROTECTED]> wrote: Hello! I need to calculate x ordinal square root in calc. I'm not sure, is this translation to English is right, but the formula could be =x^-y (this formula results in mistakeous number). I know this can be calculated easily with mathcad, but I think it should be possible to do this with calc, too. Any suggestions, how to do this calculation? Andis -- LVMI "SILAVA" Riga street 111 Salaspils, LV-2169 Phone: +37126595586 Fax: +3717901359 E-mail: [EMAIL PROTECTED] - 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] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Extended SQRT function in Calc
Hello! I need to calculate x ordinal square root in calc. I'm not sure, is this translation to English is right, but the formula could be =x^-y (this formula results in mistakeous number). I know this can be calculated easily with mathcad, but I think it should be possible to do this with calc, too. Any suggestions, how to do this calculation? Andis -- LVMI "SILAVA" Riga street 111 Salaspils, LV-2169 Phone: +37126595586 Fax: +3717901359 E-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Huge fonts in user interface
Hi! May be you can try Tools --> Options --> General (or something like this in upper corner, I have Ooo-dev tab) --> View --> User interface Scaling. Andis Dan H. wrote: Hello, I just upgraded from 1.2 to 2.0 (via upgrading my Debian Linux installation from sarge to etch), and I'm quite happy with everything except that Openoffice now insists on using gigantic fonts for the User Interface. Here's a screenshot (I deliberately left it at my original screen resolution of 1280x1024): http://www.nanoscience.de/group_r/members/dhaude/stuff/OO_hugefonts.png Apart from the fact that this just doesn't look good (to my young and sharp eyes), it just clogs up too much screen space. Sometimes you need to be able to see your document behind a "find" dialog... I also tried to completely deleting the .openoffice* folders in my home directory to exclude the possibility that OO misinterpreted something during the upgrade -- nothing. Thanks, --Dan - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Openoffice.org 2.0 crashes when Save as... or Eport as PDF... files opened from Krusader using command smb://
Hello! I have this problem with Openoffice.org 2.0 which comes together with Ubuntu Edgy installation. This is common and constant for writer and calc documents and may be for others, too. Command Document by E-mail ... works fine. Can anyone help with solution? Andis - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Help with OpenOffice.org
Hi! I'm using Netscape --> Mozilla --> Thunderbird from 90ths. I can remember some problems with certain extensions, especially with early Mozilla releases, which supported extensions, and I lost my profile information (not mail archive) several times. I had never problem like message disappearing you mention. It sounds like problem with server configuration or firewall settings. The only real problem for me working with Thunderbird + Sunbird is huge amount of memory they can consume. It's strange that tiny Sunbird can eats more RAM than openoffice.org, which at the same time do much more things. Andis Harold Fuchs wrote: This is very off topic but ... It lost my messages. None of the approximately 10-15 messages I sent to this group using Thunderbird ever arrived. As soon as I reverted to Outlook Express they started arriving again. I don't know how long you have been reading this list but you may remember I sent a series of "can you hear me, mother?" messages a couple of weeks or so ago; that was to check that my messages were starting to come through again after my experiment with Thunderbird. There are other more trivial things but losing messages is unacceptable. Harold Fuchs London, England - 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] Finding Text and Converting to Subscript
Hi! Chose Find & Replace... under Edit menu. Write text to change to subscript in both fields (Search for and Replace with), then click More options, press Format... and go to position tab, where you can chose subscript. Then press Replace All. The same could be done also for part of the document (feature which was not available in Microsoft Word, at least in past versions). Andis Rick Bilonick wrote: Is there any way to search for text and convert certain text to subscripts? Rick B. - 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] Thumbs Up
Hi! Totally agree. It will take years for every users to chose replacement for outlook, if something like outlook is not shipped with office suite or at least recommended and supported by openoffice.org. It's easy to estimate, how much time could take for every windows user visiting Mozilla, Evolution, anything else pages, reading feature lists, installing, configuring and removing all of these products (except one). Most of potential openoffice.org users are not able to do it, because lack of time, lingual barriers, lack of necessary computer knowladge etc. I'm not sure, but I think that majority of openoffice.org users comes from windows + microsoft office society and, if they decided for some reasons to switch to openoffice.org, I assume they wants completely replace their office applications at once and not to go through time consuming decision making process about certain programs. Sincerely Andis Dan, I think Mr Rieper here makes an important point, viz, that Microsoft markets these various functions as a package, and thus people seeking alternatives also tend to couple them together. This does not mean, however, that OOo should offer its own email alternative, which would be supererogatory in the extreme, but rather that it should recommend - and perhaps even provide relevant links to - such alternatives to, e g, Outlook as Thunderbird and/or Evolutions to new users. Remember that most people have been brought up on a (carefully constructed) Margaret-Thatcher view of computer software : TINS. The task is to show them that this is not, indeed, the case Henri - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] How to fix column headings in calc.
Hi! For the 1.question. Just like in Excel select row below headings and under Window chose Freeze. For the 2.question. First of all text formatting capabilities in openoffice.org calc are much better than in excel, even in new versions. I don't think it is possible to easily change background for certain words in 1 cell, you can change background for the whole cell by choosing icon Background color (move cursor over icons and if you have default settings you will see title of the icon. It is possible to change color of certain words or letters inside the cell by selecting those words or letters and pressing icon Font color (next to right side after Background color icon). There are also help texts available describing functions of these icons. Andis I used Microsoft Excel until I retired 11 years ago. I now have a need to use spreadsheets again and have downloaded the free version of Open Office. Generally I am finding it great but obviously there are differences. Some I am managing to work out but others prove refractory. 1.. On thing I would like to be able to do is to fix the column headings in a spreadsheet i.e. so that they stay at the top of the screen when I scroll down. Is it possible to do this please? It is something I used to be able to do in Excel. 2.. The second thing is an observation. I wanted to highlight text. I went to the Help facility and found a familiar icon (superscript ab with below a diagonal pen leading to a coloured line at the bottom). I could not find this icon on any of the toolbars in Calc. that I looked at (those that by name seemed relevant). By examining the icons on the Formatting Toolbar I soon found one with what looked like paint being poured from a pot. It highlighted any cell or selection of cells that I wanted but would not highlight a selection of words from a sentence in a cell. This is fine as you can do the latter by changing the text colour and I really wanted to colour the background to words as you would in a text document. I wonder if this information about the icon and how to use it in a spreadsheet could be included in the Help function? Or, maybe it is there but I was unable to find it. I notice that the familiar Icon that I found in help was in the Writer section. I had tried looking in several other highlight help areas but without success. Regards, Dave Potter D & SA Potter. 221 Borden Lane, Sittingbourne, Kent. ME9 8HR. Tel: +44 (0)1795 473302 Email: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Caption numbering on landscape pages
Hello! I never had such behavior by default, but may be something wrong with caption options. May be you can try press Options... in Caption dialog and select in Level box for all captions. Andis Graham Smith wrote: I have added a table to my document on a landscape page using the instructions in the help to set up a landscape page style, and then switch to landscape using the format paragraph dialog. However, when I try to caption this table, the numbering starts at 1 (it should be table 3). How do I get the captions to number sequentially in the landscape page. Many thanks, Graham - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] missing openofficeorg20.msi file to uninstall
Hi! Download that build (680m5) executable, unpack it somewhere by executing install file, then install newer version and when installer asks for openofficeorg20.msi file browse to location of unpacked 680m5 location. Development builds can be obtained from the same servers you can download stable builds of ooo or try to use emule or dc++ to find files you need. Andis Doug Austin wrote: Version:2.0.9073 OpenOffice.org 2.0 (en-US)(OOD680m5(Build:9073)) I am unable to install newer version until this version is uninstalled. Where can I access the openofficeorg20.msi for this version? - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Bibliography
Hi! I usually do it so, that I add all the unreferenced articles in separate page at the end of document, which is not printed later. Not vary nice solution, but it's useful, because references can be moved to other places in text if necessary. Other suggestion. I don't think it is good to add articles to bibliography list, if they are not referenced in text. At least in my country it would be vary big technical mistake leading to rewriting of thesis. In cases like yours I try to add some kind of recommended literature. Greetings! Andis David Pölz wrote: Hello im currently writing my diploma thesis. i have done my literature research and entered all the information to the references into the open office writer bibliography database. at the end of my thesis i want to add a listing of all my resarched literature that is in the database. it works really fine with the articles i have referenced in the thesis but i have some articles that are not referenced in the thesis. how do i get those into the bibliography listing? greeting David - 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] Calendar Capability?
Hi! I suggest you should try Mozilla Thunderbird with Lightning extension or separate Mozilla Sunbird application, as there are no plans anymore to introduce something like Outlook into openoffice.org. But openoffice.org is supporting development of Lightning, so may be in far future it will become useful product. At the moment I would recommend Sunbird + Thunderbird or any other e-mail client. Andis David B Teague wrote: Dan Lewis wrote: On Sunday 10 December 2006 11:04 pm, Camillo Iacoboni wrote: I am not sure what you mean by calendar capability? What specifically are you looking for? http://www.delewis.com/OOo/calendar.ods is a Calc file. It contains a macro which creates any month you want on one of its sheets. Perhaps this is what you want? Dan Dan Regarding file calendar.ods: I need to create a calendar for January through May but I do not know how to modify it so I can create such calendars. It seems to me that there must be an easy way to do this. Please tell me how to do so. David Teague - 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] Please help: Internal Error 2908 and error 1935.
Hi! May be try this http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=187071&SiteID=1 Andis Peter Leenders wrote: The solution from Dan Lewis didn't work. I don't have any anti-virus program, so that can't be the problem. I disconnected the computer from the internet and exit the windows firewall. But stil I can't install OpenOffice. Maybe somebody else has a solution?? Thanks, Peter Dan Lewis schreef:
Re: [users] More Odd Behavior - Is OOo Really Useable???
Hello! I remember this problem from ms office word 2000. First of all you have to check all your page and paragraph styles. There should be an option to insert blank pages before style or after. In ms word, for instance, the same behaviour occured when use insert page break in paragraph which have option page break before, like Heading 1 or something like this. Then it was vary complicated to find this issue. Other option you can try is to uncheck Print automatically inserted pages under writer print options (Tools - Options menu). Third, from my experience - using of frames, graphics and other things anchored to page, not as characters always leads to crash both in msoffice and openoffice (and openoffice is much more stable regarding this issue). Good luck! Andis Rick Bilonick wrote: On Tue, 2006-12-19 at 09:47 +, Harold Fuchs wrote: I'm not printing at all and I'm not changing printer drivers. I update all the indexes so that the Table of Contents, and all other tables of figures etc. are correct. I save this. There is a certain number of total pages, say 237. Then I export to a PDF. When you export to a PDF, it says at the bottom that it is repaginating (why, I don't know). When it does this it typically inserts blank pages at different places so that the total page count is larger than 237. Thus the pdf is created with all the indexes WRONG. I can't believe no one else has seen this. This happens on two different linux computers, one running FC5 (OOo 2.02) and the other running FC6 (OOo 2.04). I cannot get the PDF to be created without screwing up the indexes. This means that all the automatic features using fields for table of contents etc. are virtually useless. I need as the final output a pdf. I have no idea why this odd behavior occurs. I have used frames a lot (I've inserted each figure, table, and listing into it's own frame and captioned the frame - it makes it easier to move things around. Could the use a frames be the problem?) I have some very wide tables on landscape pages. It seems to want to insert pages before the landscape pages (but not just there at other places too). I'm beginning to think that OOo is not really useable - at least not for large documents. Rick B. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Help with installing enw fonts.
If you have linux, than spadmin is located under /opt/openoffice.org/program/ or /usr/lib/openoffice.org/program/ or something like this. By the way, you can locate this file using Search function. Andis Jay Bauman wrote: Hi All, I'm using OO 2.0.4. I'm trying to add some new fonts. I've followed the help directions in OO. But for one thing, I can't find the spadmin file/directory/program or whatever it is. Help. Regards Jay Bauman 021 215 9585 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] I am using version 2.1 of OpenOffice.org. My problem is format accuracy with MS Word
There are lot of utilities to export documents to pdf from any application. Check sourceforge.net. If you have ms word and complex documents to export, it's better to do it directly from ms word, not to user ooo writer. Otherwise, if you are using ooo, why to create doc files insted of using native ooo format, where are noramally no problems with pagination. Andis Glenn Seidman wrote: We are having a problem where we use the Open Office engine to render word documents into PDFs. We cannot get the PDF output to be precisely the same. The biggest issue is that pagination is different. Does anyone know what we can do to make the accuracy near-perfect or perhaps a set of fonts/styles/character attributes that will achieve very close or precise accuracy? Pagination is the most important and we don't want to put in manual page breaks. We also want to put in tables and 2-columns. How will this affect the accuracy? Thanks, Glenn _ Dr. Glenn Seidman Vice President, Product Development I-many, inc.
Re: [users] 2 axis climate graph
Hi! Open Office will not allow me to properly format a 2-axis climate graph for my students. I had to introduce excel to do this feature. Temprature should be on the left with a line graph. Precipitation should be on the right with a bar graph. When you format eaither data series to line or bar, it automaticlly place temperature into bar and precip into line. It should be the reverse. May be try to change order of the rows or columns before inserting chart and try other types of charts. It should be possible to change order of values in the chart. Any attempt to reverse this is futile. It also will not allow me to put a secondary axis label (precipitation) in? Any suggestions. Secondary axis also is possible. Select data set, right click on data set and chose object properties. Then chose options and check second axis. Other parameters as well as visual effects can be specified later. Andis - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Calendar Capability?
I think windows users which used to outlook or even staroffice 5.x PIM manager (like me) should try Thunderbird + Calendar extension. It consumes huge amount of memory, but it is useful. As an e-mail application it's much, much better than outlook and evolution. May be in some years we will be able also to create events directly from ooo window and attach ooo documents to events and tasks. I think the main problem is lack of relevant relpacement for outlook under windows, not component list of ooo. But without PIM manager it's impossible to switch to openoffice.org, so it should be developed anyway within or outside openoffice.org project. Andis Adam Williams wrote: The Windows port of Evolution is experimental and nothing resembling stable or complete. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] calc legend bug
There are lot of bugs in chart component, including this one. New charting program for ooo is under development. You can read more in relevant project page in ooo web site. Too many things to develop with too few resources. The only way to avoid wrong position and size of legend in charts is to make experiments withfont size and lenght of titles (shorter are usually better). Andis alexander indra wrote: hi robin try to resize the legend in your diagrams, it will not work even by right click on the legend and chosimg size and position. you can change the values but this will not have any meaning for the actual size. sascha - Original von: Robin Laing <[EMAIL PROTECTED]>: I have used calc for years and I don't know what you are talking about. Can you describe in more detail? Have you filed a bug? - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --- Versendet durch aonWebmail (webmail.aon.at) - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] outlook
I would recommend Mozilla thunderbird + Calendar or Lightning extension, if you are staying with windows. There are also plans to support development of these products within the scope of openoffice.org project. You will not get outlook functionality for personal information management, but you will get much better e-mail client. Evolution is a bit closer to outlook in functionality, but porting to windows is going vary slow and it isn't supported from Novell. Andis Ralph Gillis wrote: Is there an Open Office product that can replace msOutlook? ___ Ralph Gillis, AIA GILLIS PREVITI ARCHITECTS, PC 345 Seventh Avenue New York, NY 10001 212.243.5330 [EMAIL PROTECTED] www.gillispreviti.com <http://www.gillispreviti.com/>
Re: [users] Micrsoft Word Format
Another alternative is chose under File menu Send Email as Microsoft Word Of course, you should save changes before sending. Thus you can avoid wasting of disk space and your time. Andis Dan Lewis wrote: On Friday 24 November 2006 07:54 pm, Muhammad Abdullah wrote: From another member of this mailing list: I am still not experienced in OO Writer, but you can set the default "save" format in OO Writer via: to get one window, then and then scroll down in that window to "Load/Save - General," which opens up a window. Near the bottom are two small menu panes (left and right). Under the left one (document type), use the menu item "text document." Under the right pane "always save as," select either "Microsoft Word 97/2000/XP" or, if your teacher has an older or newer version of Microsoft Word, select one of the other Microsoft Word options. On any given document, however, you can "save as" another format if you wish - as a version of Word (.doc), rich text format (.rtf), Open Document Text (.odt), etc. I hope this helps.
Re: [users] Error: Invalid Name
I think you have to use =IF((AND(D2>5;C2>1));2;1). This should work. Andis BaX wrote: When I insert the following formula: =IF((AND(D2>5,C2>1)), 2,1) into a cell and press the Enter key, #NAME? appears in the cell and the error message at the bottom right of Calc indicates Error: Invalid name.
Re: [users] page count
You should enable Header under Format - Page menu, and then insert page number using Insert - Fields - Page Number. Andis [EMAIL PROTECTED] wrote: hi i am using open office version 2.0.4 with w98se and i think i am missing something, i would to get a page number in the upper right hand corner of a 10 page ducument ( 1, 2, 3 etc ) that my printer can print so pages don t get out of order , i don t see an easy command to click on like word 2000 has, what have i missed, all i get now is page one numbered but the next nine aren t ! Do you have simple instruction for me - thanks and your office is nice . . .
Re: [users] Calc, Sheet 1 / 3 yet only 2 sheets are visible?
It seems that you hide one sheet. You can get it visible using Format - Sheet - Show... (hopeful) Andis Kirill S. Palagin wrote: Hello. I had several cases where in status bar Calc shows "Sheet 1 / 3" yet just two sheets are visible (see attached screenshot, in case list filters it out it is also avail at http://www.mytempdir.com/1078756). Do I have 3 sheets in that .xls or Calc miscounts? I could post the file itself, but afraid of disclosing data. Thanks a lot. WBR, K. Palagin. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] crop
I don't know about availability of this function in impress, but in writer crop function is included in picture toolbar. Search cropping under help. This function is not vary nice to use so better to try image manipulating software instead. Andis Jim Berglund wrote: In the open office Impress (Powerpoint) I am looking for a visual tool that works to crop pictures inserted on slide. I know about the one where you fill in all the information but on powerpoint they also have one the you just click on points and it crops picture quickly. Is it in some different location? Also is there a way to enable the "ctl d" for duplicating objects, texts and slide as it is used in powerpoint? Would appreciate any response Thanks [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Switching from Outlook to Open Office
Thunderbird + Calendar extension (not supportet anymore by Mozilla) is something related to outlook, but it is not integrated with openoffice.org, so this part of outlook functionality will be loosed. The same about Ximian Evolution, in spite it is much more advanced as calendar application than Thunderbird Calendar or Lightning project. But Thunderbird is vary nice e-mail program, I think, the best one. About importing outlook data into Thunderbird: Import Outlook contacts - http://kb.mozillazine.org/Import_Outlook_contacts Import mail - http://kb.mozillazine.org/Importing_and_exporting_your_mail WENDY GADSON wrote: How easy is this process? I am VERY dependent on my Outlook database. Help?
