[users] Saving .xls to .csv with full precision for numbers
I have a spreadsheet with numbers like 71.08929399 which when save end up to be 71.09. I need to save all numbers in the exact precision in which they are stored. I'm using OOo 2.3 (Red Hat). I don't see any options to force this. Rick B. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Saving .xls to .csv with full precision for numbers
On Tue, 2008-05-06 at 10:46 -0400, James Knott wrote: Rick Bilonick wrote: I have a spreadsheet with numbers like 71.08929399 which when save end up to be 71.09. I need to save all numbers in the exact precision in which they are stored. I'm using OOo 2.3 (Red Hat). I don't see any options to force this. You can set up to 20 decimal places for a number. Is that sufficient? Also, if you're not doing calculations with that number, you could use the text format. The number 71.08929399 is what is actually in the .xls spreadsheet but only 2 decimal places display in the cell. When I save the spreadsheet to a .csv file, only 71.09 is saved. I want to always and automatically save the full precision to the .csv file (otherwise I'm inadvertently changing the contents). You say I can save up to 20 decimal places but you give ABSOLUTELY NO INFORMATION on how to do it. Using text format makes no sense. The data comes in a spreadsheet with 2 decimal places formatted for display. I want to keep ALL the real precision when saving to .csv. I don't want to round or truncate when saving to .csv. I can change the format for viewing but that is a real pain plus it makes viewing the spreadsheet difficult. There must be some way to force Calc to save all numbers with complete precision. I've looked through all the options and tried changing some but nothing I've done so far does the trick. Rick B. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Saving .xls to .csv with full precision for numbers
On Tue, 2008-05-06 at 17:04 +0100, Lisi Reisz wrote: On Tuesday 06 May 2008 15:56:40 Rick Bilonick wrote: The number 71.08929399 is what is actually in the .xls spreadsheet but only 2 decimal places display in the cell. When I save the spreadsheet to a .csv file, only 71.09 is saved. I want to always and automatically save the full precision to the .csv file (otherwise I'm inadvertently changing the contents). You say I can save up to 20 decimal places but you give ABSOLUTELY NO INFORMATION on how to do it. To change to more decimal places globally: Open a Calc page, then: Tools - Options - OpenOffice.org Calc - Calculate - Decimal places - choose your number (between 0 and 20) HTH Lisi It was already set to 12. It thus has no effect and doesn't solve this problem. I tried increasing earlier but it has NO effect whatsoever. Output is still rounded to 2 decimal places in the .csv file. Rick B. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Saving .xls to .csv with full precision for numbers
On Tue, 2008-05-06 at 11:16 -0400, James Knott wrote: Rick Bilonick wrote: On Tue, 2008-05-06 at 10:46 -0400, James Knott wrote: Rick Bilonick wrote: I have a spreadsheet with numbers like 71.08929399 which when save end up to be 71.09. I need to save all numbers in the exact precision in which they are stored. I'm using OOo 2.3 (Red Hat). I don't see any options to force this. You can set up to 20 decimal places for a number. Is that sufficient? Also, if you're not doing calculations with that number, you could use the text format. The number 71.08929399 is what is actually in the .xls spreadsheet but only 2 decimal places display in the cell. When I save the spreadsheet to a .csv file, only 71.09 is saved. I want to always and automatically save the full precision to the .csv file (otherwise I'm inadvertently changing the contents). You say I can save up to 20 decimal places but you give ABSOLUTELY NO INFORMATION on how to do it. When you format a cell or column, you choose number. On that panel is a spin box, where you can select the desired number of decimal places. When you save to CSV, it will included the specified number of decimal places. Using text format makes no sense. The data comes in a spreadsheet with 2 decimal places formatted for display. I want to keep ALL the real precision when saving to .csv. I don't want to round or truncate when saving to .csv. I can change the format for viewing but that is a real pain plus it makes viewing the spreadsheet difficult. There must be some way to force Calc to save all numbers with complete precision. I've looked through all the options and tried changing some but nothing I've done so far does the trick. Text formatting often makes sense, depending on what you're doing with the data. If you want to have a free form number, that would be what you'd use. Without knowing your requirements, I have no way to know if it would be suitable or not. I was simply offering it as a possibility. As an experiment, try saving both as a number, with a fixed number of decimal places and also as text. You'll find the fixed number of decimal places will result in some trailing zeros, if you don't use all the places. On the other hand, text will save the string exactly as you entered it, but with the addition of quotes. Which is better for you, depends on what you do with the data. Anthony Chilco pointed me to the problem. On the csv text filter panel, Save cell content as shown must not be checked. (Somehow it got checked either by upgrading or changing to the Red Hat version from the official OOo version.) By not having this checked, data is always saved at the full precision which is the only option one would want for importing the data to a statistics package as a csv file. Rick - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] I need to save in word 2003 doc
On Tue, 2008-02-26 at 14:47 -0600, Barbara Duprey wrote: James Knott wrote: Amy Issokson wrote: The prof requires it because there is and editing function that she has that only works with 2003.doc. Every format I have tried to submit has not worked with her editing software. Couldn't your instructor just open your .doc file and save it out in the format she wants? Then run whatever she wants on it? Rick B. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Filling in blank cells in calc with 0s
On Mon, 2007-10-01 at 14:58 +0100, Brian Barker wrote: At 14:18 01/10/2007 +0200, Lars Forseth wrote: I have this problem: I get text files from various programs which I want to use in various statistics programs; like WinBASP, PAST or R. Sometimes these files contain blank fields; ie when I import them in calc there are blank cells, (nodata). Some of the statistics software does not like this; and I would like to change the blank cells to 0. I would like to use calc for this because it is also nice to be able to use these files in a spreadsheet. Does anyone have a solution to suggest? I have googled the problem, but got no obvious solution. Sine the data are in several columns some sort of use of matrix and IF and ISBLANK functions is probably necessary, but I am stuck. I do not program in Basic, but can handle simple tasks in Python o Enter zero into a spare cell somewhere. o Copy that cell to the clipboard. o Now select all your original data and use Edit | Paste Special... (or right-click | Paste Special... or just Ctrl+Shift+V) to paste this zero over it. In the Paste Special dialogue, select Add under Operations; also remove the tick from Paste all if necessary, and then make sure that Formats is not ticked but Numbers is. This has the effect of adding zero to all your values, but will have the incidental effect of changing any blank cell to an explicit zero. If all your values are numbers or text, you don't have to worry about Formats not being ticked, in fact: this is necessary only to avoid corrupting any date values there may be. I trust this helps. Brian Barker I use OOo Calc all the time to convert .xls files to .csv files for input to R. Blank cells are AUTOMATICALLY assumed to be NA's when the .csv file is input to R. If your blank cells really represent no data or not available (i.e., missing data), then you DON'T want to change them to zero Changing missing data to zero will definitely screw up the computations. (A missing value is unknown and you can't assume it's zero or any other particular value. How missing values are handled will depend on the statistical methodology.) Rick B. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Installing Extensions
I'm running OOo 2.2.1 under Fedora Core 6. I've downloaded several extensions from the OOo extension web site (Multiple Pages,DocConverter). They are zip files. I've opened extension manager and added the zip files under My Extensions but OOo won't let me enable them. I've tried unzipping them first and then adding them but that doesn't work either. I've also tried to do this as root but still no luck. I was able to install ExtendedPDF several months ago but I can't install other extensions now in 2.2.1. Any suggestions? Rick B. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Greek Letters Missing in OOo 2.2.1??
I installed 2.2.1 about 2 weeks ago (on FC6) and just noticed that Greek letters don't display correctly (or at all) in formula objects (Math). Has anyone else noticed this and is there any way to fix this? I just checked and there is no open symbol font in 2.2.1 (at least, not my version). There used to be. There is a standard symbol. Rick B. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Greek Letters Missing in OOo 2.2.1??
On Wed, 2007-08-01 at 15:52 -0400, Rick Bilonick wrote: I installed 2.2.1 about 2 weeks ago (on FC6) and just noticed that Greek letters don't display correctly (or at all) in formula objects (Math). Has anyone else noticed this and is there any way to fix this? I just checked and there is no open symbol font in 2.2.1 (at least, not my version). There used to be. There is a standard symbol. Rick B. What is really weird is if I run OOo 2.2.1 from the root account, the open symbol font is visible in the list and the formulas work correctly. This would seem to suggest a problem with permissions but which ones? Rick B. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Desktop Integration for FC6
I'm using FC6 - a standard installation which I believe uses Gnome. I also installed KDE. I installed an earlier version of OOo 2.2 from the OOo website and start it from the command line. I want to install the current 2.2 and have it integrated into the desktop. There are two rpms - one is kde and the other is redhat. In the past I've tried both but neither seems to do the desktop integration. Which one should work? (When I installed 2.1 I had to go into the icons and change which files they were pointing to. I'm trying to get this to work automatically. Rick B. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Re: Windows Vista and Open Office?
On Fri, 2007-03-30 at 22:03 -0600, jimw wagner wrote: My problem in this regard will be slightly different; when I finally retire my old machine and get a new one, I'll probably still have to pay the Windows tax for the inclusion of a system I'll scrub pretty well immediately. JimW Why not just buy a computer without an operating system? The last three computers I bought over the last five years did not include an OS. It's also easy enough to assemble your own but there are plenty of companies that provide them already assembled. Rick B. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Merging PS FIles - Any Suggestions for Utility Programs?
I'm using OOo 2.1 and 2.2 on a FC6 pc. It has been a long hard road, although I've learned a lot. I took my original large document (about 400 pages) and broke it into sections, and then used a master document to tie it all together (using the same template for everything). Of course, it didn't work (even though all the parts look perfect, the TOC is all screwed up - page numbers don't match sections, the figure references get altered (no longer pointing to the right figure - even though the figure captions haven't changed) and the odd blank page gets inserted just for good measure to further screw up the TOC etc. At least I have all the separate parts that I can create nice pdf's from (using ps2pdf [from the saved Postscript printed to a file] given that there is still an unresolved bug with OOo directly making pdf's with the font I chose at the beginning). BTW, I given the TOC etc were all screwed up, I made copies of all the separate parts and created separate TOCS, index of figures, etc. for each part (and used hidden sections to hide these elements), and then copied all the pieces so I had one perfect TOC etc. (This was labor intensive but all the references are correct.) For each part, I set the starting page number, figure number, table number, etc. (I made a spreadsheet to figure out what these values were to keep it all straight.) I sort of figured the master document approach would not work given all the problems I've had (including difficulty in placing figures/frames, and on and on). So I figured I could always use psmerge to combine all the parts into one big Postscript file and then use ps2pdf on it. I tried using psmerge with a couple of parts early on just to see if it would work and I swear it looked like it worked fine. But of course, when I used it to tie togther all 21 Postscript parts, it turns out that psmerge screws up the fonts - terribly (figure and table references turn to Courier, etc.). (The only thing that psmerge warns about is making sure you use the same application to make all the Postscript files that are to be merged - which of course I did,) Does anyone know of another program to merge Postscript files that won't screw up the fonts? Or, say combine pdf's? It would be nice to have everything in one file (although I'm sort of resigned to having 7 pdf's). Rick B. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] extendedPDF
Has anyone gotten extendedPDF add-on to work with OOo 2.1 or 2.2? I used the extension manager to install extendedPDF 1.4 (the zip file). It shows it enabled (along with IannzFindFiles). But it doesn't show up under Add-Ons (only IannzFindFiles shows up). I've exited OOo and restarted it, I've uninstalled and re-installed, and I also tried 1.3 but it never appears. Any ideas on what I'm doing wrong? Rick B. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Merging PS FIles - Any Suggestions for Utility Programs?
Does anyone know of another program to merge Postscript files that won't screw up the fonts? Or, say combine pdf's? It would be nice to have everything in one file (although I'm sort of resigned to having 7 pdf's). Rick B. A kind user e-mailed me and suggested just concatenating the PS files. I didn't think the solution was so simple. I just used something like: cat a.ps b.ps c.ps out.ps ps2pdf out.ps Seems to have worked perfectly - I haven't found any font problems. Rick B. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Blocks of Text
The first part of your question might be better handled with a Frame which is similar to a Text Box in a well known brand X word processor ;-) I have to say I've only done minimal testing so you may find this has drawbacks too. The second part can, I think, be handled by selecting the PM2.5 and (by treating it as a paragraph) doing the do not split paragraph trick I described above. -- Harold Fuchs London, England Please reply *only* to users@openoffice.org I've resigned myself to using a 1x1 table cell for the text block. I do see that the do not split paragraph in Paragraph when applied to the highlighted text does work exactly as I need. Thanks. Rick B. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Keeping Letters Together
On Thu, 2007-03-15 at 08:40 +, Harold Fuchs wrote: On 03/03/07, Rick Bilonick [EMAIL PROTECTED] wrote: I have a Greek letter with a subscript. Sometimes at the end of a line, the subscript will move to the next line. For example, instead of s1 (where s is sigma), I get: s 1 How can I keep these together on the same line? It must be something simple I'm missing. Rick B. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] I think that this might work: Select the characters you want kept together; ensure there is at least one [unselected] space before them Go to FormatParagraphText Flow In the Options section, click Do not split paragraph. This will cause the selected characters to move as a unit when there is no longer room on the line to hold all of them. Of course, the line has to be long enough to take all of them; if it isn't, Writer will have no choice but to split them. If you need to do this a lot, you should be able to create a template (or modify your default template) that contains a named style that has this Text Flow attribute and then simply select that style as and when. Thank you! This is exactly what I needed to know. I had thought of using this but ruled it out without trying it because I thought it would apply somehow to the WHOLE paragraph the text was in. Rick B. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Blocks of Text
On Wed, 2007-03-14 at 00:32 +, Harold Fuchs wrote: Rick Bilonick wrote: Is there any way in OOo to create a block of text? I want the text to be treated like it was a paragraph, sort of. I don't want it to split across pages. I guess I could put it into a single table cell and not show the borders but maybe there is a simpler way to do this. Rick B. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Select the paragraph and then I think that FormatParagraphText Flow and then check Do not split paragraph is what you need. Sorry, I guess I wasn't clear enough. The text that I want to treat as a block includes more than one paragraph. For example, I have programming code pasted from somewhere else. Each line is a new paragraph. I can format each line to keep with the next paragraph, but this does not work well (if only because the keep with next paragraph seems to get turned off when the text moves. The only way I can see doing this is to use a 1x1 table. I also would love to know how to keep text together (e.g., PM2.5 where the 2.5 is a subscript) and not break at the end of a line into PM on one line and 2.5 on the next or some other variant. Rick B. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Re: Keeping Letters Together
On Wed, 2007-03-07 at 15:27 -0500, Jim Allan wrote: Rick Bilonick wrote: I have a Greek letter with a subscript. Sometimes at the end of a line, the subscript will move to the next line. For example, instead of s1 (where s is sigma), I get: s 1 How can I keep these together on the same line? It must be something simple I'm missing. Inserting a Unicode no-width no break character should work. This is Unicode character U+2060 which is defined to act as glue to stick adjoining characters together. You can insert this through the menu Insert - Formatting Mark - No-width no break or by pressing ALT+I G B. Jallan - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Just saw your post. Thanks but my menus in 2.1 don't have Insert - Formatting Mark - No-width no break and ALT+I G B doesn't seem to work. What am I doing wrong? Is there some way to directly insert U +2060? Rick B. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Blocks of Text
Is there any way in OOo to create a block of text? I want the text to be treated like it was a paragraph, sort of. I don't want it to split across pages. I guess I could put it into a single table cell and not show the borders but maybe there is a simpler way to do this. Rick B. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Keeping Letters Together
I have a Greek letter with a subscript. Sometimes at the end of a line, the subscript will move to the next line. For example, instead of s1 (where s is sigma), I get: s 1 How can I keep these together on the same line? It must be something simple I'm missing. Rick B. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Keeping Letters Together
On Sat, 2007-03-03 at 09:30 -0500, Rick Bilonick wrote: I have a Greek letter with a subscript. Sometimes at the end of a line, the subscript will move to the next line. For example, instead of s1 (where s is sigma), I get: s 1 How can I keep these together on the same line? It must be something simple I'm missing. Rick B. For some reason, OOo doesn't see s1 as a word. I tried Format/Character/Font and setting language to none but it has no effect. This is supposed to prevent hyphenation but then this isn't really hyphenation to begin with. Any way to prevent this behavior? It would be a pain to have to insert a formula object everywhere. Rick B. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Figure Numbering in References Is Wrong
I've created a subdocument. The Figures start at 1 in the subdocument. The references in the text match up with the figures (reference to figure 1 matches with figure 1, etc.) When I insert the subdocument into the master document, the numbering is completely screwed up for the references in the text when viewed in the master yet the actual figure numbering is correct. The first figure reference in the subdocument starts at 34 when it should start at 8. I can't see where this is going wrong. I have other subducuments in which the figure numbering is correct. How can I fix this? The table numbering and referecnes in the text are correct. Is there any to figure out what is going wrong and fix it? Rick B. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Inserting Subdocuments into a Master Page Formatting
I've read the master document guide and tried to follow the examples but I can't get it to work for my documents. I used the same template for the master and all the subdocuments. When I insert the first subdocument (after setting up the master document with a title page etc.), I can see the subdocument section line at the top of the subdocument and the text (one paragraph - a single empty line) at the top of the page. (The first subdocument I'm inserting is actually the last subdocument - I'm following the guide's approach.) The first page of the subdoc has a first chapter page format and the following pages of the subdocument have just a chapter page format (the headers and footers differ). When I insert the next subdocument, I lose this text area which causes the first chapter page format to change to just the chapter page format. I can't get this to work.The same problem occurs with the newly inserted subdoc. What am I missing? Rick B. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Preventing Frames From Overlapping
I use frames a lot (to hold pics and I caption the frame). I typically anchor the frames to character and set text flow on and no wrap. The documents often have a large number of frames/figures compared to text. Is there any way to absolutely forbid frames from overlapping each other? (The no wrap apparently only applies to text.) I've tried placing pics in table cells and this certainly prevents overlap but has its own set of drawbacks (e.g., you can't have text flow around the figure - you have to place figures between paragraphs). All I want is a reasonable placement of the figures in the text. (I can imagine there might be times you would want one frame to overlap another but that would seem to be the exception.) Rick B. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] no suitable windowing system found, exiting
I'm trying to install OOo 2.1 on FC5 on a 64-bit Athlon system. I get: no suitable windowing system found, exiting I included the redhat rpm for desktop integration. How can I get OOo to run? Rick B. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Re: Rotating a Table
On Sat, 2007-02-10 at 12:03 +, Andy Lewis wrote: Rick Bilonick wrote: Is it possible to rotate a table 90 degrees to better fit on a portrait page? This would seem to be easier than using a landscape page and trying to get the header and footer right. Also, I don't see that text can flow from a portrait page to a landscape page. Rick B. You can place the table inside a frame, and then rotate the frame by 90 degrees. (Format-Frame-Options tab-drop down box at bottom.) Andy Thanks but I don't see an option that says rotate. The only thing I see is Text direction with an option Right-to-left (vertical) but that doesn't rotate the frame. What am I missing? Rick B. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Re: Rotating a Table
That's the correct option. It does rotate the frame (at least it does on my machine!) Did you put some text or a table in the frame first, to observe the effect? Andy - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Yes. I took a copy of an existing table. I did select Right-to-left (vertical) and also rotated the text 270 degrees (I had to do both before it looked somewhat reasonable). But things work very strangely. I was able with a lot of effort to get the table so that it looks OK. I had to do a lot of manual adjustment (row heights and column widths did not translate as you would expect - several columns that were on the right seemed to disappear but after adjusting the table width they reappeared). The only thing it won't do is flow text from one line to the next. For example, I have to have the columns (now running horizontally) very wide - otherwise the text is cut off - it won't flow to the next line down. The other major problem is the orientation of the table. I need it to be left-to-right vertical but that is not an option. (Wouldn't left-to-right vertical be more natural? I want the left hand side to start at the bottom and then the first row be on the left and the last row on the right. Although I notice that book titles along the spine are oriented right-to-left vertical.) Any thoughts on fixing the text flow to the next line? Most of my tables have titles that need to occupy several lines within the cell. I tried also pasting the frame with table into Draw. I was amazed that this even worked BUT it won't let you rotate the frame (as it will with a figure although I haven't tried a frame with a pictue). Thanks. Rick B. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Re: Rotating a Table
On Sat, 2007-02-10 at 17:30 +0100, Marc Hug wrote: Once you have inserted the frame, select Format Frame Options, and then open the line at the bottom (right). You will have to select one from 4 lines. I did it, and it works... (I cannot tell you the exact formulations, because I am using the French version); Marc H. Rick Bilonick a écrit : On Sat, 2007-02-10 at 12:03 +, Andy Lewis wrote: Rick Bilonick wrote: Thanks. Someone else mentioned this. The only option that will do this is Right-to-left (vertical) (there is no Left-to-right (vertical) unfortunately) plus you have to rotate the text 270 degrees. That's the only way I obtained something barely usable as a table (column widths in particular were weird - some columns did not display without manual adjustment of the entire table width). I needed to manually fix a lot of things and it doesn't seem to handle long text very well (it just cuts it off and displays a red arrow instead of wrapping to the next line). There has to be a more sensible way for OOo to rotate a table 90 degrees. I checked and you cannot rotate the frame in Draw (even though you can paste the frame with table into Draw). Rick B. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Re: Rotating a Table
On Sat, 2007-02-10 at 17:59 +, Andy Lewis wrote: Yes. I took a copy of an existing table. I did select Right-to-left (vertical) and also rotated the text 270 degrees (I had to do both before it looked somewhat reasonable). Hmm - this is strange - I don't need to rotate the text as well - just selecting right-to-left (vertical) for the frame rotates the text for me. OK, I found the problem. For some reason, the table I was experimenting with had Left-to-right instead of superordinate - superordinate says to follow the style of the container (in this case, the frame - I never knew what superordinate meant until today). When I changed the table to superordinate, then pasted it into the frame, and then changed the frame to Right-to-left (vertical) it worked much more nicely. Thanks for helping me work this out. Rick - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Rotating a Table
Is it possible to rotate a table 90 degrees to better fit on a portrait page? This would seem to be easier than using a landscape page and trying to get the header and footer right. Also, I don't see that text can flow from a portrait page to a landscape page. Rick B. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Re: Disappearing Pictures
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 swear that this problem is connected to TOC insertion but it only seems to happen in documents I use a TOC and the document can be just a few pages. I opened an issue about the disappearing graphics and they have requested me to send my document. My document is confidential at the moment so I'm hoping I can count on them not to disclose the document. I'm not sure whether I should try to change all the graphics to links and/or to try to split the document into chapters and then use a master document approach. I'm not sure if any of this will help. Rick B. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Disappearing Pictures
On Sun, 2007-02-04 at 08:48 +0100, Hagar de l'Est wrote: The pics have DISAPPEARED - nowhere to be found in the document. Upon further investigation if I click where the picture USED TO BE, an outline appears and I can bring up the picture panel. If I go to the picture panel it shows a thumbnail of the picture BUT THE PICTURE DOES NOT DISPLAY AT ALL (plus the caption is now at the top of the pic instead of at the bottom where it was originally). Even modifying the size % doesn't improve the situation ? If you copy the file, open it with an archive manager and look into the /Pictures folder, do you see your pics ? If not, then, bad luck. WHY would a pic inserted in a frame JUST disappear from the document? The pic was anchored to the frame. Pics disappearing from frames they are anchored to appears to happen randomly BUT OFTEN enough to be of concern. The pic is there in a way but won't display on screen or when printed or output to a pdf. For pictures, I think that the more robust method is to insert them in a table, this way, there is no wrapping/anchoring issue with text. Note that a caption automatically inserts a frame around the picture. Inserting a picture in a frame and again in another frame may lead to problems. Do you save in .odt or .doc ? There ARE problems with pictures in frames for .doc. Hagar. 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. If you select autocaption, I believe it does the same thing. 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? Also, I'm only using .odt files. 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. Rick - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Re: Disappearing Pictures
On Sun, 2007-02-04 at 18:38 -0800, Tim Wescott wrote: Rick Bilonick wrote: I'm using OOo 2.1 on Fedora 6 (using the OOo site 2.1 not Fedora's rpms). This is an ongoing saga working with a 350 page document. Just when I think I understand how OOo works, it surprises (and disappoints) me. I have a large number of pictures, most if not all inserted into frames and I've captioned the frames. Every time I make major revisions, I save to a new file for that version. I've had to pin down most of the frames to keep them from stacking over each other (using the lock position, size, and contents). I moved a number of frames to different locations. Then did a page preview only to see that 4 frames with pics I never moved (nearer the beginning of the document - the ones I moved around were nearer the end) - the pictures disappeared. The captions remained but the pics were gone. I had to copy the pics back in from an earlier version. Does anyone have an idea WHY this would happen? What could I have done or OOo done to cause this? I recall having that problem. I was able to work around that by saving pictures as a link to a file that I kept with the document. This worked well enough to let me publish a book (http://www.wescottdesign.com/actfes/actfes.html), but it's not the best answer to the problem. This problem seemed to go away with OOo 2.0 -- you should file a bug if it's still an issue. Well it's definitely a problem with 2.1. It's happened at least 3 times on different occasions. I did file a bug report. You are saying that this does not happen with links. If that is the case, maybe I should take the time to change all the pictures to links. The problem is that there are over 90 pictures. I wish I knew this when I started. I didn't use links because there were/are problems if you should export to a .doc file. Fortunately, I'm not planning on doing that. Thanks for the input. Sometimes it seems I'm the only one that experiences bizarre problems with OOo. (Maybe it's because I invariably push software to the limit.) Rick B. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Disappearing Pictures
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]
Re: [users] Disappearing Pictures
On Mon, 2007-02-05 at 07:58 +0200, Andis Lazdinsh wrote: 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 OK, I appreciate the help. I'm not sure which help document (or help system) you mean. I'm not inserting pics into two frames - just one. I caption the frame. But from what you say it's probably better to use the table approach since the document is so big and the memory is limited. I will be going through my document and switching to tables. Do you think it's better to embed the graphics or link them? Thanks. Rick B. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: [users] Disappearing Pictures
On Fri, 2007-02-02 at 15:08 +0100, Joe Grech wrote: Rt click on the pict; from the dialogue box that appears choose: anchor: to page (or to paragraph if it is more appropriate). I'm not sure what problem this is repsonse is supposed to fix! If you read what I sent, doesn't seem to apply at all. The pics have DISAPPEARED - nowhere to be found in the document. Upon further investigation if I click where the picture USED TO BE, an outline appears and I can bring up the picture panel. If I go to the picture panel it shows a thumbnail of the picture BUT THE PICTURE DOES NOT DISPLAY AT ALL (plus the caption is now at the top of the pic instead of at the bottom where it was originally). WHY would a pic inserted in a frame JUST disappear from the document? The pic was anchored to the frame. Pics disappearing from frames they are anchored to appears to happen randomly BUT OFTEN enough to be of concern. The pic is there in a way but won't display on screen or when printed or output to a pdf. Rick B. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Disappearing Pictures
I'm using OOo 2.1 on Fedora 6 (using the OOo site 2.1 not Fedora's rpms). This is an ongoing saga working with a 350 page document. Just when I think I understand how OOo works, it surprises (and disappoints) me. I have a large number of pictures, most if not all inserted into frames and I've captioned the frames. Every time I make major revisions, I save to a new file for that version. I've had to pin down most of the frames to keep them from stacking over each other (using the lock position, size, and contents). I moved a number of frames to different locations. Then did a page preview only to see that 4 frames with pics I never moved (nearer the beginning of the document - the ones I moved around were nearer the end) - the pictures disappeared. The captions remained but the pics were gone. I had to copy the pics back in from an earlier version. Does anyone have an idea WHY this would happen? What could I have done or OOo done to cause this? Rick B. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Navigation Headings - Heading 1 Has Disappeared from the Navigator Outline
On Sun, 2007-01-28 at 23:32 -0800, Hagar de l'Est wrote: From 2.1, there have been changes to avoid some problems between styles and outline numbering. Now, you cannot have a Bullet/Numbering style together with the Outline Numbering feature (from menu Tools...). If you apply a numbering style (in the 'Numbering' tab of the Heading paragraph style), it removes the style from its outline level. You've to set the heading back to its level in the ToolsOutline Numbering dialog. It will automatically remove the numbering style. Then, modify the field 'Before' in the dialog, it may be here (but spaces in such fields are invisible ! Hagar. Thanks. This fixed the problem. Rick B. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Navigation Headings - Heading 1 Has Disappeared from the Navigator Outline
I'm using OOo 2.1 on Fedora 6. I'm using heading 1 paragraph style for headings. Usually, these show up nicely under Headings in the navigator display (shows headings, tables, frames, graphics, etc.). This makes it easy to jump from heading to heading. I created a new document from an older document and applied the paragraph heading style to some headings that had no applied style. For some reason, the headings had a space as the first character I could not get rid of unless I turned numbering off by editing heading 1's paragraph style. However, doing this caused all the headings to disappear from the navigator outline. I've looked at every option for paragraph style but CANNOT get the headings to re-appear in the navigator outline (the outline level of the navigator is at 10 - heading 2 headings show up in the navigator outline). I'm not sure what is going on. I've been trying to use styles extensively and have used the navigator to move around other documents without any problems. Any idea how I can fix this document or what is going on? Rick B. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Finding Text and Converting to Subscript
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]
Re: [users] OOo PDF Output Now Screwed Up!
On Mon, 2007-01-08 at 21:42 -0800, TerryJ wrote: Rick Bilonick wrote: I'm running FC6 (newly installed and up-to-date) and OOo 2.1 from OOo website (not fc6 rpms). When I create a pdf from the document in OOo, the kerning of adjacent letters is bad, and there are other font-type problems. This shows clearly in acroread and kpdf (so it's not acroread). If I print to a file and convert the postscript file to a pdf using ps2pdf, everything looks perfect. What is wrong with OOo or my setup? Rick B. P.S. I thought things had improved with OOo 2.1 from other paginationa/ pdf problems I was having using 2.02 or 2.04 on FC4, FC5 and FC6 but there are still strange problems. Rick, it must be clear by now that the software is a work in progress. I understand that good results can be obtained with Extended PDF. IIRC, Andrew Pitonyak uses it to convert his massive macro document to pdf. I consult the pdf version of his document in preference to the Writer version. The link is http://www.ooomacros.org/user.php#102785 Thanks. I will try it. At least I know I can use ps2pdf. I'm not sure why OOo's pdf converter would mess up spacing of some letters. Most of it looks fine but on every other page the letter spacing in one or two places is noticeably wrong. Rick B. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] OOo PDF Output Now Screwed Up!
I'm running FC6 (newly installed and up-to-date) and OOo 2.1 from OOo website (not fc6 rpms). When I create a pdf from the document in OOo, the kerning of adjacent letters is bad, and there are other font-type problems. This shows clearly in acroread and kpdf (so it's not acroread). If I print to a file and convert the postscript file to a pdf using ps2pdf, everything looks perfect. What is wrong with OOo or my setup? Rick B. P.S. I thought things had improved with OOo 2.1 from other paginationa/ pdf problems I was having using 2.02 or 2.04 on FC4, FC5 and FC6 but there are still strange problems. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Converting PDF's to Something that can be imported into OOo
On Tue, 2007-01-02 at 16:30 +1000, Adrian Try wrote: Hi Rick Thanks. But all I need is a way to convert from postscript to eps. Solid Converter appears to work only on windows (not really clear on the web site). I need something I can use on Linux (which I should have emphasized). KWord (part of KOffice) can open PDF files and save in OpenDocument format. It might be what you're looking for. Adrian Thanks. This sounds exactly what I'm looking for - it would be easier than using ps2eps, fixing the missing bounding box (not sure why the ps2eps has a problem with the postscript I've created from the pdfs), and then inserting in an .odt file. I will give it a try. Rick B. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Converting PDF's to Something that can be imported into OOo
On Tue, 2007-01-02 at 01:11 -0500, Rick Bilonick wrote: Solid Converter PDF www.solidpdf.com/ Not free, but very capable. Douglas Hinds Thanks. But all I need is a way to convert from postscript to eps. Solid Converter appears to work only on windows (not really clear on the web site). I need something I can use on Linux (which I should have emphasized). Rick I did find ps2eps - this seems to do a great job and it has a lot of options. It finds all the problems in the Postscript code (if any) and can fix them. ps2pdf then works better. Rick B. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Converting PDF's to Something that can be imported into OOo
Solid Converter PDF www.solidpdf.com/ Not free, but very capable. Douglas Hinds Thanks. But all I need is a way to convert from postscript to eps. Solid Converter appears to work only on windows (not really clear on the web site). I need something I can use on Linux (which I should have emphasized). Rick B. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Solution to OOo's Goofy PDF Pagination Problem
On Thu, 2006-12-21 at 20:26 +0100, Mathias Bauer wrote: Rick Bilonick wrote: I've described recently OOo's nasty pagination problem when exporting to a PDF when dealing with large documents (200 pages). Why OOo finds it necessary to repaginate a paginated document when creating a PDF I have no idea. I tried everything I could think of within OOo (trying the Tools Update menu in various ways) but nothing prevents OOo from screwing up all the indexes (like the Table of Contents) once it changes the total no. of pages by inserting blank pages willy nilly. Most probably your problem is not a matter of the size of the document. OOo does not have a problem with large documents. I assume that your problem is what we call a layout loop. Sometimes complex formatting can lead to an object (a paragraph, a frame, a graphic etc.) moving around between two pages in each iteration step of the layouter. To avoid an endless formatting loop OOo breaks this loop at some time. It is possible that the result of the procedure can leave to different results depending on the device of the action done before. So it is possible that layouting the document for printing, for the screen or for PDF leads to slightly different layouts. If we could identify the particular problem in your document I'm pretty sure that the problem would persist if you removed most of the other pages that are not part of the problem. The best thing would be that you created an issue and attached your document to it (if possible). Ciao, Mathias You are probably correct - but I'm not sure how to find exactly what is causing the problem. The document now is about 320 pages (8.8 mb). I've found a way to get correct indexing of chapters, tables, figures, etc. and export to a pdf file. Here is what consistently works: 1) Do an Tools - Update - All Indexes and Tables 2) Print to File - creates an postscript file (does not repaginate) 3) Use ps2pdf This creates a pdf where the indexing is correct. This so far has always worked. I'm not sure why pdf export insists on repaginating. Several people suggested turning of blank page insertion - I did this in Options (two different Print panels) and also in pdf export - it made no difference at all. Someone else suggested using the official OOo rpms and not Fedora Core ones. I removed the Fedora Core rpms and install the official rpms for 2.1. It's spifier with more options and the menu icons are correct (not like the someowhat screwed up Fedora Core menus) - but it makes no difference - still same pagination problem. The same behavior happens on FC6 on a 32 bit laptop and a 64 bit desktop (the laptop is running 2.1 now and the desktop is 2.02 - but also occurred with 2.04 Fedora Core rpms on the laptop). At the moment I can't send the document to anyone - but maybe I can in the near future. The material will be in the public domain but I can't release it quite yet. I'm going though and trying to simplify and rationalize the output. I'm sure this behavior is somewhat connected to my inexperience with OOo. I've learned a lot about templates and styles but figure placement is a problem especially when there are more figures than text - I don't understand the best way to anchor figures - they end up in weird places (OOo should know better - you don't want figures in the margins, for example). Regardless, it would make more sense that indexing be automatically performed AFTER any repagination takes place and before any output occurs. Rick - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Converting PDF's to Something that can be imported into OOo
I have several muli-page pdf's that I need to incorporate into my document. I've tried this: 1) Print out each page separately to separate postscript files from acroread 2) Use ps2epsi to convert to eps files with previews - they have .epsi extensions 3) Remove the previews (prolog info and the trailer lines 4) Rename file to .eps so OOo can see it This allows me to insert the eps file into OOo and it looks just like it should and I can export a viewable pdf. But I need to print the document to a postscript file and then use ps2pdf to convert it to a pdf file (it's the only consistent way I can obtain a pdf with correct indexing of pages - see my other posts on this). Unfortunately, ps2pdf doesn't produce a viewable pdf using the steps above. ps2pdf does not report any errors but acroread won't display the file. Possibly I'm not removing the preview correctly. I haven't found a program that would allow me to convert from ps directly to eps (the only program I found is ps2epsi). Any suggestions would be appreciated. Rick B. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Reverse order printing
On Wed, 2006-12-20 at 22:36 -0600, Philip Spray wrote: Another problem: I would like to print a document with headers like a dictionary, where the header changes from page to page, or at least chapter to chapter. The only way I can think to do it is to make each chapter a separate document. Making it do the header changes automatically would be nice but that is not really necessary. If the header could be set to a this point forward it would function. However, altering the header does it both forward and backward. :( -- Phil For different headers on different pages you could set up different page styles. If you want to put the chapter heading in the footer, you could instead use the same page style throughout but use paragraph styles to link the chapter headings to a field in the header. There are tutorials on using styles and headers on the Internet. There is no reason to use separate documents (although you can have a master document with links to other documents). Rick B - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] More Odd Behavior - Is OOo Really Useable???
On Tue, 2006-12-19 at 09:47 +, Harold Fuchs wrote: On Monday, December 18, 2006 1:56 PM [GMT+1=CET], Rick Bilonick [EMAIL PROTECTED] wrote: I'm using OOo 2.02 on a 64-bit Athlon system running FC5. Now I've noticed that in page preview, it shows a total of 239 pages even though in regular mode for editing it shows a total of 238 pages. It seems that the page numbering changes every time I open the file. Without adding or deleting any material, the total no. of pages jumps around from 237 to 239. I notice when I hit page preview, it says it is repaginating at the bottom of the window. Should I always do a page preview before saving? When is it necessary to do an update all under the Tools menu? I just tried an update and the total number of pages changed to 236. I scrolled to look at the pages and now the total is reported as 239. Scrolled again now it shows 240 and looking at the last page it says 240. Now page preview says 240 also. I don't understand how just scrolling without making any changes, changes the pagination. I don't understand why the page numbering keeps changing without changing the document. Rick It shouldn't matter but do you from time to time use different page sizes in different applications? Or different printers with different margin requirements? In other words, is the [effective] page size being changed underneath OOo which then OOo notices and repaginates your document to fit? I have seen this with MS Word in the past but never got to the bottom of it. In those cases I was *not* using different [effective] page sizes. Otherwise, stumped. Harold Fuchs London, England 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]
[users] Solution to OOo's Goofy PDF Pagination Problem
I've described recently OOo's nasty pagination problem when exporting to a PDF when dealing with large documents (200 pages). Why OOo finds it necessary to repaginate a paginated document when creating a PDF I have no idea. I tried everything I could think of within OOo (trying the Tools Update menu in various ways) but nothing prevents OOo from screwing up all the indexes (like the Table of Contents) once it changes the total no. of pages by inserting blank pages willy nilly. My work-around to this frustrating problem (which if not solved makes OOo useless, at least for large documents) was to print the document to a (Postscript) file. Then I used ps2pdf to convert to a pdf. I was sure ps2pdf would choke but it didn't. It also did not find the need to insert random blank pages. It appears to keep the pagination the same and all the references in the Table of Contents (Figures, Tables, etc.) all match up with the actual page numbers. Fortunately the Unix approach of allowing for multiple ways of doing things saves the day. After investing months of work in creating this document I was at my wits end trying to produce a useable pdf document. Rick B. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Solution to OOo's Goofy PDF Pagination Problem
On Tue, 2006-12-19 at 17:53 +, Peter Hillier-Brook wrote: Rick Bilonick wrote: I've described recently OOo's nasty pagination problem when exporting to a PDF when dealing with large documents (200 pages). Why OOo finds it necessary to repaginate a paginated document when creating a PDF I have no idea. I tried everything I could think of within OOo (trying the Tools Update menu in various ways) but nothing prevents OOo from screwing up all the indexes (like the Table of Contents) once it changes the total no. of pages by inserting blank pages willy nilly. [cut] I don't know whether it fits your requirements, but a look at HelpPDF export might be useful. Blank pages are inserted in specific circumstances and in a controllable fashion, unless you have encountered a bug. Peter HB I've looked in Help for PDF export but I don't see anything in particular connected to the control of insertion of blank pages. I still don't understand why it would be necessary to add blank pages in a pdf, especially AFTER all the indexing is done. It doesn't make much sense. Fortunately, ps2pdf seems to work in a logical fashion and not screw up the pagination. Rick B. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: [users] Solution to OOo's Goofy PDF Pagination Problem
Hi, Using Windoze XP SP2 and Ooo 2.1.0 I have a 3116 page document all pages are portrait and updating the Table of Contents does not affect the number of pages. When I export as .pdf there are no changes that I am aware of. The pages listed in the TOC are the actual pages before and after the export to .pdf. Floyd Humpherys Well I'm glad it works for somebody. Unfortunately I need to have several landscape pages. If I could figure out how to rotate a table I could likely remove the landscape pages. I don't see any reason for pdf export to repaginate (it tells you it is repaginating). There is no problem with updating the TOC. That works fine. The problem is with pdf export. If repagination occurs automatically then the logical thing to do is to update all the indicies automatically before creating the pdf. My solution is to avoid pdf export and instead to print to a file (after making sure everything is updated), and then use ps2pdf to convert to a pdf. ps2pdf doesn't try to repaginate and everything looks perfect and I've saved myself a nervous breakdown. Someone has said that there is a way to stop pdf export from inserting blank pages - but I can find nothing about this in the Help system. Rick B. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Solution to OOo's Goofy PDF Pagination Problem
Rick: Maybe you've said this and I missed it, but have you tried PDF Creator? (a free program) It would be interesting to see if that worked any differently than OOo's PDF exporter. I fully agree with your contention that there is no reason that OOo should be repaginating as part of the pdf creation process. So something seems amiss. I can't remember what system you're on (Windows? Linux?) If there would be any way of trying it (either yourself if you can, or finding someone else) on the other operating system, the one you're not using, it might help figure out if this is a general OOo bug (or very annoying feature, depending on how you look at it), or if it's something specific with your system or setup. I haven't tried PDF Creator so I'll see if I can find a copy. I'm using Linux FC4, FC5, and FC6 on three different machines. I'm just happy ps2pdf works to convert the Postscript output to a pdf with no repagination. Thanks. Rick B. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] More Odd Behavior - Is OOo Really Useable???
Try print to file and then try converting that file from ps to pdf using the utility ps2pdf. Thanks but I already arrived at this solution (see my other posts on: Solution to OOo's Goofy PDF Pagination Problem). Fortunately, ps2pdf does not re-paginate nor does it insert blank pages. Rick B. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] More Odd Behavior
I'm using OOo 2.02 on a 64-bit Athlon system running FC5. Now I've noticed that in page preview, it shows a total of 239 pages even though in regular mode for editing it shows a total of 238 pages. It seems that the page numbering changes every time I open the file. Without adding or deleting any material, the total no. of pages jumps around from 237 to 239. I notice when I hit page preview, it says it is repaginating at the bottom of the window. Should I always do a page preview before saving? When is it necessary to do an update all under the Tools menu? I just tried an update and the total number of pages changed to 236. I scrolled to look at the pages and now the total is reported as 239. Scrolled again now it shows 240 and looking at the last page it says 240. Now page preview says 240 also. I don't understand how just scrolling without making any changes, changes the pagination. I don't understand why the page numbering keeps changing without changing the document. Rick - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Even More Odd Pagination Behavior
FC5 OS on a 64-bit system with OOo 2.02. I scrolled the document (and have not added any new material nor made any changes) and now in page preview the total no. of pages has jumped from 240 to 243. I see that at least two blank pages have appeared (pp. 27 and 28) where there were none before. I haven't upgraded this machine to a newer OOo because on another almost identical 64-bit system, the bibliographic database does not work in the newer OOo. Rick - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Even More Odd Pagination Behavior
On Mon, 2006-12-18 at 09:16 -0500, [EMAIL PROTECTED] wrote: I can't help, other than to confirm that I've seen behavior like this myself. In my case, it involves a newsletter that I am editor of, and it has either 12 or 16 pages depending on the issue. I've carefully gotten things to fit properly, then saved it and closed it, and when I re-opened it, there is sometimes (not all the time) one or two additional pages because page breaks are now occuring in different places. So it's not just me. I went back into edit mode from page preview and looked at the two added pages 27 and 28. I turned on view nonprinting characters. There are no characters on the two pages that OOo decided to insert. At the end of text on p. 26, there was a paragraph mark and then on the next line another paragraph mark. I removed it and the two blank pages went away. Now the total number of pages is shown as 243. How can I stop OOo from acting so bizarrely? What am I doing that is causing OOo to screw up the number of pages? Scrolled some more and 6 additional blank pages appeared. I deleted the extra paragraph marks. Now the total is back down to 236. Rick - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Even More Odd Pagination Behavior
On Mon, 2006-12-18 at 09:16 -0500, [EMAIL PROTECTED] wrote: I can't help, other than to confirm that I've seen behavior like this myself. In my case, it involves a newsletter that I am editor of, and it has either 12 or 16 pages depending on the issue. I've carefully gotten things to fit properly, then saved it and closed it, and when I re-opened it, there is sometimes (not all the time) one or two additional pages because page breaks are now occuring in different places. I went back into edit mode from page preview and looked at the two added pages 27 and 28. I turned on view nonprinting characters. There are no characters on the two pages that OOo decided to insert. At the end of text on p. 26, there was a paragraph mark and then on the next line another paragraph mark. I removed it and the two blank pages went away. Now the total number of pages is shown as 243. How can I stop OOo from acting so bizarrely? What am I doing that is causing OOo to screw up the number of pages? Did a page preview and the total changed to 239. Went back to edit mode and its at 238. Rick - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] OOo Odd Behavior
I'm putting together a document that will likely have about 300 pages when completed with lots of graphs and tables. Often when I open the same document again, the pagination will change - even after doing a complete Tools Update Update All before closing the file. When I created a pdf and printed there were 238 pages. When I opened the document now there are only 237 pages. Also, I had tried inserting a watermark that I made. I inserted it in the background. After doing this, several graphs disappeared. Fortunately I save a new file after every few changes to the document. But I don't understand why adding a simple png graphic to background would cause pictures to disappear completely. I typically place each graphic and table in frames and then caption the frame. It makes it easier to move things around. I anchor the graphic to the frame. Another problem is that the frames tend to jump around a lot If I try to move some of the frames even slightly, everything will go haywire and the frame will change pages and partially cover another frame. At this point I'm afraid every time I have to make even a slight change to the document let alone insert pages of new material. Rick B - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] XP Conflicts?
On Tue, 2006-12-05 at 21:44 -0500, James Knott wrote: Jim Lynch wrote: Anyone have any problems with conflicts between Microsoft XP (Home) and OpenOffice.org? My computer is crashing and my tech wonders if there is a problem with OOo. thnx James P.Jim Lynch [EMAIL PROTECTED] [EMAIL PROTECTED] (H) 540-775-7002; (cell) 540-273-2829 (Note: I use an agressive spam catcher) No. I have it installed on both XP Home and XP Work g and no problem at all. The OS shouldn't crash. If a program causes the OS to crash, there is something wrong with the OS. Have you installed the latest patches to XP Home? Rick B. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Re: Font for Greek Letters in Formula
Sorry, I meant to do that. A code point is just the index assigned to a particular glyph. In ASCII (and Unicode) the letter 'a' is assigned to the code point 97, or in Unicode notation (hex/base 16), U+0061. In Linux (at least for Gnome/Gtk-based applications like OOo), you can enter that code point directly by holding down Shift+Ctrl, typing the digits, and releasing the Shift+Ctrl. In OOo, this has two small problems: it was broken by changes to 2.0.4, so it won't work at all there. In earlier versions, it works but the coded character is not inserted until you press another key after you release Shift+Ctrl, at which point you get both characters. In the formula editor, hold Shift+Ctrl and type 6 1, release Shift+Ctrl and hit Space. You should see 'a' inserted, same as if you hit and released the 'a' key. Now try Shift+Ctrl 3 b 1 (release, Space). You should see an alpha. Shift+Ctrl 3 b 2 is beta, and so on. Whichever Linux you're using, you should have a character map utility that will let you see the characters and the code point that corresponds to it. You should actually be able to copy/paste or drag characters out of that character map. Unfortunately, the OOo Insert Special Character dialog is not available for the formula editor. When I inserted the symbols that way in the formula editor, they appeared correctly in the .doc file loaded into Word. Joe Thanks. I tried it and it works but not all the characters display correctly in the formula text window but they do display correctly on screen. I know that 2.04 has other problems, at least on 64 bit systems. The bibliography data base does not function correctly. I knew that somebody here knew how to fix the symbol font problem. Thanks again! Rick B. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Re: Font for Greek Letters in Formula
On Wed, 2006-11-29 at 00:13 -0500, Joe Smith wrote: Rick Bilonick wrote: ... Unfortunately they would all choose to use MS Word so I'm not keen on suggesting it. ... Hey, I sympathize. Make your case for everyone using OOo; ask them to pitch in and buy you MS Office if that's what they want to use, or a better computer so you can run Windows virtually ;-) Maybe you can work out a system where, rather than round-tripping the entire document, they only send you additions and changes (as .doc) and you handle the editing of the master document (as .odt). That's what I'm doing - they send me the .doc parts and I usually send a pdf back. At least they'll be aware of OOo and be exposed to something other than Office. ... I don't understand how OOo chooses which font to use for Greek letters. And I feel safe to predict that that won't be the last little mystery you'll be trying to solve if you persist in trying to use different tools. I understand how important it is for OOo to market itself as compatible with Office but the reality is that it is not and never will be perfectly compatible. Whether it is compatible enough has to be answered for each project/document, and very often the answer is no. I wonder if it is a mistake in the long run to encourage people to think of OOo as Office compatible only to be embarassed and disappointed when things don't work out. Also, I don't understand why I can type in certain font names like Times New Roman and Symbol even though these font names do not show up in the pull down font list. OOo doesn't care if you manually specify a font that isn't present: it just records that string in the style definition and displays a substitute font, hopefully something close. If the document then goes to a system that has the specified font, great. You can specify what fonts are substituted (although it only seems to work for fonts that are present--weird). Of course, you can easily install those fonts on Linux too. Joe When I specify Symbol, the actual symbol displayed looks different from both OpenSymbols and Standard Symbol L. When I do this, the symbols show up OK in MS Word. If I use OpenSymbols or Standard Symbol L then they don't show up in text. Rick B. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Re: Font for Greek Letters in Formula
On Wed, 2006-11-29 at 22:28 -0500, Joe Smith wrote: Rick Bilonick wrote: When I specify Symbol, the actual symbol displayed looks different from both OpenSymbols and Standard Symbol L. When I do this, the symbols show up OK in MS Word. If I use OpenSymbols or Standard Symbol L then they don't show up in text. Ok, I had access today to an XP system with OOo and Office on it and played around for a few minutes. I think it was Office2k; I forgot to check. I was able to reproduce your problem: %alpha, etc. in formulas work fine for OOo, but saved as .doc and opened in Word, they produce missing glyph squares. The funny thing is, the formulas are embedded in the .doc file as OLE objects and double-clicking on them actually brings up OOo Math to edit the formula. So the symbols are not showing in Word even though they are being displayed by OOo Math--that really makes no sense; maybe I'm not understanding something there. Anyway, I think this also means that anyone wanting to edit your formulas in Word will have to have OOo installed as well. I was able to get symbols to display in formulas exported to Word by typing the Unicode code points into the formula editor, or by dragging them from the character map. So Math can handle Unicode and it displays exactly the same in Word as it does in Writer. I could also use the Tools Catalog to define new %symbols, specifying the Open Symbol font, and those worked also in Word. A formula pasted as a GDI Metafile also worked, but had the same behavior: missing glyphs with %alpha; ok with Unicode characters. I will also say that Word seemed most unhappy with the document I exported: it was very slow to open (10-20s), crashed once, was very sluggish in re-painting the screen, etc. All in all, I think it's do-able but I'd stick to PDF. Joe Thanks. But I don't understand what you mean by unicode code points. Could you give me a concrete example for one symbol? Rick B. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Re: Font for Greek Letters in Formula
On Tue, 2006-11-28 at 10:57 -0500, Joe Smith wrote: Rick Bilonick wrote: I don't want to use MS Word at all but I do want my OOo documents converted correctly to a .doc file that will be viewable in MS Word. ... Any word processor document format is a poor choice for distribution: they depend too much on external resources (fonts, locale, linked files, etc.). I agree that the .doc export should work better for your documents, but the real answer is to use PDF. Personally, if your recipients need to edit the files and round-trip them back to you for further editing, then I would strongly recommend that you all use the same word processor. Who has time to chase down incompatibilities like this? Joe Unfortunately they would all choose to use MS Word so I'm not keen on suggesting it. Also, MS Word isn't available for Linux even if I wanted to use it (although I might be able to run it using virtualization or whatever). We all need to exchange easy-to-edit documents. I thought that I might be doing something wrong that I could easily fix. I don't understand how OOo chooses which font to use for Greek letters. Also, I don't understand why I can type in certain font names like Times New Roman and Symbol even though these font names do not show up in the pull down font list. Rick B. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Font for Greek Letters in Formula
On Mon, 2006-11-27 at 08:35 +0100, Thomas Lange wrote: Hello Rick, Is there any way to change the font being used when a Greek letter is displayed when using a formula object? If I convert an OOo document to a .doc, the Greek letters in regular text (not a formula) don't display correctly unless I use the Symbol font (Standard Symbols L and OpenSymbol don't seem to convert properly). But I don't see how to force formulas to use the Symbol font. The Greek letters in formulas don't convert properly. For example, the Greek letter (lowercase) mu is: Surte there is. Just use the dialog Tools/Symbols select a single character from the Greek symbol-set and then press Edit. You can now change the font. When you have returned from the following dialog you can do the same for all the remaining symbols. This should solve the problem. Regards, Thomas Thanks but I don't see Tools/Symbols when I'm in the formula editor. I do see Tools/Catalog. But I don't see that this does much more than just typing, for example, %mu, in the formula panel. The problem is that when the document is converted to a .doc and then opened in MS Word, all the Greek letters (and some other symbols) are missing. Other things like summations show up but not the Greek letters. A similar thing happens if I use the OpenSymbols font or the Standard Symbol L font in the text. When opened in MS Word, the wrong character appears. If I had typed mu in either of these fonts, when opened in MS Word, a different Greek letter or math symbol will appear (even though on the screen in OOo it shows a mu). However, if I use the Symbol font (I have to type in the work Symbol - it doesn't appear in the pull-down list of fonts), then what I see in OOo on the screen and print out from OOo under Linux shows up in MS Word too. All I want to do is have people using MS Word to see the correct Greek letters/symbols that I'm typing in OOo. I do see in the Tools/Catalog/Symbol panel it allows you to modify the characters but I cannot type in Symbol like I can for fonts for regular text. Rick B. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Re: Font for Greek Letters in Formula
I think your problem might be in your use of the standard Microsoft Symbol font. This uses now outdated technology in which characters appear in that font equated by position to more normal characters in a standard Latin-1 (ANSI) font. However such symbol fonts were difficult to use, especially with the higher values as character codes do not always properly convert between different operating systems or different character old-style character sets on the same operating system. All symbol characters are now assigned their own values in the Unicode character set (though they certainly don't appear in every font). You might try globally replacing the symbols in your document within MS Word with corresponding Unicode characters from a non-symbol font. Then you should be able to transform between MS-Word and Open Office and between Windows and Linux as you wish without any changing of characters. However, then you will indeed lose the ability to have your characters properly appear in older systems. Jallan I don't want to use MS Word at all but I do want my OOo documents converted correctly to a .doc file that will be viewable in MS Word. Is it that the people trying to read my document have old versions of MS Word? (If I have to open my OOo .doc created file in Word and then change the missing characters, I might as well just write it in Word to begin with (something I really don't want to do). Rick B. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Font for Greek Letters in Formula
Is there any way to change the font being used when a Greek letter is displayed when using a formula object? If I convert an OOo document to a .doc, the Greek letters in regular text (not a formula) don't display correctly unless I use the Symbol font (Standard Symbols L and OpenSymbol don't seem to convert properly). But I don't see how to force formulas to use the Symbol font. The Greek letters in formulas don't convert properly. For example, the Greek letter (lowercase) mu is: %mu Is there someway to force it to use Symbol? Rick B. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Severe Limitations in Bibliography Database? - NO!
On Sun, 2006-11-05 at 17:53 +1000, Jean Hollis Weber wrote: Rick Bilonick wrote: Thank you. You are the man. Heh, actually I'm the woman. :-) Cheers, Jean Opps! Sorry. BTW, it looks like the fields can't be more than 254 characters. Fortunately, this is large enough. Do you know if MS Word has a built-in bibliography feature? It would be great if I could get everyone else in the department to switch to OOo. I know some people use a separate bibliography tool (don't remember the name - maybe Endnotes?). After playing with all these features, I feel confident I can use them in the report I'm building. I'm hoping that by using all the automatic features and taking the time to build them in upfront, corrections and revisions will be much easier and there will be fewer typos/errors. OOo hasn't crashed and so far have I've not found any (major) bugs. Not being able to place a page ahead of a TOC isn't that big a deal because one wouldn't ordinarily place a TOC on the very first page (only did this accidentally because I was experimenting - hadn't used any of these more complex features). It was easy enough to just delete the TOC and re-insert. Thanks again for your help. Rick B. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Deleting Type Choices in Bibliographic Database
Somehow, the bibliographic database's type field has conference procedings under three different codes. Is there any way to change the values for type? I'm asking this because I have the same reference showing up twice (even though as far as I can tell there is only one bibliographic entry). There seems to be a disconnect between the bibliographic database and the document's database. Rick B. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Re: Severe Limitations in Bibliography Database? - No!
do you know about Bibus? IMHO its much easier to use than than the built-in bibliography management. bibus-biblio.sourceforge.net/ Cheers, Bernd Thanks. I did not know about this program but I'll look into it. I don't think that the built-in biblio database is hard to use - I just wasn't familiar with it. But it's always great to have several options. Rick B. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Inserting a New Page before the current first page which has the TOC
I'm trying to insert a new first page. I'm aware of insert manual break but when I place the cursor at the beginning of the current first page, insert manual break is ghosted. Currently, the first page is the Table of Contents that I created using outline numbering and insert index. If I hit ctrl enter it creates a new first page but it is part of the the Table of Contents (I can tell because it is all grey). I had to turn off protection for the TOC but it doesn't do what I want. So how do I get a title page before the Table of Contents? I'm trying to figure out how to do all these things because I'm creating a large document and I'd like to be able to have automatically a TOC, bibliography, and alphabetical index. Thanks. Rick B. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Inserting a New Page before the current first page which has the TOC
Rick: Insert a newline character before the title of your TOC (you did title it before creating it, right) This should allow you to insert a manual break for a new page. Also, this is a mailing list, staffed by volunteers. Please to not reply to my e-mail address but please reply to users@openoffice.org or if using GMANE or Google Groups, to the news group. Thank you. James McKenzie The TOC has the title Table of Contents - I didn't title it. I can't insert anything ahead of the TOC - that's the problem. Anything I try to insert goes into the TOC (but only if I remove protection - if I don't remove protection nothing can be inserted). Maybe I don't understand what you mean by a newline character - I'm assuming this is just hitting the enter key. I've tried to insert anything in front of the TOC and have never been able to. Rick B. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Inserting a New Page before the current first page which has the TOC
The TOC has the title Table of Contents - I didn't title it. I can't insert anything ahead of the TOC - that's the problem. Anything I try to insert goes into the TOC (but only if I remove protection - if I don't remove protection nothing can be inserted). Maybe I don't understand what you mean by a newline character - I'm assuming this is just hitting the enter key. I've tried to insert anything in front of the TOC and have never been able to. Rick B. Given I can't figure out how to do the insertion in this case and apparently no one else knows, I guess the easiest thing to do is just delete the TOC, insert a new page, and recreate the the TOC. Rick B. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Removing Entries from Alphabetical Index
I've created an alphabetical index. But how do you remove entries that you don't want in the index? I've manually tried removing entries but when the index is updated they always reappear. Rick B. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Removing Entries from Alphabetical Index
On Sat, 2006-11-04 at 15:38 -0500, Rick Bilonick wrote: I've created an alphabetical index. But how do you remove entries that you don't want in the index? I've manually tried removing entries but when the index is updated they always reappear. Rick B. OK, I figured it out. You place the cursor over the entry in the body of the document (not in the index) and right click the mouse. This brings up a menu and you choose index entry. From there you can delete the entry. It is also set up to delete multiple entries. Slick and easy to use. Rick B. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Removing Entries from Alphabetical Index
How did you create this index? I have a feeling that this involves linking of some type. If so, most likely you will have to remove the link before the index will not cause it to reappear. Dan - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] I just posted the answer. Right click the mouse over the entry and choose index entry. From there you can easily delete one or more entries. Rick B. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Modifying the Bibliography Structure
On Sat, 2006-11-04 at 18:03 -0500, Rick Bilonick wrote: I inserted a bibliography into my document. All the variables (year, title, author(s), etc.) all run together. Is there some way to format the entries? Rick B. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] I figured this out. You can insert spaces, punctuation between the entries in the Entries panel that allows you to enter variables from the biblio database. The Index/Table panel allows the entries in the document to be numbered (instead of using the short names). But the entries in the Bibliography ARE NOT numbered - at least not automatically. How would a reader looking at the reference numbers in the text, find the appropriate entry? How can I cause the entries in the bibliography to be numbered? Rick B. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Modifying the Bibliography Structure
The Index/Table panel allows the entries in the document to be numbered (instead of using the short names). But the entries in the Bibliography ARE NOT numbered - at least not automatically. How would a reader looking at the reference numbers in the text, find the appropriate entry? How can I cause the entries in the bibliography to be numbered? Rick B. OK, by playing around I was able to get the entries numbered. You insert the short name at the beginning (in the Structure panel). If you have selected numbering then this causes numbers to show in place of the short name. The last thing to do was to cause the book titles to be in bold and I did this by clicking on the TI for title in the Sturcture panel and then selecting strong emphasis for character style. Rick B. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Severe Limitations in Bibliography Database?
OK, I thought I figured out how to set up and modify a bibliography. Now it looks like that the titles and authors text is too long for the database and is truncated (I've entered the text several times and it's always tructated). I'm putting together a scientific document and the titles of many articles and the list of authors are often quite long. I don't see how the bibliography database can be very useful if it truncates the entries. Is there someway around this limitation? Rick B. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Severe Limitations in Bibliography Database?
On Sun, 2006-11-05 at 01:12 -0500, Rick Bilonick wrote: OK, I thought I figured out how to set up and modify a bibliography. Now it looks like that the titles and authors text is too long for the database and is truncated (I've entered the text several times and it's always tructated). I'm putting together a scientific document and the titles of many articles and the list of authors are often quite long. I don't see how the bibliography database can be very useful if it truncates the entries. Is there someway around this limitation? Rick B. I notice that it may be possible to modify the variables in the database by modifying the format. But I can't find much info on text format codes. There is a lot of info on number format codes but the only thing I've found for text is the @ symbol. Is it possible to specify longer text lengths? Rick B. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Severe Limitations in Bibliography Database?
I notice that it may be possible to modify the variables in the database by modifying the format. But I can't find much info on text format codes. There is a lot of info on number format codes but the only thing I've found for text is the @ symbol. Is it possible to specify longer text lengths? Rick B. So far, the only way I see around this limitation is to use the user-defined fields and add part of the title (or authors) in one of the user-defined columns, and print both fields next to each other. This is kind of kludgey but it seems to work. However, a new problem has cropped up. When I added the info in the new fields, and updated the bibliography, all the bibliographic references (which had displayed as numbers) now ALL display Bibliography entry, instead of the number. What gives? Rick B. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Severe Limitations in Bibliography Database?
On Sun, 2006-11-05 at 01:57 -0500, Rick Bilonick wrote: I notice that it may be possible to modify the variables in the database by modifying the format. But I can't find much info on text format codes. There is a lot of info on number format codes but the only thing I've found for text is the @ symbol. Is it possible to specify longer text lengths? Rick B. So far, the only way I see around this limitation is to use the user-defined fields and add part of the title (or authors) in one of the user-defined columns, and print both fields next to each other. This is kind of kludgey but it seems to work. However, a new problem has cropped up. When I added the info in the new fields, and updated the bibliography, all the bibliographic references (which had displayed as numbers) now ALL display Bibliography entry, instead of the number. What gives? Rick B. It's actually worse - ALL fields now do not display correctly. Instead of showing a chapter number, it shows Chapter. Instead of showing a page number it shows Page numbers, and so forth. Fortunately, I just thought of doing a page preview to see what would print and that forced all the fields to display correctly in the preview but only briely in the document right before the preview displays. Once I close the preview the fields again do not display correctly. What would cause this? Rick B. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Re: Severe Limitations in Bibliography Database?
You can change the length of the fields in the bibliography database, though it's not obvious how to do so. Chapter 12, Creating Tables of Contents, Indexes, and Bibliographies in the Writer Guide tells how (as well as some of the other things your other note says you figured out for yourself -- good work, btw, as all of it is not obvious). You can get a free PDF of this and other chapters from: http://documentation.openoffice.org/manuals/oooauthors2/index.html Regards, Jean You are right, it's not obvious. But your reference was right on and showed exactly how to increase the fields. Thanks so much. Rick B. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Severe Limitations in Bibliography Database?
On Sun, 2006-11-05 at 17:14 +1000, Jean Hollis Weber wrote: Rick Bilonick wrote: ... a new problem has cropped up. When I added the info in the new fields, and updated the bibliography, all the bibliographic references (which had displayed as numbers) now ALL display Bibliography entry, instead of the number. What gives? Rick B. It's actually worse - ALL fields now do not display correctly. Instead of showing a chapter number, it shows Chapter. Instead of showing a page number it shows Page numbers, and so forth. [...] What would cause this? You have accidentally turned on show field names. Press Ctrl+F9 to turn this off and display the field contents instead. --Jean Thank you. You are the man. Not sure how I turned on field names. I was afraid I damaged the file. Rick B. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Merging Tables
I have never been able to merge two tables (both with the same number of columns). The table - merge table menu item is always ghosted. The two tables are right next to each other. What is the secret to merging tables? Rick B. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Merging Tables
On Sat, 2006-10-28 at 00:01 -0400, Rick Bilonick wrote: I have never been able to merge two tables (both with the same number of columns). The table - merge table menu item is always ghosted. The two tables are right next to each other. What is the secret to merging tables? Rick B. I created a new text document and inserted two tables so that one table was directly below the other (there was no space whatsoever between the tables). Then the merge table was unghosted and worked. However, if I hit a carriage return and create a line between the two tables the merge can't be done. I turned on hidden characters and it looks like there is a paragraph marker between the two tables but I cannot get rid of it no matter how I try to delete it. This appears to be the reason I cannot merge tables in my other document. Any suggestions? Rick B. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Merging Tables
I created a new text document and inserted two tables so that one table was directly below the other (there was no space whatsoever between the tables). Then the merge table was unghosted and worked. However, if I hit a carriage return and create a line between the two tables the merge can't be done. I turned on hidden characters and it looks like there is a paragraph marker between the two tables but I cannot get rid of it no matter how I try to delete it. This appears to be the reason I cannot merge tables in my other document. Any suggestions? Rick B. OK, I found that you can delete page marks by using the find replace checking off regular expressions and using a $ for the paragraph mark. However this doesn't work for any paragraph mark immediately in front of a table. What gives??? Rick B. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Merging Tables
If you place the text cursor in the empty paragraph between the two tables and press delete (the paragraph must be empty of course) then it should be removed and you can then merge the tables. This worked for me just now, but had I tried this some other time I would have been totally lost without your clues. Ross Where is this documented and how did you know this? It worked of course. Thanks. Using the backspace key doesn't work. Using search $ didn't work. This solves a big problem for me. I searched the help system and the Internet and found no information on this. Rick B. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Installing Macros
I would like to use IannzFindReplace macro. The installation instructions don't appear to match the current version of OOo. I can use the macro but it is very awkward to get to. I have tried to assign it to a menu item. It shows up in the menu (I put it under edit) but it won't run. When I go to tools | macro items, you can't really select macros directly. It's all very bewildering and non-intuitive. Could someone explain how one should install a third party macro to make it easy to use whenever one brings up OOo? Rick B. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Using the command line
Is there any way to use oodraw on the command line to convert an eps file to an emf file without opening the gui? I've been using oodraw to do this but the gui always opens and then I select the emf format for output. I don't seen any info on this in the help information. I can open the eps: oodraw file.eps Is there any way to do all this entirely using the command line and avoiding opening the gui? Rick B. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] oodraw command line usage
I use R to create .eps graphics and then use oodraw to convert them to .emf versions. (One reason I do this is that OOo tends to re-size .eps files and I haven't found a way to stop it or change it once the graph is resized. .emf files are not distorted by OOo - fortunately.) I use a command like: oodraw filename.eps The gui opens and then I select .emf and do an export. I haven't found a way to eliminate the gui and do everything from the command line. Is this possible? I need to convert a large number of files and it would be convenient to do it all from the command line. (I also note that I sometimes get warning messages that OOo can't create .emf files - but there is never a problem creating the .emf files.) I'm using the latest version of OOo. I've looked at the arguments for oodraw and I don't see any way to specify that I want a .emf file as an output. Rick B. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Losing all pictures when converting from .odt to .doc
I'm using OOo version 2.0.1.1 on Fedora Core 4 with all the latest patches. I create a document with pictures from files. The picture is an encapsulated postscript (.eps) file that I use OOo draw to convert to a .emf (enhanced metafile). I convert them because OOo has the nasty habit of not displaying eps files correctly (it screws up the size and makes them smaller with no way to correct them - it doesn't do this with emf's). I insert the emf (embedded not linked) and save as both a .odt and .doc. As long as the .doc file hasn't been closed, the emf picture appears and looks perfect. If I close the .doc and re-open - the picture is gone (this doesn't happen with the .odt version). This ALWAYS happens. If I take the .doc and .emf to windows, open in MS Word, and insert the .emf file in the .doc, the .emf displays perfectly. If I save the .doc from MS Windows, it opens perfectly in OOo and displays the .emf picture. Why can't I get OOo to store the .emf picutre in a .doc version file? How can OOo be used for compatibility with MS Word docs if it doesnt' save it's own pictures? Is this a bug or am I doing something wrong? I've checked options to see if something is set wrong but I don't see any applicable options to change. I know I'm embedding the pictures and not just linking them. Rick B. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Different Page Style in Every WorkSheets... How to I do ?
On Mon, 2005-12-19 at 12:53 +0100, [EMAIL PROTECTED] wrote: Hi ! I'm very angry, because this is the problem what everytime I get... I many times working with workbook have many sheets. When I want to another printing formats (page style) for every page, I cannot do it. Example: I have a sheet that LandScape, and other that Portrait. How to I setup these sheets to I make these printing styles ? I need different printing style. How to I do it ? OO2, Calc. Thanx for help: dd Ps: That is the question for OO Write too, because I cannot create a document with a LandScape Page (1. page) and after a Portrait Page (2. page)... Please help me ! Did you find a way to do this? Sorry for all the unhelpful responses from others. Also, sorry the techniques mentioned in OOo's Help and the pdf documents don't appear to work either. OOo is great but sometimes the documentation is wrong (or maybe something that it crucial is missing). I have had the same problem - all I want is one or two landscape pages and the rest of the pages as portrait. I tried sections also (although you shouldn't have to do sections to this seemingly simple thing) - but the pdf chapters saying to use sections don't work either. All the things I tried (except the one I'll explain shortly) don't work (using page styles with or without sections) either gives me all landscape pages or JUST the first page changes (incorrectly) to landscape - never the page I want to be landscape. Fortunately, some kind person posted the correct (and as far as I know) the only solution. First, use Format | Styles and Formatting to copy an existing page style and change the page orientation to landscape. Call it ls or whatever. You must then insert a manual page break (you CANNOT use ctrl enter keys) using the menu item. So do an Insert | Manual Break. Look at the panel and you'll see Style - select the new page style you just created. This will then create one landscape page. The rest of your document should remain as portrait. Repeat this as many times as you need. I hope this helps. Rick B. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Re: Different Page Style in Every WorkSheets... How to I do ?
On Mon, 2005-12-19 at 13:02 -0500, Matej Cepl wrote: [EMAIL PROTECTED] wrote: I'm very angry, because this is the problem what everytime I get... That's sad, but what about reading documentation? When I want to another printing formats (page style) for every page, I cannot do it. Example: I have a sheet that LandScape, and other that Portrait. How to I setup these sheets to I make these printing styles ? Create two Page styles and switch between them? I do not understand your problem, probably. That is the question for OO Write too, because I cannot create a document with a LandScape Page (1. page) and after a Portrait Page (2. page)... Insert sections and for each section use different Page style. Matej Personally, I've tried reading the OOo documentation on doing this and it does not appear to work. I've tried using sections also. None of the approaches mentioned here appear to work (at least not in the Linux OOo version running under FC4). The ONLY way I've found to work is using the Insert | Manual Break and selecting a landscape page style. Rick B. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Unpredictable Display of EPS Files
I create encapsulated postscript (.eps) file from R and insert them as pictures in writer and impress. gsview, gv, evince, etc. all show them properly. Most of the time they display correctly in writer and impress. But sooner or later as I add more eps files, eventually they don't all display correctly. The graphic frame stays the same size but the graphic itself shrinks to the lower left corner to about 70% of its correct size. Info that OOo displays shows the correct size but the images do not display correctly. When I close the document and then later re-open it, which graphics display correctly and which don't appears to be random. I have not found a solution to this and it makes it very difficult to make documents with nice graphs. Rick B. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] how to use statistics in spreadsheet
G. Roderick Singleton wrote: On Sat, 2005-02-26 at 13:28 -0500, [EMAIL PROTECTED] wrote: Previously using Lotus123 I could compare a Y column of data to one or more X columns, getting the coefficients of correlation, a constant, and a multiplier of X that produces expected value of Y. Thus Y = A + BX . A being the constant and B the multiplier of X to produce the expected value of Y for any input of X. In openoffice statistics COREL produces the coefficient of correlation, but I have not been able to get the other values. I have tried FORECAST, which may or may not be the right one, but have mismanaged such as to get no results The same applies to LINEST under ARRAY. I must be too ignorant to solve this. Any help? Perhaps http://www.ooomacros.org/user.php#106652 will be useful You should NEVER, EVER, use a spreadsheet to do statistical computations and graphics of any kind, for any reason. Spreadsheets are not a natural way to do statistical analysis and are dangerous to use for statistical computations. You should use R: http://www.r-project.org/. Spreadsheets are dangerous to use for even storing data for input to other programs. You can check for numerous sites on the web that talk about these dangers. Most directly concern the use of Excel but many of the problems apply equally well to any spreadsheet. Spreadsheets have a certain limited usefulness but if you try to go beyond these very simple applications you are asking for problems. Use the appropriate tool for the job. If you are doing statistics and/or graphics use R. Statistics is more than doing computations. Doing statistical analysis well requires a thoughtful analysis which R is designed, by its nature, to help provide. This is an iterative process of investigating the data and determining what the data are telling us. Plus you can trust the computations done by R to be correct. Rick B. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]