Unwanted Capitalization.
I use 4.1.3 with Win 10. OO Writer has an infuriating habit of capitalizing things I do not want capitalized. Does anyone know how to fix this? - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Update OO.
Rory: Thank you. Fred On 2/15/2019 12:33 AM, Rory O'Farrell wrote: On Thu, 14 Feb 2019 16:07:12 -0800 FC wrote: I use OO 4.1.3 and Win 10. In trying to update to oo 4.1.6, going to Help > Check for updates yields, Checking for an update failed. Any suggestions? This is a known problem with the reception of the information, which varies from computer to computer. Go to [url]http://www.openoffice.org/download/[/url] the official site, which will offer you the download information. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Update OO.
I use OO 4.1.3 and Win 10. In trying to update to oo 4.1.6, going to Help > Check for updates yields, Checking for an update failed. Any suggestions? - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Envelopes
Joe: > Insert > Envelopes then follow the tabs and instructions. Fred Charette On 09/21/15 6:48 AM, Joe Lawless wrote: I love this software but I cannot seem to find a place to address envelopes. Did I overlook it or is there an envelope addressing tool at all? Thank you in advance. Joe Lawless
Another Print Range Problem.
Attention: Alan. Since you were so helpful to me in helping to solve the extra blank page printed on my one-page spreadsheet perhaps you have a suggestion on another one. I have three linked spreadsheets, A, B, and C, of ten pages each where C is a sum of the cells in A and B. Obviously, an accounting of two departments combined in a third. The print ranges in A and B are ok, printing pages 1 -10. But, for some unknown reason the C spreadsheet wants to print pages 1 - 14, i.e., 4 phantom blank pages. No big deal, but pesky. I've tried deleting rows below the data and columns to the right of the data but to no avail. Do you have any suggestions for eliminating the 4 blank sheets in C? Fred
Print Range.
I use Open Office Calc 3.4.1 with Win 7 Home Premium 64-bit. I have a very simple one-page spreadsheet, but the software wants to print out this sheet plus a second sheet which is blank. I know I can set the print range manually each time I print it, but I would like to avoid this step permanently. Can some kind person suggest how I can correct this apparently simple but very pesky problem? Fred
Latest Version.
I use OO 3.4.1 with Win 7 Home Premium 64-bit. The site openoffice.org/download doesn't seem to offer a version for my operating system. Any suggestions? Fred
Should I Upgrade?
I use OO 3.4.1 with Win 7 Home Premium 64-bit. I'm an ordinary user; nothing exotic. Should I upgrade and why? I once tried 4.0 and encountered many problems so I'm wary. Fred
OO Writer.
I use OO Writer 3.4.1 and Win 7 Home Premium 64-bit How do I cancel or override automatic indentation and numbering? Fred
Reading a .wpd file in OO Writer.
I use Win 7 Home Premium and OO 3.4.1 How do I open and read a .wpd file using OO Writer? Thanks in advance to any kind knowledgeable person. Fred
Re: Print Range on Combined Spreadsheet
Dennis: The three Linked Spreadsheets are named FIN14F, FIN14M, and FIN14FM, where the first two contain financial data and the third merges the data cells of the first two. For example, Cell G73 on the first two spreadsheets contain numbers and and the third contains the expression: =SUM($FIN14F.G73;$FIN14M.G73). Fred On 11/29/14 8:46 PM, Dennis E. Hamilton wrote: On sheet 3 how is the merging of matching cells from sheets 1 and 2 expressed? Is it a consolidation? What does the Consolidation dialog specify as the range On sheet 3? - Dennis PS: Also look up print area selection in the Calc Help. On each of your sheets, Select Format | Print Ranges | Edit to see if there are any settings there. -Original Message- From: FC [mailto:fc...@cox.net] Sent: Saturday, November 29, 2014 17:33 To: users@openoffice.apache.org Subject: Re: Print Range on Combined Spreadsheet Dennis: Thanks. I have three 10-page spreadsheets of 67 Rows and A - O Columns each, with the contents of each cell of Sheet 3 a merging of the contents of the corresponding cells in Sheets 1 and 2. I forget what OO calls that. When I do Ctrl-P on Sheets 1 or 2, under Thereof print for Pages the entry is 1 - 10, but for Sheet 3 the entry is 1 - 14. The last cell to contain data in all three Sheets is Cell O632 of Page 10 in each Sheet. But I've searched Sheet 3 and all the cells in pages 11 and below are empty. Furthermore, I've done a Delete Row for all the rows in these pages. So the only way I've found to avoid printing 4 blank pages with Sheet 3 is to manually change the Pages field from 14 to 10 each time I Print. It's a small thing and I thought surely it must have an easy solution. Fred On 11/29/14 4:49 PM, Dennis E. Hamilton wrote: Um, I think cell A1 must be selected. Is that what you mean? -Original Message- From: FC [mailto:fc...@cox.net] Sent: Saturday, November 29, 2014 15:41 To: users@openoffice.apache.org Subject: Re: Print Range on Combined Spreadsheet Dennis: Thanks, but is there a step missing? Fred On 11/29/14 7:33 AM, Dennis E. Hamilton wrote: Open the problematic sheet in Calc. With the cursor initially in cell A1, Click Ctrl-End on your keyboard. This will move to the lower-right corner cell of the sheet such that all used cells are included in the rectangular grid having that A1 and that as corners. From there, you can start deleting rows or columns as necessary to shrink that grid back to one that just includes the necessary cells and excludes blank strays. This is better than setting print area because that often ends up excluding information when changes are made or, as seems to be the case here, there may be inconsistency in handling multiple sheets in the Calc document. - Dennis -Original Message- From: Brian Barker [mailto:b.m.bar...@btinternet.com] Sent: Friday, November 28, 2014 21:17 To: users@openoffice.apache.org Subject: Re: Print Range on Combined Spreadsheet At 12:16 28/11/2014 -0800, Fred Conly wrote: [ ... ] But one of my comments transpires nevertheless to have been apposite, I think: Note also that areas that appear empty on any sheet may not be empty but contain either explicit blank characters or formulae that evaluate to blank strings. Such areas will be included in what is printed. Surely you must just have some significant cell or cells that Calc assumes that you want printed some way beyond the last part that you do? This might be visible in your spreadsheet or it may be that the significant data is just blank spaces - so not visibly different from an empty cell. But Calc will think that you put those blanks there because you wanted that cell printed. If you cannot find the rogue cell or cells, you may want to replace any confidential information with nonsense text and send the spreadsheet (still showing the problem) to someone to investigate. I trust this helps. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Print Range on Combined Spreadsheet
Dennis: Thanks, but is there a step missing? Fred On 11/29/14 7:33 AM, Dennis E. Hamilton wrote: Open the problematic sheet in Calc. With the cursor initially in cell A1, Click Ctrl-End on your keyboard. This will move to the lower-right corner cell of the sheet such that all used cells are included in the rectangular grid having that A1 and that as corners. From there, you can start deleting rows or columns as necessary to shrink that grid back to one that just includes the necessary cells and excludes blank strays. This is better than setting print area because that often ends up excluding information when changes are made or, as seems to be the case here, there may be inconsistency in handling multiple sheets in the Calc document. - Dennis -Original Message- From: Brian Barker [mailto:b.m.bar...@btinternet.com] Sent: Friday, November 28, 2014 21:17 To: users@openoffice.apache.org Subject: Re: Print Range on Combined Spreadsheet At 12:16 28/11/2014 -0800, Fred Conly wrote: [ ... ] But one of my comments transpires nevertheless to have been apposite, I think: Note also that areas that appear empty on any sheet may not be empty but contain either explicit blank characters or formulae that evaluate to blank strings. Such areas will be included in what is printed. Surely you must just have some significant cell or cells that Calc assumes that you want printed some way beyond the last part that you do? This might be visible in your spreadsheet or it may be that the significant data is just blank spaces - so not visibly different from an empty cell. But Calc will think that you put those blanks there because you wanted that cell printed. If you cannot find the rogue cell or cells, you may want to replace any confidential information with nonsense text and send the spreadsheet (still showing the problem) to someone to investigate. I trust this helps. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Print Range on Combined Spreadsheet
Dennis: Thanks. I have three 10-page spreadsheets of 67 Rows and A - O Columns each, with the contents of each cell of Sheet 3 a merging of the contents of the corresponding cells in Sheets 1 and 2. I forget what OO calls that. When I do Ctrl-P on Sheets 1 or 2, under Thereof print for Pages the entry is 1 - 10, but for Sheet 3 the entry is 1 - 14. The last cell to contain data in all three Sheets is Cell O632 of Page 10 in each Sheet. But I've searched Sheet 3 and all the cells in pages 11 and below are empty. Furthermore, I've done a Delete Row for all the rows in these pages. So the only way I've found to avoid printing 4 blank pages with Sheet 3 is to manually change the Pages field from 14 to 10 each time I Print. It's a small thing and I thought surely it must have an easy solution. Fred On 11/29/14 4:49 PM, Dennis E. Hamilton wrote: Um, I think cell A1 must be selected. Is that what you mean? -Original Message- From: FC [mailto:fc...@cox.net] Sent: Saturday, November 29, 2014 15:41 To: users@openoffice.apache.org Subject: Re: Print Range on Combined Spreadsheet Dennis: Thanks, but is there a step missing? Fred On 11/29/14 7:33 AM, Dennis E. Hamilton wrote: Open the problematic sheet in Calc. With the cursor initially in cell A1, Click Ctrl-End on your keyboard. This will move to the lower-right corner cell of the sheet such that all used cells are included in the rectangular grid having that A1 and that as corners. From there, you can start deleting rows or columns as necessary to shrink that grid back to one that just includes the necessary cells and excludes blank strays. This is better than setting print area because that often ends up excluding information when changes are made or, as seems to be the case here, there may be inconsistency in handling multiple sheets in the Calc document. - Dennis -Original Message- From: Brian Barker [mailto:b.m.bar...@btinternet.com] Sent: Friday, November 28, 2014 21:17 To: users@openoffice.apache.org Subject: Re: Print Range on Combined Spreadsheet At 12:16 28/11/2014 -0800, Fred Conly wrote: [ ... ] But one of my comments transpires nevertheless to have been apposite, I think: Note also that areas that appear empty on any sheet may not be empty but contain either explicit blank characters or formulae that evaluate to blank strings. Such areas will be included in what is printed. Surely you must just have some significant cell or cells that Calc assumes that you want printed some way beyond the last part that you do? This might be visible in your spreadsheet or it may be that the significant data is just blank spaces - so not visibly different from an empty cell. But Calc will think that you put those blanks there because you wanted that cell printed. If you cannot find the rogue cell or cells, you may want to replace any confidential information with nonsense text and send the spreadsheet (still showing the problem) to someone to investigate. I trust this helps. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Print Range on Combined Spreadsheet
Brian: Thanks again. I tried all your suggestions, but still couldn't solve the problem. So when I print the third spreadsheet I manually change the print page range from 1- 14 to the correct 1 - 10. I have upgraded to a 4.n.n version in the past, but encountered many problems. It was confirmed to be unstable on the Forum. So I went back to 3.4.1. and have stuck with it so far. Fred On 11/27/14 9:12 PM, Brian Barker wrote: At 17:32 27/11/2014 -0800, Fred Conly wrote: I use Open Office Calc 3.4.1 with Win 7 Home Premium 64-bit. It's probably well past time to upgrade. I have three related ten-page spreadsheets where the third combines data from the first and second. For an unknown reason the third has a print range of 1 - 14 and of course those last 4 pages print blank. I haven't been able to correct the print range to pages 1 - 10. although it must be very simple. Can anyone suggest a solution? This is a little confused - at least, to me. A spreadsheet is a document, so do you mean that you have three separate document files? In that case, I don't think the first two are relevant. Or do you mean that your single spreadsheet document has three sheets? Print ranges are not strictly defined as pages, I think, but as cell ranges - as their name suggests. Any cell range will translate into a number of pages, of course, when it is printed, but the actual pages created will depend on other formatting details. Oh, and it is not helpful to say you haven't been able to do something, without doing the courtesy of saying what you have tried and in what way it didn't work. o You can delete a print range using Format | Print Ranges | Remove. Then you could reinstate the print range you really wanted using Format | Print Ranges | Define. o Alternatively, you can examine the current print range using Format | Print Ranges | Edit... . You can edit the details in the Edit Print Ranges dialogue. Alternatively, you can click the relevant Shrink button in the Edit Print Ranges dialogue to display the cell ranges included, which you can then modify as necessary. Note that print ranges are define within individual sheets of a spreadsheet, but take effect collectively on what is printed. So you may have to examine all sheets of any spreadsheet separately to discover what is happening. Note also that areas that appear empty on any sheet may not be empty but contain either explicit blank characters or formulae that evaluate to blank strings. Such areas will be included in what is printed. Depending on the exact details, a quick way around your problem may be to tick the option at Tools | Options... | OpenOffice Calc | Print | Pages | Suppress output of empty pages. You can also reach this option on the fly in the Print dialogue. I trust this helps. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Print Range on Combined Spreadsheet.
I use Open Office Calc 3.4.1 with Win 7 Home Premium 64-bit. I have three related ten-page spreadsheets where the third combines data from the first and second. For an unknown reason the third has a print range of 1 - 14 and of course those last 4 pages print blank. I haven't been able to correct the print range to pages 1 - 10. although it must be very simple. Can anyone suggest a solution? Fred
Re: How Do I Change Text in the Legend of a Chart?
Brian: Thanks for trying to help. Tell me, what does $SPH or SSPH, it's hard to distinguish which, that appears before a Data Range and what does it do? Fred On 11/24/14 4:33 AM, Brian Barker wrote: At 20:19 23/11/2014 -0800, Fred Conly wrote: I used your second suggestion [adjusting the data ranges to include column headers] and I could produce labels for two of the three columns. Strangely, I could not produce the third and I can't figure out why. Do you mean that you couldn't adjust one of the data ranges or that you did so but the text still did not appear in the legend? Does the correct range appear in the Range for y-Values box? Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: How Do I Change Text in the Legend of a Chart?
Brian: Thanks again. The name SPH must be assigned by OO Calc because it's nothing I named. Also SPH. preceeds each Data Range from Column A, which contains the x-axis data, and columns C, D, and E which contain the data charted. The prolific use of $ is unnecessary and confusing in this case. I will try again now knowing what this hieroglyphic means. Fred On 11/24/14 2:56 PM, Brian Barker wrote: At 13:25 24/11/2014 -0800, Fred Conly wrote: Tell me, what does $SPH or SSPH, it's hard to distinguish which, that appears before a Data Range and what does it do? The SPH will be the sheet name and qualifies the call range to indicate which sheet in the spreadsheet is being referred to. The $ sign will have its usual function of freezing the reference against automatic changes when copied or filled. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: How Do I Change Text in the Legend of a Chart?
Brian: Thanks again. Why anyone would use the designation SPH to refer to Sheet n is incomprehensible; why not, for example, SHn? I understand what you say about multiple sheet references. In this case there is only one sheet of Data and one sheet of Chart. Fred On 11/24/14 5:13 PM, Brian Barker wrote: At 16:07 24/11/2014 -0800, FC wrote: The name SPH must be assigned by OO Calc because it's nothing I named. Hardly likely: it's the name you (or someone) gave to the sheet - shown on the tab at its bottom left. The default names are Sheet1, Sheet2, and so on. Also SPH. precedes each Data Range from Column A, which contains the x-axis data, and columns C, D, and E which contain the data charted. Because all your data is on sheet SPH, whereas it could have been on other sheets in your spreadsheet. Bare references such as A1 are ambiguous if you have more than one sheet: there is an A1 on each sheet. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
How Do I Change Text in the Legend of a Chart?
I use OpenOffice 3.4.1 with Windows 7 Home Premium 64-bit. I'm only an occasional chart maker. I created a chart years ago, of Column, Stacked, with three Data Sets. Will some kind person please remind me how to change the text in the Legend for the three Data Sets? Fred
Re: How Do I Change Text in the Legend of a Chart?
Joost: Thanks. I'm using Open Office Calc. There are three Columns of Data I used for the Chart. I must have started the Data Range /below /the Column Headings. Hence the three Labels appearing in the Legend, each preceeded by a Square object with the same color or shading in the Column Bar as the Data Series it represents, with the three Texts reading: Column E, Column D, and Column C. It is these Texts I would like to change. I suppose I could change the Data Ranges to include the Column Headings. If that's the easiest way then I need a reminder of how to do that. It's been years since I created this, or any other Chart. Fred On 11/23/14 12:57 PM, Joost Andrae wrote: Hi Fred, you usually just need to change the title of the colums within the source data set. If you create a chart within AOO then the chart is an OLE (object linking and embedding) object. Such objects share a connection to the source data within the document where you create the chart. In Writer (the wordprocessor) the source data is usually stored within a table and within Calc (the spreadsheet module) the source data is part of this document where every element (cell) of this document can be a source of a chart. I Calc to find out which table part is used as source data then open that document and doubleclick the chart. In this case source data for this chart is highlighted. In Writer unfortunately it isn't. This would be a useful feature to implement... Am 23.11.2014 um 19:36 schrieb FC: I use OpenOffice 3.4.1 with Windows 7 Home Premium 64-bit. I'm only an occasional chart maker. I created a chart years ago, of Column, Stacked, with three Data Sets. Will some kind person please remind me how to change the text in the Legend for the three Data Sets? Fred Kind regards, Joost - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: How Do I Change Text in the Legend of a Chart?
Brian: Thanks. I used your second suggestion and I could produce labels for two of the three columns. Strangely, I could not produce the third and I can't figure out why. Fred On 11/23/14 5:05 PM, Brian Barker wrote: At 10:36 23/11/2014 -0800, Fred Conly wrote: I use OpenOffice 3.4.1 with Windows 7 Home Premium 64-bit. I'm only an occasional chart maker. I created a chart years ago, of Column, Stacked, with three Data Sets. Will some kind person please remind me how to change the text in the Legend for the three Data Sets? o Double-click the chart to select it - so you see the grey border, not just the eight coloured handles. o The source cells for the legend text should be highlighted in the spreadsheet - either as column (or row) titles for the data ranges or else independently. o If so, modify the text there. If not - and especially if the legend text is Column X and so on - you can set up a table for the legend: o Enter the required legend text into separate suitable cells anywhere in the spreadsheet. o Double-click the chart to select it - so you see the grey border, not just the eight coloured handles. o Go to Format | Data Ranges... | Data Series (or right-click | Data Ranges... | Data Series). o Select each data series in turn in the Data series column and select Name in the Data ranges column. o Next to Range for Name, click the Select data range button. o Click the relevant cell. o Repeat for other data series. At 15:00 23/11/2014 -0800, Fred Conly wrote: I'm using Open Office Calc. There are three Columns of Data I used for the Chart. I must have started the Data Range /below /the Column Headings. Hence the three Labels appearing in the Legend, each preceded by a Square object with the same color or shading in the Column Bar as the Data Series it represents, with the three Texts reading: Column E, Column D, and Column C. It is these Texts I would like to change. I suppose I could change the Data Ranges to include the Column Headings. If that's the easiest way then I need a reminder of how to do that. To do it that way: o Double-click the chart to select it - so you see the grey border, not just the eight coloured handles. o Go to Format | Data Ranges... | Data Series (or right-click | Data Ranges... | Data Series). o Select each data series in turn in the Data series column and select y-Values in the Data ranges column. o Next to Range for y-Values, click the Select data range button. o Ignore the existing marked range (without the column heading) and drag over the correct range - now including the heading. o Repeat for other data series. I trust this helps. Brian Barker - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
