from:"WA.TWORSX via AOL"

Can AOO open MS ACCESS files?

2021-04-12 Thread WA.TWORSX via AOL



Hello:

I've got several files that have either ".LDB" or ".MDB" file extension 
names.   I believe these files were generated with MS ACCESS vers 1.0. 
Can they be opened/used by AOO?


Regards,
VinceB.

Re: French judges using OpenOffice - need help create a document template with "fields"

2020-09-08 Thread WA.TWORSX via AOL



On 9/8/2020 3:31 AM, Rory O'Farrell wrote:

On Mon, 7 Sep 2020 21:09:44 +
"marketing1...@outlook.com"  wrote:




I cannot help with any personal experience of the use of fields, but the 
following article and the files linked from it have been of use to OpenOffice 
users with a similar problem.

https://www.techrepublic.com/blog/linux-and-open-source/three-great-ways-to-use-variables-in-libreoffice-and-openoffice/

Linked from that article is an article and file from an American attorney on 
his use of fields in preparation of cases for court hearings.

  


Error 404 on Figures/illustrations within that link.

Re: Bouncing Message Listing

2020-07-02 Thread WA.TWORSX via AOL


Martin:

Your reminder of David Fisher's reply of 1 Dec is much appreciated.  
David's reply is, indeed, very clear. I have taken the necessary time to 
re-read his reply, and, this time, I paid closer attention to:



To retrieve a set of messages 123-145 (a maximum of 100 per request),
send a short message to:

I have just sent an email to the users-get.###_###@ ...  email address, 
and am at present aware of how that tool functions; hopefully, I will 
remember that tool's availability.


Thank you for the pointer/reminder.  Stay well and safe.

Regards,

VinceB.




-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Bouncing Message Listing

2020-07-01 Thread WA.TWORSX via AOL



HI:

I am using the Thunder Bird vers 6.8.10.0 email client for my 
@gmail.com, @verizon.net, and @yahoo.com email addresses on a Win10x64 
Home (1909) PC.


Every now & then I have received a message similar to:


Hi, this is the Mlmmj program managing the
mailing list.

Some messages to you could not be delivered. If you're seeing this
message it means things are back to normal, and it's merely for your
information.

Here is the list of the bounced messages:
- 56183
What must I do / Where should I navigate to, to further identify what?? 
is meant by "56183" ??? What is the correlation to this 
(users@openoffice.apache.org) eMail List?


Is there a central repository for @openoffice.apache.org and 
us...@global.libreoffice.org where I should be able to read message # 
56183 ?


Regards, and stay healthy and safe,

VinceB.

Telephone Number Formatting

2020-05-30 Thread WA.TWORSX via AOL




I have a Calc file that presently has telephone numbersexisting within a 
column. They were previously imported from a source that used the 
following format: 800 555 1234, and some cells are blank.



How can I reformat the column and all existing numbers within the column 
to be in the form: (800) 555-1234?



Be well; stay safe.


VinceB.



-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Java Version

2020-05-20 Thread WA.TWORSX via AOL


Dave and Group:

OKay; I now have a jre1.8.0_251 folder showing under C:Program Files 
(x86) Java. I think I am now convinced that a 32-bit JRE is installed on 
my computer.


1. Does that mean that AOO will recognize it?
2. What additional steps should I do for AOO functionality?
3. Is there a test that I can/should do?  I think AOO-Base relies on
   JRE; maybe I should attempt to run a Base template, since I do not
   have any Base files of my own doing, yet.

Please excuse my carelessness on the path, earlier.

VinceB.


On 5/20/2020 2:33 AM, BMCS wrote:

When you go to Tools -> Options -> OpenOffice -> Java you need to wait a
little while for the JRE to be found.

I think you mean C:\Program Files(x86) with only one backslash.
The attachment (striped by he list server) shows a snippet from Windows
file manager on one of my Windows 10 machines.

If you have the 32bit JRE installed AOO will normally find it.

Dave




-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Java Version

2020-05-19 Thread WA.TWORSX via AOL


BMCS:

When I go to Tools -> Options -> OpenOffice -> Java, I do have a check 
mark in box near the top for "Use a Java runtime environment", so I 
think AOO has been informed there.  But the next block does not show any 
JRE already installed.


I did not locate a Java sub folder in C:\\Program Files(x86), however.  
Is that normal for AOO?



On 5/19/2020 3:11 PM, BMCS wrote:


Provided you tell AOO to use the 32bit JRE and LO to use the 64bit JRE
it will not be a problem for you. Hint: Tools->Options->OpenOffice->Java



-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Java Version

2020-05-19 Thread WA.TWORSX via AOL




I will look within C:\\Program Files for the 64-bit jre and within the 
C:\\ Program Files(x86) for the 32-bit jre.


I did an update today; within Program Files > Java, showing these folders:

1. jre1.8.0.241 and
2. jre1.8.0.251, now.

AFAIK, the versions I gave in my OP for AOO and LO are the latest. I am 
on a *n*ormal Release Distribution.


VinceB.

On 5/19/2020 3:11 PM, BMCS wrote:

My responses are given in-line with your original message.


*From:* Vince@GMAIL [mailto:wa2rs...@gmail.com]
*Sent:* Tuesday, May 19, 2020, 18:17 UTC
*To:* AOO Mail List
*Subject:* 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

Unless there is a very good reason not to, you should update both to the
latest versions.

The two JREs available to me are:

1. jre-8u201-windows-i586
2. jre-8u241-windows-x64

Again update both to jre-8u251 https://www.java.com/en/download/manual.jsp

Given that a 32-bit java and a 64-bit java should/must not be
installed on the same machine/partition.

Where did you acquire this misinformation. For years I have had both 32
& 64 bit JRE installed and never encountered any issues.

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.

Provided you tell AOO to use the 32bit JRE and LO to use the 64bit JRE
it will not be a problem for you. Hint: Tools->Options->OpenOffice->Java

How should I proceed if I go ahead with the 64-bit AOO installation?
Will I loose any 32-bit AOO files/templates?

NO.

Are there any practical advantages included in AOO-64 over AOO-32?

Not sure what you mean by this.

Your suggestions will be appreciated.

Thanks for reading this. Stay well and be safe.

VinceB.

Hope this helps.

Dave



-
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: Registering a Template in Calc

2020-05-16 Thread WA.TWORSX via AOL




Thank you Joost;

I spent some time today attempting to organize a rather long list of 
templates under My Templates in the Template Management pop-up dialogue 
window.  I have Templates selected in both near the bottom of the 
Management window.


When I double-click on My Templates  within the left-side pane, I see my 
20, or so, existing templates.  I would like to organize them into sub 
folders; e.g., Bowling Templates, Inventory Templates, Budgeting 
Templates, etc.  However, after using Commands > New   Insert, and then 
doing Commands > Update, I am NOT seeing any difference; was expecting 
to see a slot for me to enter name of my new sub-folder; e.g., Bowing 
Templates.


What am I missing?

Regards, and stay safe.

VinceB.

On 5/16/2020 10:03 AM, Joost Andrae wrote:

Hi VinceB,

just use menu item File->Templates->Save...
to save a template.

Within the File->Templates menu you'll find also a dialog to organize 
templates.


Kind regards, Joost

Am 15.05.2020 um 19:04 schrieb WA.TWORSX via AOL:

AOO415m1(Build:9789)  -  Rev. 1817496
2017-12-11 17:25

Win10-64 bit Home w/desktop PC




I am wondering if there is a better method to use to "register" a 
newly created template in AOO-Calc.  What I have just done is;


1. Delete content of any and all cells that contain numeric data and/or
    unwanted text strings within an existing, similar, Calc spreadsheet
    (.ods)
2. Save the spreadsheet file in a template file format (.ots)
3. Use Windows File Explorer to drill down to the 'template' folder,
(C:\Users\username\AppData\Roaming\OpenOffice\4\user\template), and
4. Save the newly created template

Step 3. above takes a bit of time to finish.  Is there an easier way 
to accomplish this task within AOO-Calc?  Can someone point me to the 
relevant documentation or offer an easier procedure?


Thanks for reading this, and please stay safe.

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

Registering a Template in Calc

2020-05-15 Thread WA.TWORSX via AOL


AOO415m1(Build:9789)  -  Rev. 1817496
2017-12-11 17:25

Win10-64 bit Home w/desktop PC




I am wondering if there is a better method to use to "register" a newly 
created template in AOO-Calc.  What I have just done is;


1. Delete content of any and all cells that contain numeric data and/or
   unwanted text strings within an existing, similar, Calc spreadsheet
   (.ods)
2. Save the spreadsheet file in a template file format (.ots)
3. Use Windows File Explorer to drill down to the 'template' folder,
   (C:\Users\username\AppData\Roaming\OpenOffice\4\user\template), and
4. Save the newly created template

Step 3. above takes a bit of time to finish.  Is there an easier way to 
accomplish this task within AOO-Calc?  Can someone point me to the 
relevant documentation or offer an easier procedure?


Thanks for reading this, and please stay safe.

VinceB.

Re: Optimum Row Height-Default

2020-05-04 Thread WA.TWORSX via AOL




On 5/3/2020 1:44 AM, 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?

o You can easily select multiple rows using click and Shift+click in 
the row headers or by dragging down the row headers. Then you can 
adjust the row height for all those rows in a single step.


o Even more generally, you can select an entire sheet (or even 
multiple sheets) by clicking in the rectangle at top left, where the 
row and column headers meet. Again, you can adjust the row height for 
all those rows at once.




Yes, but first I must drop down to any Row's left margin header area and 
do a right-click; only after doing that, am I able to add my desired 
additional space (pitch) and make a change for optimum row height for 
all rows in the sheet (most of the time, as this sometimes misses a 
row(s)).



o With a bit more work, you can change the row height in a blank 
spreadsheet and then save it as a template. You can even choose your 
new template to be the default - which more or less achieves what you 
ask for. Note that if you insert any new sheets into a document 
created with such a template, they will revert to the original default 
row height, so you will want either to create sufficient sheets in 
your template to render extra sheets unnecessary, or else to create 
any new sheets by copying existing (empty?) sheets rather than by 
inserting new sheets.


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

Optimum Row Height-Default

2020-05-02 Thread WA.TWORSX via AOL


In Calc, where can the default setting be reset/changed?



-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Difficulty to control printing of a Calc file

2020-05-01 Thread WA.TWORSX via AOL


Hi Brian:

I am still experimenting/learning here.

You have helped me to better understand how to make use of the Format | 
Page... | Sheet | Scale | Scaling mode. I find that my document's 
printed output appears correctly, or at least, to my satisfaction, at 
this moment, when I use the setting of "Fit range width to width/height" 
and use Width = 1 page and Height = 6 pages; and I don't need to do any 
manual page breaks, in this case.


