Re: Transferring Data from Other Sheet

2017-04-08 Thread VinceB.
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

Transferring Data from Other Sheet

2017-04-08 Thread VinceB.
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

Re: When Can/Cannot a Calc Template Be Opened?

2017-03-27 Thread VinceB.
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

Re: When Can/Cannot a Calc Template Be Opened?

2017-03-26 Thread VinceB.
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 Can/Cannot a Calc Template Be Opened?

2017-03-26 Thread VinceB.
. 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

For What Home-Office Tasks are you Using AOO-BASE?

2017-03-09 Thread VinceB.
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. Regard

Re: Determine Five Best Scores

2017-03-09 Thread VinceB.
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

2017-03-07 Thread VinceB.
, 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

2017-03-05 Thread VinceB.
. 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

2017-03-05 Thread VinceB.
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

Quick Method to Insert Rows

2017-03-04 Thread VinceB.
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". Regard

Re: Install/Download of AOO 4.1.3 Failure

2017-02-08 Thread VinceB.
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

Re: Install/Download of AOO 4.1.3 Failure

2017-02-08 Thread VinceB.
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

Install/Download of AOO 4.1.3 Failure

2017-02-08 Thread VinceB.
. ...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

Re: Conditional Formatting over Same Range of Cells

2017-02-06 Thread VinceB.
ckground 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

2017-02-03 Thread VinceB.
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 a

Caps and Lowercase-Auto-complete Problem

2017-02-03 Thread VinceB.
red 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

Conditional Formatting over Same Range of Cells

2017-01-25 Thread VinceB.
g 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?

2017-01-22 Thread VinceB.
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

Re: COUNTIF Function Criteria: Can color of cell data be detected for counting?

2017-01-22 Thread VinceB.
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,

Re: COUNTIF Function Criteria: Can color of cell data be detected for counting?

2017-01-22 Thread VinceB.
l 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

COUNTIF Function Criteria: Can color of cell data be detected for counting?

2017-01-22 Thread VinceB.
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

2017-01-02 Thread VinceB.
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

Re: "McAfee Spam" Folder and "popstate-1.dat" Folder

2016-12-18 Thread VinceB.
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

"McAfee Spam" Folder and "popstate-1.dat" Folder

2016-12-18 Thread VinceB.
d. 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

2016-10-28 Thread VinceB.
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?

2016-10-25 Thread VinceB.
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