Java Version

2020-05-19 Thread Vince@GMAIL
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 Offi

Error Creating Object

2020-04-24 Thread Vince@GMAIL
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

It Is Time for Me to Generate an Updated Telephone-Addressbook

2020-04-17 Thread Vince@GMAIL
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-

Re: Calc Help

2020-01-20 Thread Vince@GMAIL
eful 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

Calc Help

2020-01-18 Thread Vince@GMAIL
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 sho

Re: Links Do Not Work in Calc

2019-10-05 Thread Vince@GMAIL
On 9/29/2019 2:12 PM, Brian Barker wrote: One idea: the target document needs to have been saved after any changes before any values from it can be harvested in this way. That one idea hit the mark Brian! When I returned to work on my Calc spreadsheets today, the problem was not experie

Update All Links Question

2019-09-29 Thread Vince@GMAIL
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

2019-09-29 Thread Vince@GMAIL
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

No Selection Possible in AOO Calc

2019-01-06 Thread Vince@GMAIL
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

Method to select multiple columns:rows in Calc

2018-09-11 Thread Vince@GMAIL
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 keystro

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 occasions, but do no

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 an

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 and/o

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 p

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 existing Ca

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 attemp

Re: Trouble printing

2018-03-27 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. O

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-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 post

Need Help with Calc =LARGE( ) Function

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

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 workbook,