Thank you for leading me to further investigate the scaling mode options 
and to discover where my mistakes/errors were introduced.  (The number 
of operator's errors should now be fewer!)


Regards,

VinceB.


On 4/30/2020 12:52 PM, Brian Barker wrote:

At 11:58 30/04/2020 -0400, Vince Bonly wrote:

It seems that print-settings for my Calc file do not stick.


I think they should.


(Wasted several sheets of ink.)


There are two solutions for that:

o Use File | Page Preview (or the Page Preview button in the Standard 
toolbar) before actually printing. (You can adjust page formatting 
from within Page Preview.)


o Another way is to install a virtual PDF printer: freeware versions 
are available. You don't need this for creating PDF copies of your 
documents, as OpenOffice includes the File | Export as PDF... 
facility. But having a PDF creation facility masquerading as a printer 
means that you can use the normal Print function to create a PDF and 
inspect it before wasting paper and ink or toner.


A change of page-breaks also causes a change of scaling, or width, of 
the printed document. Is that normal?


I think the answer is "No - by default". But it can be "Yes" if you 
have chosen to set Format | Page... | Sheet | Scale | Scaling mode to 
something other than "Reduce/enlarge printout". With other options 
there, you will see automatic adjustments as you make other changes. 
Try "Reduce/enlarge printout" and Scaling factor: 100% if in doubt.


Please, someone remind me of which slider control, near top or near 
bottom of screen, actually controls print-output scaling factor and 
which controls the screen scale factor. I might be using the 
incorrect one.


I think the scaling mode and factor described above are the only place 
where the output differs from what you have set up in your actual 
spreadsheet. The screen scaling - which doesn't affect printout - can 
be changed in various ways:


o Go to View | Zoom... . Experiment with the settings there to produce 
the effect you prefer.


There are also two controls near the right end of the Status Bar, at 
the bottom of the OpenOffice window. (You may need to toggle this on 
at View | Status Bar):


o The Zoom slider allows you to adjust the zoom factor in alternative 
ways:

 + Click the button where you want it to appear,
 + Drag the button to the appropriate position,
 + Or click the "-" and "+" buttons as desired to increase or decrease 
the zoom factor.


o Right-click the "Zoom percent" display in the corner and select an 
option from the context menu.


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: Difficulty to control printing of a Calc file

2020-05-01 Thread WA.TWORSX via AOL

Hi Peter:

Thank you for providing that link, which I have quickly read through. I
am trying to digest the info now.

Can you, (or anyone else,) verify that the sequence presented in that
article is the correct sequence of steps to be followed?

I can follow a procedure that has numbered steps, if given.

After generating the spreadsheet data for my Calc file, I:

1. select _V_iew --_P_age Break Preview to set manual page breaks;
2. select Format--Print Ranges to Define/Edit my required print range;
3. select File--Printer Settings (usually double-sided printing);
4. select Page Preview (for a final visual check);
5. select _F_ile--Print, to my printer, (or Save as a PDF file via the
Print dialog).

in that sequence. Should I change my sequence?

Suggestions are welcomed by me.

Regards,

VinceB.

On 4/30/2020 12:15 PM, Peter Kovacs wrote: t

you can check this How To:

https://wiki.openoffice.org/wiki/Documentation/FAQ/Calc/Printing/How_do_I_print_my_spreadsheets%3F

All the Best

Peter

Am 30.04.20 um 17:58 schrieb WA.TWORSX via AOL:

AOO415m1(Build:9789) - Rev. 18174962017-12-11 17:25

win10x64 home desktop

It seems that print-settings for my Calk file do not stick. (Wasted
several sheets of ink.) A change of page-breaks also causes a change
of scaling, or width, of the printed document. Is that normal?

Please, someone remind me of which slider control, near top or near
bottom of screen, actually controls print-output scaling factor and
which controls the screen scale factor. I might be using the
incorrect one.

Please be well and stay safe.

VinceB.

Difficulty to control printing of a Calc file

2020-04-30 Thread WA.TWORSX via AOL




AOO415m1(Build:9789) -  Rev. 18174962017-12-11 17:25

win10x64 home desktop

--

It seems that print-settings for my Calk file do not stick. (Wasted 
several sheets of ink.) A change of page-breaks also causes a change of 
scaling, or width, of the printed document. Is that normal?



Please, someone remind me of which slider control, near top  or near 
bottom of screen, actually controls print-output scaling factor and 
which controls the screen scale factor. I might be using the incorrect one.



Please be well and stay safe.


VinceB.




-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Numbers automatically advance in spreadsheet columns

2020-04-27 Thread WA.TWORSX via AOL


TNX Alan:

I had experienced same as David did; now I know that I must hold Ctrl 
key to repeat the number while dragging the mouse pointer.


Regards, and please ALL, stay safe.

VinceB.

On 4/27/2020 1:13 PM, Alan B wrote:

Hello David,

Have you tried,
- select cell
- grab cell handle at bottom right with mouse left click and hold
- press and hold Ctrl key
- drag mouse

That will produce a column that repeats the number in the highlighted cell.

On Mon, Apr 27, 2020 at 1:08 PM David Deeks 
wrote:


I have been an Open Office user for many years, but only recently
discovered this group, and have already learned a couple of things!

I am hoping however that someone can help with a specific and longstanding
problem with numbers in spreadsheet columns. If I have a cell with a number
in that I want repeated down the column, I would love to able to simply
highlight the cell and drag down the column. The problem is that in each
line the numbers always increase by 1. This is useful of course sometimes,
but not always! I have tried all formats, including text etc, and feel as
though I’ve looked through every menu - but cannot find how to stop it
doing this. I am sure there must be a way?

Thanks

David Deeks
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

format for a website

2020-04-25 Thread WA.TWORSX via AOL



Calc 4.1.5, Win10 x64, desktop

___

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) ?


I know how to convert a hotlink to a non-hot link, but how do I go the 
other way?


Stay safe.

Regards,

VinceB.

Re: Error Creating Object

2020-04-24 Thread WA.TWORSX via AOL


I think I have accomplished a work around.

I copy-pasted each of the 3 sheets into sheets of a blank Calc file, 
renamed the sheets, and managed to save the just created Calc file under 
a different filename.


I used Task Manager to kill the AOO process on the corrupted Calc file.  
NOW: when I open that same file, it is able to be modified and then 
saved.  So, the Task was hung up it seems even though I was able to make 
revisions, etc.


I am now back to Normal:  CONFUSED !




On 4/24/2020 11:15 AM, Peter Kovacs wrote:

I have no Idea.

Do other save locations work?

Am 24.04.20 um 17:13 schrieb WA.TWORSX via AOL:

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.

Error Creating Object

2020-04-24 Thread WA.TWORSX via AOL


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.

Error Creating Object

2020-04-24 Thread WA.TWORSX via AOL


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.





-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

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

2020-04-18 Thread WA.TWORSX via AOL



My thanks to Dan and Pete for both of their comments I find very 
interesting.


I did not know that TB's address book could be used as the source 
database.  Am I correct in thinking that my GOOGLE Contacts list could 
also serve as a database ?


I have been trying to keep my TB address book up to date as well as my 
GOOGLE's Contacts list, and to keep both of those in sync. Can those, 
both, be used simultaneously as data sources?


I suppose that I should register my GMAIL email address with this AOO 
Email List, because I keep forgetting that it is my @verizon.net that is 
already registered.


TNX and, please, everyone stay safe!

VinceB.


On 4/18/2020 7:08 AM, Dan Lewis wrote:
As you are not subscribed to this mailing list, you will not see all 
of the replies. So, I have copied Peter's response for you to see 
below my remarks. Also, do not reply directly to me for information: 
send it to users@openoffice.apache.org.


If you are comfortable in using Thunderbird as you data source, you 
can fill in the information that you want to have in it. Then you can 
use Base to connect to it creating Thunderbird.odb. When you open this 
file you will have all of the information that is in Thunderbird's 
Address Book at your finger tips. Both AOO and LIbreOffice will open 
this file.


Important: Any changes you want to make in the address information has 
to be made in the Thunderbird Address Book. Base only shows the 
information that is contained in this address book. However, you can 
still create queries, forms, and reports using this information. This 
opens up all kinds of ways to work with this information. If, for 
example, you wanted to send a single email to several different people 
at one time, this can be done by AOO or LibreOffice. It is called mail 
merge. Just some thoughts.


Dan

Peter Kovacs 

Hi,

I would say it depends what your goal is.

Is it a simple Address List, then Calc is the way to go. Do you want 
to do complex stuff with the List then you may want to consider a 
database approach and look if you base is sufficient.


I would personally install locally an Email App and use the build in 
Address book (maybe Thunderbird?). If you configure to sync Google 
then you have an easy job syncing the Addresses between your PC, 
Google and even to an Android Smart phone will be simple. And you can 
then maintain your address List on your phone. This works for me.



All the Best

Peter

On 4/17/20 16:34, Vince@GMAIL wrote:


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: Saving changes in original

2020-03-07 Thread WA.TWORSX via AOL




What type of document are you working with? From your description, seems 
that it might be a template (.ott).



On 3/6/2020 3:28 AM, SaleemaEG wrote:

Hi, and thank you so much for open office, it is great!

Would you please tell me how to "save" changes in my original document
without creating a new version?  I am trying to save my changes (I do not
choose "save as")  but I keep getting a new page with the edit I want to
save. Sometimes I simply notice a misspelled word and I correct it,  but
the original remains the same. Is there a way to* save* in the original?

Thank you in advance for any help you can offer.

With Gratitude,
Saleema



-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Unable to Remove/Delete a Link Button in Calc

2020-01-31 Thread WA.TWORSX via AOL

I believe that I have found a solution to my buttoned hyperlink problem,
after reading through info given here:

https://wiki.openoffice.org/wiki/Documentation/OOo3_User_Guides/Calc_Guide/Hyperlinks_and_URLs

The pertinent info is:

A hyperlink button is a type of form control. As with all form
controls, it can be anchored or positioned by right-clicking on the
button in design mode. More information about forms can be found
inUsing Forms in Writer
<https://wiki.openoffice.org/wiki/Documentation/OOo3_User_Guides/Writer_Guide/Using_Forms_in_Writer>.

For the button to work , the spreadsheet must/not/be in design mode.
To toggle design mode on and off, view the Form Controls toolbar
(*View > Toolbars > Form Controls*) and click the*Design Mode
On/Off*buttonFormDesignOffIcon.png
<https://wiki.openoffice.org/wiki/File:FormDesignOffIcon.png>.

Once I became aware that a hyperlink button is a type of form control, I
toggled Design Mode On; that enabled me to *move* the buttoned hyperlink
anchored location point so that it no longer conflicts with existing
cell's data. Then, with Design Mode On, I could right-click and Cut it
from the .ods file !! To return to a default state, I then toggled
Design Mode Off.

On 1/29/2020 11:06 AM, WA.TWORSX via AOL wrote:

AOO-Calc .1.5 on Win10x64 Home desktop

After doing some revision to my Bowling Score Data spreadsheet, I
find, (what I think is), an unwanted button to a link that now spans
from column O thru column AP, in row 2.Those columns were previously
hidden while I was focusing my revision work in adjacent areas, i.e.,
columns A thru N and columns AJ thru AT. Not sure if that is related
to the cause of this problem, but might be. I seem to recall that the
button was originally located within column AH, prior to hiding those
columns. The link is no longer valid, so when I click on the button in
an attempt to delete it, I am shown an error message saying that
Windows cannot find the file.

I deleted the existing row 2, but the unwanted button continues to
appear in (new) row 2.

The same problem occurs within row 16, except that the unwanted button
spans columns O thru AI. At one time, I probably had a button to a
link located within column AH, possibly in row 16. Again, the button
remains and breaks formulae below row 16 if I delete the entire row 16.

Help!

-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Unable to Remove/Delete a Link Button in Calc

2020-01-29 Thread WA.TWORSX via AOL


AOO-Calc .1.5 on Win10x64 Home desktop



After doing some revision to my Bowling Score Data spreadsheet, I find, 
(what I think is), an unwanted button to a link that now spans from 
column O thru column AP, in row 2.Those columns were previously hidden 
while I was focusing my revision work in adjacent areas, i.e., columns A 
thru N and columns AJ thru AT. Not sure if that is related to the cause 
of this problem, but might be. I seem to recall that the button was 
originally located within column AH, prior to hiding those columns. The 
link is no longer valid, so when I click on the button in an attempt to 
delete it, I am shown an error message saying that Windows cannot find 
the file.


I deleted the existing row 2, but the unwanted button continues to 
appear in (new) row 2.


The same problem occurs within row 16, except that the unwanted button 
spans columns O thru AI. At one time, I probably had a button to a link 
located within column AH, possibly in row 16. Again, the button remains 
and breaks formulae below row 16 if I delete the entire row 16.



Help!




-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Calc Help-INTERIM SOLUTION

2020-01-27 Thread WA.TWORSX via AOL




Not a problem, Alan.


On 1/27/2020 5:43 PM, Alan B wrote:

See David Robeley's response.

I was jumping back and forth between virtual machines and inadvertently
used the one with LibreOffice without remembering you're using OpenOffice.
My bad.

Sorry about that.

On Mon, Jan 27, 2020 at 4:20 PM WA.TWORSX via AOL
 wrote:


Alan:

I tried in cell H44: =MINIFS(G6:G41,G6:G41,">0"), but it is not working
for me. Error508: Error in bracketing is shown.

I also tried with use of semicolons =MINIFS(G6:G41;G6:G41;">0") rather
than commas; #NAME? error is returned.

No joy here.

I could not find anything  as =MINFS(  ) funtion within the built-in
(F1) Help file. Can you point me to a discussion elsewhere?





-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Calc Help-INTERIM SOLUTION

2020-01-27 Thread WA.TWORSX via AOL




TNX David; I have just been visiting the LibreOffice help 
https://help.libreoffice.org/6.2/he/text/scalc/01/func_minifs.html?DbPAR=CALC 



and came to that same conclusion.


On 1/27/2020 4:46 PM, David Robley wrote:
Those functions are not available in AOO - but exist in LibreOffice 
since around version 5.2


On 28/1/20 7:50 am, WA.TWORSX via AOL wrote:

Alan:

I tried in cell H44: =MINIFS(G6:G41,G6:G41,">0"), but it is not 
working for me. Error508: Error in bracketing is shown.


