Alternate Row Shading

2018-05-31 Thread Vince@GMAIL
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

Re: Insertion of a Link

2018-05-29 Thread Vince@GMAIL
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 occasio

Insertion of a Link

2018-05-28 Thread Vince@GMAIL
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

Re: Incomplete/Incorrect Template Name is Shown via Use of Splash Screen

2018-05-28 Thread Vince@GMAIL
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

Incomplete/Incorrect Template Name is Shown via Use of Splash Screen

2018-05-27 Thread Vince@GMAIL
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

Re: Unable to Insert a Column

2018-05-24 Thread Vince@GMAIL
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 exis

Unable to Insert a Column

2018-05-23 Thread Vince@GMAIL
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

Re: Trouble printing

2018-03-28 Thread Vince@GMAIL
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.

NAMES in AOO- Calc

2018-03-22 Thread Vince@GMAIL
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

Re: Need Formula to use with Results of LARGE( ) Function's Result- Lookup?

2018-03-14 Thread Vince B.
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, Mar

Re: Need Formula to use with Results of LARGE( ) Function's Result- Lookup?

2018-03-12 Thread Vince@GMAIL
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

Need Help with Calc =LARGE( ) Function

2018-03-09 Thread Vince@GMAIL
_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

How to Embed My List of Reminders

2018-03-04 Thread Vince@GMAIL
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

Re: Unfamiliar Additional Column has Appeared in my Calc Sheet #7

2018-02-17 Thread Vince B.
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 pr

Re: Printed Page Layout

2017-06-01 Thread Vince B
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

Page Layout

2017-05-29 Thread Vince
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

Printed Page Layout

2017-05-29 Thread Vince B
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

Re: Quick Method to Insert Rows

2017-03-04 Thread Vince B.
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 qui

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

2017-01-22 Thread Vince
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:

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

2017-01-02 Thread Vince B.
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: >> &g

Re: Cannot locate Dialog for editing Cell range in Calc's Line Chart

2016-11-14 Thread Vince
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.

Re: Is there an insert Filename or insert Full Path Available?

2016-10-27 Thread Vince
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.

Re: How can I Cut and Paste Calc's Formulae Data into Thunderbird email Client?

2016-10-17 Thread Vince
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

Re: Naming a String that appears within a Calc formula

2016-10-17 Thread Vince
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.

Naming a String that appears within a Calc formula

2016-10-16 Thread Vince (II): WA2RSX
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 

Re: How can I Cut and Paste Calc's Formulae Data into Thunderbird email Client?

2016-10-16 Thread Vince
.) 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,

How can I Cut and Paste Calc's Formulae Data into Thunderbird email Client?

2016-10-16 Thread Vince
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

Re: Problem with Sort in Calc

2016-10-10 Thread Vince B.
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

Problem with Sort in Calc

2016-10-06 Thread Vince
Windows 10, desktop, AOO412m3(Build:9782) - Rev. 1709696 2015-10-21 09:53:29 (Mi, 21 Okt 2015) When sorting data in AOO Calc, must the "key" text data be located in the leftmost column? It seems that it is so. Regards, VinceB.

Re: Adjustment of high limit and low Limit in AOO-Calc Line Chart

2016-09-21 Thread Vince
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

Re: Adjustment of high limit and low Limit in AOO-Calc Line Chart

2016-09-21 Thread Vince B.
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: &

Adjustment of high limit and low Limit in AOO-Calc Line Chart

2016-09-20 Thread Vince
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

Re: Identify Colors Used within an Existing/Selected Cell

2016-06-25 Thread Vince
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.

Re: Identify Colors Used within an Existing/Selected Cell

2016-06-25 Thread Vince
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

Identify Colors Used within an Existing/Selected Cell

2016-06-24 Thread Vince
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

Re: Search & Replace Formula in Cell with a Named Array

2016-06-05 Thread Vince B.
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

Search & Replace Formula in Cell with a Named Array

2016-06-04 Thread Vince
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

Re: Unable to Get Page Break Preview

2016-06-03 Thread Vince
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 wro

Unable to Get Page Break Preview

2016-06-02 Thread Vince
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,

Re: Detecting/Counting Cell's Values if data is within a Specific Range of Values

2016-06-01 Thread Vince B.
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:

Re: Detecting/Counting Cell's Values if data is within a Specific Range of Values

2016-05-31 Thread Vince
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

Re: Detecting/Counting Cell's Values if data is within a Specific Range of Values

2016-05-31 Thread Vince
out 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 da

Re: Sort Sequence in Calc

2016-05-30 Thread Vince
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

Re: Sort Sequence in Calc

2016-05-29 Thread Vince
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 c

Sort Sequence in Calc

2016-05-28 Thread Vince
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

Detecting/Counting Cell's Values if data is within a Specific Range of Values

2016-05-20 Thread Vince
00. 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? Reg

Re: bug

2016-05-18 Thread Vince B.
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, R

Deletion of Chart in Calc

2016-05-07 Thread Vince
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

Convert AAO-Calc to AAO-Base and vice-versa

2016-04-24 Thread Vince B.
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

2016-04-22 Thread Vince
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

Re: Drop Down Menu, Again (SOLVED)

2016-04-22 Thread Vince
cted. 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 re

Drop Down Menu, Again

2016-04-19 Thread Vince
a-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 thi

JAVA Requirements

2016-03-29 Thread Vince
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

Finding the Largest Value within a Specific Column's Range of Cells in AOO-Calc

2016-02-26 Thread Vince
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/ .

Re: How to Generate a Drop Down List within a Calc cell?

