Re: Transferring Data from Other Sheet
TNX Jim. That worked for me. Regards, VinceB. On 4/8/2017 4:17 PM, James Plante wrote: Select sheet 1. Select cell C5. Type “=“ (no quotes). Now, select sheet 2. Select C8. Hit return to accept. You should be back in sheet 1, and cell C5 should be showing the value or text that is in sheet2:C8. Jim Plante On Apr 8, 2017, at 2:41 PM, VinceB. <wa.two...@verizon.net> wrote: Using Calc:AOO413m1(Build:9783) - Rev. 1761381 2016-09-29 02:39:19 on desktop Win10 PC. I am trying To Reference a Cell in the Same Document, but from two separate sheets. That is, I want to duplicate the value contained in cell C8 of my sheet 2 into cell C5 of my sheet 1. Getting err:501 or err:509. Please advise how this should be done. I suspect that I am missing quotation marks or something. 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
Transferring Data from Other Sheet
Using Calc:AOO413m1(Build:9783) - Rev. 1761381 2016-09-29 02:39:19 on desktop Win10 PC. I am trying To Reference a Cell in the Same Document, but from two separate sheets. That is, I want to duplicate the value contained in cell C8 of my sheet 2 into cell C5 of my sheet 1. Getting err:501 or err:509. Please advise how this should be done. I suspect that I am missing quotation marks or something. VinceB. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: When Can/Cannot a Calc Template Be Opened?
On 3/26/2017 10:12 PM, Brian Barker wrote: At 21:39 26/03/2017 -0400, Vince Bonly wrote: No joy here! Plenty here: warm, sunny, spring blossom, daylight saving ... If you are able to open an existing template while already having an opened Calc file, please tell me how. I don't mean using File | Recent Documents. You keep moving the goalposts! What's wrong with File | Recent Documents >? Nothing at all, if the list includes the file that I need at the moment. I have the default of 10 files included within the Recent Documents list. o To open the template for normal use, click the down-arrow next to the New button in the Standard toolbar and select Templates and Documents | Templates | My Templates (or My Documents, depending on where you have put your template). Sweet ! Now I see how you manage to achieve what I have been attempting to do here, myself. Thank You! Frankly, I have not noticed the "Templates and Documents" option under that "New" button. o To open the template for editing, go to File | Templates > | Edit... (...My Documents, depending on where you have put your template). I am not able to open the quick access launcher/dashboard, or whatever it's called, if I already have a Calc file opened. What I think of as the start screen? No: that is available only when you do not yet have a document open. When I navigate to my desktop and then click on the OpenOffice 4,1.3 shortcut, if a Calc file is already opened, I get that opened file; whereas I want to use the Templates button at the launcher screen to select a specific template for editing. I am trying to get both a template and a document file available within separate AOO windows screens. I think you are saying that you want to get back to the start screen after you have left it to open some template or document. Then it wouldn't be a start screen. And the fact that you lose it as soon as you open something surely has nothing to do anyway with whether you are handling documents, templates as templates, or templates for editing? 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: When Can/Cannot a Calc Template Be Opened?
No joy here! If you are able to open an existing template while already having an opened Calc file, please tell me how. I don't mean using File | Recent Documents. I am not able to open the quick access launcher/dashboard, or whatever it's called, if I already have a Calc file opened. When I navigate to my desktop and then click on the OpenOffice4,1.3 shortcut, if a Calc file is already opened, I get that opened file; whereas I want to use the Templates button at the launcher screen to select a specific template for editing. I am trying to get both a template and a document file available within separate AOO windows screens. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
When Can/Cannot a Calc Template Be Opened?
AOO 4.1.3 (AOO413m1(Build:9783) - Rev. 1761381 2016-09-29 02:39:19) on Windows 10 desktop. Whenever I already have a Calc file (.ods) opened, it seems that I am not allowed to open an existing Calc template file (.odt). OTOH, if a template is already opened, I am able to open a Calc file. Am I doing something incorrectly or is this normal behavior? Please advise how a template file can be opened while having a calc spreadsheet already opened. Regards, VinceB. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
For What Home-Office Tasks are you Using AOO-BASE?
Hello Group: Steven Ahers made a ref: to AOO BASE within his reply comments to one of my previous posts. I have not seen (m)any postings via the email list with regard to AOO BASE or the several other modules, for that matter. I have yet to come up with a practical use of the AOO BASE module. I wonder in what way BASE is being used by HomeOffice operators? An application of using BASE for developing a "Telephone Directory" database is what first comes to my mind; I did begin to do that here, but find that AOO CALC is easier for me. Anyone care to give their list of BASE task applications? Becoming aware of how HomeOffice operators are using BASE would be beneficial to me, and may give me reason to reconsider using a DBM rather than a spreadsheet tool in some instances. Regards, VinceB. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Determine Five Best Scores
On 3/9/2017 8:52 AM, James Plante wrote: @Brian: Thank you! I had not seen that function in use before. @Vince: Take a look in the Help file for another explanation of the LARGE() and SMALL() functions. Since you’re keeping track of bowling scores, you might also want to take a look at the RANK() function. From your posts, I’m thinking it may come in handy later on. Jim Plante Thanks Jim for the pointer; I will study the RANK function, and keep it in mind for future usage, in particular, when tracking bowling scores. I too was not aware of the LARGE( ) function until mentioned here by Brian, and I am making progress. In my experience, it is helpful being aware of the context of how CALC is being utilized by others. Your heads up comment about the RANK function most likely would not have ever been written by you if you were not somehow aware of my bowling score application with CALC. Regards, VinceB. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Determine Five Best Scores
Can someone offer assistance to me to solve a problem, using AOO 4.1.3-CALC ? I have typically 8 or 9 players in a bowling group. We are currently participating in a competitive tournament whereby I must submit a 5-member Team score results to the BVL Tournament administrator. Here is what I have: Eight players bowled three games today. I have entered each players' name in column A, followed by their individual scores in columns C, D, and E. I need to determine the five highest scores from the group of 8 players after each player finished 3 games of bowling. Is their a function that would allow determination and display of the five highest scores when considering 8x3=24 scores ? The data looks something like this: AB C DE March 7, 2017 PLAYER NAMES GAME #1 GAME #2 GAME #3 Player#1 156 111 165 Player#2 168 211 178 Player#3 109 127 97 Player#4 148 157 136 Player#5 114 127 134 Player#6 127 166 138 Player#7 146 197 177 Player#8 167 169 121 HIGH SCORE 168 211 178 Next HIGH 1 167 197 177 Next HIGH 2 156 169 165 In the above, the HIGH SCORE for columns C, D, and E were calculated using =MAX( ); the Next HIGH 1 and Next HIGH 2 were eyeballed ! I need to submit the five highest scores for 7 Mar 2017; and repeat this task for the remaining 3 tournament play sessions, 14, 21, and 28 Mar 2017. I don't know if this requires a macro or a lookup table, neither of which I have ever used in CALC. Any help on this is appreciated very much. Regards. VinceB.
Re: Quick Method to Insert Rows
On 3/4/2017 10:47 PM, Rochelle wrote: Instead I copied (command c) the number of blank rows I desired from far left column, then inserted it where I needed it. Rochelle Rochelle: That method works for me, also. If you can find two, or more, blank rows, the above method is not much of a problem to insert rows, for me. Do that once, or more, with one, or more, blank row(s), then select the resulting blank rows, and repeat as needed. I vaguely recalled a dialog window whereby you can specify the quantity of rows to be inserted, but that probably was within MS Excel. Regards, VinceB. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Quick Method to Insert Rows
On 3/4/2017 2:04 PM, Girvin Herr 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. 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 Girvin: Thank you, again. Your instructions were followed, and they worked perfectly on my WINDOWS 10 desktop. Regards, VinceB. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Quick Method to Insert Rows
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
Re: Install/Download of AOO 4.1.3 Failure
Problem solved. TNX for your info. On 2/8/2017 12:17 PM, VinceB. wrote: Today is the 2nd time that I have been unsuccessful in getting to the 4.1..3 version of AOO. I am using Windows 10 on a desktop PC. I made sure that AOO 4.1.2 is not opened. I am using this URL: http://www.openoffice.org/download/?utm_source=AOO4_1_2_en-US_medium=Client_campaign=Upgrade . There was a notice given that the page could not be found; I tried again, and it seemed to continue. However, there is no desktop shortcut for 4.1.3; a desktop shortcut for 4.1.2 remains. There was an error message saying ... Installation was interrupted. Your computer was not revised. ...I suspect that the installation went into an incorrect folder; should it be Programs x86 ? Into which folder, precisely, should it be located. Please advise. Regards, VinceB. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Install/Download of AOO 4.1.3 Failure
On 2/8/2017 12:52 PM, Andrea wrote: Am 08.02.2017 um 18:17 schrieb VinceB.: Today is the 2nd time that I have been unsuccessful in getting to the 4.1..3 version of AOO. I am using Windows 10 on a desktop PC. I made sure that AOO 4.1.2 is not opened. I am using this URL: http://www.openoffice.org/download/?utm_source=AOO4_1_2_en-US_medium=Client_campaign=Upgrade . There was a notice given that the page could not be found; I tried again, and it seemed to continue. The link works fine for me ... I should not have included "/Downloaded" in the Subject line of my OP. The link also, eventually, worked for me. I find the downloaded files in a sub-subfolder on my Desktop folder, /i.e./, equivalent to the Download folder. I believe that during the *installation wizard* process, the folder pointed to was incorrect. What I mean to be asking is: Into which folder should the executable, soffice.exe, for version 4.1.3 be found? Shouldn't it have overwritten the location of the 4.1.2 soffice.exe, which is found at: /This PC\OS(C:)\Program Files (x86)\OpenOffice 4\program /. I think that the Installation Wizard should have pointed to the aforementioned location. I am doing a search now for /soffice.exe /on /This PC / to see where the executable for 4.1.3 might be located. taking forever to finish !
Install/Download of AOO 4.1.3 Failure
Today is the 2nd time that I have been unsuccessful in getting to the 4.1..3 version of AOO. I am using Windows 10 on a desktop PC. I made sure that AOO 4.1.2 is not opened. I am using this URL: http://www.openoffice.org/download/?utm_source=AOO4_1_2_en-US_medium=Client_campaign=Upgrade . There was a notice given that the page could not be found; I tried again, and it seemed to continue. However, there is no desktop shortcut for 4.1.3; a desktop shortcut for 4.1.2 remains. There was an error message saying ... Installation was interrupted. Your computer was not revised. ...I suspect that the installation went into an incorrect folder; should it be Programs x86 ? Into which folder, precisely, should it be located. Please advise. Regards, VinceB. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Re: Conditional Formatting over Same Range of Cells
On 1/26/2017 2:02 AM, Brian Barker wrote: At 21:46 25/01/2017 -0500, Vince Bonly wrote: Using AOO 4.1.2 Calc on my WIN10 desktop, I have succeeded in detecting scores above a threshold (>174) and marking the cell for red font for a specified range of cells. That uses 1 of the 3 available criteria settings. Next, I tried setting a criteria setting (condition 2 of 3) for the same range of cells to apply a bold font whenever scores are >199. Thus, for example, a score of 225 would have both red and bold applied to the cell. It seems that Calc is unable to set a 2nd or 3rd criteria over *the same range of cells*. By experiment, I see that is not true: you can achieve what you want. Unfortunately, you don't explain exactly what you have done and what result you see, so anyone is left to guess. OK; I can verify FYI that at the time of my OP I had the following settings at the Format*|*Conditional Formatting dialogue: Condition 1: Cell value isgreater than74 Cell StyleRed if >174 Condition 2: Cell value isgreater than199 Cell StyleBOLD if >199 Scored Condition 3: Cell value isgreater than199 Cell Style11 pt if >199 Scored Conditional formatting works by applying cell styles. You talk about applying "both red and bold", but you cannot apply two styles simultaneously to the same cell or cell range, of course. So you would need one cell style for red and another for red-bold. (The criteria you wish to apply are such that you don't need bold without red.) Is that what you did? No, I did not. (See above.) All that's left is to notice the built-in help text, which says _inter alia_ "The conditions are evaluated from 1 to 3. If the condition 1 matches the condition, the defined style will be used. Otherwise, condition 2 is evaluated, and its defined style used. If this style does not match, condition 3 is evaluated." (This doesn't appear to be explained in the Calc Guide.) Note those words "Otherwise" and "If ... not": if any condition is satisfied, later ones are disregarded. In your case, if you apply the >174 condition first, the >199 condition will be evaluated only if the value is not >174 - so can never be effective. The solution is just to set >199 with red-bold as Condition 1 and >174 with red as Condition 2. Thank you, Brian. Indeed, very helpful, and key to grasping what is going on when using Format*|*Conditional Formatting feature in Calc. Is a Boolean AND required/possible in the criteria settings? Not if you are using "Cell value is", I think. Is the 3-criteria a limit for each Calc sheet? No: it's a limit for any individual cell, I think. However you construct your cell ranges, each cell has its own set of up to three conditions. I trust this helps. Brian Barker _ FYI, I now have the following settings; they work satisfactorily for my needs: Condition 1 cell style: Cell valueis greater than199. Cell Style*|*Font tab: I have selected Arial-Font; Bold-Typeface; and 11 pt-Size as the Font cell style definitions. Cell Style*|*Font Effects tab: I have selected Red-character color as the Font Effects cell style definition. Condition 2 cell style: Cell valueis greater than174. Cell Style*|*Font Effects tab: I have selected Red as the Font Effects cell style definition. Condition 3 cell style: Cell valueis greater between1 and100. Cell Style*|*Background tab: I have selected YELLOW fill-in color as the Background cell style definition. I hope that my info is also helpful. My TNX for your detailed discussion. Regards, VinceB.
Re: Caps and Lowercase-Auto-complete Problem
On 2/3/2017 10:03 AM, Rory O'Farrell wrote: On Fri, 03 Feb 2017 09:51:01 -0500 "VinceB." <wa.two...@verizon.net> wrote: I am trying to enter a case-specific text string into a Calc cell. The string has both uppercase and lowercase and numerical characters. It appears that Calc is remembering similar/previously entered strings and forces those to appear within the cell, i.e., changing a lowercase to an uppercase appearing as the first character, or changing a lowercase to an uppercase where the character is not the first nor the last character within the string. The format for the cell is "Text". Clearing cell's all content and tried again; no go. Using the check mark with the desired string display in the bar does not help me. How can I disable the auto-complete feature for this effort? What am I doing incorrectly ? Regards, VinceB. Try unchecking /Tools /Cell Content /Autoinput Thank you Rory. Your suggestion worked and solved my problem. I discovered that by using your suggestion, it is a control over the entire sheet. I thought I could apply it to only the column where I am entering case-sensitive text strings; so, I must reapply the /Autoinput tool feature afterward. TNX again. VinceB. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Caps and Lowercase-Auto-complete Problem
I am trying to enter a case-specific text string into a Calc cell. The string has both uppercase and lowercase and numerical characters. It appears that Calc is remembering similar/previously entered strings and forces those to appear within the cell, i.e., changing a lowercase to an uppercase appearing as the first character, or changing a lowercase to an uppercase where the character is not the first nor the last character within the string. The format for the cell is "Text". Clearing cell's all content and tried again; no go. Using the check mark with the desired string display in the bar does not help me. How can I disable the auto-complete feature for this effort? What am I doing incorrectly ? Regards, VinceB. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
Conditional Formatting over Same Range of Cells
Using AOO 4.1.2 Calc on my WIN10 desktop, I have succeeded in detecting scores above a threshold (>174) and marking the cell for red font for a specified range of cells. That uses 1 of the 3 available criteria settings. Next, I tried setting a criteria setting (condition 2 of 3) for the same range of cells to apply a bold font whenever scores are >199. Thus, for example, a score of 225 would have both red and bold applied to the cell. It seems that Calc is unable to set a 2nd or 3rd criteria over *the same range of cells*. 1. Is that normal, or else I am doing something else incorrectly ? 2. Is a Boolean AND required/possible in the criteria settings? 3. Is the 3-criteria a limit for each Calc sheet? Please advise. Regards, VinceB.
Re: COUNTIF Function Criteria: Can color of cell data be detected for counting?
On 1/22/2017 10:32 AM, VinceB. wrote: 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. Have found my error: *semicolon* rather than a comma following Range, i.e., COUNTIF(Range*;* Criteria). I am grateful of your helpful replies. Cause of error found (my vision); Solution found, Problem solved. */Now on to that method of Conditional formatting !/* Regards, VinceB.
Re: COUNTIF Function Criteria: Can color of cell data be detected for counting?
Thank you. On 1/22/2017 11:28 AM, Wade Smart wrote: Error Codes https://wiki.openoffice.org/wiki/Calc_Error_Codes -- 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
Re: COUNTIF Function Criteria: Can color of cell data be detected for counting?
On 1/22/2017 10:46 AM, Brian Barker wrote: At 10:32 22/01/2017 -0500, Vince Bonly wrote: 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. You probably shouldn't "take the time" to do this, but use conditional formatting to do it for you automatically. 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? I don't see any obvious way to do this. I tried: =COUNTIF(D439:K453,>174), but that does not work and did not return any error ref. I'm surprised you see no error. The simple answer is that you have the COUNTIF() function's syntax slightly wrong. You can use =COUNTIF(D439:K453,Xn) with Xn containing the string >10 (with no quotes), but if you want to put the condition in the formula itself - which is very often convenient, of course - you need to express it in quotes: =COUNTIF(D439:K453,">174") . I trust this helps. Brian Barker Thanks Wade and Brian for pointing out the Conditional formatting method; I shall most likely study that next. Should save me much time and avoid scanning a range of cells to detect occurrences of >174 values. Brian: I am getting error 508 with each of your two suggested COUNTIF entries (now using quotes >174 end quotes method). Is there a tutorial on defining such error numbers as 508? VinceB. - 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
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? 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
Re: "McAfee Spam" Folder and "popstate-1.dat" Folder
I must confess that I have not simply tried to delete these folders. I supposed that it is better to ask first ! Regards, VinceB. 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. About one month ago, I went through the task of deleting McAfee software, using their own s/w tool from their website to do the deletion/removal. Other than the Gmail email account, each of my other email accounts include, in the left-hand pane, have a folder entitled: "McAfee Anti-Spam". Both of those folders are empty. Is there a way to delete these unwanted/unnecessary folders ? B. What is the significance of a "popstate-1.dat" folder? 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.
"McAfee Spam" Folder and "popstate-1.dat" Folder
Using Tbird 45.5.1 on Windows10x64 desktop I have two Verizon, one Gmail and one Yahoo email accounts registered with Tbird. _ A. About one month ago, I went through the task of deleting McAfee software, using their own s/w tool from their website to do the deletion/removal. Other than the Gmail email account, each of my other email accounts include, in the left-hand pane, have a folder entitled: "McAfee Anti-Spam". Both of those folders are empty. Is there a way to delete these unwanted/unnecessary folders ? B. What is the significance of a "popstate-1.dat" folder? 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.
AOO Calc Chart Not including Last Two cell Contents
AOO412m3(Build:9782) - Rev. 1709696 2015-10-21 09:53:29 (Mi, 21 Okt 2015) WIN10x64 Well, here I go again: today's problem with my treasured Bowling Scores spreadsheet ! :-[ In my Calc sheet I have an existing line chart that shows my recent average bowling scores, e.g., where cell O435 contains the formula: =IF(D435="";"";AVERAGE(D435:L435)) . The heading for column O is MATCH AVG. The chart's X-axis should be reflecting the calculated results in cells $O$415 thru $O450, although O437 thru O450 do not as yet contain calculated data (my bowling MATCH AVG scores). The X-axis does show the numbers 1, 2, 3 19, 20 and 21, but data points 20 and 21 are missing from the graph/chart. Calc's Data Table does not show _Y-Values_ entries adjacent to the _Categories_ 20 and 21 entries. What needs to be done to include data points 20 and 21, which correlate to cells O435 and O436, in the line chart ?? (Cells O435 and O436 do have a calculated MATCH AVG score for my two most recent sessions at the bowling alley.) 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. Regards, VinceB.
Is there an insert Filename or insert Full Path Available?
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. - To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