I also tried with use of semicolons =MINIFS(G6:G41;G6:G41;">0") 
rather than commas; #NAME? error is returned.


No joy here.

I could not find anything  as =MINFS(  ) funtion within the built-in 
(F1) Help file. Can you point me to a discussion elsewhere?




Cheers


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Calc Help-INTERIM SOLUTION

2020-01-27 Thread WA.TWORSX via AOL

Alan:

I tried in cell H44: =MINIFS(G6:G41,G6:G41,">0"), but it is not working
for me. Error508: Error in bracketing is shown.

I also tried with use of semicolons =MINIFS(G6:G41;G6:G41;">0") rather
than commas; #NAME? error is returned.

No joy here.

I could not find anything as =MINFS( ) funtion within the built-in
(F1) Help file. Can you point me to a discussion elsewhere?

On 1/27/2020 3:01 PM, Alan B wrote:

Hello Vince,

Thank you for your kind words.

In your sheet notes you describe needing to "segment a formula" into
several ranges. Unnecessary work, I think.

Try the following formulas instead...
In H43, =MAXIFS(G6:G41,G6:G41,">0")
In H44, =MINIFS(G6:G41,G6:G41,">0")

They appear to me to work as desired in your example sheet.

On Sun, Jan 26, 2020 at 2:40 PM WA.TWORSX via AOL
wrote:

I believe that I am successful with an interim solution to my original
problem.

This DropBox link, I think, will allow you to download my interim
solution, which comes with some caveats and compromises:

https://www.dropbox.com/s/05gk2h8zt7lbua2/Calc%20Help-updating%20Data_INTERIM%20SOLUTION.ods?dl=0

The caveats and compromises are presented in the referenced .ods file by
way of annotated comments on the content of cells as used in my solution.

I am very appreciative to AlanB for the time he has spent in an effort
to lead me toward the correct Calc sheet. Believe me, I have learned
from his thoughtfulness and patience to explain why he made specific
suggestions for changing my approach. This is how I am able to learn.
Thank you Alan! If it were not for your assistance, I would not have
gotten to this point.

In his 1/24/2020 posted reply, Alan mentioned a glitch involving cell
G36. I have not been able to duplicate the problem.

Alan's logic for the formula in cell J6:

* The formula in cell J6 for "Total Pins" column calculates total pins

for

rows 6 through row the formula is in.

=IF(ISNUMBER(I6),DSUM($G$5:INDIRECT(CONCATENATE("$G",ROW())),1,$BB$5:$BB$6),"")

This formula should be copied to all week# rows in column J. It updates
correctly for each row it is in.

is far above my present skill level. Thus, I may return to it in the
future when I attempt to set up a calc sheet for a new WINTER SR LEAGUE
bowling season.

Yes, this all started with my goal of AL7 and AN7 being updated
automatically, without first changing the enclosed formula or being
modified by hand. My interim solution allows for auto-updating of AL7.
Cell AN7 is simply: AN7=(AL7/3).

Regards,

VinceB.

P.S. The PBA Oklahoma Open Bowing Tournament stepladder finals are
presently being televised on FS1 channel. I'm gone!

-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Is there a FAXing Facility in AOO?

2020-01-27 Thread WA.TWORSX via AOL




I have a PDF file that contains info that I want to transmit to a FAX 
recipient. If I convert that PDF file, via OCR, would AOO-Writer be 
useful to FAX the document?


Regards, VinceB.


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Calc Help-INTERIM SOLUTION

2020-01-26 Thread WA.TWORSX via AOL

I believe that I am successful with an interim solution to my original
problem.

This DropBox link, I think, will allow you to download my interim
solution, which comes with some caveats and compromises:

https://www.dropbox.com/s/05gk2h8zt7lbua2/Calc%20Help-updating%20Data_INTERIM%20SOLUTION.ods?dl=0

The caveats and compromises are presented in the referenced .ods file by
way of annotated comments on the content of cells as used in my solution.

In his 1/24/2020 posted reply, Alan mentioned a glitch involving cell
G36. I have not been able to duplicate the problem.

Alan's logic for the formula in cell J6:

* The formula in cell J6 for "Total Pins" column calculates total pins for
rows 6 through row the formula is in.
=IF(ISNUMBER(I6),DSUM($G$5:INDIRECT(CONCATENATE("$G",ROW())),1,$BB$5:$BB$6),"")
This formula should be copied to all week# rows in column J. It updates
correctly for each row it is in.
is far above my present skill level. Thus, I may return to it in the
future when I attempt to set up a calc sheet for a new WINTER SR LEAGUE
bowling season.

Regards,

VinceB.

P.S. The PBA Oklahoma Open Bowing Tournament stepladder finals are
presently being televised on FS1 channel. I'm gone!

Re: Calc Help

2020-01-25 Thread WA.TWORSX via AOL



And, here I was about to claim that I have a satisfactory *work-around 
solution*, including cell AL7, and was about to incorporate the changes 
into my actual .ods file that is being used for the present bowling 
season. I'll come up with a DropBox link to what I think is a workable 
solution, soon.


Will take a closer look at the G36 issue, perhaps, later today, because 
I do hope to have a template of this calc sheet for use during future 
bowling seasons, i.e., covering G6:G41.



On 1/24/2020 7:17 PM, Alan B wrote:

DNB is meant to note someone did not bowl. It is just text entered in each
cell rather than merging the cells and entering "Did not bowl".

Now, some bad news. After reviewing what I suggested I realized the formula
given for cell AL7 will always show the value in G36 if the column G
formula is copied to every row at the start of each season. If it is added
week by week to each row in column G, then no problem. That doesn't make
for an easy to maintain sheet though.

My idea was enter three scores each week and everything else updates.

I did a little more thinking and came up with the following which meets the
goal above (this all started so AL7 and AN7 will update without being
modified by hand)...

* cells in the range D6:F41 must always be a score, the text "DNB", or be
empty
* Rows 6 through 41 must always have the games entered week by week. IOW,
no entering week 7 before week 6.
* the row for half way in the season must be removed. Only rows for bowling
weeks are allowed

* The formula in cell G6 for "Match Series" column is...
=IF(SUM(D6:F6)=0,IF(D6="DNB","DNB",""),SUM(D6:F6))
The formula displays the total for the games, DNB, or "".
SUM is 0 if columns D-F have DNB or "".
This formula can be copied to all the rows in the column and it will update
correctly for each row it is in.

* The formula in cell H6 for "Match Average" column is...
=IF(ISNUMBER(G6),G6/3,G6)
This formula can be copied to all the rows in the column and it will update
correctly for each row it is in.

* The formula in cell J6 for "Total Pins" column calculates total pins for
rows 6 through row the formula is in.
=IF(ISNUMBER(I6),DSUM($G$5:INDIRECT(CONCATENATE("$G",ROW())),1,$BB$5:$BB$6),"")
This formula should be copied to all week# rows in column J. It updates
correctly for each row it is in.
So for row 10 it calculates the total of rows 6 through 10, For row 15 the
total of row 6 through 15 and so on. If there is no number in League
Average it displays "".
Buried in the formula is the DSUM function. It requires a "Criteria Range"
to work. As written here the criteria range is cells BB5 and BB6. Cell BB5
contains the formula =G5. Cell BB6 contains >=0. For a criteria range to
work the column titles of the "database" and the "criteria range" must
match exactly (not accounting for formatting). If column title G, "Match
Series", is ever changed having cell BB5 be a formula that refers to it
prevents needing to remember to update the criteria.
The INDIRECT function enables the formula to identify the ROW() it is in so
the DSUM database range doesn't have to be entered individually for each
row, e.g. $G$5:$G$5, $G$5:$G$6, $G$5:$G$7 ... , $G$5:$G$10 and so on.

* The formula in cell AL7 for Vince post match play is...
=INDEX($Sheet1.G6:G41,36-COUNTBLANK($G$6:$G$41),1)
The column G formula returns one of three values, the sum of the games,
"DNB", or "". The season has 36 weeks. The formula presumes that as weeks
go by the Match Series column will be either a number, "DNB", or "" and
that "" are always the last rows in the column. Provided these conditions
are true the formula always returns the most recently entered week's Match
Series result.

* The formula in cell AN7 for Vince post match average is...
=INDEX($Sheet1.H6:H41,36-COUNTBLANK($H$6:$H$41),1)
This works the same as the above formula except for Match Average.




On Fri, Jan 24, 2020 at 10:16 AM WA.TWORSX via AOL
 wrote:


On 1/20/2020 5:58 PM, Alan B wrote:

I've found a method that can work, providing the spreadsheet design is
modified somewhat.
It comes from a formula provided by RusselB in the OpenOffice forums.

=index(range;count(range);1)

For your sample spreadsheet this formula in cell AL7
=INDEX($Sheet1.G6:G42,COUNTA($Sheet1.G6:G42),1)
will return the Match Series value for the last value entered. When

week#20

is completed the number in AL7 will update. When week#21 is completed it
will update again, and so on.

REQUIRED design changes
1. There must not be any merged cells that span column G. A merged cell

in

the column breaks the formula. Update the =INDEX formula for column H and
the same is true, no merged cells.
2. The formulas in the Match Average and Total Pins columns should

change.

Th

Re: Calc Help

2020-01-24 Thread WA.TWORSX via AOL

Ooops!

DNB=Did not Bowl.

I am presently troubleshooting why the result at cell AL7 (i.e.,
=INDEX($Sheet1.G6:G42,COUNTA($Sheet1.G6:G42),1) is not correct.

The difference between COUNT and COUNTA is yet to sink into this
author's gray matter.

On 1/24/2020 10:16 AM, WA.TWORSX via AOL wrote:

On 1/20/2020 5:58 PM, Alan B wrote:

I've found a method that can work, providing the spreadsheet design is
modified somewhat.
It comes from a formula provided by RusselB in the OpenOffice forums.

=index(range;count(range);1)

For your sample spreadsheet this formula in cell AL7
=INDEX($Sheet1.G6:G42,COUNTA($Sheet1.G6:G42),1)
will return the Match Series value for the last value entered. When
week#20

is completed the number in AL7 will update. When week#21 is completed it
will update again, and so on.

REQUIRED design changes
1. There must not be any merged cells that span column G. A merged
cell in
the column breaks the formula. Update the =INDEX formula for column H
and

the same is true, no merged cells.
2. The formulas in the Match Average and Total Pins columns should
change.

The IF test should be whether the tested cell contains a number, not
whether it is blank. This will prevent #value! errors being displayed in
those cells.
3. Last, any blank rows in a column must be BELOW the currently
completed

week number.

To meet design change #1 the "Did not bowl" in week 6 cannot be merged
cells. And to meet condition #3 they cannot be empty either. As an
alternative you could enter DNB in each cell in the row.

AlanB: What is meant by "DNB" ?

The row of merged cells that demark "half season" needs to change
because

of #1. If the row is deleted and the season half is indicated by a heavy
border between week 18 and 19, that would suffice.

This is the simplest solution I could find. More complex formulas
might be
possible that would meet your goal but I'm not familiar enough with
Calc to

readily conceive of them.

On Mon, Jan 20, 2020 at 1:31 PM Vince@GMAIL wrote:

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&rlkey=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 wi

Re: Calc Help

2020-01-24 Thread WA.TWORSX via AOL

On 1/20/2020 5:58 PM, Alan B wrote:

I've found a method that can work, providing the spreadsheet design is
modified somewhat.
It comes from a formula provided by RusselB in the OpenOffice forums.

=index(range;count(range);1)

For your sample spreadsheet this formula in cell AL7
=INDEX($Sheet1.G6:G42,COUNTA($Sheet1.G6:G42),1)
will return the Match Series value for the last value entered. When week#20
is completed the number in AL7 will update. When week#21 is completed it
will update again, and so on.

REQUIRED design changes
1. There must not be any merged cells that span column G. A merged cell in
the column breaks the formula. Update the =INDEX formula for column H and
the same is true, no merged cells.
2. The formulas in the Match Average and Total Pins columns should change.
The IF test should be whether the tested cell contains a number, not
whether it is blank. This will prevent #value! errors being displayed in
those cells.
3. Last, any blank rows in a column must be BELOW the currently completed
week number.

To meet design change #1 the "Did not bowl" in week 6 cannot be merged
cells. And to meet condition #3 they cannot be empty either. As an
alternative you could enter DNB in each cell in the row.

AlanB: What is meant by "DNB" ?

The row of merged cells that demark "half season" needs to change because
of #1. If the row is deleted and the season half is indicated by a heavy
border between week 18 and 19, that would suffice.

This is the simplest solution I could find. More complex formulas might be
possible that would meet your goal but I'm not familiar enough with Calc to
readily conceive of them.

On Mon, Jan 20, 2020 at 1:31 PM Vince@GMAIL wrote:

Hello Alan B:

TNX for reading my query about Calc Help-updating Data.ods.

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&rlkey=zeujgqduhbuo82jmxryylinvd
.

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. )

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