2016-02-13 Thread Vince B.
< 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

Re: How to Generate a Drop Down List within a Calc cell?

2016-02-12 Thread Vince
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

Re: How to Generate a Drop Down List within a CALC cELL?

2016-02-12 Thread Vince
e ( ' ) 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

Re: How to Generate a Drop Down List within a CALC cELL?

2016-02-11 Thread Vince
ime 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.ne

How to Generate a Drop Down List within a CALC cELL?

2016-02-11 Thread Vince
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.

2016-01-30 Thread Vince
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,.

Re: Err: 508 When trying to Auto Replicate/Transfer data between two sheets._SOLVED

2016-01-30 Thread Vince
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

Re: Err: 508 When trying to Auto Replicate/Transfer data between two sheets.

2016-01-29 Thread Vince B.
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: &

Err: 508 When trying to Auto Replicate/Transfer data between two sheets.

2016-01-29 Thread Vince
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

Re: Err: 508 When trying to Auto Replicate/Transfer data between two sheets.

2016-01-29 Thread Vince B.
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 wro

OT: Cataract IOLs Replaced WAS: Re: Err: 508 When trying to Auto Replicate/Transfer data between two sheets.

2016-01-29 Thread Vince
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

Re: Chart Wizard

2015-08-15 Thread Vince B.
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

Re: Chart Wizard

2015-08-15 Thread Vince B.
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

Chart Wizard

2015-08-08 Thread Vince-WA2RSX
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

Re: Chart Wizard

2015-08-08 Thread Vince B.
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

Re: Conversion from Word Perfect 12 to AAO Writer

2015-05-25 Thread Vince B.
...@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

Conversion from Word Perfect 12 to AAO Writer

2015-05-24 Thread Vince (II): WA2RSX
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? 

Re: This file has notes

2015-04-12 Thread Vince-WA2RSX
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

This file has notes

2015-04-11 Thread Vince
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

2015-03-28 Thread Vince-WA2RSX
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

Re: Mystery messages

2015-03-27 Thread Vince B.
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

2015-03-08 Thread Vince B.
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

Re: I need help please

2015-03-08 Thread Vince B.
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

Re: My First ooBase Database

2015-03-05 Thread Vince (II): WA2RSX
.  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

Re: My First ooBase Database

2015-03-04 Thread Vince B.
proper pre-configuration, yet. Hmm? I believe Canada and UK also use zip code, or equivalent, and perhaps others do. Regards, Vince B. Sent from my iPad On Mar 3, 2015, at 16:40, Kay Schenk kay.sch...@gmail.com wrote: On Mon, Mar 2, 2015 at 7:29 AM, Vince (II): WA2RSX wa2

My First ooBase Database

2015-03-02 Thread Vince (II): WA2RSX
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

Need Help with Java with AOO4 Calc

2015-02-12 Thread Vince B.
Using AOO4 on Win 8.2. When trying to merge cells in Spreadsheet/Calc, I am told that Java runtime is needed. How may I verify that the Java install is correct/ can be repaired? Regards, Vince Sent from my iPad

Re: Need Help with Java with AOO4 Calc

2015-02-12 Thread Vince B.
that website to verify that I have both still installed properly in this machine. Thanks again for all of your time, effort, and help. Regards, Vince Sent from my iPad On Feb 12, 2015, at 11:10, Rory O'Farrell ofarr...@iol.ie wrote: On Thu, 12 Feb 2015 10:58:24 -0500 Vince B. wa.two

Re: Drop Down Menu in AOO4.1.1

2015-02-04 Thread Vince-WA2RSX
at https://forum.openoffice.org/, -Original Message- From: Vince B. [mailto:wa.two...@verizon.net] Sent: Wednesday, January 28, 2015 14:38 To: users@openoffice.apache.org Subject: Re: Drop Down Menu in AOO4.1.1 There are no suggested values; I manually monitor data on a random date

Re: Drop Down Menu in AOO4.1.1

2015-02-04 Thread Vince B.
After formatting the cells to Date (MMM D, ) your suggestion of =NOW() Worked splendidly; thanks! Regards, Vince Sent from my iPad On Feb 4, 2015, at 13:55, Brian Barker b.m.bar...@btinternet.com wrote: At 19:30 04/02/2015 +0100, Dave Barton wrote: From: Vince Bonly: Date: Wed

Re: Drop Down Menu in AOO4.1.1

2015-02-04 Thread Vince B.
No problem. Regards, Vince Sent from my iPad On Feb 4, 2015, at 14:48, Dave Barton d...@tasit.net wrote: Original Message From: Brian Barker b.m.bar...@btinternet.com To: users@openoffice.apache.org Date: Wed, 04 Feb 2015 18:55:53 + At 19:30 04/02/2015 +0100

Re: Drop Down Menu in AOO4.1.1

2015-01-28 Thread Vince B.
Base and Spreadsheet? Regards, VinceB Sent from my iPad On Jan 28, 2015, at 11:42, Brian Barker b.m.bar...@btinternet.com wrote: At 11:19 28/01/2015 -0500, Vince Bonly wrote: Can someone point me to info on creating a dropdown menu in a Spreadsheet cell, if this is possible? I have

Drop Down Menu in AOO4.1.1

2015-01-28 Thread Vince-WA2RSX
I am using AOO AOO411m6(Build:9775) - Rev. 1617669 2014-08-13 09:06:54 (Mi, 13 Aug 2014) on WIN 8.2 Desktop. Can someone point me to info on creating a dropdown menu in a Spreadsheet cell, if this is possible? I have created a spreadsheet to calculate Heating Fuel consumption, and