Re: #VALUE! Error
I do have AOO vers 4.1.13 as well as LO vers 7.3; but I also make the mistake of sending my OP to AOO List when it could have/should have been sent to the LO List. Getting old is Not fun~!~ On 8/28/2022 7:58 PM, David Robley wrote: I think you have LibreOffice, as Apache OpenOffice is only at version 4.1.13. There may be differences between the two programs that could in some cases make a difference to the answers to questions; please make sure you are clear about what software you are using. On 29/8/22 00:19, Vince@Verizon wrote: I have a vers: 7.3.2.2 Calc sheet on my Win10x64 Home Cheers
Re: #VALUE! Error-- SOLUTION Found
On 8/28/2022 10:49 AM, Vince@Verizon wrote:
{{{ snipped }}}
I don't know why I am getting a #VALUE! error in cell [H4]. Probably
something simple... but it escapes me
How can this be corrected?
{{{ snipped }}}
I now know why and how to correct this error.
I found that when entering the starting date in cell A4, if I initially
enter02/23/2022, rather than 23 February 2022, the result in cell H4 is
correct; e.g., 186.
So, to Brian's point, error 519 resulted at H4 because 23 February 2022
when typed from my keyboard, indeed is a text string instead of a
number value and "/is not a date in spreadsheet terms/". { TNX Brian! }
In the future I must pay closer attention and utilize the correct
methodwhen wanting to type a date value within a cell. I also must
remember that the cell format is only controlling what is displayed on
screen.
My apology for my mistakes when writing my OP. Sometimes what appears on
the mail list becomes corrupt. If the mail list permitted attachments
and/or copying and pasting of what is displayed on the Calc screen, I
think I would be making fewer mistakes when posting ...
Regards,
VinceB.
Re: #VALUE! Error
On 8/28/2022 10:49 AM, Vince@Verizon wrote: [snipped] Cells A4 and B4 are formatted as Date, D, . Misspoke; meant to write: DD [snipped] The calculated results in those cells are: 23 February 2022 28 August 28 2022 #VALUE! Another of my errors. Should be: August 28 2022. [snipped]
#VALUE! Error
Hi: Hope all is well with you and yours. I have a vers: 7.3.2.2 Calc sheet on my Win10x64 Home, build 19043, desktop with labels for columns A, B and H as follows: [A] [B] [H] Delivery Date Today Is Days Since Delivery The data within cells A4, B4 and H4 are as follows: 23 February 2022 =TODAY() =B4-A4 Cells A4 and B4 are formatted as Date, D, . The calculated results in those cells are: 23 February 2022 28 August 28 2022 #VALUE! I don't know why I am getting a #VALUE! error in cell [H4]. Probably something simple... but it escapes me How can this be corrected? TNX. VinceB.
Re: Formatting for USA Telephone Numbers
Some success here I have made a mental note of the resultant Format code line after highlighting the most recently added/available format, i.e., " F_o_rmat -+1 () -1234) ". Also, I noticed that what appears within the _F_ormat code line is NOT what I had entered. The Comment line shows what I expected. What I typed into the cell is: 111222. ( NumLk is enabled ). The resultant display within that cell is +1 (111) 222-, which is absolutely acceptable to me. I must figure a way to convert existing cell contents such as (877) 300- to the desired display format. Can this task be accomplished using a formula? I think I saw a toolbar feature that converts to numbers, but that might have been within LibreOffice, not AOO. Two clicks in LO changed the existing data to 1234567890 format, and from there, I applied the desired display format, as shown in image included above. Ultimately, I want to be able to use LO or AOO for USA Telephone Number formatting. Then, I must deal with very few international telephone numbers within my Calc file. TIA. On 2/27/2022 12:58 PM, Vince@Verizon wrote: My thanks to all that have replied. It has been wild here with home repair concerns, or I would have acknowledged sooner. I will attempt 1^(###)^###- (where ^ is a space) under the numbers tab, when time permits. 1. I believe that as soon as I begin typing into the definition box, it becomes "User Defined". Is that normal? 2. If I choose to edit the comment line, e.g., USA Telephone Numbers, will my revision then appear in the selection box-right side, above the definition box? I hope that these characters are displayed correctly in the actual posted message; sometimes, somehow, things get jumbled up. Regards, VinceB.
Re: Formatting for USA Telephone Numbers
My thanks to all that have replied. It has been wild here with home repair concerns, or I would have acknowledged sooner. I will attempt 1^(###)^###- (where ^ is a space) under the numbers tab, when time permits. 1. I believe that as soon as I begin typing into the definition box, it becomes "User Defined". Is that normal? 2. If I choose to edit the comment line, e.g., USA Telephone Numbers, will my revision then appear in the selection box-right side, above the definition box? I hope that these characters are displayed correctly in the actual posted message; sometimes, somehow, things get jumbled up. Regards, VinceB. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Formatting for USA Telephone Numbers
Hi: How do I format cells for entry of USA Telephone Numbers, as: 1 (###) ###*-* whenever, for example,I have typed a ten-digit number, e.g., 1234567890 (no spaces, no negative/minus sign, no parenthesis, by use of the number keypad (NumLk is enabled). Yes, I want the "1" prefix, the area code to appear within parenthesis, and a negative/minus sign between the 3rd digit and the 4th digit. A space follows the prefix "1" and a space follows the closing parenthesis. I have tried to set a user defined number-format, but am getting strange results with apostrophes and/or double quote markings mixed in when viewing the Format Cells dialogue, e.g., (#") "###"*-*". And, I don;t understand why that is. I was hoping to find a pre-defined/default format for use when entering USA telephone numbers. I am flexible; I can probably do without the "1" prefix and/or the parenthesis. Should I be formatting these cells as "text" (left-justified) rather than as numbers (right-justified)? Regards, VinceB.
Re: Printing
Ooops! That was for LO. ___ For AOO, use: Format > Print Ranges > Define. On 10/10/2021 9:39 AM, Vince@Verizon wrote: C.: Have you defined the Print Range? Data > Define Range. First, give it a range name, then adjust the range to include your desired printed range for that sheet. VinceB. On 10/9/2021 2:20 PM, cmc1...@minburncomm.net wrote: Hello, �I have created an autoformatted spreadsheet using openoffice. I have named this spreadsheet but am not able to print it. How do I do this? C. Carlton
Re: Printing
C.: Have you defined the Print Range? Data > Define Range. First, give it a range name, then adjust the range to include your desired printed range for that sheet. VinceB. On 10/9/2021 2:20 PM, cmc1...@minburncomm.net wrote: Hello, �I have created an autoformatted spreadsheet using openoffice. I have named this spreadsheet but am not able to print it. How do I do this? C. Carlton
Re: Richiesta urgente
La richiesta di abbonamento non dovrebbe avvenire... Dove hai scaricato il programma Apache Open Office? Era da https://www.openoffice.org/download/index.html? Buona fortuna. ___ Request for a subscription should not be happening... Where did you download the Apache Open Office program? Was it from https://www.openoffice.org/download/index.html ? Good luck. On 8/31/2021 5:21 PM, Valentina Manzo wrote: Ho ancora moltissimi problemi con il programma openoffice sul mio Mac. Ogni volta che lo apro, come da voi suggerito, devo andare sulle impostazioni ed autorizzarlo. Ma la cosa peggiore è che quando salvo i documenti in odt, mi chiede comunque l’abbonamento per poter modificare e salvare i documenti. Chiedo urgentemente aiuto da parte vostra per risolvere questo problema. Cordiali saluti e grazie per la collaborazione Valentina Manzo - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Apple Big Sur 11.4
Hi Rob: I believe that Big Sur is a mac OS, in which case your problem might be related to Mac's Gatekeeper feature. Since I am not using that OS here for AOO mail list, I cannot give any details, but I have seen messages here about the Gatekeeper. Good luck. VinceB. On 6/23/2021 9:23 PM, Rob Taylor wrote: Hi Snce I auto upgraded to Big Sur 11.4 my Open Office has stopped working - apparently its not compatible. Any idea when it might be? Thanks Rob - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Java Version
Hello Group: My Windows 10 Home is used on a 64-bit architecture DELL desktop. I recently downloaded and installed Libre Office software. So, now I have both packages: 1. Apache Open Office: AOO415m1(Build:9789) - Rev. 1817496 2017-12-11 17:25 (This is AOO 32-bit version.) 2. Libre Office: Version: 6.3.5.2 (x64) Build ID: dd0751754f11728f69b42ee2af66670068624673 The two JREs available to me are: 1. jre-8u201-windows-i586 2. jre-8u241-windows-x64 Given that a 32-bit java and a 64-bit java should/must not be installed on the same machine/partition. I therefore must remove one of the JREs from my machine. Or, install and run the AOO 64-bit version, and keep the JRE-64 bit. But I am uncertain if I would loose any of my 32-bit AOO existing files and/or templates. How should I proceed if I go ahead with the 64-bit AOO installation? Will I loose any 32-bit AOO files/templates? Are there any practical advantages included in AOO-64 over AOO-32? Your suggestions will be appreciated. Thanks for reading this. Stay well and be safe. VinceB. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: format for a website
TNX Brian. That works for me! Regards, Vince Sent from my iPad > On Apr 25, 2020, at 09:45, Brian Barker > wrote: > > At 09:27 25/04/2020 -0400, Vince Bonly wrote: >> Within a Calc sheet there exists, say, www.domain.com in plain text format, >> (or email.addr...@isp.net). How is this converted to a hotlink so when >> clicked my browser opens to that website (or my email client opens a compose >> window) ? > > Easy way: > o Position the cursor in the cell immediately after the relevant text. > o Press the spacebar. > o Backspace over the space to delete it. > > More generally: > o Select not the entire cell but the required text within that cell. > o Insert | Hyperlink. > o Etc. > > 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 >
Re: Optimum Row Height-Default
> On May 3, 2020, at 01:44, Brian Barker > wrote: > > At 13:04 02/05/2020 -0400, Vince Bonly wrote: >> Optimum Row Height-Default >> In Calc, where can the default setting be reset/changed? > > I don't think it can - but do you need to? No; but I almost always want to avoid repeated steps when using PC. > > - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Error Creating Object
AOO 4.1.5; Windows 10 x64 Home on DELL desktop. I have a Calc file opened, and have made some revisions. Everything appears to still be active/working as expected, including auto saves flashings. However, when I attempt to close the file I am shown an error message that reads: Error saving the document filename.. : Error creating object. Could not create backup copy. Any ideas on what is going on and how to save the file? Regards, and please stay safe: VinceB.
It Is Time for Me to Generate an Updated Telephone-Addressbook
Hi: I am staying at home and have time on my hands, so I think this might be a good time to generate an updated telephone/address book in a PC format. Can anyone suggest a "relatively" simple database template for tracking Names, Postal Addresses, Telephone numbers-House, Telephone numbers-Cell, Telephone numbers-Businesses, Medical offices' data, etc? I started by exporting my Contacts from the GMAIL website for my one @gmail.com email account, and have that data now on my WIN10-x64 desktop PC as a .CSV file (to Excel). I also plan to eventually enter the data from a paper telephone/address book into a database. I am not certain which to use, (vers 4.1.5) AOO-Calc or AOO-Base. I also have Libre Office (Version: 6.3.4.2 (x64) Build ID: 60da17e045e08f1793c57c00ba83cdfce946d0aa) installed, but am even less skilled with its operation. 1. Should I go with AOO-Calc or attempt to learn more about AOO-Base for this project? 2. Any suggestion for a template file would be appreciated. Thanks for reading this. Regards and stay safe, VinceB.
Re: Calc Help
Hello Alan B: TNX for reading my query about Calc Help-updating Data.ods. For reasons, unknown to me, my pasted example seems to be plain/unformatted text, although I had sent it out via Mozilla Thunderbird email client using both HTML and plain text to the AOO mailing list, and appeared properly displayed in my compose window. I realize that w/o the full formatting, it is difficult to read and understand what is displayed at your end. This Dropbox link, I think, will allow you to download the full AOO-Calc file: https://www.dropbox.com/scl/fi/2ibk2u5elew1y4mx9b583/Calc-Help-updating-Data.ods?dl=0=zeujgqduhbuo82jmxryylinvd . I am trying to "harvest", via a formula or function, the resulting _Match Series_ (column G) data, which is data only relevant to Vince's game scores. Sorry, I neglected to include the _Vince's Individual Record_ heading over columns B:L in my original example. The game scores for Vince (only) are being tracked on a weekly basis to generate the result that is given in column $G. At present, Cell AL7 contains the formula =G26. This value changes each week, as Vince's new scores are poked into columns D, E, and F each week (i.e., on the next week's row). So, at present, I am manually changing the formula within AL7 to reflect the current week's row. (The _Match Series_ data for my teammates Russ, Dave, and Bob are being poked manually into AL6, AL8, and AL9, weekly. ) In another thread, dated 1/18/2020, Brian Barker has offered suggestions using =MATCH, =OFFSET, and =INDIRECT functions. I am not familiar with those functions, but will likely attempt their use when time permits me to learn more about them. Brian also prefers the use of minimal examples; therefore, I fear that I am verbose in my queries and comments. However, I am hopeful that my comments above have been helpful in clarifying my OP. Again, thanks for your interest in solving my problem. Regards, VinceB. On 1/19/2020 10:00 PM, Alan B wrote: Hello Vince, I'm intrigued but not able to follow what you're trying to do. Columns D through H appear to be the games bowled in any given week, rows (or should I say weeks) 1 through 21 are the results of the games in those weeks. That seems clear to me. But whose games, Russ, Vince, Dave, or Bob's? The disconnect comes with "using the results in [AL] and [AN]". How does a single row shown as 1 - 21 and columns [D] though [H] in your example relate to multiple individuals [AL] through [AN]? They do not . And more importantly, what are you trying to achieve? If I understood that I might be able to offer some useful help. See my comments above. HTH. On Sat, Jan 18, 2020 at 12:48 PM Vince@GMAIL wrote: AOO 4.1.5 on Win10 Home desktop _ Note: Cells with a yellow background identify required data must be entered. Cells with a (darker) gray background identify cells which show calculated results. I have a Calc sheet that I enter data on a regular basis, as shown below: [D] [E] [F][G][H] < Column headings */_Today is Week #_/* */_Today's Date Is_/* */_Game #1_/* */_Game #2 _/* */_Game #3_/* */_Match Series_/* */_Match Average_/* *1* 6-Sep 152 146 187 485 161.7 *2* 13-Sep 133 159 141 433 144.3 *3* 20-Sep 147 155 148 450 150.0 *4* 27-Sep 161 151 142 454 151.3 *5* 4-Oct 130 139 116 385 128.3 *6* 11-Oct *Did Not Bowl. * *7* 18-Oct 148 187 119 454 151.3 *8* 25-Oct 155 167 169 491 163.7 *9* 1-Nov 140 141 157 438 146.0 *10*8-Nov 147 135 155 437 145.7 *11*15-Nov 139 133 155 427 142.3 *12*22-Nov 164 162 164 490 163.3 *13*29-Nov 120 110 155 385 128.3 *14*6-Dec 150 136 125 411 137.0 *15*13-Dec 170 187 132 489 163.0 *16*20-Dec 160 168 146 474 158.0 *17*27-Dec 160 144 150 454 151.3 *18*3-Jan 151 141 138 430 143.3 */_---Half Season---_/* *19*10-Jan *Did Not Bowl. * *20*17-Jan 161 134 147 442 147.3 *21*24-Jan I use the results generated in columns G and H in another section of the sheet, as shown: [AL] [AN] < Column headings *Team #2- ACHES & PAINS v2.0 Post Match Play* *Russ: *458 *Player's Average: *152.67 *Vince: * 442 147.33 *Dave: *555 185.00 *Bob: * 600 200.00 Cells AL7 and AN7 are set to = the results calculated and provided within cells G26 and H26, i.e., they show: 442 and 147.3. My problem is that after calculating an update result within columns G and H, e.g., on 24 Jan, (week # 21's data), the results based on entry of data in D27:F27, there will
Calc Help
AOO 4.1.5 on Win10 Home desktop _ Note: Cells with a yellow background identify required data must be entered. Cells with a (darker) gray background identify cells which show calculated results. I have a Calc sheet that I enter data on a regular basis, as shown below: [D] [E] [F] [G] [H] < Column headings */_Today is Week #_/* */_Today's Date Is_/* */_Game #1_/* */_Game #2 _/* */_Game #3_/* */_Match Series_/* */_Match Average_/* *1* 6-Sep 152 146 187 485 161.7 *2* 13-Sep 133 159 141 433 144.3 *3* 20-Sep 147 155 148 450 150.0 *4* 27-Sep 161 151 142 454 151.3 *5* 4-Oct 130 139 116 385 128.3 *6* 11-Oct *Did Not Bowl. * *7* 18-Oct 148 187 119 454 151.3 *8* 25-Oct 155 167 169 491 163.7 *9* 1-Nov 140 141 157 438 146.0 *10*8-Nov 147 135 155 437 145.7 *11*15-Nov 139 133 155 427 142.3 *12*22-Nov 164 162 164 490 163.3 *13*29-Nov 120 110 155 385 128.3 *14*6-Dec 150 136 125 411 137.0 *15*13-Dec 170 187 132 489 163.0 *16*20-Dec 160 168 146 474 158.0 *17*27-Dec 160 144 150 454 151.3 *18*3-Jan 151 141 138 430 143.3 */_---Half Season---_/* *19*10-Jan *Did Not Bowl. * *20*17-Jan 161 134 147 442 147.3 *21*24-Jan I use the results generated in columns G and H in another section of the sheet, as shown: [AL] [AN] < Column headings *Team #2- ACHES & PAINS v2.0 Post Match Play* *Russ: *458 *Player's Average: * 152.67 *Vince: * 442 147.33 *Dave: *555 185.00 *Bob: * 600 200.00 Cells AL7 and AN7 are set to = the results calculated and provided within cells G26 and H26, i.e., they show: 442 and 147.3. My problem is that after calculating an update result within columns G and H, e.g., on 24 Jan, (week # 21's data), the results based on entry of data in D27:F27, there will be new results in the next row, at cells G27 and H27. Therefore, I am forced to manually change the formulae within AL7 and AN7 to correctly reflect the updated results provided in columns AL and AN, by changing =G26 to =G27 and by changing =H26 to =H27. Is there an easier method of handling this task, through use of a function or a formula? I hope this is described clearly enough. If needed, I will attempt to store the complete calc sheet at a Dropbox link. Let me know. Regards, VinceB.
Re: Printing issue
Check on the configured Print Range setting. HTH. Regards, Vince Sent from my iPad > On Oct 27, 2019, at 15:00, Christel Lugo wrote: > > Hello, > > I am having a problem with Calc-specifically, it won’t print the pages I need > printed. I keep trying to print three specific pages and it will only ever > print one of them. The print preview only shows one of them, too. > > I have tried defining the print range via format and highlighting to no > avail. I have also tried simply selecting a page number range in the print > screen. I have tried deleting the print range under format, but nothing > works. > > Can you help? > > Thanks, > > Dave Lugo > > Sent from my iPhone > - > To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org > For additional commands, e-mail: users-h...@openoffice.apache.org >
Update All Links Question
With a Calc file already opened, is it possible to update all links? - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Links Do Not Work in Calc
AOO 4.1.5 on DELL desktop; WIN10 Home x64
_
I don't know or understand how update Links, or update Styles, is
supposed to work in Calc.
Each time a Calc file is opened, I am prompted for a Yes/No to up date
All Links, or sometimes Y/N to update New Styles.
In an opened Calc file I have selected a cell and pointed to a specific
cell that is located in a different Calc file.
( e.g., entered in the cell:
=('file:///C:/Users/Username/Documents/./filename.ods'#$'sheetname...'.J79
).
This is no longer working in several Calc files ( "0" value is returned
rather than the expected value contained within the external file &
Cell). But, this /pointing to an external file's cell/ does work in a
New Calc file, when pointing to the same external file sheet & cell.
I hope that somebody can point me in the direction of or give me a
description of how this is suppose to work, and perhaps enlighten me on
the possibilities of why it is no longer working for several of my
existing Calc files.
In addition, I would appreciate receiving hints about the Update/Use Old
Styles template prompts.
TNX.
Regards,
VinceB.
No Selection Possible in AOO Calc
Hi: After doing a sort routine in AOO Calc, whenever I right-click on a cell, I am getting an error that reads "". Also, Sort is grayed out under the Data menu. In fact, there are many options that are now grayed out in several drop down menus. The Calc file is opened at present time. Can I close this file w/o loosing work/data? Any ideas on how to correct these problems? Regards, VinceB.
Method to select multiple columns:rows in Calc
I have a Calc sheet in which unwanted background fill color is displayed. The range begins B1307 and C1307 and seems to go the the end (wherever that is). Can anyone suggest an easier method than using the mouse to scroll to the "end" starting from B1307:C? Is there an specific keystroke to jump to the end of a selected column? Using Windows10-64 desktop and AOO-Calc 4.1.5.
Alternate Row Shading
AOO415m1(Build:9789) - Rev. 1817496 2017-12-11 17:25 WIN10-64 Desktop ___ I find that often the template files obtained from https://www.vertex42.com/ make use of alternate row shading, and I would like to also. Example (copied from a CALC spreadsheet): Does anybody know of a technique of placing shading on alternate rows in CALC, as shown above? Does this require use of macros or is there a function that can implement this? Implementing this in my CALC spreadsheets might lead to some difficulties, since I often use a sorting routine. I will address that issue at a later time. Regards, VinceB.
Re: Insertion of a Link
On 5/28/2018 4:16 PM, Brian Barker wrote: At 13:16 28/05/2018 -0400, Vince Bonly wrote: I am attempting to insert a link to a .ODT file that contains "read me first" information associated with one of my Calc spreadsheets. I have made use of an inserted link on one or two occasions, but do not recall with confidence what I actually had done. At present, I want to: 1. initially, create the ReadMeFirst text (.ODT) with AOO Writer; 2. insert a link to the resulting .ODT text file within my Calc .ODS file; 3. have edits to the .ODT file with Writer in the future reflected/updated whenever I click on the link in the .ODS file. Can this be accomplished with AOO? If yes, how should I go about doing the link insertion in Calc? Have you read "Hyperlinks and URLs" in Chapter 10, "Linking Calc Data", of the Calc Guide? You should, you know. o Go to Insert | Hyperlink (or click the Hyperlink button in the Standard toolbar). o Click Document at the left. o Under Document, click the Open File icon and browse to and select your target text file. o Under "Further settings", select Text or Button as preferred. o For Text, enter the text you want to appear for the link. o Click Apply and Close. You may want to go to Tools | Options... | Load/Save | General | Save and to tick "Save URLs relative to file system" or to leave it unticked if you want these to be absolute. The usefulness of relative addressing is that the link will still work if the files are moved but retain the same relative positions in folders. So if you have , say, both files in the same folder or perhaps have the text file in a "Text" subfolder of the spreadsheet's folder, the hyperlink will still work if both files are moved - perhaps even to another system - but retain their relative positions. Do not worry that, even with relative addressing chosen, the address for Path in the Hyperlink dialogue will always show as an absolute path. I trust this helps. Brian Barker Brian: I assume that you mean the following document, which I have on my PC as a PDF file: /_OpenOffice.org 3.3_//_ _//_Calc Guide_//_ _//_Using Spreadsheets in OpenOffice.org 3.3_/ Copyright © 2005–2011 by its contributors. I also have a LibreOffice 4.1 document entitled: _/Calc Guide/__/ /__/Using Spreadsheets,/_ Copyright © 2013 by the LibreOffice Documentation Team. I do not use LibreOffice, but do have it installed on my PC. Both those documents' ToC appear to be very similar. I will use Chapter 10 in the OpenOffice. org 3.3 document for my study. I have added a button for Hyperlink to my toolbar. TNX. VinceB.
Insertion of a Link
AOO415m1(Build:9789) - Rev. 1817496 2017-12-11 17:25 WIN10-64 ___ I am attempting to insert a link to a .ODT file that contains "read me first" information associated with one of my Calc spreadsheets. I have made use of an inserted link on one or two occasions, but do not recall with confidence what I actually had done. At present, I want to: 1. initially, create the ReadMeFirst text (.ODT) with AOO Writer; 2. insert a link to the resulting .ODT text file within my Calc .ODS file; 3. have edits to the .ODT file with Writer in the future reflected/updated whenever I click on the link in the .ODS file. Can this be accomplished with AOO? If yes, how should I go about doing the link insertion in Calc? Regards, VinceB.
Re: Incomplete/Incorrect Template Name is Shown via Use of Splash Screen
Thanks Brian. On 5/27/2018 6:53 PM, Brian Barker wrote: At 16:13 27/05/2018 -0400, Vince Bonly wrote: I went through a process to convert an existing .ods to a .ots . I used File | Templates | Save, ... Now, however, I believe that an incomplete/incorrect is shown via the Splash Screen and/or via File | Templates | Template Management. When clicking on "Te_m_plates..." at the logo/splash screen, the Templates and Documents dialogue screen is displayed. I then click on _T_emplates and then I select My Templates to get a listing within the Title pane area. Within the listing is shown: IRS Income Tax Template; that is an incorrect template name/filename. I think it should be listed as: IRS Income Tax CalculationsTEMPLATE (no space between Calculations and TEMPLATE). The complete Windows filename is: IRS Income Tax CalculationsTEMPLATE.ots, which is what I Saved As into my /AppData/Roaming/OpenOffice/4/user/template/ folder after removing numerical data from a spreadsheet named: IRS Income Tax.ods. I get the same incorrect template name when using File | Templates | Template Management in the Templates pane, whereas I get the correct filename shown within the Documents pane. What am I not doing correctly? I have shut down AOO and restarted AOO with the same problem. I have rebooted my PC and opened AOO, also with the same problem. I think you are perhaps contradicting yourself here. You say you saved the template in My Templates using File | Templates > | Save... . But then you say that you used Save As... (presumably File | Save As...) to save a document file (as a template) to a specific folder - the "template" folder. These are two different things, and I suspect that confusion between the two is causing your problem. No, I did not use File | Save As. Perhaps I have misspoken, made a typo or experienced an unwarranted PC auto fill. I used File | Templates> | Save ... while having the revised (blank numerical data) file opened; to place the new template into AOO's template folder, (%AppData%). I chose to name the newly created template: IRS Income Tax CalculationsTEMPLATE (no space between Calculations and TEMPLATE). In general it is good practice to use the user interface provided and not to try to take shortcuts that you think or hope will produce the same effect. So I suggest that you should use File | Templates > | Save... and that you will see no problem that way. OpenOffice is being cleverer that you give it credit for here, such that you can give templates names which are not possible file names in the Windows file system. Take, for example, a template name containing a question mark: you can have this, but OpenOffice needs to use an alternative file name where it saves the template - and does. I suspect that you have been saving and deleting templates and files and confusing OpenOffice and possibly also yourself. I'm guessing that the "wrong" name you see is one your somehow previously ctreated. I am unclear as to how I managed to make AOO confused about the template name. In any case, looking forward, I shall make an effort to think of the %AppData% folder as an Authorized Personnel Only area; perhaps go there when I need to view template names and/or date of creation/modified, etc. Maybe also when I have downloaded a template that then needs to be imported there. Recommendation: Close File Explorer and don't meddle in %AppData% unless you really have to. Save, organise, and delete templates using the File | Templates interface. Delete any wrongly named template there and save it anew with your preferred name.
Incomplete/Incorrect Template Name is Shown via Use of Splash Screen
AOO415m1(Build:9789) - Rev. 1817496 2017-12-11 17:25 WIN10-64 desktop I went through a process to convert an existing .ods to a .ots . I used File | Templates | Save, after removing the various inputted numerical data from a previous year's computation. Now, however, I believe that an incomplete/incorrect is shown via the Splash Screen and/or via File | Templates | Template Management. When clicking on "Te_m_plates..." at the logo/splash screen, the Templates and Documents dialogue screen is displayed. I then click on _T_emplates and then I select My Templates to get a listing within the Title pane area. Within the listing is shown: IRS Income Tax Template; that is an incorrect template name/filename. I think it should be listed as: IRS Income Tax CalculationsTEMPLATE (no space between Calculations and TEMPLATE). The complete Windows filename is: IRS Income Tax CalculationsTEMPLATE.ots, which is what I Saved As into my /AppData/Roaming/OpenOffice/4/user/template/ folder after removing numerical data from a spreadsheet named: IRS Income Tax.ods. I get the same incorrect template name when using File | Templates | Template Management in the Templates pane, whereas I get the correct filename shown within the Documents pane. What am I not doing correctly? I have shut down AOO and restarted AOO with the same problem. I have rebooted my PC and opened AOO, also with the same problem. Has anyone else had this problem? Regards, VinceB.
Re: Unable to Insert a Column
Cause of my problem has been found and removed! Yes; I had copied & pasted an entire row from the original spreadsheet into my new targeted sheet, and that filled every column. On 5/23/2018 11:51 AM, Brian Barker wrote: At 11:03 23/05/2018 -0400, Vince Bonly wrote: Working with an existing Calc spreadsheet, I copied it in its entirety to a new sheet. I now find that I am unable to insert a column anywhere on the new targeted sheet. When I attempt to insert a column in the targeted new sheet, I am shown the following error, which I have not ever seen before. /*Filled cells cannot be shifted beyond the sheet.*/ I am able to insert a new row. In any spreadsheet application, there is a limit to the number of columns (and rows) that you can use. The limits are so large that you don't usually have to have any recognition of them. But when you insert a column (or row), an existing column (or row) has to be knocked of the side or bottom of the sheet. This is fine if that column (or row) is empty - as will normally be the case - but not if it contains a value or formula. If you cannot insert a column, there must be something in the extreme right hand of the available columns; that's *available* columns, of course - not just those you can see. So why is there something in that column? Unless your active data is unusually extensive, it is probable that you have used a technique to fill at least one row indefinitely, perhaps using Edit | Fill > | Series... or by selecting an entire row before pasting some content, which will have put content into all the possible cells of that row. The reason that you can insert new rows is simply because you have not filled any column indefinitely in the same way. There are various solutions: o When filling the row or rows, avoid doing so indefinitely. o Move to the right of the spreadsheet area that you are actually meaning to use, and delete an unnecessary column or columns. This will move the rogue material at the extreme right of the relevant row in by a column or columns, leaving empty cells. You will now be able to insert a column, dropping a new, empty column off at the right. 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
Unable to Insert a Column
AOO415m1(Build:9789) - Rev. 1817496 2017-12-11 17:25 Desktop Win10-64 Working with an existing Calc spreadsheet, I copied it in its entirety to a new sheet. I now find that I am unable to insert a column anywhere on the new targeted sheet. When I attempt to insert a column in the targeted new sheet, I am shown the following error, which I have not ever seen before. /*Filled cells cannot be shifted beyond the sheet.*/ I am able to insert a new row. Would like to find out what is causing this problem. TNX. Regards, VinceB.
Re: Trouble printing
Glad that you managed to clean things up. I occasionally allow my HP8600 to run a 'clean-the-print head' routine. If I am not mistaken, the recommendation for inkjet printers is to Not have it energized until ready to put it into operation; to avoid inkjets becoming clogged ? VinceB. On 3/26/2018 7:01 PM, MARIE RETKA wrote: I think I got it fixed. I ended up cleaning my whole printer, including taking out the print heads and scrubbing them. It seemed to work. THANKS!! _ - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
NAMES in AOO- Calc
AOO415m1(Build:9789) - Rev. 1817496 2017-12-11 17:25 on WIN10-x64 desktop Using Calc: Have recently became aware of and began using Names in Calc spreadsheets (thanks MartinG.). Is there a method to transfer Names that already exist within a Calc .ODS file to another Calc .ODS file? How is it done? Regards, VinceB. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Need Formula to use with Results of LARGE( ) Function's Result- Lookup?
Martin: What is your point ? If you’re not that interested in offering assistance, please ignore my request(s) for help. Normally, I give thanks to (helpful) replies. Clearly, your reply is of no help to me. Regards, Vince Sent from my iPad > On Mar 14, 2018, at 17:18, Martin Groenescheij <mar...@groenescheij.com> > wrote: > > This is the fourth version of your problem. > Keep trying, if you don't succeed by version 21 I will have a look into your > question. > > >> On 15/03/18 3:29 AM, WA.TWORSX via AOL wrote: >> >> >> Hi Again: >> >> _ >> >> AOO415m1(Build:9789) - Rev. 1817496 >> 2017-12-11 17:25 on WIN10-64 Desktop >> >> _ >> >> I am still struggling with this project; and I do need and seek help, >> however! >> >> I have uploaded to DropBox an AOO-Calc spreadsheet file. Here is the shared >> link: >> https://www.dropbox.com/s/e84yntxyouf7if7/BVL%20Summary%20Trial%20Sheets%20%281%29.ods?dl=0 >> >> >> I draw your attention to Sheet 4 in the BVL Summary Trial Sheets(1).ods file: >> >> Note that cells E57:Q57 contain the names of 13 bowlers. The data displayed >> in cells E58:Q60 was calculated using the LARGE( ) function to obtain the >> game scores for each bowler. The data displayed within cells D75:F109 was >> calculated using the LARGE( ) function to obtain 35 bowling scores in >> decreasing order (“233” is the highest and “77” is the lowest). >> >> The task is to correlate the highest score (i.e., “233”, found in cell F75), >> and each score that follows in cells F76:F109, with the name of the bowler, >> that made the corresponding game score, (in this instance, Bob M., found in >> cell F57). I want to display the appropriate resulting bowler names within >> cells H75:H109. >> >> Is there an AOO-Calc formula/multiple functions that can be used to solve >> the task at hand? I have looked at the LOOKUP( ) and RANK( ) functions, >> but did not get very far. I am hoping that there is a way to match the >> bowlers' name with the corresponding game score. >> >> >> Regards, >> VinceB. >> >> >> > > > - > To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org > For additional commands, e-mail: users-h...@openoffice.apache.org >
Re: Need Formula to use with Results of LARGE( ) Function's Result- Lookup?
FYI: I have updated my Drop Box BVL Summary Trial.ods sheet. Here is the link to it (I hope that it works this time): https://www.dropbox.com/s/rtkpz3yl7cqritu/Drop%20Box%20BVL%20Summary%20Trial.ods?dl=0 . On 3/10/2018 10:57 AM, WA.TWORSX via AOL wrote: Hi Again: Well, my previous posting failed, due to the formatting not being carried over in the post. Copy and Paste works okay with a YahooGroup Mailing List, but not here. So, I am making another attempt to present my question/problem, and ask for advice and assistance. (I imagine that this problem is not unlike a sales manager ranking the performance of 13 salesmen during a specific period, nor is it unlike determining which of 13 factories produced the highest product output over a specific time period. I have read through Chapter 7 of the Calc vers 3 user's guide, but did not find a solution. Perhaps this problem could more easier be solved using AOO- Base, with which I am not experienced in using.) _ AOO415m1(Build:9789) - Rev. 1817496 2017-12-11 17:25 on WIN10-64 Desktop _ I am working with a data set that, ultimately, at the end of a bowling tournament will show a collection of bowling scores. At present, there are 13 bowlers participating in the tournament, and that number might increase. See this drop box link, which shows my work thus far: https://www.dropbox.com/s/rtkpz3yl7cqritu/Drop%20Box%20BVL%20Summary%20Trial.ods?dl=0 . Cells E25:T25 contain the names of the 13 bowlers. Cells E33:T44 contain the numerical data of interest (i.e., scores gathered during the tournament's competition phase). I used the =LARGE($E$33:$T$44;1) thru =LARGE($E$33:$T$44;9) to calculate the nine highest scores within the score data of interest; the results are shown in cells E9:E17. This will ultimately be expanded to include the 45 highest bowling scores with the identifying bowler's name for each (qualifying) score. (I have begun doing that in cells G9:I19.) I need to correlate the BOWLER'S NAME with each of the HIGHEST SCORES, and fill in the BOWLER's NAME column (cells D9:D17;H9:H19, etc.). E.g., POSITION 1 shows a score of 233 (in cell F35) and that was by bowler Bob M. (in cell F25). Is there a Calc function that will "look up" the appropriate name in Row 25 for each of the remaining HIGHEST SCORES and display the result within the BOWLER's NAME columns? Any suggestions shall be appreciated. Regards, VinceB. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Need Help with Calc =LARGE( ) Function
AOO415m1(Build:9789) - Rev. 1817496 2017-12-11 17:25 on WIN10-64 Desktop _ Hi: I am working with the data set shown below, at bottom. Cells E4:T4 contain the names of 13 players. Cells E32:T43 contain the score numerical data of interest. I used the =LARGE($E$32:$T$43;1) thru =LARGE($E$32:$T$43;9) to calculate the nine highest scores within the score data of interest, and obtained the following results: __ _POSITION_ _HIGHEST SCORES__Player Name_ 1 233 2 222 3 194 4 188 5 185 6 179 7 176 8 174 9 184 I need to correlate the player's name with the HIGHEST SCORE, and fill in the Player Name column. E.g., Position 1 shows a score of 233 (in cell F13) and that was by player whose name is Bob M. (in cell F4). Is there a Calc function that will "look up" the appropriate name in Row 4 for each of the remaining HIGHEST SCORES and display in the Player Name column? */ /* _Date_ _ _ /ANTHONY ?/ /BOB M./ /DENISE C./ /GLEN U./ /JASIU M./ /JOHN G./ /RAY H./ /RON J./ /SAM C./ /RUSSEL P./ /VINCE B./ /WILLIE M./ /VAN ?/ _20th February-practice #1_ _Game 1_ 92 149 122 0 117 150 61 104 197 154 184 177 n/a _Game 2_0 147 148 0 130 179 97 143 212 107 185 156 n/a _Game 3_0 187 152 0 129 165 80 144 181 122 141 154 n/a _27th February-practice #2_ _Game 1_ 0 190 0 140 113 149 0 142 153 96 169 199 n/a _Game 2_0 162 0 124 155 166 0 157 220 132 151 134 n/a _Game 3_0 204 0 119 100 184 0 137 143 175 154 161 n/a _6th March -Competition #1_ _Game 1_ 0 161 125 83 87 173 88 188 222 105 179 126 119 _Game 2_0 168 110 146 154 185 92 159 194 167 132 157 77 _Game 3_0 233 113 147 108 152 129 147 176 125 173 174 0 _Competition #2_ _Game 1_ n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a _Game 2_n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a _Game 3_n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a _Competition #3_ _Game 1_ n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a _Game 2_n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a _Game 3_n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a _Competition #4_ _Game 1_ n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a _Game 2_n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a _Game 3_n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a n/a _ _ /ANTHONY ?/ /BOB M./ /DENISE C./ /GLEN U./ /JASIU M./ /JOHN G./ /RAY H./ /RON J./ /SAM C./ /RUSSEL P./ /VINCE B./ /WILLIE M./ /VAN ?/
How to Embed My List of Reminders
AOO415m1(Build:9789) - Rev. 1817496 2017-12-11 17:25 - Calc in use on a WIN10-64 desktop. I would like to register/link/embed a file on my computer that serves as a reminder of the colors that I should use within a particular Calc workbook, as shown below. There is a high likelihood that additional "reminder" entries will occur sometime in the future, so I think a centrally registered, stored AOO Writer file, which shall be revised as needed, is desired for this purpose. At present I have the reminders present on each Calc sheet in my spreadsheet file. This is problematic, because it is somewhat difficult to paste the info when considering the width of the column and the likelihood that additional reminder entries are potentially needed. I tried using copy-paste into a "comment" box, but the color shadings are not shown when displaying the comment in Calc; i.e., the color shading is required. I suspect that an "object" file must be inserted; however, I am not experienced in that Calc feature at present. Can anyone suggest a method that I might use such that I can optionally display my "registered reminders" (see below), perhaps as a popup on screen while I am at the same time viewing the Calc sheet presently being worked on? Is it possible to "split" the displayed screen such that Sheet 1 is on the left and Sheet 2 is on the right? I need to see both the reminders and the present worksheet on the screen at the same time. Thanks. Regards, VinceB. COLOR CODING USED ON THIS SHEET GRAY 1: Shaded box area for filled-in form. GRAY 3: Calculated (locally) value result. GREEN 3: Values swiped from another sheet. CHART 1:Values swiped from another document/sheet. YELLOW: Values filled-in manually by operator. GRAY 1 GRAY 2 GRAY 3 GRAY 4
Re: Unfamiliar Additional Column has Appeared in my Calc Sheet #7
Thanks again. Regards, Vince Sent from my iPad > On Feb 17, 2018, at 14:21, Brian Barker <b.m.bar...@btinternet.com> wrote: > > At 13:15 17/02/2018 -0500, Vince Bonly wrote: >> Yes, Data | Group and Outline> | Remove did the trick, Brian. Thank you. > > No probs! > >> Now that I am aware of another feature, I must read up on it. I have no idea >> about what Group and Outline does or when I would want to make use of it. > > See Chapter 2, "Entering, Editing, and Formatting Data", and Chapter 8, > "Using the DataPilot", of the Calc Guide, apparently. > > Brian Barker > > - > To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org > For additional commands, e-mail: users-h...@openoffice.apache.org >
Re: Printed Page Layout
At 12:58 29/05/2017 -0400, Vince Bonly wrote: I have an AOO-Calc sheet set for landscape orientation. I have set the row height for Optimum Row Height since several cells have multiple lines of text data. The first seven rows are repeated at top of each printed page. Am having difficulty getting the height of each page to be equal, after moving the Blue page break line up/down while in View | Page Break Preview mode. I don't see what difficulty you can be having. You can move page breaks up to reduce what is on each page, of course. If you move breaks down, so as to overload any page, it seems that what you are squeezing in is automatically scaled to fit. You can see this at Format | Page... | Sheet | Scale | Scaling mode | Scaling factor. If you set the scaling factor back to 100% there, you force your overloaded page to become two again, of course - but retain another break where you put it. It is not clear to me what you mean by "so as to overload any page" or "you force your overloaded page to become two again, ". Is there a method to configure each page to be a specified, consistent, and equal height, i.e. equal number of rows? There cannot be - as those are two conflicting requirements. You imply that your row heights vary, so the same number of rows would in general be different page heights. Yes, I did say " since several cells have multiple lines of text data". I disagree; the programming does not presently exist but could be implemented. I.E., it would be nice that when "framing" the page palette, such that it includes a consistent amount of row data (area), if a multiple-line row cannot fit, then the complete row is carried over to the next page frame; sorta like in a word processor, paragraphs are kept together and brought to the next page. Is there a feature for setting page height to Optimum Page Height? Surely that's what you get by default - before you start tinkering in Page Break Preview? Otherwise, isn't it all down to careful experimentation? I have spent a good deal of time "tinkering" and "experimentation", without success, but with frustration. Is there an easy way to start from scratch, i.e., with the defaulted page frames? if so, how? I have just now copied the entire sheet to a blank AOO Calc sheet. That appears to have answered my own question, and now I have the defaulted page framing. That part of my problem is solved. I would also like to have, e.g., five or ten, empty rows appear at the bottom of each printed page, so that I may manually hand write in new data to that particular printed page for later incorporation/revision to the sheet. You'll need to add these empty rows to your spreadsheet explicitly, I think. It's fiddly but easy to do. You can see in Page Preview exactly where your extra rows should come and you can add them easily using Insert | Rows. Depending on your design of the spreadsheet, you may need to modify some formulae if they are still to work appropriately for you. You may well wish to use a copy of your document in which to add these rows, so that you can return to the unchanged version for future editing. Perhaps, addition of one full page of blank rows is a solution to this quest, or I will try addition of a footer containing blank rows. But, is there a limitation imposed for the footer area? This particular AOO-Calc sheet contains text strings only; no formulae are required. Maybe I will try using a Table within AOO-Writer instead of using AOO-Calc ! In either case, I do need to be able to do a sort on a selected column and repeat the column headings on each printed page. I trust this helps. Brian Barker Thank you Brian for your reply to my concerns. VinceB.
Page Layout
Using Windows 10-64 on a desktop DELL; and AOO413m1(Build:9783) - Rev. 1761381 2016-09-29 02:39:19 ___ I have an AOO-Calc sheet set for landscape orientation. I have set the row height for Optimum Row Height since several cells have multiple lines of text data. The first seven rows are repeated at top of each printed page. Am having difficulty getting the height of each page to be equal, after moving the Blue page break line up/down while in View | Page Break Preview mode. Is there a method to configure each page to be a specified, consistent, and equal height, i.e., equal number of rows? Is there a feature for setting page height to Optimum Page Height? I would also like to have, e.g., five or ten, empty rows appear at the bottom of each printed page, so that I may manually hand write in new data to that particular printed page for later incorporation/revision to the sheet. Would I use the repeat rows feature in this case? If so, when using Format | Print Range | Edit, can multiple ranges of rows-to-be-repeated be implemented: how? Or, is a Footer, containing five or ten empty rows, required here? Regards, VinceB, - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Printed Page Layout
Using Windows 10-64 on a desktop DELL; and AOO413m1(Build:9783) - Rev. 1761381 2016-09-29 02:39:19 ___ I have an AOO-Calc sheet set for landscape orientation. I have set the row height for Optimum Row Height since several cells have multiple lines of text data. The first seven rows are repeated at top of each printed page. Am having difficulty getting the height of each page to be equal, after moving the Blue page break line up/down while in View | Page Break Preview mode. Is there a method to configure each page to be a specified, consistent, and equal height, i.e., equal number of rows? Is there a feature for setting page height to Optimum Page Height? I would also like to have, e.g., five or ten, empty rows appear at the bottom of each printed page, so that I may manually hand write in new data to that particular printed page for later incorporation/revision to the sheet. Would I use the repeat rows feature in this case? If so, when using Format | Print Range | Edit, can multiple ranges of rows-to-be-repeated be implemented: how? Or, is a Footer, containing five or ten empty rows, required here? Regards, VinceB,
Re: Quick Method to Insert Rows
Thank you, I shall give that a try, later. Regards, Vince Sent from my iPad > On Mar 4, 2017, at 14:04, Girvin Herr <ghe...@fastmail.com> wrote: > > > >> On 03/04/2017 09:50 AM, VinceB. wrote: >> Hello: >> >> In AOO Calc 4.1.3, is there a quicker method for adding rows other than one >> at a time? There has been need to insert, for example, ten rows between two >> existing rows. Doing this one row at a time is "dull". >> >> Regards, >> >> VinceB. >> >> >> >> - >> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org >> For additional commands, e-mail: users-h...@openoffice.apache.org >> > Vince, > Yes. Left click on the row number (far left column) you want to start > insertion. While holding the left mouse button down, drag the mouse down the > number of rows you want to insert and release the left button. Right click > somewhere on the selected row numbers and select "Insert rows". The number > of rows selected should shift down and create the number of blank rows for > you. > HTH. > Girvin Herr > > > - > To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org > For additional commands, e-mail: users-h...@openoffice.apache.org >
COUNTIF Function Criteria: Can color of cell data be detected for counting?
Hi Folks: I keep track of my bowling scores in a AOO 4.1.2 Calc file on WIN10 desktop. I take the time to enter scores above a certain threshold in Red font color. I would like to count the number of times a score within a range of cells is above the specified threshold. For example: COUNTIF(A1:G10,Red). Is this possible to do? It appears, per the Help documentation, that the COUNTIF function criteria does not allow for detection of attributes assigned to a cell. Is that correct? I tried: =COUNTIF(D439:K453,>174), but that does not work and did not return any error ref. Please advise. Regards, VinceB. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: "McAfee Spam" Folder and "popstate-1.dat" Folder
Martin: Thank you very much for taking time to answer my question. Regards, VinceB. Regards, Vince Sent from my iPad > On Jan 2, 2017, at 19:26, Martin Groenescheij <mar...@groenescheij.com> wrote: > > > >> On 03/01/17 3:57 AM, VinceB. wrote: >> >> I have managed to delete both of those folders. >> >> Does anyone have an answer to B. below? >> >> >>> On 12/18/2016 12:18 PM, VinceB. wrote: >>> >>> Using Tbird 45.5.1 on Windows10x64 desktop >>> >>> >>> I have two Verizon, one Gmail and one Yahoo email accounts >>> registered with Tbird. >>> >>> _ >>> >>> >>> A. >>> >>> >>>[.] >> >>> B. >>> >>> >>> What is the significance of a "popstate-1.dat" folder? > > See here for the answer: https://support.mozilla.org/en-US/questions/1129690 > >>> >>> >>> One of the two Verizon email accounts and the Yahoo email account, >>> each, show a "popstate-1.dat" folder. I have no clue how or why >>> those folders were created. Both .dat folders are empty. >>> >>> >>> Is there a way to delete these unwanted/unnecessary folders ? >>> >>> __ >>> >>> >>> Regards, >>> >>> >>> VinceB. >>> >>> >>> >>> >>> >> >> >> - >> 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: Cannot locate Dialog for editing Cell range in Calc's Line Chart
On 11/5/2016 1:31 PM, VinceB. wrote: AOO412m3(Build:9782) - Rev. 1709696 2015-10-21 09:53:29 (Mi, 21 Okt 2015 WIN10x64 Desktop Please point me to the required dialog for changing the cell range in a Calc Line Chart. When I right-click in white area, the drop down shows Edit, but nothing about cell range or data series is then shown? I cannot seem to locate how to edit the chart's X-axis cell range or cell series (I don't know/understand which is needed) to include the latest MATCH AVG data points. (See also my 28 OCT posting.) Regards, VinceB. I do not know if the above actually made it to the Mailing List servers. I've forgotten which email address I used to register for the AOO users Mail List. If there is a method to extend/revise the cell range for an existing line chart in Calc, please give me some instruction on locating the required dialog screen. I've had to create a new line chart as a workaround, but I suspect that I am not using the correct sequence. Thanks in advance. Regards, VinceB - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Is there an insert Filename or insert Full Path Available?
On 10/25/2016 8:04 PM, VinceB. wrote: AOO412m3(Build:9782) - Rev. 1709696 2015-10-21 09:53:29 (Mi, 21 Okt 2015) WIN10x64 I would like to include the full path or filename within a CALC cell and within the print range area. Is this possible ? Regards, VinceB. I am still struggling with this issue. In AOO 4.1.2, *Calc*, I do not find Insert >> Fields. I am not referring to AOO-Writer/Text Document. Will check this out there also, but I vaguely recall having the function available; it might have been MS Excel, however. Yes, I am hoping that there is something available that works automatically. :-) I do have fat fingers, am visually impaired, and am an old fart nearly 72 in yrs. There have been a few occasions where I use split screen to view two Calc files on screen. A display of the filename/full path of each opened Calc file would be helpful to me. Having the Filename or Full Path appear in a printout is also helpful to me. I do appreciate the replies given, and any other comments that may arrive. Regards, VinceB.
Re: How can I Cut and Paste Calc's Formulae Data into Thunderbird email Client?
On 10/16/2016 10:41 PM, Brian Barker wrote: At 12:24 16/10/2016 -0400, Vince Bonly wrote: I am attempting to paste a portion of a AOO 4.1.2 Calc sheet with Formulae displayed into Thunderbird 45.4.0 compose window on WIN10x64 machine. My ISP is Verizon. Seems that I am not able to show the formulae, which is what I want to discuss, into the email compose window; only the results of the existing formulae can be pasted. Two suggestions: o Paste plain text. If Thunderbird has a facility to paste unformatted text only, I think that should work. If not, consider staging the copy via a plain text editor or even via an OpenOffice text (Writer) document, using Paste Special and "Unformatted text" to paste there. Values will be separated by tab characters, so you will need to set tabs to space your columns out appropriately. I must look onto obtaining a better understanding of the Paste Special and the "Unformatted test" features...:-) o Save the sheet as CSV (as has been suggested). o Reopen the CSV file in Calc. o In the Text Import window, select appropriate columns and change "Column type" from Standard to Text. o You now have a new spreadsheet with just the appearance of your original one with formulae viewed. o Copy and paste from that. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Naming a String that appears within a Calc formula
On 10/16/2016 10:41 PM, Brian Barker wrote: If you insert rows or columns, formulae containing ranges spanning those insertions are automatically updated to expand the range. This is true whether the range appears explicitly or as a name. In other words, names are also updated appropriately. The problem is that the usual exception to that - perhaps understandably - is if rows or columns are inserted before or after the range, in other words immediately outside it. So, to have names updated appropriately, I simply must learn to insert any required additional rows "inside" the existing range of cells. Brilliant !! ;-) Doing so will save me headaches of sufferings. Apparently, I was imposing an exception, routinely ! ! I have been in the habit of waiting until I have used up all rows within the range of cells, going about inserting new, blank rows, located immediately outside the range, and then doing a copy & paste of that last "inside" row, in its entirety, to all newly added rows but the very last one. But you can choose to allow exactly that - as you wish here - simply by ticking the option at Tools | Options... | OpenOffice Calc | General | Input settings | Expand references when new columns/rows are inserted. Ahhh; I will give this Tools | Options . a try as well. Can't hurt. Many thanks, again, Brian. Regards, VinceB. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Naming a String that appears within a Calc formula
This is a Drop Box link to my (whole nine yards) spreadsheet:https://www.dropbox.com/s/0l47bmgpwlsx4bo/2016%20My%20Bowling%20Score%20Data.ods?dl=0 I draw your attention to the '2016 Scores sheet, Rows C459 thru C479. The formula that appears in C459 contains the text string:$D$343:$L450 Since the number of rows is increasing over the year, I would like to name that range and use it as a replacement in the formulae. Then, whenever I find that I need to insert additional rows, I think there is a simpler method to edit/modify the named range of cells to end at a $L### cell, as needed. Does this make any sense? Is it possible to do, rather than using Search and replace for each appearance of $L450 with a new ending range point cell, $L###? I hope that I described the problem and my goal clearly enough. Regards, VinceB.
Re: How can I Cut and Paste Calc's Formulae Data into Thunderbird email Client?
TNX Steve. Right now I am not sure I can send anything via Verizon SMTP server. Will try to create a portion of the spreadsheet and place it on DropBox for creation of a link before halftime of football game (being recorded now). Have not ever done that, yet! (Or, perhaps the whole nine yards.) Regards, VinceB. On 10/16/2016 1:04 PM, Steven Ahlers wrote: Vince, You can share the spread sheet through Drop Box and put the link in an email. Steve Sent from my iPhone On Oct 16, 2016, at 9:53 AM, Wade Smart <wadesm...@gmail.com> wrote: On Sun, Oct 16, 2016 at 11:24 AM, Vince@Gmail <wa2rs...@gmail.com> wrote: I am attempting to paste a portion of a AOO 4.1.2 Calc sheet with Formulae displayed into Thunderbird45.4.0 compose window on WIN10x64 machine. My ISP is Verizon. Seems that I am not able to show the formulae,which is what I want to discuss, into the email compose window; only the results of the existing formulae can be pasted. What am I missing? Can someone recommend a website for storage of a Print Screen for this purpose? Regards, VinceB. You can copy each cells formula but not multiple cells. I just tried it here and it only displays the results. -- Registered Linux User: #480675 Registered Linux Machine: #408606 Linux since June 2005 - 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
How can I Cut and Paste Calc's Formulae Data into Thunderbird email Client?
I am attempting to paste a portion of a AOO 4.1.2 Calc sheet with Formulae displayed into Thunderbird45.4.0 compose window on WIN10x64 machine. My ISP is Verizon. Seems that I am not able to show the formulae,which is what I want to discuss, into the email compose window; only the results of the existing formulae can be pasted. What am I missing? Can someone recommend a website for storage of a Print Screen for this purpose? Regards, VinceB. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Problem with Sort in Calc
Sorry for my delay in replying; had email issues with my @verizon account. Yes, I was using the Sort Ascending button, will try to remember to use Data | Sort for sorting adjacent columns of data. Regards, Vince Sent from my iPad > On Oct 6, 2016, at 18:59, Brian Barker <b.m.bar...@btinternet.com> wrote: > > At 11:59 06/10/2016 -0400, Vince Bonly wrote: >> When sorting data in AOO Calc, must the "key" text data be located in the >> leftmost column? It seems that it is so. > > No, definitely not. > > It may be that you are using the Sort Ascending or Sort Descending buttons in > the Standard toolbar. When you have selected a cell range, one of those cells > is left individually highlighted. If you then use one of the Sort buttons, > the cell range is sorted on the column containing that individual cell. By > taking care over the way you drag the mouse to select the range or how you > use click and Shift+click, you may be able to sort on different columns. > > Alternatively, after you have selected the cell range, go to Data | Sort... > instead. This opens the Sort dialogue, which gives a wide range of options, > including the sort criterion: under "Sort by" you can select the column (or > columns) to be used. > > 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 >
Re: Adjustment of high limit and low Limit in AOO-Calc Line Chart
It's possible that I do! However, my apology; I mixed up you for another poster (Rory). On 9/21/2016 11:39 AM, Brian Barker wrote: At 09:14 21/09/2016 -0400, Vince Bonly wrote: Thank you, Brian. No probs! I hope you have a successful trip. Trip? What trip? Do you know something I don't?! 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: Adjustment of high limit and low Limit in AOO-Calc Line Chart
Thank you, Brian. As is the usual case, your concise hints are extremely helpful. Yes, my issue was in regard to the Y-axis scaling. I hope you have a successful trip. Regards, Vince Sent from my iPad > On Sep 20, 2016, at 20:28, Brian Barker <b.m.bar...@btinternet.com> wrote: > > At 15:31 20/09/2016 -0400, Vince Bonly wrote: >> I am working with a line graph chart in Calc that presently shows "180.00" >> as the top limit and "0.00" as the low limit. I vaguely recall that there is >> a way to adjust those limits, but I have not been able to locate the >> edit-dialog. I want high limit to be "250" and low limit to be "100" and >> increments of 5. > > You are talking about the y-axis, I trust - not the x-axis? > > o Double-click the chart, so that it shows its grey border (not the eight > coloured handles). > o Right-click the y-axis and go to Format Axis... (or go to Format | Axis > | > y-axis...). > o On the Scale tab, remove the ticks from Automatic as necessary and modify > the Minimum, Maximum, and "Major interval" values. > > Note that the labels will follow the grid you have defined only if their font > size is small enough to permit this. You can adjust this on the Font tab of > the same 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 >
Adjustment of high limit and low Limit in AOO-Calc Line Chart
WIN10 on desktop PC and AOO412m3(Build:9782) - Rev. 1709696 2015-10-21 09:53:29 (Mi, 21 Okt 2015) _ I am working with a line graph chart in Calc that presently shows "180.00" as the top limit and "0.00" as the low limit. I vaguely recall that there is a way to adjust those limits, but I have not been able to locate the edit-dialog. I want high limit to be "250" and low limit to be "100" and increments of 5. Please advise. regards, VinceB. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Identify Colors Used within an Existing/Selected Cell
TNX Steve; that worked for me. On 6/24/2016 5:08 PM, Steve Ahlers wrote: Vince, Copy the source cell, then Paste Special and choose characteristics to paste into destination cell. Steve Sent from my iPad On Jun 24, 2016, at 2:03 PM, Vince <wa.two...@verizon.net> wrote: AOO 4.1.2-Calc on WIN8.1 desktop __ Is there a way to easily identify the background fill-color or the font-color that is being used within a cell ? There should be, but I do not know how, as yet. I am trying to change the background fill-color to match/be the same as the background fill-color that is being used within another existing cell. Same difficulty when trying to match the font-color. Opening the background color/font-color palette shows me the many available choices, but I am hoping that there is a way to identify what is being used within a selected cell, by being shown its name. My guess is always incorrect, it seems. Regards, VinceB. - 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: Identify Colors Used within an Existing/Selected Cell
TNX Brian; that worked nicely. On 6/24/2016 6:56 PM, Brian Barker wrote: At 17:03 24/06/2016 -0400, Vince Bonly wrote: AOO 4.1.2-Calc on WIN8.1 desktop Is there a way to easily identify the background fill-color or the font-color that is being used within a cell ? There should be, but I do not know how, as yet. I am trying to change the background fill-color to match/be the same as the background fill-color that is being used within another existing cell. Same difficulty when trying to match the font-color. Opening the background color/font-color palette shows me the many available choices, but I am hoping that there is a way to identify what is being used within a selected cell, by being shown its name. My guess is always incorrect, it seems. As you suggest, if you use the controls in the Formatting toolbar you will not see any indication of the current font colour or background colour. But instead go to Format | Cells... or right-click | Format Cells... . On the Font Effects tab the font colour is identified by name and on the Background tab the background colour is highlighted with a border in the colour palette and named below it. 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
Identify Colors Used within an Existing/Selected Cell
AOO 4.1.2-Calc on WIN8.1 desktop __ Is there a way to easily identify the background fill-color or the font-color that is being used within a cell ? There should be, but I do not know how, as yet. I am trying to change the background fill-color to match/be the same as the background fill-color that is being used within another existing cell. Same difficulty when trying to match the font-color. Opening the background color/font-color palette shows me the many available choices, but I am hoping that there is a way to identify what is being used within a selected cell, by being shown its name. My guess is always incorrect, it seems. Regards, VinceB. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Search & Replace Formula in Cell with a Named Array
Thank you. Regards, Vince Sent from my iPad > On Jun 5, 2016, at 14:17, Dennis E. Hamilton <dennis.hamil...@acm.org> wrote: > > > >> > > In case this remains a question. >100 does not include 100 and <109 does not > include 109. > > So long as the values are integers, >99 and <110 cover 100 to 109 inclusive. > > Just remember that ">" is more-than and "<" is less-than. > > > > - > To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org > For additional commands, e-mail: users-h...@openoffice.apache.org >
Search & Replace Formula in Cell with a Named Array
Using the Find feature in AOO 4.1.2 Calc, is it possible to replace a formula, such as: =SUMPRODUCT($D$343:$L391>100;$D$343:$L391<109) with: =SUMPRODUCT(_2016_Scores_Target_Vince>100;_2016_Scores_Target_Vince<109) where: _2016_Scores_Target_Vince is a named array ($D343:$L391) ? If this is possible, then doing so would save me huge amount of retyping and perhaps also allow me to move the resulting array to another location/sheet. Do I need to enclose the formula within quotation marks, " " in the Search dialog window? Regards, VinceB. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Unable to Get Page Break Preview
Well, I have gone around in circles, today, for about 1.25 hours! :-[ However, I am happy :-) to be able to report that I now am able to see a "normal" View>Page Break Preview on screen for each of the tabbed-sheets within the /2016 My Bowling Score Data.ods/ file. It remains a mystery to me, for now, what I actually had done to create this problem! It turns out that I needed to /define a print range/ for each tabbed-sheet; not to remove/delete those that already existed, within that .ods file. Thanks to Brian and to Girvin for taking their time to offer helpful suggestions. Now, I am back to redesigning the .ods file to include Brian's or Dennis's formula for detecting hits of my bowling scores that fall within specific /range bin-decades/, from 100 to 109, 110 to 119, 290 to 299, etc., and 300. Regards, VinceB. On 6/2/2016 5:22 PM, Vince wrote: AOO-Calc 4.1.2; WIN8.1 _ I have been working for several hours today with a Calc file that has eight tab-sheets within it. All tab-sheets, except for two, do not show the expected Page Break Preview. Instead, the entire sheet palette is a shade of gray background. Also, within one sheet that also happens to have hidden cell data, the color of the characters are showing as white in those cells. There are no indication of (blue) page breaks or watermarked- Page numbers. I have no idea how or why this has happened. (I probably did something silly while jumping back and forth from one tab-sheet to another.) After exiting AOO and after rebooting my computer, the problem remains. I've checked several other Calc files, and they do not exhibit this particular problem. Can anyone shed some light on this problem and offer a solution? Thanks for reading this. Regards, VinceB.
Unable to Get Page Break Preview
AOO-Calc 4.1.2; WIN8.1 _ I have been working for several hours today with a Calc file that has eight tab-sheets within it. All tab-sheets, except for two, do not show the expected Page Break Preview. Instead, the entire sheet palette is a shade of gray background. Also, within one sheet that also happens to have hidden cell data, the color of the characters are showing as white in those cells. There are no indication of (blue) page breaks or watermarked- Page numbers. I have no idea how or why this has happened. (I probably did something silly while jumping back and forth from one tab-sheet to another.) After exiting AOO and after rebooting my computer, the problem remains. I've checked several other Calc files, and they do not exhibit this particular problem. Can anyone shed some light on this problem and offer a solution? Thanks for reading this. Regards, VinceB. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Detecting/Counting Cell's Values if data is within a Specific Range of Values
I thought attachments are not permitted for this mail list? Would an embedded link to my Drop Box work here? (I am new to Drop Box.) I'll place the dummy array in my DB, to start. Regards, Vince Sent from my iPad > On Jun 1, 2016, at 00:22, James Plante <jimpla...@me.com> wrote: > > One way would be to export it to PDF, and send the PDF as an attachment. > > Jim > >> On May 31, 2016, at 8:15 PM, Vince <wa.two...@verizon.net> wrote: >> >> Ooops! Copy from AOO-Calc and Paste to Thunderbird 45.1.0 for the mail list >> did not go very well (my first attempt) with that array. >> >> >> If anyone is interested, is there a suggestion for how I could project the >> array properly for email list viewing? >> >> VinceB. >> >> >>> On 5/31/2016 8:04 PM, Vince wrote: >>> Hi Brian: >>> >>> I created a play-file that used the array shown below: >>> >>> >>> B CD >>> E >>> * */Week #/* */Game #1/* */Game #2 /* */Game #3/* >>> 8 >>> 9 1 141 137 >>> 135 >>> 10 2 97 135 >>> 134 >>> 113 193 172 >>> 138 >>> 124 151 185 >>> 125 >>> 135 197 127 >>> 186 >>> 146 153 138 137 >>> 157 158 188 134 >>> 168 132 150 132 >>> >>> Your suggested formula (=SUMPRODUCT($D$9:$F$16>100;$D$9:$F$16<129), with a >>> modified target range, results returned are: >>> >>> *<100* *1* >> >>> *100 thru 129* *2* >>> *130 thru 139* *10* >>> *140 thru 149* *1* >>> *150 thru 159* *3* >>> *160 thru 169* *0* >>> *170 thru 179* *1* >>> *180 thru 189* *3* >>> *190 thru 199* *3* >> >> >> - >> 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: Detecting/Counting Cell's Values if data is within a Specific Range of Values
Hi Dennis: Your suggestion ( =COUNTIF(F342:N380;">99")-COUNTIF(F342:N380;">129"), also worked here. I have used your suggestion here to generate result in an array, shown below: <100 1 100 thru 1090 110 thru 1190 120 thru 1292 130 thru 13910 140 thru 1491 150 thru 1593 160 thru 1690 170 thru 1791 180 thru 1893 190 thru 1992 200 thru 2090 210 thru 2190 220 thru 2290 230 thru 2390 240 thru 2490 250 thru 2590 260 thru 2690 270 thru 2790 I need to add a couple more rows to that array, not that I expect to reach a bowling score within the range of 280 to 300, inclusive, anytime soon! Thanks. Regards, VinceB. On 5/20/2016 12:01 PM, Dennis E. Hamilton wrote: There might be a more direct way, but try =COUNTIF(D342:L380;">99")-COUNTIF(D342:L380;">129") If you mean between 100 and 129 inclusive. Adjust as necessary. - Dennis
Re: Detecting/Counting Cell's Values if data is within a Specific Range of Values
Hi Brian: I created a play-file that used the array shown below: B C D E * * */Week #/* */Game #1/* */Game #2 /**/Game #3/* 8 9 1 141 137 135 10 2 97 135 134 11 3 193 172 138 12 4 151 185 125 13 5 197 127 186 14 6 153 138 137 15 7 158 188 134 16 8 132 150 132 Your suggested formula (=SUMPRODUCT($D$9:$F$16>100;$D$9:$F$16<129), with a modified target range, results returned are: *<100* *1* *100 thru 129* *2* *130 thru 139* *10* *140 thru 149* *1* *150 thru 159* *3* *160 thru 169* *0* *170 thru 179* *1* *180 thru 189* *3* *190 thru 199* *3* I was expecting to use some sort of a Boolean expression or domain limits; however, I will read up on =SUMPRODUCT( ... ). You might have guessed that the array data is derived from my bowling scores. Since JAN 2008, I have recorded, within a Calc sheet, the scores for more than 1500 games; lots of data to play with and, at the same time, learn about using AOO-Calc. Thank you. VinceB. __ On 5/20/2016 1:34 PM, Brian Barker wrote: At 11:01 20/05/2016 -0400, Vince Bonly wrote: I am using this =COUNTIF(D342:L380;">100") ... . Possible data values found within D342 and L380 include: 0 through 300. However, what I really want to count is all data values between 100 and 129, ... I should have written: "... what I really want is to count all data values from 100 to 129, inclusive; from 130 to 139, inclusive; etc. etc. thus yielding an array like this: <100 1 100 thru 1292 130 thru 13910 140 thru 1491 150 thru 1593 160 thru 1690 170 thru 1791 180 thru 1893 190 thru 1993 200 thru 2090 210 thru 2190 220 thru 2290 230 thru 2390 240 thru 2490 250 thru 2590 260 thru 2690 270 thru 2790 As an alternative to what has already been suggested, you could use: =SUMPRODUCT(D342:L380>100;D342:L380<129) The two comparisons each generate an array of boolean values. When the array of products is formed, TRUE is interpreted as 1 and FALSE as 0 - so the result is 1 for each cell for which both criteria are true and 0 otherwise. Summing those 1s effectively counts them and gives you the result you need. I trust this helps. Brian Barker
Re: Sort Sequence in Calc
Thanks Jonathon: Font was Tahoma-10 whenever auto -wrap text was previously invoked for a cell. I don't think Tahoma would cause a problem here. I have changed to Arial-10 for the range of cells that I do the sort routine on. Will see if that makes a difference in row height and if the font sticks? Regards, VinceB. On 5/30/2016 12:35 AM, toki wrote: Vince wrote on 29/05/2016 18:20: and the rows for any previously existing row with word wrapping, appear too small/low. Typically, that happens when one uses a non-default font that is bigger than the default. To compensate for that adjust heights at >Format >Row Optimal Height adjustment. If that (larger than default font) is the cause, then it will only need to be done once. I've forgotten which fonts don't play nicely with Calc. As a general rule, these fonts break several conventions in creating glyphs. (Too little white space at the edges, is the most common problem.) I asked about a possible method to freeze the row's height I use a spreadsheet for my passwords, and have never encountered the situation you describe. The biggest problem I've encountered, was when OOo changed encryption routines. I had to save the spreadsheet without a password, to be able to use it on my different computers. Since all my computers are now running the same version of the same office suite, I can encrypt that spreadsheet, without any issues. jonathon - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Sort Sequence in Calc
_FYI Update_: I misspoke in my OP; I did not select the entire column (A), but rather I highlighted the specific cells within column A prior to executing the sort, A to Z. I initially began with a default spreadsheet, using whatever cell formatting and row-height setting. _Today_: 1. I unfroze the window for the sheet in question. Perhaps having the screen's window frozen is p/o the cause of this problem. 2. I have formatted the entire sheet for "text". None of my entries for the purpose of my Password List require formulae entries. 3. I have just now added one new entry into column A and then did a sort A to Z; the row height for the newly added entry, which needed word-wrapping, and the rows for any previously existing row with word wrapping, appear too small/low. I asked about a possible method to freeze the row's height because, frankly, it is a PITA to readjust row heights after doing the sort routine. I suppose that it would be wiser for me to make up a dummy spreadsheet for experimentation, to duplicate my issue, rather than go through the hoops each time that I revise / add data and risk loosing my work thus far. I will post again when I get some troubleshooting results to report here. Thanks for reading this. Regards, VinceB. On 5/29/2016 3:48 AM, Brian Barker wrote: At 11:43 28/05/2016 -0400, Vince Bonly wrote: Two observations when using the Toolbar A-Z sort button: I've noted that if/whenever another cell within the same row does /_not_/ have anything entered, the sorted result appears to be messed up. I don't see this (and it appears no-one else does either). I select a (key) column and afterward do click on the "Extend selection" button. Must I enter dummy data (hyphen, for example) to satisfy the apparent requirement that every adjacent cell in the row must have some data? I don't see any such requirement. I hope there isn't, as it would be silly. If you continue to see this, you may have to construct and describe a simple-as-possible set of instructions to reproduce the problem. Are the contents of the adjacent cells actual values (numbers, text, whatever?) or are they the results of formulae? If they are formulae (no matter how simple), remember that the results of those formulae may be affected by the process of sorting. Is that what you are seeing? No. For example, suppose that you have text values (to be sorted) in column A and formulae in column B, with column headings in row 1. Say that B3 has =LEFT(A2) and so on, filled down column B. The result of this will be that each B cell will have just the initial letter of the A cell in the *previous* row. If you now sort on column A as you describe, the values in column B will correspond to the *new* preceding row and not what preceded it before the sort process. That may or may not be what anyone would want. Some cells are formatted for Wrap Text alignment. The row height of those rows that do contain wrapped-text is varied (made too small) after executing the sort routine, forcing me to readjust the row's height. Is this normal behavior? Yes and no. If you have set the row heights manually, I think these settings will be preserved - which may create the effect you see. Is there a method to freeze the row height? Er, do you want to preserve the row heights where they are - so that the data may no longer fit - or do you wish the heights not to be frozen but to move around with the data? I expect that the rows' height are automatically changed to accommodate the amount of text that is entered within any of the columns' width, even after doing a/multiple sort routine(s). Addition of data and doing sort routines should not require readjustment of row heights. If you use the default row height (double-click on the row separator below the relevant row in the row headers) and then choose "Wrap text automatically" in the cell formatting (is that what you mean?), I think you will see what you need. Do you mean that there is a particular required sequence when choosing auto text wrap cell-formatting, before or after manually doing a row-height setting for a specific row? I expect to manually readjust the rows' height setting once, but not after doing a sort routine. __ I trust this helps. Brian Barker
Sort Sequence in Calc
AOO 4.1.2 on WIN8.1 desktop __ I am trying to organize the many passwords that I use when accessing the computer and the internet, etc. My goal is simply to have a paper copy of the various passwords for storage is a secure location and I will probably also store the AOO Calc .ods file on a flash drive. . (I am also wondering if I should be using AOO Base instead of Calc?) Two observations when using the Toolbar A-Z sort button: 1. I've noted that if/whenever another cell within the same row does /_not_/ have anything entered, the sorted result appears to be messed up. I select a (key) column and afterward do click on the "Extend selection" button. Must I enter dummy data (hyphen, for example) to satisfy the apparent requirement that every adjacent cell in the row must have some data? Is there another possible workaround? 2. Some cells are formatted for Wrap Text alignment. The row height of those rows that do contain wrapped-text is varied (made too small) after executing the sort routine, forcing me to readjust the row's height . Is this normal behavior? Is there a method to freeze the row height? Thanks for reading this. Regards, VinceB
Detecting/Counting Cell's Values if data is within a Specific Range of Values
Using AOO 4.1.2 and Win 8.1 _ I am using this =COUNTIF(D342:L380;">100") in a Calc cell, and it returns a count of all data values within the D342:L380 that are greater than 100 . Possible data values found within D342 and L380 include: 0 through 300. However, what I really want to count is all data values between 100 and 129, for example. IOW, count if data value within cells D342 through L380 is between 100 and 129. What is the required formula/function in Calc to reach my goal? Regards, Vince B. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: bug
Rory: Would doing as you have suggested cause the pagination data appear right-side for the odd-numbered pages and appear left-side for the ever-numbered pages? (That is the conventional pagination method, as I recall.) Regards, Vince Sent from my iPad > On May 18, 2016, at 11:30, Rory O'Farrell <ofarr...@iol.ie> wrote: > > On Wed, 18 May 2016 13:33:13 + (UTC) > Bonita Genova <heng...@yahoo.com.INVALID> wrote: > >> please help >> I cannot find an answer in your indexes >> I want to consecutively number my document into the header on each page at >> top right >> I have incorporated the header on each page >> on page one inside the header top right your program gives the number as "1" >> on page two inside the header top right your program gives no number -- it >> is blank >> on page three inside the header top right your program gives the number as >> "3" >> on page four inside the header top right your program gives no number -- it >> is blank >> etc. >> >> >> then when I attempt to copy the document onto letter size paper >> page 1 is copied and the number is 1 >> page 2 is not -- it comes out blank >> page 3 is copied and the number is 3 >> page 4 is not -- it comes out blank >> etc. >> PLEASE HELP >> My cel number is 908-514-2981 > > On the Page Style definition, Header tab, check "Same content left and > right"; on the Page tab of the same style definition, select "Mirrored" from > the dropdown for Page layout. > > > -- > Rory O'Farrell <ofarr...@iol.ie> > > - > To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org > For additional commands, e-mail: users-h...@openoffice.apache.org >
Deletion of Chart in Calc
Win8.x-64 AOO 4.1.2 ___ I am frustrated with my attempts to delete an erroneous Chart in Calc. It seems that a chart can only be cut. I am experiencing repeated AOO crashes. What is the proper procedure to select and then delete (entirely) an existing chart in Calc? I could not locate Help info for deletion of an object/chart. Regards, VinceB. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Convert AAO-Calc to AAO-Base and vice-versa
Is it possible ? I have several Calc files that I suspect would be an improved experience if they were Base files. I am using Win8.x-64. Regards, Vince Sent from my iPad
Re: Drop Down Menu, Again
Just a small variation to make it work easier for me, Shown below: On 4/20/2016 2:19 AM, Brian Barker wrote: At 17:05 19/04/2016 -0400, Vince Bonly wrote: I want a drop down arrow that when clicked opens a list of pre-written choices. This list is presently located on a separate worksheet, titled "Lists", in AOO Calc; and it works locally there on the List worksheet. But, I want to introduce this "drop down menu selection" within an existing column within a separate worksheet; and not at the head of the column. There is no such thing as a "worksheet" in OpenOffice (Calc): each spreadsheet (document) contains, potentially, a number of sheets. OK; I'll try to remember to refer to them as "tabbed-sheets" (within a local or remote spreadsheet). I'm not sure whether you mean another sheet in the same spreadsheet or a different spreadsheet; I'm guessing the former. Both are possible, but neither is necessary. o Prepare the list of prompted values. o Select the range of cells to which this should apply. o Go to Data | Validity... | Criteria. o For Allow, select "Cell range". o Either put the cursor into the Source box or click the Shrink button to its right. o Drag the cursor down the list of values. (This can be on another sheet.) Here, I hit ENTER key. o Click the Shrink button if necessary. o OK. It appears that you cannot drag down a cell range on a sheet in a separate spreadsheet document, but you *can* construct an expression in the Source box that refers to such a cell range. (But I'm guessing you don't want to do this anyway.) I will want to add additional choices at a later time; ... The simplest way to do this is probably to select a cell range (above) that is big enough to contain as many choices as you are likely to need. Then fill the as yet unneeded cells with copies of one of the original values. Your list may say something like one / two / three / four / one / one / one etc. Providing the sort option is used (see below), only one copy of such a repeated entry will appear in the drop-down menu. ... thus, I think the List must be on a separate worksheet so that I can resort the entries alphabetically. No, there are two misunderstandings here: o It is unnecessary to sort your list of prompted values alphabetically: you can leave it unsorted and tick the "Sort entries ascending" box on the Criteria tab in the Validity dialogue. Yes; now that I am using the correct dialogue window, sorting is not an issue. o In any case, there would be nothing to stop you sorting this list separately if you wished - without sorting any rows or surrounding values. I trust this helps. Indeed, it has! Brian Barker
Re: Drop Down Menu, Again (SOLVED)
TNX for the reminder to use Data-Validity-Criteria (i.e., not use Data-Filter-Auto Filter)! I have Cut & Pasted instructions into the tabbed-sheet for future reference. I have incorporated my drop down choice listing in my application spreadsheet, and all seems to be working as expected. This has made a difference for me when entering the names of common vendors, etc. On 4/19/2016 5:05 PM, Vince wrote: AOO412m3(Build:9782) - Rev. 1709696 2015-10-21 09:53:29 (Mi, 21 Okt 2015) Win 8x64 I have done this once before, but am not able to repeat it. I want a drop down arrow that when clicked opens a list of pre-written choices. This list is presently located on a separate worksheet, titled "Lists", in AOO Calc; and it works locally there on the List worksheet. But, I want to introduce this "drop down menu selection" within an existing column within a separate worksheet; and not at the head of the column. I have tried Data-Filter-Auto Filter, but that seems to require beginning at the very top of a column. I will want to add additional choices at a later time; thus, I think the List must be on a separate worksheet so that I can resort the entries alphabetically. Thanks for reading this. Regards, Vince B. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Drop Down Menu, Again
AOO412m3(Build:9782) - Rev. 1709696 2015-10-21 09:53:29 (Mi, 21 Okt 2015) Win 8x64 I have done this once before, but am not able to repeat it. I want a drop down arrow that when clicked opens a list of pre-written choices. This list is presently located on a separate worksheet, titled "Lists", in AOO Calc; and it works locally there on the List worksheet. But, I want to introduce this "drop down menu selection" within an existing column within a separate worksheet; and not at the head of the column. I have tried Data-Filter-Auto Filter, but that seems to require beginning at the very top of a column. I will want to add additional choices at a later time; thus, I think the List must be on a separate worksheet so that I can resort the entries alphabetically. Thanks for reading this. Regards, Vince B. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
JAVA Requirements
Hello fellow AOO users: The other day I wanted to make use of the AOO-Calc Help function from the menu bar, but I was given an error message about Java file corrupted or invalid version and that I should install a different JRE. I am using Win8x64. Thought that all was okay with regard to Java requirements, but something was wrong. How can I verify which JAVA run time is installed and that it is the correct version? When using Tools-OO-Java, I am told that Oracle Corporation version 1.8.0_73 JRE is already installed. I do not recall how to locate the JRE within my hard drive. Back in the 2015 Fall, I did a OS reset from Win10 back to Win8.1, and I do recall that both x32 and x64 JREs were installed on C: drive at that time. It appears to Not be a problem now, and Calc has been running as expected all along. Could this be a timing issue? Regards, VinceB - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Finding the Largest Value within a Specific Column's Range of Cells in AOO-Calc
Hello:
I am using AOO412m3(Build:9782) - Rev. 1709696 2015-10-21 09:53:29
(Mi, 21 Okt 2015) on a Win 8.1 machine.
The following formula/function originated via www.samplewords.com;
specifically: http://www.samplewords.com/bowling-record-sheet/ .
=AVERAGE(LARGE(C9:C57;ROW(INDIRECT("1:10"
It is being used in the AAO-Calc that I use to monitor my bowling scores
to display the highest value found within a cell range. I do not
understand it; and would like to know if there is an equivalent
formula/function within AOO-Calc? This is working within my AOO-Calc,
but there have been times that some problems occur. If I understood what
this complex function does and/or if an AOO-Calc substitute can be used,
then perhaps my future troubleshooting efforts when dealing with my
Bowling Score Data Calc-sheets would go more smothly.
I seem to recall using MAX and MIN within Excel (MS Office 2003 Basic).
(Did I just answer my own question ?)
No hurry on this; not an emergency, since I am in a /recovery mode/ from
today's poor performance on the lanes!
Regards,
VinceB.
Re: How to Generate a Drop Down List within a Calc cell?
I have followed suggestions given here to change to Text formatting in the Source cells and in the targeted cell. Have noticed that it appears the font and character size cannot be changed for the targeted cell. The next time I have need for a drop-down list, I will try a leading < or ' , to see if an Err: pops up here. Regards, VinceB. Regards, Vince Sent from my iPad > On Feb 12, 2016, at 18:00, James Plante <jimpla...@me.com> wrote: > > Vince, I’m not sure that it’s really necessary, but you might also format the > cells in your list box to text as well as the target range. > > One thing that may save you some time: You can copy and paste the active cell > (the one in which the user chooses from the list). This will save you from > having to format a whole column of cells. > Just select the cell and copy normally. Go to the next cell where you want to > make those choices and select “Paste”, or Ctrl-V. > >> On Feb 12, 2016, at 4:22 PM, Vince <wa.two...@verizon.net> wrote: >> >> >> >> When '16 BVL Practice was used, IIRC, the ERR:519 showed. The cells within >> my Source were not formatted as text beforehand. >> >> Next time, I will try that Shrink box. >> >> TNX. >> >>> On 2/12/2016 4:38 PM, Brian Barker wrote: >>> At 16:18 12/02/2016 -0500, Vince Bonly wrote: >>>> Came upon one glitch: I did not see a Shrink button in my version (4.1.2) >>>> of AOO on the right of the "cell range" box. What I did see, after setting >>>> the Criteria-Allow to "Cell range", is an input line after a "Source" >>>> prompt. >>> >>> The Shrink button is to the right of that Source box. It's an alternative >>> (easier and more reliable) way to fill the box. >>> >>>> I learned that the definition string for my selection choices should not >>>> begin with an apostrophe ( ' ) nor with a [left] arrow ( < ). I was >>>> trying to begin with '16 BVL Practice or ; neither of those worked. >>> >>> That's not true. An apostrophe before a number will be interpreted as a >>> text format marker and not included in the cell value - but that shouldn't >>> cause any problem if you have text following it, as you do here. (There are >>> some complications if you have AutoCorrect set to change apostrophes to >>> smart quotes.) In any case, you need only to format the cell range as Text >>> before entering the values to avoid this problem entirely. >>> >>> I don't see why should be a problem. (It isn't for me.) If you >>> actually want to be able to accept genuinely empty cells, just ensure that >>> "Allow blank cells" is ticked in the Validity 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 >> >> >> - >> 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: How to Generate a Drop Down List within a Calc cell?
When '16 BVL Practice was used, IIRC, the ERR:519 showed. The cells within my Source were not formatted as text beforehand. Next time, I will try that Shrink box. TNX. On 2/12/2016 4:38 PM, Brian Barker wrote: At 16:18 12/02/2016 -0500, Vince Bonly wrote: Came upon one glitch: I did not see a Shrink button in my version (4.1.2) of AOO on the right of the "cell range" box. What I did see, after setting the Criteria-Allow to "Cell range", is an input line after a "Source" prompt. The Shrink button is to the right of that Source box. It's an alternative (easier and more reliable) way to fill the box. I learned that the definition string for my selection choices should not begin with an apostrophe ( ' ) nor with a [left] arrow ( < ). I was trying to begin with '16 BVL Practice or ; neither of those worked. That's not true. An apostrophe before a number will be interpreted as a text format marker and not included in the cell value - but that shouldn't cause any problem if you have text following it, as you do here. (There are some complications if you have AutoCorrect set to change apostrophes to smart quotes.) In any case, you need only to format the cell range as Text before entering the values to avoid this problem entirely. I don't see why should be a problem. (It isn't for me.) If you actually want to be able to accept genuinely empty cells, just ensure that "Allow blank cells" is ticked in the Validity 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 - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: How to Generate a Drop Down List within a CALC cELL?
Jim: I have had success with this issue, by following your guidance. Came upon one glitch: I did not see a Shrink button in my version (4.1.2) of AOO on the right of the "cell range" box. What I did see, after setting the Criteria-Allow to "Cell range", is an input line after a "Source" prompt. Knowing that I had to provide a reference string pointing to my "List" sheet, I entered $List.$D$1:$D$6 as Source. Then, all went very nicely. I learned that the definition string for my selection choices should not begin with an apostrophe ( ' ) nor with a right arrow ( < ). I was trying to begin with '16 BVL Practice or ; neither of those worked. I did not pick up a 7-10 split, but rather Spared on a 4-7-10 split when I bowled yesterday! TNX again. Regards, VinceB. On 2/11/2016 7:45 PM, James Plante wrote: Reply inline On Feb 11, 2016, at 3:35 PM, Vince <wa.two...@verizon.net> wrote: TNX Jim for the info; I will give it a try, but would like to be clear about how to compose the required reference string and about where to properly locate the drop-down selection list . You can locate it anywhere you find convenient. I’d suggest that you put it on another sheet, but you don’t have to. I will first try with the selection list definition being located on a sheet within the same workbook. I could name that sheet "Selection Lists" and write a reference string to that. I would pick a short name. If you put a space in the title, it has to be quoted when you reference it. Just call it “Lists,” or something like that. If you’ll use the shrink button as I said, you don’t have to “write” any references. It’s all done for you. You just select the range of the cells in which the choices appear. But you can write it if you want to: $Lists.$A$1:$A$5 will work just as well as selecting with the shrink button, and it works just as well. All those $’s hold the reference in one spot. They’re called “Absolute references.” I have not ever tried to write a reference string to a sheet that is located within a separate Workbook file, and do not know if that is possible to work. Well, you *can* put the list in a separate workbook, but both workbooks have to be open for the reference to work. Just keep it in the same workbook, but on a different sheet. Sheets are selected with the tabs at the bottom of the window where it says “Sheet1”, “Sheet2”, and “Sheet3.” You can add more sheets if you need them, and you can change the names. Right-click on the sheet tab to bring up a context menu that will allow you to change the sheet name. ***If you’re going to do that, though, do it before you create your reference list. At this point, my selection list must include the following that I plan to do logic operations on from another sheet: * With Vets '16 * With George '16 * During '16 BVL Practice * During '16 BVL Competition * '16 Practice Alone List them just the way I told you: One selection per cell, all cells in the same column. Those choices are associated with a Workbook where I record my bowling scores and George's bowling scores, such as they are! In some cases I bowl a 3-game series whereas in other cases I bowl a 5-game match, and yet when practicing alone, any number of games may be bowled!. This isn’t rocket science, and nowhere near as hard as picking up a 7-10 split. Just give it a try and throw a few gutter balls. We learn best from failure. Good thing programming doesn’t hurt, or I’d be a wreck. Regards, VinceB. On 2/11/2016 12:18 PM, James Plante wrote: First, create the choices that you want to have in the dropdown list: In a blank spreadsheet, Go to cell D1. Enter “One”, return; in D2 enter “Two”, return; etc. Let’s say you do six entries, D1:D6. Now, select the cell at which you want to make the dropdown list. Let’s use A2. Now go to Data->Validity; you’ll get a dialog box. In that box, at the “Allow” prompt, click the dropdown box and select “Cell Range.” The dialog changes. On the right of the “cell range” box, select the “shrink” button. Now in the spreadsheet, select D1 and drag to D6. Hit the shrink button again, and once again the dialog changes. The selected range of inputs is now $Sheet1.$D$1:$D$6. Click “OK” and you’re good to go. Cell A2 now has an arrow next to it when it is selected—and only when selected! Click the arrow, and you can choose any of the six entries you made in D1:D6. There are other options available in the dialog. Explore them. You can use numbers, text, or formulas that give rise to arrays. Read the docs to find out more about it. (Google is your buddy.) For instance, if you had a bunch of different cells in which you wanted to control or expedite data entry, you could put all the selections in different areas on Sheet2. Then when it’s time to select your cell range, shrink the dialog, change sheets, select the desired range, hit shrink agai
Re: How to Generate a Drop Down List within a CALC cELL?
TNX Jim for the info; I will give it a try, but would like to be clear about how to compose the required reference string and about where to properly locate the drop-down selection list . I will first try with the selection list definition being located on a sheet within the same workbook. I could name that sheet "Selection Lists" and write a reference string to that. I have not ever tried to write a reference string to a sheet that is located within a separate Workbook file, and do not know if that is possible to work. At this point, my selection list must include the following that I plan to do logic operations on from another sheet: * With Vets '16 * With George '16 * During '16 BVL Practice * During '16 BVL Competition * '16 Practice Alone Those choices are associated with a Workbook where I record my bowling scores and George's bowling scores, such as they are! In some cases I bowl a 3-game series whereas in other cases I bowl a 5-game match, and yet when practicing alone, any number of games may be bowled!. Regards, VinceB. On 2/11/2016 12:18 PM, James Plante wrote: First, create the choices that you want to have in the dropdown list: In a blank spreadsheet, Go to cell D1. Enter “One”, return; in D2 enter “Two”, return; etc. Let’s say you do six entries, D1:D6. Now, select the cell at which you want to make the dropdown list. Let’s use A2. Now go to Data->Validity; you’ll get a dialog box. In that box, at the “Allow” prompt, click the dropdown box and select “Cell Range.” The dialog changes. On the right of the “cell range” box, select the “shrink” button. Now in the spreadsheet, select D1 and drag to D6. Hit the shrink button again, and once again the dialog changes. The selected range of inputs is now $Sheet1.$D$1:$D$6. Click “OK” and you’re good to go. Cell A2 now has an arrow next to it when it is selected—and only when selected! Click the arrow, and you can choose any of the six entries you made in D1:D6. There are other options available in the dialog. Explore them. You can use numbers, text, or formulas that give rise to arrays. Read the docs to find out more about it. (Google is your buddy.) For instance, if you had a bunch of different cells in which you wanted to control or expedite data entry, you could put all the selections in different areas on Sheet2. Then when it’s time to select your cell range, shrink the dialog, change sheets, select the desired range, hit shrink again, and the dialog would show something like “$Sheet2.$F$10:$F$15”, and those choices would populate your target cell. Jim Plante On Feb 11, 2016, at 10:56 AM, Vince <wa.two...@verizon.net> wrote: Hello: Using AOO 4.1.2 on WIN 8.1. I do not know the correct terminology for searching in HELP file, but I want to have a drop down selection list, with a clickable arrowhead, inside a Calc cell. How can this be done? Regards, VinceB. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
How to Generate a Drop Down List within a CALC cELL?
Hello: Using AOO 4.1.2 on WIN 8.1. I do not know the correct terminology for searching in HELP file, but I want to have a drop down selection list, with a clickable arrowhead, inside a Calc cell. How can this be done? Regards, VinceB.
Re: Err: 508 When trying to Auto Replicate/Transfer data between two sheets.
On 1/29/2016 7:17 PM, Steve Ahlers wrote: Another way of creating the formula is to type the = then click on the source cell and hit return. Steve I am unable to click to a different worksheet to then swipe the text string from the source cell, after putting = into the target cell,. Am I missing something? - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Err: 508 When trying to Auto Replicate/Transfer data between two sheets._SOLVED
On 1/29/2016 6:58 PM, Keith N. McKenna wrote: Vince wrote: I am using AOO Calc vers 4.1.2 and Win 8.1x64 (file name is 2016 My Bowling Score Data.ods). I want to "automatically transfer" the data that is typed/entered into Cell M342 of the Sheet named: 2016 Scores into Cell D6 of the Sheet named: 2016 Match Play. The Cell M342 data is calculated by the formula: =SUM(C342:K342), which yields a result of 386. I have entered: =($'2016 Scores',M342) into Cell D6 of the Sheet named: 2016 Match Play. Cell D6 results in Err: 508. Is this error due to an improper typography? Any suggestions are welcomed. VinceB. Vince; The formula =$'2016 Scores'.M342 should be the formula you need. The 508 error comes from the use of the parents, and the separator in Calc is a . rather than the , used in Excel. Hope this helps Keith Once I have changed the comma to a period within my originally entered formula, all is working as expected here. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Err: 508 When trying to Auto Replicate/Transfer data between two sheets.
TNX Keith: I am rather sure that your info will help me; I am certain that a new script for reading vision is what I also need, since having cataracts re moved! Regards, Vince Sent from my iPad > On Jan 29, 2016, at 18:58, Keith N. McKenna <keith.mcke...@comcast.net> wrote: > > Vince wrote: >> >> >> >> I am using AOO Calc vers 4.1.2 and Win 8.1x64 (file name is 2016 My >> Bowling Score Data.ods). >> >> I want to "automatically transfer" the data that is typed/entered into >> Cell M342 of the Sheet named: 2016 Scores into Cell D6 of the Sheet >> named: 2016 Match Play. >> >> The Cell M342 data is calculated by the formula: >> =SUM(C342:K342), >> which yields a result of 386. >> >> I have entered: >> =($'2016 Scores',M342) >> into Cell D6 of the Sheet named: 2016 Match Play. >> >> Cell D6 results in Err: 508. >> >> Is this error due to an improper typography? Any suggestions are welcomed. >> >> VinceB. >> >> >> >> > Vince; > > The formula =$'2016 Scores'.M342 should be the formula you need. The 508 > error comes from the use of the parents, and the separator in Calc is a > . rather than the , used in Excel. > > Hope this helps > Keith >
Err: 508 When trying to Auto Replicate/Transfer data between two sheets.
I am using AOO Calc vers 4.1.2 and Win 8.1x64 (file name is 2016 My Bowling Score Data.ods). I want to "automatically transfer" the data that is typed/entered into Cell M342 of the Sheet named: 2016 Scores into Cell D6 of the Sheet named: 2016 Match Play. The Cell M342 data is calculated by the formula: =SUM(C342:K342), which yields a result of 386. I have entered: =($'2016 Scores',M342) into Cell D6 of the Sheet named: 2016 Match Play. Cell D6 results in Err: 508. Is this error due to an improper typography? Any suggestions are welcomed. VinceB.
Re: Err: 508 When trying to Auto Replicate/Transfer data between two sheets.
That is a very good hint/reminder, Steve. I knew about this when staying within the same sheet; I hope it works for me. TNX. Regards, Vince Sent from my iPad > On Jan 29, 2016, at 19:17, Steve Ahlers <sahlers...@yahoo.com.INVALID> wrote: > > > >> Vince wrote: >>> >>> >>> >>> I am using AOO Calc vers 4.1.2 and Win 8.1x64 (file name is 2016 My >>> Bowling Score Data.ods). >>> >>> I want to "automatically transfer" the data that is typed/entered into >>> Cell M342 of the Sheet named: 2016 Scores into Cell D6 of the Sheet >>> named: 2016 Match Play. >>> >>> The Cell M342 data is calculated by the formula: >>> =SUM(C342:K342), >>> which yields a result of 386. >>> >>> I have entered: >>> =($'2016 Scores',M342) >>> into Cell D6 of the Sheet named: 2016 Match Play. >>> >>> Cell D6 results in Err: 508. >>> >>> Is this error due to an improper typography? Any suggestions are welcomed. >>> >>> VinceB. >> Vince; >> >> The formula =$'2016 Scores'.M342 should be the formula you need. The 508 >> error comes from the use of the parents, and the separator in Calc is a >> . rather than the , used in Excel. >> >> Hope this helps >> Keith > > Another way of creating the formula is to type the = then click on the source > cell and hit return. > > Steve > - > To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org > For additional commands, e-mail: users-h...@openoffice.apache.org >
OT: Cataract IOLs Replaced WAS: Re: Err: 508 When trying to Auto Replicate/Transfer data between two sheets.
On 1/29/2016 10:02 PM, Doug wrote: On 01/29/2016 08:03 PM, Vince B. wrote: TNX Keith: I am rather sure that your info will help me; I am certain that a new script for reading vision is what I also need, since having cataracts re moved! Regards, Vince I haven't been following this thread--I don't even know what you folks are writing about--but I accidentally saw this first line. I have had two cataracts _replaced_. When the cataract was removed, it was replaced with a plastic lens whose characteristics were designed by my ophthalmologist. I still need glasses for close work, reading, etc, but I can actually see better than I could see before I got the cataracts. So if Vince B. can't do that, maybe he should see another ophthalmologist! Something doesn't sound right, there. Good luck, Vince! --doug - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org Hi Doug: My 71 yr old, densecataract internal ocular lens were _replaced_ on DEC 15th and JAN 5th. I've yet to get to my optometrist (who is also my daughter); she will examine me on FEB 6th, and write a script for new reading glasses. Using my old reading glasses for now; but they are not up-to-par, now that the new IOLs are in place. For me, it was amazing to see a blue sky at sunrise with my left (corrected) eye, while waiting to have the right eye's cataract replaced; the same sky appeared gray/overcast (with the uncorrected right eye), but it wasn't! My long distance vision is _clearly_ better than before the surgeries; I no longer need to wear glasses while driving. Colored objects, especially those that are blue, green, yellow and white, appear truer to me. Regards, VinceB.
Re: Chart Wizard
I have misspoken again! The specific error msg given by Windows is: User Profile Service Service failed! User profile cannot be loaded. Not failed password; rather, profile service. Regards, Vince Sent from my iPad On Aug 15, 2015, at 17:08, Vince B. wa.two...@verizon.net wrote: Not caused or related to AOO. I just wanted to say that, hopefully, I will try the suggestion given (privately). Thanks. Regards, Vince Sent from my iPad On Aug 15, 2015, at 13:39, Dennis E. Hamilton dennis.hamil...@acm.org wrote: Please be more specific about failed password service? Does this arise somehow in your attempting to use Apache OpenOffice, or is it independent? - Dennis -Original Message- From: Vince B. [mailto:wa.two...@verizon.net] Sent: Saturday, August 15, 2015 08:57 To: users@openoffice.apache.org Subject: Re: Chart Wizard I hope to return to this issue, but right.now my desktop PC -win10 upgraded, is not useable due to failed password service not loading a required file properly. Regards, Vince Sent from my iPad On Aug 8, 2015, at 13:37, Vince B. wa.two...@verizon.net wrote: Ooops; that should be AOO 4.1.1 Regards, Vince Sent from my iPad On Aug 8, 2015, at 12:25, Vince-WA2RSX wa.two...@verizon.net wrote: Win10; AOO 38.1.0. I've been keeping a record of my bowling scores in Calc, and now attempting to use a line graph of the YTD Average data within column O (as y-axis) and use the date of bowling session as x-axis. This is my very first attempt to use Chart Wizard! Is what is written below a valid entry in the Chart Wizard for Calc when entering a Data Range? $9-Game Series.$o$5:$o$53 After clicking on Next button in wizard, nothing appears to happen. Is a hyphen valid within the Sheet Name? Are quotation marks required somewhere in this? Regards, VinceB. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Chart Wizard
I hope to return to this issue, but right.now my desktop PC -win10 upgraded, is not useable due to failed password service not loading a required file properly. Regards, Vince Sent from my iPad On Aug 8, 2015, at 13:37, Vince B. wa.two...@verizon.net wrote: Ooops; that should be AOO 4.1.1 Regards, Vince Sent from my iPad On Aug 8, 2015, at 12:25, Vince-WA2RSX wa.two...@verizon.net wrote: Win10; AOO 38.1.0. I've been keeping a record of my bowling scores in Calc, and now attempting to use a line graph of the YTD Average data within column O (as y-axis) and use the date of bowling session as x-axis. This is my very first attempt to use Chart Wizard! Is what is written below a valid entry in the Chart Wizard for Calc when entering a Data Range? $9-Game Series.$o$5:$o$53 After clicking on Next button in wizard, nothing appears to happen. Is a hyphen valid within the Sheet Name? Are quotation marks required somewhere in this? Regards, VinceB.
Chart Wizard
Win10; AOO 38.1.0. I've been keeping a record of my bowling scores in Calc, and now attempting to use a line graph of the YTD Average data within column O (as y-axis) and use the date of bowling session as x-axis. This is my very first attempt to use Chart Wizard! Is what is written below a valid entry in the Chart Wizard for Calc when entering a Data Range? $9-Game Series.$o$5:$o$53 After clicking on Next button in wizard, nothing appears to happen. Is a hyphen valid within the Sheet Name? Are quotation marks required somewhere in this? Regards, VinceB.
Re: Chart Wizard
Ooops; that should be AOO 4.1.1 Regards, Vince Sent from my iPad On Aug 8, 2015, at 12:25, Vince-WA2RSX wa.two...@verizon.net wrote: Win10; AOO 38.1.0. I've been keeping a record of my bowling scores in Calc, and now attempting to use a line graph of the YTD Average data within column O (as y-axis) and use the date of bowling session as x-axis. This is my very first attempt to use Chart Wizard! Is what is written below a valid entry in the Chart Wizard for Calc when entering a Data Range? $9-Game Series.$o$5:$o$53 After clicking on Next button in wizard, nothing appears to happen. Is a hyphen valid within the Sheet Name? Are quotation marks required somewhere in this? Regards, VinceB.
Re: Conversion from Word Perfect 12 to AAO Writer
Tnx Jan. I have a WP document that is a tabulation of data. When saving as .doc format, then opening with AOO, it got messed up; loss of columns/row lines and blank pages. Perhaps I need to rewrite that data in a database table using AOO Base, if this effort fails. Also, have documents that are letter-type, etc., but have not as yet tried to use MS Word (from MS Office 2003/2007) to AOO. I thought I would try LibreOffice, and did not want to make mistake of using an unusual download website. Regards, VinceB. Sent from my iPad On May 24, 2015, at 19:02, Jeanette Foster j...@fosterswebsite.com wrote: Vince - I'm not a very savvy user of either Word Perfect or AOO but I have been using Word Perfect Version 11 for many years. I was disappointed when I recently ran into this problem. I run on Windows 7. I tried this and it worked - * open the document in Word Perfect * open AOO in another window as if you were about to create a new text document * hilite and copy the entire text from the Word Perfect file * paste the text into the blank AOO file * Save in AOO If your existing documents are not too big or complex this simplistic work-around might meet your needs. Good luck. Jan F. On 5/24/2015 1:15 PM, Vince (II): WA2RSX wrote: Hello group: I am using WIN8.1 desktop, WORD PERFECT 12, and want to convert several existing documents to AAO 4.1.1, Build 9775. However, I have read here that LibreOffice supports WP and AAO does not. If that is true, then where do you suggest that LibreOffice be downloaded from? regards,VinceB.
Conversion from Word Perfect 12 to AAO Writer
Hello group: I am using WIN8.1 desktop, WORD PERFECT 12, and want to convert several existing documents to AAO 4.1.1, Build 9775. However, I have read here that LibreOffice supports WP and AAO does not. If that is true, then where do you suggest that LibreOffice be downloaded from? regards,VinceB.
Re: This file has notes
Yes, Brian, thanks for your helpful explanation. I was curious; that I must go looking for these Notes, because I did not knowingly write any! As far as I am concerned, it is not necessary that the Comments/Notes be displayed, until I need a reminder of what I was thinking at the time that I wrote the Calc formula for a particular cell. But, I will not turn off the Security Warning. Thanks again. Regards, Vince B. On 4/11/2015 6:22 PM, Brian Barker wrote: At 17:49 11/04/2015 -0400, Vince Noname wrote: Using AAO version 4.1.1m6 (build 9775-rev 1617669) on Win 8.1.1 desktop. I don't know why this pop up began about 4 weeks ago. I am told that: __ This document contains: Notes Do you want to continue saving the document? Yes. No. __ I click on Yes, and there doesn't appear to be any special problem occurring. But I do not know where the Notes are located or what they mean! Why am I given this dialog pop up? Since the embedded comments are not immediately visible, you may be saving this information unknowingly. You are given the option to bring up this warning whenever hidden information is present. To disable the warning, remove the tick from Tools | Options... | OpenOffice | Security | Security warnings | Warn if [...] When saving or sending. Are Notes equivalent to comments? As far as I can see, yes: they are generally called Comments but occasionally (confusingly?) referred to as Notes. I trust this helps. Brian Barker
This file has notes
Using AAO version 4.1.1m6 (build 9775-rev 1617669) on Win 8.1.1 desktop. I don't know why this pop up began about 4 weeks ago. I am told that: __ This document contains: Notes Do you want to continue saving the document? Yes. No. __ I click on Yes, and there doesn't appear to be any special problem occurring. But I do not know where the Notes are located or what they mean! Why am I given this dialog pop up? Are Notes equivalent to comments? Seems that this began after importing a ms excel file into AAO Spreadsheet. The excel file did have several Comments embedded in it, and they are available within the AAO file now, as expected. Any hints will be appreciated. Regards, Vince Sent from my iPad
Re: Mystery messages
TNX. On 3/27/2015 4:42 PM, Dennis E. Hamilton wrote: Yes, the archive location does not appear in the footers added by the list server. All of that information, for each list, is at http://openoffice.apache.org/mailing-lists.html. - Dennis -Original Message- From: Vince B. [mailto:wa.two...@verizon.net] Sent: Friday, March 27, 2015 12:24 To: users@openoffice.apache.org Subject: Re: Mystery messages How do I get to the List Archive? I am list- registered, but have not come across Archive. Regards, Vince Sent from my iPad - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Mystery messages
How do I get to the List Archive? I am list- registered, but have not come across Archive. Regards, Vince Sent from my iPad
Re: My First ooBase Database
Brian, thank you: You hit on very good points, and I do appreciate them. So, to edit data within a Table, use the Edit menu tab near top of screen; to edit the structure of Table, use the context- menu while Table name is highlighted. I am no expert at using spreadsheets either, but am finding my knowledge of spreadsheets, such as it may be, to be confusing my attempts to learn ooBase at this point! As the saying goes: Difficult to change or break old habits. ... Am presently working on learning the basic use of Forms. Difficulty is in becoming aware of the required workflow steps for using Tables and Forms in a database manager system. Challenge at this point is to get the Form to be synced with the Table, and vice versa. Have not yet grasped the concept of a Relational Database Manager System. For now, I am trying to learn the basics, and, ultimately, have a useful end- product whenever I feel successful! Regards, Vince_B. Sent from my iPad On Mar 6, 2015, at 03:19, Brian Barker b.m.bar...@btinternet.com wrote: At 21:03 05/03/2015 +, Vince Bonly wrote: OKay! Have learned that table editing must be initiated via a right-click drop-down menu on the highlighted name of table, rather than attempting to use the menu-bar's Edit tab. I knew it was a simple solution. That's not true: you can always use the menus. There are two things you might mean by editing: modifying the table design (which is what you originally asked about - adding another field to an existing table) and editing the data the table contains. o To modify the table design, you can use Edit in the context (right-click) menu, but you can indeed get to the same Table Design view via Edit | Edit... . o To modify a table's data, you need Table Data View instead. You can double-click the icon, use Open in the context menu, or go to Edit | Open Database Object... . My next task is to be able to insert a row between two already existing rows; is this possible, rather than the added row being located at the bottom of the table, i,e., last field? I have managed to add several new fields; however, it seems that these must always be appended following the presently last field within the table. Hmm. The order of records in the table display in a database shouldn't matter. The way you use a database is not by examining tables but through queries, forms, or reports. The displays you actually see should not depend on the order of records in any table, I think. If it helps, you can reorder records in a table using the sort facility. If sorting on existing fields cannot produce the order you require, you could add an additional field to indicate the order and then sort on that. But, as I say, I don't think you should particularly want to do this. 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
Re: I need help please
I am also interested in possibly using Forum. Am using a Win 8.x machine. Mailing List replies have been very helpful to me, but I believe that Forum may have additional value, such as screenshot uploads, etc. Regards, Vince_B. Sent from my iPad On Mar 8, 2015, at 12:17, Wayne Cameron dunro...@gmail.com wrote: I'm new to data base and am struggling to teach myself how to use it. I would like to participate in a community forum, so I could ask a question to help me over humps. How can I do this please? I may have registered, long ago, I don't remember. Unfortunately I am now unable to either register or log in, so I really need help please. Wayne Cameron
Re: My First ooBase Database
OKay! Have learned that table editing must be initiated via a right-click drop-down menu on the highlighted name of table, rather than attempting to use the menu-bar's Edit tab. I knew it was a simple solution. Beginning to get a little feel for ooBase. My next task is to be able to insert a row between two already existing rows; is this possible, rather than the added row being located at the bottom of the table, i,e., last field? I have managed to add several new fields; however, it seems that these must always be appended following the presently last field within the table. Hmm. Now, back to more tutorials. Regards,Vince_B. On Monday, March 2, 2015 10:29 AM, Vince (II): WA2RSX wa2...@yahoo.com wrote: Using AOO 4.1.1 on Win8 machine. Followed tutorial (http://sheepdogguides.com/fdb/fdb1tableone.htm), and wonder why a field for ZipCode is not included. Now trying to revise/edit my NameAddrPhone table, which does have an ID (autofill) column, to include a ZipCode field. I would also like to include several fields to accommodate phone numbers for: Home#, Cell#, Work#1, Work#2, Work#3, etc. Or, is that something that would be placed within a second table? What am I missing that would allow me to modify my existing table's design, which has only one record within it at this point? Am I jumping the gun when trying to edit an existing table? TIA. Vince_B.