_/* */_Game #3_/* */_Match Series_/* */_Match Average_/*
*1* 6-Sep 152 146 187 485 161.7
*2* 13-Sep 133

Re: Calc Help

2020-01-22 Thread WA.TWORSX via AOL

Hi Alan:

I am trying to work my way through your suggestions. Changes to satisfy
Design Change Requirements #1 and #3 are not a problem.

However, Required Design Change #2 is problematic for me. :-[

I am not successful with IF-testing in the Match Average and Total Pins
columns to satisfy Required Design Change #2.

I have tried:

1. When I use =IF(G27>0;G27/3);"", the returned result is 0. (Not
acceptable.)
2. When I use =IF(D27>0;G27/3);"", cell H27 returns a blank
(acceptable??).

How is a cell's content IF-tested for a number? Is IFNUMBER() needed
here? If, yes, I will try using >0 within the parenthesis.

I inserted: =INDEX($Sheet1.G6:G42,COUNTA($Sheet1.G6:G42),1) into cell
AL7; am getting Error 508. Please verify the punctuation used in your
suggested formula; I am expecting to see semicolons. I have changed the
commas to semicolons, but that produces a blank cell in AL7, which does
not change after inputting additional scores in columns D, E, and F. I
am stumped. :-[

TNX for your inputs, Alan.

Regards,

VinceB.

On 1/20/2020 5:58 PM, Alan B wrote:

I've found a method that can work, providing the spreadsheet design is
modified somewhat.
It comes from a formula provided by RusselB in the OpenOffice forums.

=index(range;count(range);1)

To meet design change #1 the "Did not bowl" in week 6 cannot be merged
cells. And to meet condition #3 they cannot be empty either. As an
alternative you could enter DNB in each cell in the row.

The row of merged cells that demark "half season" needs to change because
of #1. If the row is deleted and the season half is indicated by a heavy
border between week 18 and 19, that would suffice.

This is the simplest solution I could find. More complex formulas might be
possible that would meet your goal but I'm not familiar enough with Calc to
readily conceive of them.

On Mon, Jan 20, 2020 at 1:31 PM Vince@GMAIL wrote:

Hello Alan B:

TNX for reading my query about Calc Help-updating Data.ods.

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&rlkey=zeujgqduhbuo82jmxryylinvd
.

(The _Match Series_ data for my teammates Russ, Dave, and Bob are being
poked manually into AL6, AL8, and AL9, weekly. )

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

Calc Help

2020-01-18 Thread WA.TWORSX via AOL


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.

DRAT! I'm Experiencing a Senior Moment

2019-07-22 Thread WA.TWORSX via AOL


AOO415m1(Build:9789) -?? Rev. 1817496
2017-12-11 17:25

Windows10-x64 Home, DELL desktop

_

And, it does not quit!

There had to be a point in time when I was able to do this; unless 
perhaps the original Excel sheet when converted over to AOO-Calc, the 
white background palette came with it ?? In any case, I now have 
forgotten how to do this.


I want to configure a Calc Sheet such that there are not grid lines and 
all rows and columns show as a palette that is a bright white background 
(i.e., not egg white) .


Please point me to the area that tells me how to accomplish my preferred 
Calc Sheet format. Is this setting related to Styles in Calc?


Within an existing Calc Sheet, I have added an additional sheet; it 
appears as I would like. But when I do: File > New > Spreadsheet, grid 
lines appear and the background is an egg-white color.


TNX.

VinceB.

Pasting Chart/Graph into eMail Client

2019-05-12 Thread WA.TWORSX via AOL


AOO415m1(Build:9789) -  Rev. 1817496
2017-12-11 17:25

and

ThunderBird 60.6.1

on Win20x64 Home edition desktop

_


I need help to paste chart/graph into my ThunderBird eMail client.  I am 
not certain if my problem is TB-related or is AOO-Calc related.


When I attempt to cut&paste a selected Calc chart into TB, the labels 
assigned to the chart are not being carried over.  Is there something 
that I must do to include the label attributes?


I have been printing the selected chart as a PDF file, and then 
attaching that to my outgoing email; is there a better way of doing this?


TNX.

VinceB.

Chart/Graphing Questions

2019-05-12 Thread WA.TWORSX via AOL


AOO415m1(Build:9789) -  Rev. 1817496
2017-12-11 17:25 ;  DELL desktop; Win10-64 Home edition



I think there is a way to accomplish my wish; I might have done it once 
before, but a long time ago.  I did not find any solutions in the Calc 
Guide Chap 3 documentation.


I have created an XY (Scatter) - Lines Only graph based on data 
contained in $G$6:$G$41. The existing graph has a Y-axis that shows 0 to 
700 (increments of 100) and an X-axis that shows 0 to 40 (increments of 
5).  My questions concern the Y-axis:


1. I want the Y-axis display to start at 300 (350 would be even better)
   and end at 700 (650 would be even better).
2. It would also be GREAT if the Y-axis is scaled in increments of say
   5, or 10, between 350 (start/minimum) and 650 (end/maximum).

If any of this is indeed possible, what must I do ?

___

My other questions are about editing/revising/correcting the labels 
assigned to a existing graph:


1. For example, if I made a typo in the Title of a graph, what must I
   do to correct the error, w/o creating the graph from scratch?
2. Or, if a Legend is included, how can it be removed?
3. Or, can I add a Subtitle to an existing graph?

_

TNX, and Happy Mother's Day to all the Moms out there.

VinceB.

Re: Force a Line Return in a Calc Cell

2019-04-15 Thread WA.TWORSX via AOL




TNX Dave.  Often I want to insert a line space within a Calc cell that 
contains text strings.



On 4/15/2019 3:33 AM, Dave AOO wrote:

The keyboard combination Ctrl+Enter will force a [CR&LF] break inside a
cell.

On 15.04.2019 08:00, Alan Pearce wrote:

I think you are  asking for is the "Wrap" function so that what you are typing is wrapped 
to the next line within a cell either when you reach the limit of the cell size or you press 
carriage return. I am not able to access OO at this moment but think you will find it somewhere in 
"Format/Cells".
 
Alan.


 Original message --------
From: "WA.TWORSX via AOL" 
Date: 14/04/2019  22:24  (GMT+00:00)
To: AOO Mail List 
Subject: Force a Line Return in a Calc Cell

AOO415m1(Build:9789)  -  Rev. 18174962017-12-11 17:25, 
CALC_DELL desktop PC, Windows10x64 
Home_Calc Users:What is the required keystroke 
combination to use for forcing a carriage-return-line feed (CR&LF) in a Calc 
cell?VinceB.-To 
unsubscribe, e-mail: users-unsubscribe@openoffice.apache.orgFor 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

Is Creation of an Additional Dictionary for Use in Calc & Writer Possible?

2019-04-14 Thread WA.TWORSX via AOL


AOO415m1(Build:9789) -  Rev. 1817496
2017-12-11 17:25

__

DELL desktop PC with Windows10x64 Home

__

AOO Users:

When running the spellcheck in Calc: a word is challenged as being 
mispelled; I am given the option to add that word to the standard 
dictionary by pressing the Add button. The down arrow that appears 
adjacent to the Add button implies that other dictionaries are 
possible/available.


How do I create a non-standard, additional spell check dictionary?  I 
would like to have a separate spell check dictionary for /technical 
terms. /Perhaps create a /Personal /spell check dictionary as well.


VinceB.





-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Force a Line Return in a Calc Cell

2019-04-14 Thread WA.TWORSX via AOL


AOO415m1(Build:9789)  -  Rev. 1817496
2017-12-11 17:25, CALC

_

DELL desktop PC, Windows10x64 Home

_

Calc Users:

What is the required keystroke combination to use for forcing a 
carriage-return-line feed (CR&LF) in a Calc cell?


VinceB.






-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Emergency Breaking a Selection Process in Calc

2019-04-14 Thread WA.TWORSX via AOL




AOO415m1(Build:9789) -  Rev. 1817496
2017-12-11 17:25

_

Windows10x64 Home on a desktop DELL PC

_

Calc Users:

Is there a keystroke combination or a method of stopping a runaway 
selection/highlight process in Calc?


Too often, when I attempt to make a relatively large selection of cells 
in Calc, e.g., larger than what is presently displayed on screen, the 
selection/highlighting process runs amuck.  It continues to scroll 
down/up, and I seem to lack any control to stop the 
selection/highlighting process.


Must I do the selection in smaller steps, i.e., select rows 10 through 
25 and then continue with 26 to 50, etc. ?


Help!


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Is the HLOOKUP Function Required Here?

2019-03-28 Thread WA.TWORSX via AOL


AOO415m1(Build:9789)  -  Rev. 1817496
2017-12-11 17:25

Windows 10x64 Home on desktop PC.



The Dropbox link written in my previious messages, apparently, is not 
allowing the message to pass through to this Mailing List, so I will 
attempt to present my problem without the actual Calc file.   If anyone 
could suggest a compatible storage site, I will then attempt to upload 
the actual Calc file to it.


_

Cells E54:T54 contain sequencial enumeration 1, 2, ...16 to accomodate 
data that correlates to up to 16 bowlers.


Cells E74 through T74 contain the bolwer's names.

Cells E76 through T76 contain the calculated bowler's average scores.

I have CALCulated the Bowler's Highest 15-Game Average data, which is 
stored in the cell range $E$76:$T$76. I want Calc to evaluate the 
numerical average value data; identify the name of the bowler whom has 
the Bowler's Highest 15-Game Average score, and:


1. display within cell $E$78 the name of the bowler that has the
   LARGEST value found within $E$76:$T$76; i.e., 189.83 found in cell
   M76 and correlation to cell M74.
2. display within cell $F$78 the name of the bowler that has the 2nd
   LARGEST value found within $E$76:$T$76; i.e., 180.50 found in cell
   E76 and correlation to cell E74.
3. display within cell $G$78 the name of the bowler that has the 3rd
   LARGEST value found within $E$76:$T$76; i.e., 168.67 found in cell
   P76 and correlation to cell P74.
4. display within cell $H$78 the name of the bowler that has the 4th
   LARGEST value found within $E$76:$T$76; i.e., 155.67 found in cell
   O76 and correlation to cell O74.
5. display within cell $I$78 the name of the bowler that has the 5th
   LARGEST value found within $E$76:$T$76; i.e., 149.33 found in cell
   $L$74 and correlation to cell L74.


In this example, cells $E76:$T$76 would yield: "SAM C."; "BOB M."; 
"WILLIE M."; "VINCE B."; and "RUSSEL P.".


I suspect that the HLOOKUP function would be needed to accomplish this 
task. ?? In the Help file, there is no example of using the HLOOKUP 
function, so I am uncertain about the relational row location as 
required by the HLOOKUP function.


I suppose that I should / will define and insert a NameBox Name for 
referencing the Bowler's Highest 15-Game Average data that is contained 
within cells $E$76:$T$76.


Regards,

VinceB.



  ROW 54


Player #:   1   2   3   4   5   6   7   
8   9   10  11  12  13  14  15  16

Is the HLOOKUP Function Required Here?

2019-03-27 Thread WA.TWORSX via AOL

The message below has not yet gone through the verizon/AOL servers.

Is there a known reason for a delay? Is this Mailing List compatible
with Dropbox links? Must such messages be sent via plain text?

AOO415m1(Build:9789) - Rev. 1817496
2017-12-11 17:25

Windows 10x64 Home on desktop PC.

This Dropbox link gives access to an AOO Calc file, with which I am
having a frustrating problem:

https://www.dropbox.com/s/ys2gppp7maiwelp/%23DIV%20by%200%21%20Problem%20in%20Calc.ods?dl=0

(I hope I have the Calc file correctly marked as viewable by any others;
I have very little experience using Dropbox files viewable by others.)

With reference to cell range $E$76:$T$76 (Bowler's Highest 15-Game
Average data), I want Calc to examine the numerical values and identify
which Bowler's Highest 15-Game Average score is the LARGEST value:

1. display within cell $E$78 the name of the bowler that has the
LARGEST value found within $E$76:$T$76; i.e., 189.83 found in cell
M76 and correlation to cell M74.
2. display within cell $F$78 the name of the bowler that has the 2nd
LARGEST value found within $E$76:$T$76; i.e., 180.50 found in cell
E76 and correlation to cell E74.
3. display within cell $G$78 the name of the bowler that has the 3rd
LARGEST value found within $E$76:$T$76; i.e., 168.67 found in cell
P76 and correlation to cell P74.
4. display within cell $H$78 the name of the bowler that has the 4th
LARGEST value found within $E$76:$T$76; i.e., 155.67 found in cell
O76 and correlation to cell O74.
5. display within cell $I$78 the name of the bowler that has the 5th
LARGEST value found within $E$76:$T$76; i.e., 149.33 found in cell
and correlation to cell L74.

In this example, cells $E76:$T$76 would yield: "SAM C."; "BOB M.";
"WILLIE M."; "VINCE B."; and "RUSSEL P.".

I suspect that the HLOOKUP function would be needed to accomplish this
task. ?? In the Help file, there is no example of using the HLOOKUP
function, and I am uncertain about the relational row location as
required by the HLOOKUP function.

I suppose that I should / will define and insert a NameBox Name for
referencing the Bowler's Highest 15-Game Average data that is contained
within cells $E$76:$T$76.

Regards,

VinceB.

-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Is the HLOOKUP Function Required Here?

2019-03-27 Thread WA.TWORSX via AOL

AOO415m1(Build:9789) - Rev. 1817496
2017-12-11 17:25

Windows 10x64 Home on desktop PC.

This Dropbox link gives access to an AOO Calc file, with which I am
having a frustrating problem:

https://www.dropbox.com/s/ys2gppp7maiwelp/%23DIV%20by%200%21%20Problem%20in%20Calc.ods?dl=0

(I hope I have the Calc file correctly marked as viewable by any others;
I have very little experience using Dropbox files viewable by others.)

In this example, cells $E76:$T$76 would yield: "SAM C."; "BOB M.";
"WILLIE M."; "VINCE B."; and "RUSSEL P.".

I suppose that I should / will define and insert a NameBox Name for
referencing the Bowler's Highest 15-Game Average data that is contained
within cells $E$76:$T$76.

Regards,

VinceB.

On 3/27/2019 4:33 PM, WA.TWORSX via AOL wrote:
Please ignore the filename as written to the Dropbox server; I
resolved the #DIV/0! issue myself, but I did not edit the filename.

On 3/27/2019 4:07 PM, WA.TWORSX via AOL wrote:

AOO415m1(Build:9789) - Rev. 1817496
2017-12-11 17:25

Windows 10x64 Home on desktop PC.

With reference to cell range $E$76:$T$76 (Bowler's Highest 15-Game
Average data), I want Calc to examine the numerical values and
identify which Bowler's Highest 15-Game Average score is the LARGEST
value:

In 5. above, it should read as:

"display within cell $I$78 the name of the bowler that has the 5th
LARGEST value found within $E$76:$T$76; i.e., 149.33 found in *cell
L76* and correlation to cell L74."

Re: Is the HLOOKUP Function Required Here?

2019-03-27 Thread WA.TWORSX via AOL

Please ignore the filename as written to the Dropbox server; I resolved 
the #DIV/0! issue myself, but I did not edit the filename.


On 3/27/2019 4:07 PM, WA.TWORSX via AOL wrote:


AOO415m1(Build:9789)  -  Rev. 1817496
2017-12-11 17:25

Windows 10x64 Home on desktop PC.




With reference to cell range $E$76:$T$76 (Bowler's Highest 15-Game 
Average data), I want Calc to examine the numerical values and 
identify which Bowler's Highest 15-Game Average score is the LARGEST 
value:


 1. display within cell $E$78 the name of the bowler that has the
LARGEST value found within $E$76:$T$76; i.e., 189.83 found in cell
M76 and correlation to cell M74.
 2. display within cell $F$78 the name of the bowler that has the 2nd
LARGEST value found within $E$76:$T$76; i.e., 180.50 found in cell
E76 and correlation to cell E74.
 3. display within cell $G$78 the name of the bowler that has the 3rd
LARGEST value found within $E$76:$T$76; i.e., 168.67 found in cell
P76 and correlation to cell P74.
 4. display within cell $H$78 the name of the bowler that has the 4th
LARGEST value found within $E$76:$T$76; i.e., 155.67 found in cell
O76 and correlation to cell O74.
 5. display within cell $I$78 the name of the bowler that has the 5th
LARGEST value found within $E$76:$T$76; i.e., 149.33 found in cell
and correlation to cell L74.


In 5. above, it should read as:


"display within cell $I$78 the name of the bowler that has the 5th 
LARGEST value found within $E$76:$T$76; i.e., 149.33 found in *cell L76* 
and correlation to cell L74."

Is the HLOOKUP Function Required Here?

2019-03-27 Thread WA.TWORSX via AOL

AOO415m1(Build:9789) - Rev. 1817496
2017-12-11 17:25

Windows 10x64 Home on desktop PC.

This Dropbox link gives access to an AOO Calc file, with which I am
having a frustrating problem:

https://www.dropbox.com/s/ys2gppp7maiwelp/%23DIV%20by%200%21%20Problem%20in%20Calc.ods?dl=0

(I hope I have the Calc file correctly marked as viewable by any others;
I have very little experience using Dropbox files viewable by others.)

In this example, cells $E76:$T$76 would yield: "SAM C."; "BOB M.";
"WILLIE M."; "VINCE B."; and "RUSSEL P.".

I suppose that I should / will define and insert a NameBox Name for
referencing the Bowler's Highest 15-Game Average data that is contained
within cells $E$76:$T$76.

Regards,

VinceB.

Re: Need to Edit the name Box definitions

2019-03-22 Thread WA.TWORSX via AOL






I do wish, however, that there was a "More" or "Continue" button 
available, rather than needing to go back to step one. I had to 
change the Named Ranges for 13 columns that were shifted in the 
spreadsheet.


That's easy, and there is no need for an extra button: just repeat 
steps two, three, and four - Select, Drag, and Modify - as necessary, 
before using OK once.


Brian Barker





I was not able to do that earlier, perhaps due to severally needing to 
recover the file.


I will try again, using a PLAY-spreadsheet.



-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

This file contains links ?

2019-03-22 Thread WA.TWORSX via AOL


AOO415m1(Build:9789) -  Rev. 1817496
2017-12-11 17:25 windows 10 x64 Home

_


Upon opening a Calc spreadsheet, I am sometimes getting a prompt asking 
if I want to update "links" that are contained inside the file referring 
to other files.


I do not know what that is referring to??? so, I always reply No and 
then continue on.


What "links" are there possibly within the spreadsheet file?  I am not 
aware of any link to an external file.


VinceB.




-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Need to Edit the name Box definitions

2019-03-21 Thread WA.TWORSX via AOL




On 3/19/2019 10:00 PM, Brian Barker wrote:

At 20:48 19/03/2019 -0400, Vince Bonly wrote:
I have an AOO-Calc spreadsheet that has several "name box" 
definitions, which I must revise or redefine the defined range. I 
have forgotten how to define and / or edit the contents of the name 
box definitions. And, I could not find info about "name box" in the 
Help (F1) file. What I mean as the "name box" is the entry line with 
a down arrow that is located to the left of the input line. This is 
the area that shows the cell identification when a cell is 
selected/highlighted. In other words, if I were to select the C60 
cell in my spreadsheet, then C60 shows up in the name box area. If I 
position the mouse cursor in this area, "Name Box" appears on screen.


Yes, that drop-down menu box is called the Name Box, but the names 
themselves are called just "names".


To define a name for a cell range:
o Select the range.
o Go to Insert | Names > | Define... .
o Enter a name.
o OK.



To delete a name:
o Go to Insert | Names > | Define... .
o Select the name.
o Delete.
o Yes.
o OK.

To modify the definition of a name:
o Go to Insert | Names > | Define... .
o Select the existing name.
o Drag across the new range.
o Modify.
o OK.

Would liked to have had a "More" or "Continue" button here instead of 
clicking OK, etc.



You could always modify any definition by deleting the existing one 
and creating a new one in the same name, of course.


I trust this helps.

Brian Barker


Brian:

Just to let you know that your suggestions / instructions workedout 
splendidily here, and to say TNX again. Certainly was helpful. I do 
wish, however, that there was a "More" or "Continue" button available, 
rather than needing to go back to step one.  I had to change the Named 
Ranges for 13 columns that were shifted in the spreadsheet.


Regards,

VinceB.



-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Need to Edit the name Box definitions

2019-03-20 Thread WA.TWORSX via AOL

TNX a bunch Brian.  I will give that a try as I am about to update my 
BVL Bowling Tournament spreadsheet for this year's competition.



On 3/19/2019 10:00 PM, Brian Barker wrote:

At 20:48 19/03/2019 -0400, Vince Bonly wrote:
I have an AOO-Calc spreadsheet that has several "name box" 
definitions, which I must revise or redefine the defined range. I 
have forgotten how to define and / or edit the contents of the name 
box definitions. And, I could not find info about "name box" in the 
Help (F1) file. What I mean as the "name box" is the entry line with 
a down arrow that is located to the left of the input line. This is 
the area that shows the cell identification when a cell is 
selected/highlighted. In other words, if I were to select the C60 
cell in my spreadsheet, then C60 shows up in the name box area. If I 
position the mouse cursor in this area, "Name Box" appears on screen.


Yes, that drop-down menu box is called the Name Box, but the names 
themselves are called just "names".


To define a name for a cell range:
o Select the range.
o Go to Insert | Names > | Define... .
o Enter a name.
o OK.

To delete a name:
o Go to Insert | Names > | Define... .
o Select the name.
o Delete.
o Yes.
o OK.

To modify the definition of a name:
o Go to Insert | Names > | Define... .
o Select the existing name.
o Drag across the new range.
o Modify.
o OK.

You could always modify any definition by deleting the existing one 
and creating a new one in the same name, of course.


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

Need to Edit the name Box definitions

2019-03-19 Thread WA.TWORSX via AOL


AOO415m1(Build:9789) -  Rev. 1817496
2017-12-11 17:25

Windows 10-x64 Home, DELL desktop.

_


I have an AOO-Calc spreadsheet that has several "name box" definitions, 
which I must revise or redefine the defined range.  I have forgotten how 
to define and / or edit the contents of the name box definitions.  And, 
I could not find info about "name box" in the Help (F1) file.


What I mean as the "name box" is the entry line with a down arrow that 
is located to the left of the input line. This is the area that shows 
the cell identification when a cell is selected/highlighted. In 
otherwords, if I were to select the C60 cell in my spreadsheet, then C60 
shows up in the name box area. If I position the mouse cursor in this 
area, "Name Box" appears on screen.


Please help.

Regards,

VinceB.

Re: Is there a way to change the assigned attributes when using Find & Replace function in AOO-Calc Spreadsheets?

2019-03-14 Thread WA.TWORSX via AOL



Hi David:

I do not think you understand what I am attempting to do, so I'll try to 
clarify what my goal is.


In my spreadsheet cells I have typed a word, e.g., Goes,many times.  I 
meant to type that word in Bold font.  Is there a way to change the 
already typed word (e.g., Goes) to be in bold font by use of the Find & 
Replace function?


I am not attempting to highlight an area within the spreadsheet.  I do 
not program in vbs, or any other language for that matter. :-) Years 
ago, I started to learn machine language for the Motorola 6809E chip, 
but have not ever put what I learned to use.


