I am using AOO Calc vers 4.1.2 and Win 8.1x64 (file name is 2016 My
Bowling Score Data.ods).
I want to "automatically transfer" the data that is typed/entered into
Cell M342 of the Sheet named: 2016 Scores into Cell D6 of the Sheet
named: 2016 Match Play.
The Cell M342 data is calculated
On 1/29/2016 10:02 PM, Doug wrote:
On 01/29/2016 08:03 PM, Vince B. wrote:
TNX Keith:
I am rather sure that your info will help me; I am certain that a new
script for reading vision is what I also need, since having cataracts
re moved!
Regards,
Vince
I haven't been following
On 1/29/2016 7:17 PM, Steve Ahlers wrote:
Another way of creating the formula is to type the = then click on the source
cell and hit return.
Steve
I am unable to click to a different worksheet to then swipe the text
string from the source cell, after putting = into the target cell,. A
On 1/29/2016 6:58 PM, Keith N. McKenna wrote:
Vince wrote:
I am using AOO Calc vers 4.1.2 and Win 8.1x64 (file name is 2016 My
Bowling Score Data.ods).
I want to "automatically transfer" the data that is typed/entered into
Cell M342 of the Sheet named: 2016 Scores into Cell D6 of
Hello:
Using AOO 4.1.2 on WIN 8.1.
I do not know the correct terminology for searching in HELP file, but I
want to have a drop down selection list, with a clickable arrowhead,
inside a Calc cell. How can this be done?
Regards,
VinceB.
as on Sheet2. Then when it’s time to select your cell range, shrink the
dialog, change sheets, select the desired range, hit shrink again, and the
dialog would show something like “$Sheet2.$F$10:$F$15”, and those choices would
populate your target cell.
Jim Plante
On Feb 11, 2016, at 10:56 AM
' ) nor with a right arrow ( < ). I was
trying to begin with '16 BVL Practice or ; neither of those worked.
I did not pick up a 7-10 split, but rather Spared on a 4-7-10 split when
I bowled yesterday!
TNX again.
Regards,
VinceB.
On 2/11/2016 7:45 PM, James Plante wrote:
Reply inl
When '16 BVL Practice was used, IIRC, the ERR:519 showed. The cells
within my Source were not formatted as text beforehand.
Next time, I will try that Shrink box.
TNX.
On 2/12/2016 4:38 PM, Brian Barker wrote:
At 16:18 12/02/2016 -0500, Vince Bonly wrote:
Came upon one glitch: I di
Hello:
I am using AOO412m3(Build:9782) - Rev. 1709696 2015-10-21 09:53:29
(Mi, 21 Okt 2015) on a Win 8.1 machine.
The following formula/function originated via www.samplewords.com;
specifically: http://www.samplewords.com/bowling-record-sheet/ .
=AVERAGE(LARGE(C9:C57;ROW(INDIRECT("1:10"))
Are you aware that your comments are not a part of the OP's thread. Why
not change the Subject Line, next time? Was it useful to include the
quoted materialwithin your OT message?
On 2/26/2016 2:20 PM, jd1008 wrote:
PLease, I ask people to stop TOP POSTING!!! It destroys the sequential
flow
Hello fellow AOO users:
The other day I wanted to make use of the AOO-Calc Help function from
the menu bar, but I was given an error message about Java file corrupted
or invalid version and that I should install a different JRE.
I am using Win8x64. Thought that all was okay with regard to Jav
ter-Auto Filter, but that seems to require
beginning at the very top of a column.
I will want to add additional choices at a later time; thus, I think the
List must be on a separate worksheet so that I can resort the entries
alphabetically.
Thanks for reading thi
cted. This has made a
difference for me when entering the names of common vendors, etc.
On 4/19/2016 5:05 PM, Vince wrote:
AOO412m3(Build:9782) - Rev. 1709696
2015-10-21 09:53:29 (Mi, 21 Okt 2015)
Win 8x64
I have done this once before, but am not able to re
Just a small variation to make it work easier for me, Shown below:
On 4/20/2016 2:19 AM, Brian Barker wrote:
At 17:05 19/04/2016 -0400, Vince Bonly wrote:
I want a drop down arrow that when clicked opens a list of
pre-written choices. This list is presently located on a separate
worksheet
Win8.x-64
AOO 4.1.2
___
I am frustrated with my attempts to delete an erroneous Chart in Calc.
It seems that a chart can only be cut. I am experiencing repeated AOO
crashes.
What is the proper procedure to select and then delete (entirely) an
existing chart in Calc? I could no
00.
However, what I really want to count is all data values between 100 and
129, for example.
IOW, count if data value within cells D342 through L380 is between 100
and 129.
What is the required formula/function in Calc to reach my goal?
Reg
AOO 4.1.2 on WIN8.1 desktop
__
I am trying to organize the many passwords that I use when accessing the
computer and the internet, etc. My goal is simply to have a paper copy
of the various passwords for storage is a secure location and I will
pr
I will post again when I get some troubleshooting results to report here.
Thanks for reading this.
Regards,
VinceB.
On 5/29/2016 3:48 AM, Brian Barker wrote:
At 11:43 28/05/2016 -0400, Vince Bonly wrote:
Two observations when using the Toolbar A-Z sort button:
I've noted that if/wheneve
f the font sticks?
Regards,
VinceB.
On 5/30/2016 12:35 AM, toki wrote:
Vince wrote on 29/05/2016 18:20:
and the rows for any previously existing row with word wrapping, appear too
small/low.
Typically, that happens when one uses a non-default font that is bigger
than the default. To compensat
out using AOO-Calc.
Thank you.
VinceB.
__
On 5/20/2016 1:34 PM, Brian Barker wrote:
At 11:01 20/05/2016 -0400, Vince Bonly wrote:
I am using this
=COUNTIF(D342:L380;">100")
... . Possible da
Hi Dennis:
Your suggestion ( =COUNTIF(F342:N380;">99")-COUNTIF(F342:N380;">129"),
also worked here.
I have used your suggestion here to generate result in an array, shown
below:
<100 1
100 thru 1090
110 thru 1190
120 thru 1292
130 thru 13910
140 thru 1491
150 thr
Ooops! Copy from AOO-Calc and Paste to Thunderbird 45.1.0 for the mail
list did not go very well (my first attempt) with that array.
If anyone is interested, is there a suggestion for how I could project
the array properly for email list viewing?
VinceB.
On 5/31/2016 8:04 PM, Vince wrote
AOO-Calc 4.1.2; WIN8.1
_
I have been working for several hours today with a Calc file that has
eight tab-sheets within it.
All tab-sheets, except for two, do not show the expected Page Break
Preview. Instead, the
suggestions.
Now, I am back to redesigning the .ods file to include Brian's or
Dennis's formula for detecting hits of my bowling scores that fall
within specific /range bin-decades/, from 100 to 109, 110 to 119,
290 to 299, etc., and 300.
Regards,
VinceB.
On 6/2/2016 5:22 PM,
Using the Find&Replace feature in AOO 4.1.2 Calc, is it possible to
replace a formula, such as:
=SUMPRODUCT($D$343:$L391>100;$D$343:$L391<109)
with:
=SUMPRODUCT(_2016_Scores_Target_Vince>100;_2016_Scores_Target_Vince<109)
where:
_2016_Scores_Target_Vince
is a named array ($D343:$L391) ?
(I reported in an earlier posting, /Detecting/Counting Cell's Values if
data is within a Specific Range of Values,/ that the Play File I created
was working. I now find that there are erroneous calculations in the
file that I am now using (a larger array of data) .
Also, please note that the
Thank you Brian!
On 6/5/2016 2:07 AM, Brian Barker wrote:
Yes. But you won't need to replace the formula, of course, just the
ranges it includes.
In the Find & Replace dialogue, click More Options and select Formulae
in the "Search in" drop-down.
Aha! You're correct, of course.
You may wish
AOO 4.1.2-Calc on WIN8.1 desktop
__
Is there a way to easily identify the background fill-color or the
font-color that is being used within a cell ? There should be, but I do
not know how, as yet.
I am trying to change the background fill-color to
TNX Brian; that worked nicely.
On 6/24/2016 6:56 PM, Brian Barker wrote:
At 17:03 24/06/2016 -0400, Vince Bonly wrote:
AOO 4.1.2-Calc on WIN8.1 desktop
Is there a way to easily identify the background fill-color or the
font-color that is being used within a cell ? There should be, but I
TNX Steve; that worked for me.
On 6/24/2016 5:08 PM, Steve Ahlers wrote:
Vince,
Copy the source cell, then Paste Special and choose characteristics to paste
into destination cell.
Steve
Sent from my iPad
On Jun 24, 2016, at 2:03 PM, Vince wrote:
AOO 4.1.2-Calc on WIN8.1 desktop
good morning,
I downloaded your program in Italian openoffice4.12 but I happened to
trocarne two 4.1 and two visial c.
The two contrasting and I can not do it in disinstalarli to install what
we need it, what can I do?
I leave my mobile phone 3479678250
thanks if you can help me
Cesare Monzegli
WIN10 on desktop PC and
AOO412m3(Build:9782) - Rev. 1709696
2015-10-21 09:53:29 (Mi, 21 Okt 2015)
_
I am working with a line graph chart in Calc that presently shows
"180.00" as the top limit and "0.00" as the low limit. I vaguely recall
that there is
It's possible that I do!
However, my apology; I mixed up you for another poster (Rory).
On 9/21/2016 11:39 AM, Brian Barker wrote:
At 09:14 21/09/2016 -0400, Vince Bonly wrote:
Thank you, Brian.
No probs!
I hope you have a successful trip.
Trip? What trip? Do you know something I
Windows 10, desktop,
AOO412m3(Build:9782) - Rev. 1709696
2015-10-21 09:53:29 (Mi, 21 Okt 2015)
When sorting data in AOO Calc, must the "key" text data be located in
the leftmost column? It seems that it is so.
Regards,
VinceB.
-
I am attempting to paste a portion of a AOO 4.1.2 Calc sheet with
Formulae displayed into Thunderbird45.4.0 compose window on WIN10x64
machine. My ISP is Verizon. Seems that I am not able to show the
formulae,which is what I want to discuss, into the email compose window;
only the results of
.)
Regards,
VinceB.
On 10/16/2016 1:04 PM, Steven Ahlers wrote:
Vince,
You can share the spread sheet through Drop Box and put the link in an email.
Steve
Sent from my iPhone
On Oct 16, 2016, at 9:53 AM, Wade Smart wrote:
On Sun, Oct 16, 2016 at 11:24 AM, Vince@Gmail wrote:
I am
On 10/16/2016 10:41 PM, Brian Barker wrote:
If you insert rows or columns, formulae containing ranges spanning
those insertions are automatically updated to expand the range. This
is true whether the range appears explicitly or as a name. In other
words, names are also updated appropriately. Th
On 10/16/2016 10:41 PM, Brian Barker wrote:
At 12:24 16/10/2016 -0400, Vince Bonly wrote:
I am attempting to paste a portion of a AOO 4.1.2 Calc sheet with
Formulae displayed into Thunderbird 45.4.0 compose window on WIN10x64
machine. My ISP is Verizon. Seems that I am not able to show the
On 10/25/2016 8:04 PM, VinceB. wrote:
AOO412m3(Build:9782) - Rev. 1709696
2015-10-21 09:53:29 (Mi, 21 Okt 2015)
WIN10x64
I would like to include the full path or filename within a CALC cell
and within the print range area. Is this possible ?
Regards,
VinceB.
--
On 11/5/2016 1:31 PM, VinceB. wrote:
AOO412m3(Build:9782) - Rev. 1709696
2015-10-21 09:53:29 (Mi, 21 Okt 2015
WIN10x64 Desktop
Please point me to the required dialog for changing the cell range in
a Calc Line Chart.
Hi Folks:
I keep track of my bowling scores in a AOO 4.1.2 Calc file on WIN10
desktop. I take the time to enter scores above a certain threshold in
Red font color. I would like to count the number of times a score
within a range of cells is above the specified threshold. For example:
CO
Using Windows 10-64 on a desktop DELL; and AOO413m1(Build:9783) - Rev.
1761381
2016-09-29 02:39:19
___
I have an AOO-Calc sheet set for landscape orientation. I have set the
row height for Optimum Row Height since several cells have multip
ile did have several Comments
embedded in it, and they are available within the AAO file now, as expected.
Any hints will be appreciated.
Regards,
Vince
Sent from my iPad
TNX Keith:
I am rather sure that your info will help me; I am certain that a new script
for reading vision is what I also need, since having cataracts re moved!
Regards,
Vince
Sent from my iPad
> On Jan 29, 2016, at 18:58, Keith N. McKenna wrote:
>
> Vince wrote:
>>
That is a very good hint/reminder, Steve. I knew about this when staying
within the same sheet; I hope it works for me.
TNX.
Regards,
Vince
Sent from my iPad
> On Jan 29, 2016, at 19:17, Steve Ahlers wrote:
>
>
>
>> Vince wrote:
>>>
>>>
>
It is now working. Yesterday, however, I was unable to change "focus", thus I
asked for help.
Regards,
Vince
Sent from my iPad
> On Jan 30, 2016, at 11:33, Brian Barker wrote:
>
> At 10:54 30/01/2016 -0500, Vince Bonly wrote:
>>> On 1/29/2016 7:17 PM, Steve A
or ' ,
to see if an Err: pops up here.
Regards,
VinceB.
Regards,
Vince
Sent from my iPad
> On Feb 12, 2016, at 18:00, James Plante wrote:
>
> Vince, I’m not sure that it’s really necessary, but you might also format the
> cells in your list box to text as well as the tar
Is it possible ?
I have several Calc files that I suspect would be an improved experience if
they were Base files.
I am using Win8.x-64.
Regards,
Vince
Sent from my iPad
Rory:
Would doing as you have suggested cause the pagination data appear right-side
for the odd-numbered pages and appear left-side for the ever-numbered pages?
(That is the conventional pagination method, as I recall.)
Regards,
Vince
Sent from my iPad
> On May 18, 2016, at 11:30, R
I thought attachments are not permitted for this mail list?
Would an embedded link to my Drop Box work here? (I am new to Drop Box.) I'll
place the dummy array in my DB, to start.
Regards,
Vince
Sent from my iPad
> On Jun 1, 2016, at 00:22, James Plante wrote:
>
> One w
If I understand you correctly, then I should remove/delete any Print Range that
is found to exist. Will try that later today.
Thanks.
Regards,
Vince
Sent from my iPad
> On Jun 3, 2016, at 03:02, Brian Barker wrote:
>
> At 17:22 02/06/2016 -0400, Vince Bonly wrote:
>> I ha
Thank you.
Regards,
Vince
Sent from my iPad
> On Jun 5, 2016, at 14:17, Dennis E. Hamilton wrote:
>
>
>
>>
>
> In case this remains a question. >100 does not include 100 and <109 does not
> include 109.
>
> So long as the values are integers,
Thank you, Brian. As is the usual case, your concise hints are extremely
helpful. Yes, my issue was in regard to the Y-axis scaling.
I hope you have a successful trip.
Regards,
Vince
Sent from my iPad
> On Sep 20, 2016, at 20:28, Brian Barker wrote:
>
> At 15:31 20/09/2016 -04
Sorry for my delay in replying; had email issues with my @verizon account.
Yes, I was using the Sort Ascending button, will try to remember to use Data |
Sort for sorting adjacent columns of data.
Regards,
Vince
Sent from my iPad
> On Oct 6, 2016, at 18:59, Brian Barker wrote:
>
&
Rory:
Can you provide a link to PhotoRec? I have googled it, and arrived at a site
that prompts downloading of a program named: TestDrive (via URL cgsecurity.org)
and I feel suspicious. ...
Regards,
Vince
Sent from my iPad
> On Oct 29, 2016, at 15:02, Rory O'Farrell wrote:
&g
Thank you.
Regards,
Vince
Sent from my iPad
> On Nov 19, 2016, at 13:21, Rory O'Farrell wrote:
>
> On Sat, 19 Nov 2016 13:17:07 -0500
> "Vince B." wrote:
>
>> Rory:
>>
>> Can you provide a link to PhotoRec? I have googled it, and arr
Martin:
Thank you very much for taking time to answer
my question.
Regards,
VinceB.
Regards,
Vince
Sent from my iPad
> On Jan 2, 2017, at 19:26, Martin Groenescheij wrote:
>
>
>
>> On 03/01/17 3:57 AM, VinceB. wrote:
>>
>> I have managed to delete both
Thank you, I shall give that a try, later.
Regards,
Vince
Sent from my iPad
> On Mar 4, 2017, at 14:04, Girvin Herr wrote:
>
>
>
>> On 03/04/2017 09:50 AM, VinceB. wrote:
>> Hello:
>>
>> In AOO Calc 4.1.3, is there a quicker method for adding rows
Using Windows 10-64 on a desktop DELL; and AOO413m1(Build:9783) - Rev. 1761381
2016-09-29 02:39:19
___
I have an AOO-Calc sheet set for landscape orientation. I have set the row
height for Optimum Row Height since several cells have multiple
At 12:58 29/05/2017 -0400, Vince Bonly wrote:
I have an AOO-Calc sheet set for landscape orientation. I have set the row
height for Optimum Row Height since several cells have multiple lines of text
data. The first seven rows are repeated at top of each printed page. Am having
difficulty
Thanks again.
Regards,
Vince
Sent from my iPad
> On Feb 17, 2018, at 14:21, Brian Barker wrote:
>
> At 13:15 17/02/2018 -0500, Vince Bonly wrote:
>> Yes, Data | Group and Outline> | Remove did the trick, Brian. Thank you.
>
> No probs!
>
>> Now that I am
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,
_Date_ _
_
/ANTHONY ?/ /BOB M./ /DENISE C./ /GLEN U./ /JASIU M./ /JOHN G./
/RAY H./ /RON J./ /SAM C./ /RUSSEL P./ /VINCE B./ /WILLIE M./ /VAN ?/
_20th February-practice #1_ _Game 1_ 92 149 122 0 117 150 61
104 197 154 184 177 n/a
_Game 2_0 14
FYI:
I have updated my Drop Box BVL Summary Trial.ods sheet. Here is the
link to it (I hope that it works this time):
https://www.dropbox.com/s/rtkpz3yl7cqritu/Drop%20Box%20BVL%20Summary%20Trial.ods?dl=0
.
On 3/10/2018 10:57 AM, WA.TWORSX via AOL wrote:
Hi Again:
Well, my previous post
Martin:
What is your point ?
If you’re not that interested in offering assistance, please ignore my
request(s) for help.
Normally, I give thanks to (helpful) replies. Clearly, your reply is of no help
to me.
Regards,
Vince
Sent from my iPad
> On Mar 14, 2018, at 17:18, Mar
AOO415m1(Build:9789) - Rev. 1817496
2017-12-11 17:25 on WIN10-x64 desktop
Using Calc: Have recently became aware of and began using Names in Calc
spreadsheets (thanks MartinG.).
Is there a method to transfer Names that already exist within a Calc
.ODS
Glad that you managed to clean things up. I occasionally allow my
HP8600 to run a 'clean-the-print head' routine.
If I am not mistaken, the recommendation for inkjet printers is to Not
have it energized until ready to put it into operation; to avoid inkjets
becoming clogged ?
VinceB.
O
AOO415m1(Build:9789) - Rev. 1817496
2017-12-11 17:25
Desktop Win10-64
Working with an existing Calc spreadsheet, I copied it in its entirety
to a new sheet. I now find that I am unable to insert a column anywhere
on the new targeted sheet. When I attemp
Cause of my problem has been found and removed! Yes; I had copied &
pasted an entire row from the original spreadsheet into my new targeted
sheet, and that filled every column.
On 5/23/2018 11:51 AM, Brian Barker wrote:
At 11:03 23/05/2018 -0400, Vince Bonly wrote:
Working with an exis
AOO415m1(Build:9789) - Rev. 1817496
2017-12-11 17:25
WIN10-64 desktop
I went through a process to convert an existing .ods to a .ots . I used
File | Templates | Save, after removing the various inputted numerical
data from a p
Thanks Brian.
On 5/27/2018 6:53 PM, Brian Barker wrote:
At 16:13 27/05/2018 -0400, Vince Bonly wrote:
I went through a process to convert an existing .ods to a .ots . I
used File | Templates | Save, ...
Now, however, I believe that an incomplete/incorrect is shown via the
Splash Screen and
AOO415m1(Build:9789) - Rev. 1817496
2017-12-11 17:25
WIN10-64
___
I am attempting to insert a link to a .ODT file that contains "read me
first" information associated with one of my Calc spreadsheets. I have
made use of an
On 5/28/2018 4:16 PM, Brian Barker wrote:
At 13:16 28/05/2018 -0400, Vince Bonly wrote:
I am attempting to insert a link to a .ODT file that contains "read
me first" information associated with one of my Calc spreadsheets. I
have made use of an inserted link on one or two occasio
AOO415m1(Build:9789) - Rev. 1817496
2017-12-11 17:25
WIN10-64 Desktop
___
I find that often the template files obtained from
https://www.vertex42.com/ make use of alternate row shading, and I would
like to also. Example (copied from a
I have a Calc sheet in which unwanted background fill color is
displayed. The range begins B1307 and C1307 and seems to go the the end
(wherever that is). Can anyone suggest an easier method than using the
mouse to scroll to the "end" starting from B1307:C?
Is there an specific keystro
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
AOO 4.1.5 on DELL desktop; WIN10 Home x64
_
I don't know or understand how update Links, or update Styles, is
supposed to work in Calc.
Each time a Calc file is opened, I am prompted for a Yes/No to up date
All Links, or sometimes Y/N
With a Calc file already opened, is it possible to update all links?
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
On 9/29/2019 2:12 PM, Brian Barker wrote:
One idea: the target document needs to have been saved after any
changes before any values from it can be harvested in this way.
That one idea hit the mark Brian!
When I returned to work on my Calc spreadsheets today, the problem was
not experie
Check on the configured Print Range setting.
HTH.
Regards,
Vince
Sent from my iPad
> On Oct 27, 2019, at 15:00, Christel Lugo wrote:
>
> Hello,
>
> I am having a problem with Calc-specifically, it won’t print the pages I need
> printed. I keep trying to print three spe
HES & 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:
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 column
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-
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
> On May 3, 2020, at 01:44, 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?
No; but I almost
TNX Brian. That works for me!
Regards,
Vince
Sent from my iPad
> On Apr 25, 2020, at 09:45, Brian Barker
> wrote:
>
> At 09:27 25/04/2020 -0400, Vince Bonly wrote:
>> Within a Calc sheet there exists, say, www.domain.com in plain text format,
>> (or email.addr.
Hello Group:
My Windows 10 Home is used on a 64-bit architecture DELL desktop.
I recently downloaded and installed Libre Office software. So, now I
have both packages:
1. Apache Open Office: AOO415m1(Build:9789) - Rev. 1817496
2017-12-11 17:25 (This is AOO 32-bit version.)
2. Libre Offi
Hi Rob:
I believe that Big Sur is a mac OS, in which case your problem might be
related to Mac's Gatekeeper feature. Since I am not using that OS here
for AOO mail list, I cannot give any details, but I have seen messages
here about the Gatekeeper.
Good luck.
VinceB.
On 6/23/2021 9:23 PM
La richiesta di abbonamento non dovrebbe avvenire... Dove hai scaricato
il programma Apache Open Office? Era da
https://www.openoffice.org/download/index.html?
Buona fortuna.
___
Request for a subscription should not be happening... Where did you
d
C.:
Have you defined the Print Range? Data > Define Range.
First, give it a range name, then adjust the range to include your
desired printed range for that sheet.
VinceB.
On 10/9/2021 2:20 PM, cmc1...@minburncomm.net wrote:
Hello,
�I have created an autoformatted spreadsheet using ope
Ooops! That was for LO.
___
For AOO, use: Format > Print Ranges > Define.
On 10/10/2021 9:39 AM, Vince@Verizon wrote:
C.:
Have you defined the Print Range? Data > Define Range.
First, give it a range name, then adjust the range to include your
desired printed
Hi:
How do I format cells for entry of USA Telephone Numbers, as: 1
(###) ###*-*
whenever, for example,I have typed a ten-digit number, e.g., 1234567890
(no spaces, no negative/minus sign, no parenthesis, by use of the number
keypad (NumLk is enabled).
Yes, I want the "1" prefix, t
My thanks to all that have replied. It has been wild here with home
repair concerns, or I would have acknowledged sooner.
I will attempt 1^(###)^###- (where ^ is a space) under the numbers
tab, when time permits.
1. I believe that as soon as I begin typing into the definition box, it
s shown in image included above. Ultimately, I
want to be able to use LO or AOO for USA Telephone Number formatting.
Then, I must deal with very few international telephone numbers within
my Calc file.
TIA.
On 2/27/2022 12:58 PM, Vince@Verizon wrote:
My thanks to all that have re
Hi:
Hope all is well with you and yours.
I have a vers: 7.3.2.2 Calc sheet on my Win10x64 Home, build 19043,
desktop with labels for columns A, B and H as follows:
[A] [B] [H]
Delivery Date Today Is Days Since Delivery
The
On 8/28/2022 10:49 AM, Vince@Verizon wrote:
[snipped]
Cells A4 and B4 are formatted as Date, D, .
Misspoke; meant to write: DD
[snipped]
The calculated results in those cells are:
23 February 2022 28 August 28 2022 #VALUE!
Another of my errors
On 8/28/2022 10:49 AM, Vince@Verizon wrote:
{{{ snipped }}}
I don't know why I am getting a #VALUE! error in cell [H4]. Probably
something simple... but it escapes me
How can this be corrected?
{{{ snipped }}}
I now know why and how to correct this error.
I found that when ent
only at version
4.1.13. There may be differences between the two programs that could
in some cases make a difference to the answers to questions; please
make sure you are clear about what software you are using.
On 29/8/22 00:19, Vince@Verizon wrote:
I have a vers: 7.3.2.2 Calc sheet on my
I am using AOO AOO411m6(Build:9775) - Rev. 1617669
2014-08-13 09:06:54 (Mi, 13 Aug 2014) on WIN 8.2 Desktop.
Can someone point me to info on creating a dropdown menu in a
Spreadsheet cell, if this is possible?
I have created a spreadsheet to calculate Heating Fuel consumption, and
frequently
to combine
Base and Spreadsheet?
Regards,
VinceB
Sent from my iPad
> On Jan 28, 2015, at 11:42, Brian Barker wrote:
>
> At 11:19 28/01/2015 -0500, Vince Bonly wrote:
>> Can someone point me to info on creating a dropdown menu in a Spreadsheet
>> cell, if this is possibl
1 - 100 of 123 matches
Mail list logo