TNX for your reply.


VinceB.



On 3/14/2019 11:54 AM, David Belina wrote:

The way the data is displayed in any spreadsheet is determined by the 
formatting which is linked to cell/row/column and not the particular data.  The 
search and replace function searches the data not the format.

You might be able to write a script (in excel you do this in vbs (visual basic) 
but I’m not sure in OO.

The question is what you want to highlight.  If it is a summary or other 
function you eventually want to arrive at - you can just format the last result 
cell.


On March 14, 2019 at 9:24:27 AM, WA.TWORSX via AOL 
(wa.two...@verizon.net.invalid) wrote:


AOO415m1(Build:9789)  -  Rev. 1817496
2017-12-11 17:25

Desktop Windows 10-64 Home





I am trying to change the attributes on data that exists within an AOO
Calc cell when using the Find & Replace function. For example, if the
cell presently shows:

     Goes

I want it to be replaced with:

*    Goes*

That is, add the *bold* attribute to the existing data.

In the Find & Replace dialogue window, I have selected:  Fewer Options,
with none of the boxes checked.  I have also selected: Search in:
"Values" (near the bottom of that window).
**

Is there a way to change / replace the assigned attributes when using
Find & Replace function in AOO-Calc Spreadsheets?

Regards,

VinceB.

Is there a way to change the assigned attributes when using Find & Replace function in AOO-Calc Spreadsheets?

2019-03-14 Thread WA.TWORSX via AOL



AOO415m1(Build:9789)  -  Rev. 1817496
2017-12-11 17:25

Desktop Windows 10-64 Home





I am trying to change the attributes on data that exists within an AOO 
Calc cell when using the Find & Replace function. For example, if the 
cell presently shows:


    Goes

I want it to be replaced with:

*    Goes*

That is, add the *bold* attribute to the existing data.

In the Find & Replace dialogue window, I have selected:  Fewer Options, 
with none of the boxes checked.  I have also selected: Search in: 
"Values" (near the bottom of that window).

**

Is there a way to change / replace the assigned attributes when using 
Find & Replace function in AOO-Calc Spreadsheets?


Regards,

VinceB.

Re: Show All Comments

2019-02-18 Thread WA.TWORSX via AOL

Yes, I am aware of that, but I am wondering if /_all comments_/ that 
exist for a sheet can be toggled on / off ?



On 2/18/2019 11:54 AM, Alan Pearce wrote:

Right click in cell and providing there is a comment in the cell you will be offered 
"Show Comments"
 
Alan.


 Original message ----
From: "WA.TWORSX via AOL" 
Date: 18/02/2019  16:36  (GMT+00:00)
To: AOO Mail List 
Subject: Show All Comments

Hi Group:AOO Calc on Windows 10-64bit Home desktop.I am working in a 
spreadsheet template, and would like to have all comments displayed on screen.I 
think there is a method to show all written comments in AOO-Calc sheet.  If 
yes, Is there a way to toggle it 
off/on?VinceB.-To
 unsubscribe, e-mail: users-unsubscribe@openoffice.apache.orgFor additional 
commands, e-mail: users-h...@openoffice.apache.org

Understanding Templates Update

2019-02-18 Thread WA.TWORSX via AOL




AOO Calc 4.1.5 on Windows 10-64 bit Home desktop.

Occasionally, I am shown a prompt to use an updated template.  I do not 
recall the exact wording of the prompt. Also, I am unclear about what is 
actually being updated: the Calc sheet .ods file or the Calc template 
.ots file?


Can anyone discuss template updating here, so that I might better 
understand things? At this point I am afraid to accept an update  at 
this prompt.


Regards,

VinceB.




-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Show All Comments

2019-02-18 Thread WA.TWORSX via AOL


Hi Group:

AOO Calc on Windows 10-64bit Home desktop.

I am working in a spreadsheet template, and would like to have all 
comments displayed on screen.


I think there is a method to show all written comments in AOO-Calc 
sheet.  If yes, Is there a way to toggle it off/on?


VinceB.



-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Calc lentissimo

2019-01-30 Thread WA.TWORSX via AOL




On 1/30/2019 9:24 AM, Flavio Burlando wrote:
Buongiorno stï¿œ usando il vostro programma versione 4.1.6 con sistema 
operativo Windows 10 ma quando devo aprire un documento calc con 
macro, impiega svariati minuti. Esiste un modo per velocizzare la cosa?


Grazie Flavio




Google translation:

Hello, I'm using your program version 4.1.6 with Windows 10 operating 
system but when I have to open a calc document with macro, it takes 
several minutes. Is there a way to speed things up?


Thanks Flavio


__

Please try this to ask your questions: utenti...@openoffice.apache.org 
(Italian users mailing list)


Flavio:
Si prega di provare questo per fare le vostre domande:
utenti...@openoffice.apache.org (mailing list degli utenti italiani)






-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: How to View Two Calc Sheets on Two Monitor Screens

2019-01-12 Thread WA.TWORSX via AOL



On 1/12/2019 5:06 PM, WA.TWORSX via AOL wrote:



On 1/12/2019 2:15 PM, Regina Henschel wrote:

Hi VinceB,


WA.TWORSX via AOL schrieb am 12-Jan-19 um 19:52:

AOO415m1(Build:9789) -  Rev. 1817496
2017-12-11 17:25

Win10x64 Home

___

I am working on an AOO Calc file that contains 3 sheets (tabs). I 
want to view the contents of sheets 1 and 2 _at the same time_ so 
that I may compare each to the other, and make necessary changes.


I have two screen monitors connected.

How should I go about doing this? I seem to recall that there is a 
way to scroll two screens at the same time, and I think that would 
be great, if I can do it.


Open the Calc file.
Use menu Window, item New Window. That generates a second view on the 
same document. It is a separate window from point of operating 
system. You can drag it to where you want, e.g. to the other monitor, 
in case you have set your OS to extend the desktop to two monitors.


Kind regards
Regina



Hi Regina:

Thank you!  Your method worked, and was surprisingly easy for me to do.

The file that is displayed inside the second window shows as: 
"filename :2 OpenOffice Calc". The edits that I do in one window's 
displayed file are immediately replicated in the other window's 
displayed file.  AWESOME !


Scrolling in one window's displayed file is independent of the other 
window's displayed file.  I can live with that.


Thank you again.

Regards,

VinceB.

How to View Two Calc Sheets on Two Monitor Screens

2019-01-12 Thread WA.TWORSX via AOL


AOO415m1(Build:9789) -  Rev. 1817496
2017-12-11 17:25

Win10x64 Home

___

I am working on an AOO Calc file that contains 3 sheets (tabs). I want 
to view the contents of sheets 1 and 2 _at the same time_ so that I may 
compare each to the other, and make necessary changes.


I have two screen monitors connected.

How should I go about doing this? I seem to recall that there is a way 
to scroll two screens at the same time, and I think that would be great, 
if I can do it.


TNX.

Regards,

VinceB.

Re: No Selection Possible in AOO Calc

2019-01-06 Thread WA.TWORSX via AOL

Never Mind.  I went and tried to open a different Calc file, and AOO 
went into its recovery routine.  I was able to reconstruct w/o too much 
work. Things are back to normal now.



On 1/6/2019 1:59 PM, WA.TWORSX via AOL wrote:


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.

No Selection Possible in AOO Calc

2019-01-06 Thread WA.TWORSX via AOL



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.

Re: download problem

2019-01-05 Thread WA.TWORSX via AOL


Hi Ted:

In addition to what others have suggested, you should check that your OS 
has the Brother printer identified as the "default" printer.


Regards,

VinceB.


On 1/5/2019 11:16 AM, Ted P Betley wrote:

Since I have downloaded 4.1.6 I can not get to my BROTHER printer. It is my 
default printer. I have checked with brother support twice as to why I can not 
print from a spreadsheet to the BROTHER printer it goes a HP printer that is 
not turned on. The Brother printer tested ok and will print the test page ok. I 
need this printer as it is a laser and I only use the HP for color work because 
the cost of the ink cartridges.
Please advise as how to correct this problem ASAP.

Ted Betley
260-205-3203


Sent from Mail for Windows 10




-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Hyperlinks

2018-09-23 Thread WA.TWORSX via AOL

I am now having a new difficulty: deletion of a hyperlink button in Calc
cell.

I confess, this is a problem outside of AOO as well. I simply do not
know how to delete (what I think is HTML for) an image object.

Help, please.

VinceB.

On 9/23/2018 12:29 PM, WA.TWORSX via AOL wrote:

On 9/22/2018 12:18 PM, Brian Barker wrote:

At 12:02 22/09/2018 -0400, Vince Bonly wrote:
AOO 4.1.5 on desktop WIN10-64. I am trying to insert a hyperlink in
Calc spreadsheet. I want to open up a PDF/document file or to
display an image file from my local hard drive while working on a
Calc spreadsheet file. The Help file says to select
Format->Character->Hyperlink tab; but "Character" is greyed out.

What am I doing wrong?

Not much.

o Format | Character... is greyed out if you select a cell or range
of cells. To enable it, you have to have the text (or part of it)
within the cell(s) selected. Click enough times for this to be the
case. But it has no Hyperlink tab.

o The functionality you require seems to have been moved since the
help text was written. You will find it at Insert | Hyperlink. Or you
can use the Hyperlink toolbar; see View | Toolbars > | Hyperlink bar.

I trust this helps.

Brian Barker

Hi Brian:

Yes, I was successful in using the View | Toolbars> | Hyperlink bar.
TNX.
I have many Calc files in which I will want to add hyperlinks to
locally stored document files on C:/ drive, (or perhaps located on a
CD-ROM or USB thumb drive), if that is also possible.

I did not get anywhere with Format | Character, for unknown reason,
remains grayed out. I am not clear on your instruction to enable it
(Character). Do you mean that I must already have a full URL within
the selected cell? For me, my fingers are challenged when typing, e.g., :
file:///C:/Users/username/Documents/My%20Bowling/League%20Bowling/2018-19%20FRI%20Senior%20League%20Roster.pdf.

When selecting As Button under the Hyperlink icon on the Hyperlink
Bar, at first attempt (yesterday) I was not getting any response by
clicking on the button; I saw controls for resizing an object image.
But it is now working as expected. :-)

Ciao!
VinceB.

-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Hyperlinks

2018-09-23 Thread WA.TWORSX via AOL

On 9/22/2018 12:18 PM, Brian Barker wrote:

At 12:02 22/09/2018 -0400, Vince Bonly wrote:
AOO 4.1.5 on desktop WIN10-64. I am trying to insert a hyperlink in
Calc spreadsheet. I want to open up a PDF/document file or to display
an image file from my local hard drive while working on a Calc
spreadsheet file. The Help file says to select
Format->Character->Hyperlink tab; but "Character" is greyed out.

What am I doing wrong?

Not much.

o Format | Character... is greyed out if you select a cell or range of
cells. To enable it, you have to have the text (or part of it) within
the cell(s) selected. Click enough times for this to be the case. But
it has no Hyperlink tab.

I trust this helps.

Brian Barker

Hi Brian:

Yes, I was successful in using the View | Toolbars> | Hyperlink bar. TNX.
I have many Calc files in which I will want to add hyperlinks to locally
stored document files on C:/ drive, (or perhaps located on a CD-ROM or
USB thumb drive), if that is also possible.

I did not get anywhere with Format | Character, for unknown reason,
remains grayed out. I am not clear on your instruction to enable it
(Character). Do you mean that I must already have a full URL within the
selected cell? For me, my fingers are challenged when typing, e.g., :
file:///C:/Users/username/Documents/My%20Bowling/League%20Bowling/2018-19%20FRI%20Senior%20League%20Roster.pdf.

When selecting As Button under the Hyperlink icon on the Hyperlink Bar,
at first attempt (yesterday) I was not getting any response by clicking
on the button; I saw controls for resizing an object image. But it is
now working as expected. :-)

Ciao!
VinceB.

-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Hyperlinks

2018-09-22 Thread WA.TWORSX via AOL


AOO 4.1.5 on desktop WIN10-64.

I am trying to insert a hyperlink in Calc spreadsheet. I want to open up 
a PDF/document file or to display an image file from my local hard drive 
while working on a Calc spreadsheet file.


The Help file says to select Format->Character->Hyperlink tab; but 
"Character" is greyed out.


What am I doing wrong?

Regards,

VinceB.

Re: Method to select multiple columns:rows in Calc

2018-09-12 Thread WA.TWORSX via AOL





On 9/11/2018 7:09 PM, Brian Barker wrote:

At 15:32 11/09/2018 -0400, Vince Bonly wrote:
I have a Calc sheet in which unwanted background fill color is 
displayed. The range begins B1307 and C1307 and seems to go 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?


At 15:41 11/09/2018 -0400, Vince Bonly wrote:
I have data within the above cells in which the background color is 
desired. Is there a jump-to keystroke that gets me to the very last row?


Three techniques:

1.
o Highlight B1307.
o Press Ctrl+Shift+End.

This will select the region from B1307 to the bottom right *occupied* 
cell of your sheet. If that selects only columns B and C you can now 
remove the background. If there is material in later columns, hold 
down Shift and press left-arrow repeatedly to reduce the selection to 
columns B and C. Now remove the background.


*But*, you will scream, that doesn't get to the bottom, only to the 
lowest used part of the sheet. But that doesn't matter, as when you 
print the material nothing below that last used part will print 
(unless you have perversely set a print range to make it print). So 
the remaining cells with background are no problem.


2.
Alternatively, in the Name Box (to the left of the Input Line), enter:
B1307:C1048576
and press Enter. You now have the required range selected. Remove the 
background.


3.
Depending on what backgrounds you have in earlier rows that you do 
want, it might be easier to remove the background from the whole of 
columns B and C and reset it in those cells or ranges where you 
require it.


I trust this helps.

Brian Barker




Thank you, Brian.

Method 1. indeed did not get to the bottom.
Method 2. Worked splendidly !
Method 3. Was obvious to me, but I wanted to avoid resetting the 
filled-in cells above the target range of cells.


Regards.
VinceB.



-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Method to select multiple columns:rows in Calc

2018-09-11 Thread WA.TWORSX via AOL





On 9/11/2018 3:36 PM, Wade Smart wrote:

On Tue, Sep 11, 2018 at 2:35 PM Vince@GMAIL  wrote:


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.

How about just click the Column B and C at the top?



No; I have data within the above cells in which the background color is 
desired.


Is there a jump-to keystroke that gets me to the very last row?




-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Listing of Already Named Filters

2018-08-15 Thread WA.TWORSX via AOL


TBird 52.9.1 (32 bit), Mail List user only.

Win10x64 desktop

__


Is there a way to display a listing of all filters in TB?


I have experienced at times that an email filter does not appear to be 
working for a specific correspondent(s). I think there must/should be a 
way to simply add the email address to an existing filter and/or edit 
the appropriate existing filter, but cannot locate it by an assigned name.


Any help or hints are appreciated.  TnX.


VinceB.



-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Sorting and column labels [was: Alternate Row Shading]

2018-06-01 Thread WA.TWORSX via AOL




On 6/1/2018 11:41 AM, Brian Barker wrote:



[...]

Yup. On the Options tab of the Sort dialogue, you will see "Range 
contains column labels". If this is ticked, the top row of the block 
of values (for sorting rows, or leftmost column for sorting columns) 
will be teated as labels - in other words names for the columns (or 
rows) of actual data - rather than part of the data themselves. In 
your case, the G and the L are being treated as labels for columns B 
and C. Remove the tick and you will get what you want.


Note that Calc appears to set this option intelligently - perhaps 
assuming that text values - your G and L - are likely to be labels. I 
find it is always necessary to check this option before clicking OK to 
carry out the sort process. I suppose the proper way to do things is 
first to give all your columns labels in the preceding row and then 
always to include that label row in the range you sort. Calc should 
make the appropriate decision to tick that option and everything will 
be hunky-dory.


I trust this helps.

Brian Barker

Thanks to Russ and to you, Brian, I believe that I have learned the 
lesson about the status of the Options tab's "Range contains column 
la_b_els" box.


I just happen to use alpha characters within my previously pasted 
example; they were not meant to be "labels" or "headers".


I have just tested what CALC does when the topmost row contains an alpha 
character vs contains a numerical character  CALC senses if the 
topmost data is indeed alpha or numeric; and if numeric, the Options 
tab's "Range contains column la_b_els" box is, initially,  unchecked.  
Therefore, I think when doing a sort routine it is not necessary to 
check the status of that box if the topmost row's data is not numerical 
character(s).


Of course, if/whenever I forget to check the status in the future, the 
resultant sorted data is rather easy to recognize as being incorrectly 
sorted. In those instances, I should then recall that the state of the 
"Range contains column la_b_els" box needs to be validated.



VinceB.

Re; Sorting and Column Labels [WAS: Re: Alternate Row Shading]

2018-06-01 Thread WA.TWORSX via AOL





On 6/1/2018 11:26 AM, Russell Munk wrote:


WA.TWORSX via AOL wrote on 6/1/2018 9:00 AM:

[...]
Thee remains a problem, however.  When attempting to sort with 
extended selection data contained within B2:C14:

G L
A L
C O
D F
F N
L S
N V
O A
Q S
S Q
S W
V X
W D


the data within B2;C2 is not being included during the sorting 
execution.  I have seen this happen previously (shading not 
involved).  Any ideas on this?


Regards,
VinceB.
[...]

It sounds like row 2 is being treated as a header. So in the Sort dialog
on the Options tab be sure 'Range contains column labels' is unchecked.
- Russ


TNX Russ for drawing my attention to the Sort dialog Options tab.

-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Alternate Row Shading

2018-06-01 Thread WA.TWORSX via AOL



Go figure: If I copy/paste empty cells from CALC into my email client 
(Mozilla Thunderbird), it is removed; but if data is present within the 
cells, that is not removed?

Re: Alternate Row Shading

2018-06-01 Thread WA.TWORSX via AOL




On 5/31/2018 1:06 PM, Brian Barker wrote:

At 12:32 31/05/2018 -0400, Vince Bonly wrote:
I find that often the template files available from 
https://www.vertex42.com/ make use of alternate row shading, and I 
would like to also. Example (copied from a CALC spreadsheet):


If you included an image here, it will have been removed by the 
mailing list processor before your message was delivered. But I'm sure 
readers will understand what you mean.


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 accomplish this?


o Click the rectangle at top left where the row and column headers 
meet (or go to Edit | Select All, or press Ctrl+A) to select the 
entire sheet (or as appropriate).

o Go to Format | Conditional Formatting... .
o For Condition 1, select "Formula is".
o In the box, enter MOD(ROW();2) .
o Click New Style... .
o On the Organiser tab, against Name, enter your new style's name - 
perhaps "Shading" or "Pink"?

o On the Background tab, choose your background colour.
o OK.
o OK.

This gives shading on odd rows. If you want even rows shaded, change 
the formula to MOD(ROW();2)-1 . By ticking Condition 2 and adding 
another cell style, you can arrange to have both odd and even rows 
shaded but differently.


Implementing alternate row shading in my spreadsheets might lead to 
some difficulties, since I often use a sorting routine.


Sorting data should not disturb this shading technique.

I trust this helps.

Brian Barker



TNX again Brian; your suggestion worked perfectly.
I thought for a moment that my question was improperly phrased, as I 
want the alternate row shading NOT done to an entire sheet. So, your 
"(or as appropriate)" gave me confidence to enter the formula into 
B3:G15. Worked like a charm!


Thee remains a problem, however.  When attempting to sort with extended 
selection data contained within B2:C14:

G   L
A   L
C   O
D   F
F   N
L   S
N   V
O   A
Q   S
S   Q
S   W
V   X
W   D


the data within B2;C2 is not being included during the sorting 
execution.  I have seen this happen previously (shading not involved).  
Any ideas on this?


Regards,
VinceB.

P.S. My pasting of B2:C14 data above might not appear? So I first pasted 
the data into Notepad and then copied from Notepad to paste it below:


G    L
A    L
C    O
D    F
F    N
L    S
N    V
O    A
Q    S
S    Q
S    W
V    X
W    D

Please note that "G" and "L" (present within B2;C2) are not being 
included by the sorting routine for some reason. Is this a known issue?

Re: Alternate Row Shading

2018-05-31 Thread WA.TWORSX via AOL



Please, Goto: 
https://www.vertex42.com/ExcelTemplates/asset-tracking-software.html to 
be able to see an example of alternate row shading.



On 5/31/2018 12:32 PM, WA.TWORSX via AOL wrote:

AOO415m1(Build:9789) -  Rev. 1817496
2017-12-11 17:25

WIN10-64 Desktop

___

I find that often the template files available 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 
accomplish this?




Implementing alternate row shading in my spreadsheets might lead to 
some difficulties, since I often use a sorting routine.  I will 
address that issue at a later time.


Regards,

VinceB.

Alternate Row Shading

2018-05-31 Thread WA.TWORSX via AOL


AOO415m1(Build:9789)  -  Rev. 1817496
2017-12-11 17:25

WIN10-64 Desktop

___

I find that often the template files available 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 
accomplish this?




Implementing alternate row shading in my 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: Need Formula to use with Results of LARGE( ) Function's Result- Lookup?

2018-03-15 Thread WA.TWORSX via AOL




On 3/15/2018 11:21 AM, WA.TWORSX via AOL wrote:

Martin:

Thank you for your reply/comments.  I understand and do appreciate 
your frustration; especially since there are many absolute ($A$1)) 
references are, and must be, used.


I am aware that there are possibilities that two, or more, bowlers may 
have the same numerical game score.  I am a beginner at this, and I 
try to chew one part of the problem at a time.  My plan is to apply 
other criterion to handle duplicate/triplicate numerical scores; 
perhaps the bowlers' total pin fall or the frequency of his/her name 
appearing within the ordered pair of bowling game score and correlated 
bowlers' name, will serve as the tie breaker when identifying the team 
roster. This will require additional thinking on my part.


FYI:    OKay; here is a wider view of this "project" (please forgive 
me BrianB.):


Each Feb and Mar, a number of Veterans Administration facilities 
around the USA participate in what is called the BVL Annual Bowling 
Tournament (see 
http://www.bowlforveterans.org/annual-bvlva-bowling-tournament-set-march/ 
and 
http://www.bowlforveterans.org/bvl-programs/bvlva-annual-veterans-bowling-tournament/tournament-score-sheet/). 
I am one of several bowlers that are representing the VA Medical 
Center at Northport, NY. Ultimately, the topmost 45 bowling scores 
from a five man team(s) that represents the Northport NY VAMC will be 
summed. The result of that summation shall be submitted, via an online 
score, sheet to the tournament administrators.  If/when a team places 
1st, 2nd, or 3rd, nationally, an award is given to each member of the 
five-man team.


Regards,

VinceB.


For sake of accuracy, the next to last sentenced in my last paragraph above
The result of that summation shall be submitted, via an online score, 
sheet to the tournament administrators. 

should be changed to read as follows:
The official summation is accomplished by the BVL administrators by 
using the data that is provided by the Northport VAMC staff via the 
available online score sheet.




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

2018-03-15 Thread WA.TWORSX via AOL

Martin:

Thank you for your reply/comments. I understand and do appreciate your
frustration; especially since there are many absolute ($A$1)) references
are, and must be, used.

I am aware that there are possibilities that two, or more, bowlers may
have the same numerical game score. I am a beginner at this, and I try
to chew one part of the problem at a time. My plan is to apply other
criterion to handle duplicate/triplicate numerical scores; perhaps the
bowlers' total pin fall or the frequency of his/her name appearing
within the ordered pair of bowling game score and correlated bowlers'
name, will serve as the tie breaker when identifying the team roster.
This will require additional thinking on my part.

FYI: OKay; here is a wider view of this "project" (please forgive me
BrianB.):

Each Feb and Mar, a number of Veterans Administration facilities around
the USA participate in what is called the BVL Annual Bowling Tournament
(see
http://www.bowlforveterans.org/annual-bvlva-bowling-tournament-set-march/
and
http://www.bowlforveterans.org/bvl-programs/bvlva-annual-veterans-bowling-tournament/tournament-score-sheet/).
I am one of several bowlers that are representing the VA Medical Center
at Northport, NY. Ultimately, the topmost 45 bowling scores from a five
man team(s) that represents the Northport NY VAMC will be summed. The
result of that summation shall be submitted, via an online score, sheet
to the tournament administrators. If/when a team places 1st, 2nd, or
3rd, nationally, an award is given to each member of the five-man team.

Regards,

VinceB.

On 3/14/2018 8:23 PM, Martin Groenescheij wrote:

Well I was looking at your problem straight from the first email you
sent, and I'm half way with the solution.
The only problem I need to solve is what happens when two bowlers have
the same score.
But it get frustrating when half way the investigation you send
updates on your problem that doesn't solve anything.

Be patient.

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

2018-03-14 Thread WA.TWORSX via AOL




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.

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

2018-03-11 Thread WA.TWORSX via AOL


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 Formula to use with Results of LARGE( ) Function's Result- Lookup?

2018-03-10 Thread WA.TWORSX via AOL



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.

Re: How to Embed my List of Reminders

2018-03-04 Thread WA.TWORSX via AOL



Well, the shading background colors did not go through, but I hope that 
you get the idea? :-(



On 3/4/2018 12:51 PM, WA.TWORSX via AOL wrote:


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

How to Embed my List of Reminders

2018-03-04 Thread WA.TWORSX via AOL



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

2018-02-17 Thread WA.TWORSX via AOL



Yes, Data | Group and Outline>| Remove did the trick, Brian. Thank you.

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.


Regards,

VinceB.



On 2/17/2018 12:42 PM, Brian Barker wrote:

At 11:55 17/02/2018 -0500, Vince Bonly wrote:

I made an error by writing on a paper that was resting on my keyboard.


Remember that Edit | Undo (or Ctrl+Z) - possibly repeatedly - may be 
the easiest way to undo errors such as this if you catch them before 
making any other changes (or soon after).


Now an unfamiliar column appears at the extreme left-hand side of my 
Calc sheet #7, to left of the Column headings and left of the Row 
numbers. Within this strange column at the top there are two buttons, 
labeled 1 and 2; and further down a single button that shows as 
either a plus (+) sign or a minus (-) sign. Each of these buttons can 
be toggled by using either the left or the right mouse button. Row 7 
of my Calc sheet is either hidden or is not hidden, depending on the 
state of the buttons.


You "grouped" row 7 - possibly by inadvertently pressing F12, Enter.


Any ideas or hints on how to fix this?


Go to Data | Group and Outline > | Remove.

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

Unfamiliar Additional Column has Appeared in my Calc Sheet #7

2018-02-17 Thread WA.TWORSX via AOL


AOO415m1(Build:9789)  -  Rev. 1817496
2017-12-11 17:25 AOO-Calc on a WIN10-64 desktop

___


I made an error by writing on a paper that was resting on my keyboard. 
Now an unfamiliar column appears at the extreme left-hand side of my 
Calc sheet #7, to left of the Column headings and left of the Row 
numbers. Within this strange column at the top there are two buttons, 
labeled 1 and 2; and further down a single button that shows as either a 
plus (+) sign or a minus (-) sign.


Each of these buttons can be toggled by using either the left or the 
right mouse button.


Row 7 of my Calc sheet is either hidden or is not hidden, depending on 
the state of the buttons.


Any ideas or hints on how to fix this?

Regards,

VinceB.






-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Display of Formulae within Cells

2018-01-14 Thread WA.TWORSX via AOL


TNX

:-[
On 1/14/2018 11:07 AM, Brian Barker wrote:

At 10:44 14/01/2018 -0500, Vince Bonly wrote:

Followed the instructions given in the Help text:

1. Choose *Tools - Options - OpenOffice Calc - View*.
2. In the *Display* area mark the *Formulas* box. Click OK.


but do not find any */Display area or Formulas box /*!

The following is shown on my screen after clicking -View:

 * User Interface
 * Graphics output
 * Menu
 * Mouse
 * Font Lists
 * Selection

--- Not the desired screen-page. What am I doing incorrectly?


Not following the instructions!

You have reached Tools | Options... |  OpenOffice | View, whereas - as 
you say - you need Tools | Options... | OpenOffice Calc | View. Note 
that the OpenOffice Calc menu item will appear only if you are viewing 
a spreadsheet document.


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

Display of Formulae within Cells

2018-01-14 Thread WA.TWORSX via AOL


I am using WIN10-64 desktop and AOO415m1(Build:9789)  -  Rev. 1817496
2017-12-11 17:25

_

Followed the instructions given in the Help text:



1.

Choose *Tools - Options - OpenOffice Calc - View*.

2.

In the *Display* area mark the *Formulas* box. Click OK.


but do not find any */Display area or Formulas box /*!

The following is shown on my screen after clicking -View:

 * User Interface
 * Graphics output
 * Menu
 * Mouse
 * Font Lists
 * Selection

--- Not the desired screen-page.  What am I doing incorrectly?

Regards,

VinceB.

Re: Forced Initial CAp Problem

2017-12-30 Thread WA.TWORSX via AOL




On 12/30/2017 4:27 PM, Martin Groenescheij wrote:



On 31/12/17 7:05 AM, WA.TWORSX via AOL wrote:


Hi, and Happy New 2018 Year to all !


Using 4.1.3 AOO on WIN 10 desktop.


Time to upgrade to 4.1.5


I have manually checked for updates, and will install 4.1.4 soon. That 
version is shown as available to me here.






When I type, for example, JAN within an AOO Calc or Text document, it 
is changed to:  Jan.


Check your replacement table under Tools -> AutoCorrect Options see 
the Replace tab and Options tab


I do not see anything obviously incorrect with what is presently set 
(defaulted) under those two tabs, Martin.


This issue might be related to a recent crashing of Windows10, where a 
temporary corruption of the "profile" was suspected.


I just now realized that "JAN" and "JUL" are abbreviations for January 
and July.  JULIA works as expected, so the problem is related, I think, 
to abbreviated names of the months.




This is not occurring when using Windows Notepad or Word Perfect 12.


Both are for simple minds


I only mention them as a part of the troubleshooting done at my end.


Any ideas, suggestions would be appreciated very much.

Regards,

VinceB





Thank you for your suggestions.

Ciao!

Where Should a Template be Stored ?

2017-12-30 Thread WA.TWORSX via AOL



AOO 4.1.3 on WIN10 desktop



I have just created a "template" based on an existing AOO Calc 
document.  Into which folder should this (/Bowling Score Data 
Template/)*.ots* file be stored such that is shows up in the Listing of 
Templates ?  Is the appropriate folder :  
C:\Users\username\AppData\Roaming\OpenOffice\4\user\template ?


At present, I have the target file stored on my desktop and on a thumb 
drive.  Is there an easy way to "import" the target file to the 
appropriate folder?



Regards,

VinceB.

Forced Initial CAp Problem

2017-12-30 Thread WA.TWORSX via AOL



Hi, and Happy New 2018 Year to all !


Using 4.1.3 AOO on WIN 10 desktop.

When I type, for example, JAN within an AOO Calc or Text document, it is 
changed to:  Jan.


This is not occurring when using Windows Notepad or Word Perfect 12.

Any ideas, suggestions would be appreciated very much.

Regards,

VinceB

EZMIN PROGRAM Bounced Messages

2017-12-01 Thread WA.TWORSX via AOL



I am using AOO 52.5.0 (32bit) on WIN10-64 bit desktop computer.


I have received several bounced message notifications, such as the 
example shown below.  I need to be educated on this issue. I do not know 
why some messages are bouncing, while most are delivered w/o any 
problem.  Or, are these messages that I have attempted to send to the 
mailing list?? Can anyone explain why this is happening?


In


To retrieve a set of messages 123-145

is 123-145 an example of the bounced message numbers: should I insert

16546
16525
16561
16575
16584

instead?

Thanks.

VinceB.




Hi! This is the ezmlm program. I'm managing the
users@openoffice.apache.org  mailing list.

I'm working for my owner, who can be reached
atusers-ow...@openoffice.apache.org.


Messages to you from the users mailing list seem to
have been bouncing. I've attached a copy of the first bounce
message I received.

If this message bounces too, I will send you a probe. If the probe bounces,
I will remove your address from the users mailing list,
without further notice.


I've kept a list of which messages from the users mailing list have
bounced from your address.

Copies of these messages may be in the archive.
To retrieve a set of messages 123-145 (a maximum of 100 per request),
send a short message to:


To receive a subject and author list for the last 100 or so messages,
send a short message to:


Here are the message numbers:

16546
16525
16561
16575
16584

--- Enclosed is a copy of the bounce message I received.

Return-Path: <>
Received: (qmail 99793 invoked for bounce); 19 Sep 2017 19:59:35 -
Date: 19 Sep 2017 19:59:35 -
From:mailer-dae...@apache.org
To:users-return-165...@openoffice.apache.org
Subject: failure notice

Re: Unable to Insert a row or a column in Calc

2017-11-19 Thread WA.TWORSX via AOL


Problem solved.

I had to close the file, then reopen it.  Although Windows File Manager 
showed the file w/o the Read Only attribute applied, the title bar 
indicated "(Read Only)".


Sorry for wasting bandwidth; happy that I can now insert row/column again.


On 11/19/2017 2:31 PM, WA.TWORSX via AOL wrote:

AOO 4.1.3, WIN10-64 bit desktop


I have one Calc file that is not allowing me to insert row/column.  
When highlighting (selecting) a row, and then clicking "Insert" on 
menu bar, most items (row, column) are greyed out. Manual Break, 
Formatting Mark, Function List, ... are available.


When selecting a row or a column, and then right-click, only "Copy" is 
available. Other Calc files appear to be working normally for me. The 
problematic file was initially "Read Only"; I have removed the RO 
attribute, however.


Is this possibly related to a recent "profile" problem? Any 
suggestions; I need to update this Calc file.


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

Unable to Insert a row or a column in Calc

2017-11-19 Thread WA.TWORSX via AOL


AOO 4.1.3, WIN10-64 bit desktop


I have one Calc file that is not allowing me to insert row/column.  When 
highlighting (selecting) a row, and then clicking "Insert" on menu bar, 
most items (row, column) are greyed out. Manual Break, Formatting Mark, 
Function List, ... are available.


When selecting a row or a column, and then right-click, only "Copy" is 
available. Other Calc files appear to be working normally for me. The 
problematic file was initially "Read Only"; I have removed the RO 
attribute, however.


Is this possibly related to a recent "profile" problem? Any suggestions; 
I need to update this Calc file.


Regards,

VinceB.



-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Crash-Bam-- Lost recent Document List and Templates

2017-11-18 Thread WA.TWORSX via AOL



Never mind; I have it working again.




On 11/18/2017 2:20 PM, WA.TWORSX via AOL wrote:

AOO 4.1.3 on WIN 10-64 desktop\\


My WIN crashed, with a light blue screen for several minutes, for no 
apparent reason. There was several blanking off-on of the monitor 
screen.  I waited about 3 minutes before powering-off the PC  via the 
desktop power on/off button switch.  Then powered PC back on. It 
booted up normally. Desktop icons appear in their normal locations on 
the screen.


Now, the very first time, when I click on the icon for AOO that is 
within the system tray, it appeared to prompt me to install AOO. It 
prompted me for my name, etc.   I clicked on ?something? (maybe "Next" 
button, I do not recall ) and it brought me to the splash screen.


I looked for recent documents; none listed.  I looked for existing 
templates; it indicated that templates being used for the first time.


Have I lost all my templates?  How can I re-enable them, if they do 
remain?


Now, when I click on the icon for AOO, it opens the splash screen 
immediately.


Calling in an existing Calc file seems to be okay.

Any ideas on how to recover my templates would be greatly appreciated.


Regards,

VinceB.


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Crash-Bam-- Lost recent Document List and Templates

2017-11-18 Thread WA.TWORSX via AOL


AOO 4.1.3 on WIN 10-64 desktop\\


My WIN crashed, with a light blue screen for several minutes, for no 
apparent reason. There was several blanking off-on of the monitor 
screen.  I waited about 3 minutes before powering-off the PC  via the 
desktop power on/off button switch.  Then powered PC back on. It booted 
up normally. Desktop icons appear in their normal locations on the screen.


Now, the very first time, when I click on the icon for AOO that is 
within the system tray, it appeared to prompt me to install AOO. It 
prompted me for my name, etc.   I clicked on ?something? (maybe "Next" 
button, I do not recall ) and it brought me to the splash screen.


I looked for recent documents; none listed.  I looked for existing 
templates; it indicated that templates being used for the first time.


Have I lost all my templates?  How can I re-enable them, if they do remain?

Now, when I click on the icon for AOO, it opens the splash screen 
immediately.


Calling in an existing Calc file seems to be okay.

Any ideas on how to recover my templates would be greatly appreciated.


Regards,

VinceB.


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: missing formatting bar

2017-09-16 Thread WA.TWORSX via AOL




TNX !



On 9/16/2017 12:18 PM, Matthias Seidel wrote:

View - Toolbars - Formatting ?


Am 16.09.2017 um 18:11 schrieb WA.TWORSX via AOL:

AOO413m1(Build:9783)  -  Rev. 1761381
2016-09-29 02:39:19

Win10-64bit

After opening an existing Calc spreadsheet, the Formatting Bar is
missing.

How is the Formatting bar added back?


-
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

missing formatting bar

2017-09-16 Thread WA.TWORSX via AOL


AOO413m1(Build:9783)  -  Rev. 1761381
2016-09-29 02:39:19

Win10-64bit

After opening an existing Calc spreadsheet, the Formatting Bar is missing.

How is the Formatting bar added back?


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: stampa documenti

2017-06-11 Thread WA.TWORSX via AOL




On 6/11/2017 6:19 AM, Patrizio Prato wrote:

ho appena installato openoffice v. 4.1.3 sul mio pc windows7 e sembra
funzionare tutto correttamente ma quando vado a stampare un documento di
writer ricevo questa risposta di errore:

"print driver host for 32 bit applications ha smesso di funzionare" e
apparentemente non prende la mia laserjet hp p1005 come stampante
predefinita.

come posso risolvere? grazie in anticipo

patrizio prato


Below is the GOOGLE translation to English:

I just installed openoffice v. 4.1.3 on my windows7 pc and it seems
Work all properly but when i go to print a document of
Writer I receive this error response:

"Host print driver for 32 bit applications has stopped working" and
Apparently does not take my hp p1005 laserjet as a printer
Default.

How can I fix it? Thanks in advance

Patrician lawn
_

Could this be a JAVA runtime issue?  I'm guessing 

Regards,
VinceB.


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

96 matches

Mail list logo