Re: File /Spreadsheets/ChequeAccount.numbers uploaded
#file-notice
I am using Numbers. When I click on the cell, all I get are red triangles in that cell & all the cells below that.
Tony M
toggle quoted message
Show quoted text
On Nov 10, 2023, at 9:23?AM, Brent via groups.io <whodo678@...> wrote:
Tony, once you have a blank cell, it may continue to copy a blank cell down the column. Or if you entered a a figure into a cell, without using the formula, it will treat it as a blank cell, down the column. ?
Btw, are you using Excel, Numbers or what? Since this related to Otto’s check register, I think that was Excel.? On Nov 9, 2023, at 09:14, Jim Saklad via groups.io <jimdoc@...> wrote:
? It is a simple check: Click on the cell in question Look at the “edit line” at the bottom, which shows what is in the cell. That SHOULD show the calculation formula – if so, is that formula correct? If the cell is blank, with no formula in it, that is what you need to fix. On Nov 9, 2023, at 11:51?AM, Tony M via groups.io <nyrngrz@...> wrote:
It did not work. Since the beginning of using the spreadsheet, I have always added line below the last line and it always continued to correctly reduce or increase the balance accordingly. I tried copying & pasting the last line but it still didn’t work properly.
Tony M
On Nov 9, 2023, at 3:49?AM, Otto Nikolaus via groups.io <otto.nikolaus@...> wrote:
I’m concerned that Tony hasn’t replied to this. I’d like to know that the spreadsheet is now working correctly; if not, I’ll try to see what the problem is.?
The download at < /g/macsupportcentral/files/Spreadsheets> includes a general description of spreadsheets and instructions for this particular one. If there’s anything that needs adding or clarifying in that description, I’d be happy to do that.
Otto
(I can’t believe I set this up over a year ago!)
Yes, when you add a new row, you *must* copy the Balance cell from above as it contains the formula to update that balance. It’s easy to rectify this if you forget to do that: simply copy (?-c) the Balance cell where it last worked correctly, and then paste (?-v) into all Balance cells below.
jimdoc@...<Jim logo small.jpg>
|
Re: Sending text from MacBook Air to Android phones
I send Messages to Android phones, daily. No problem. If you send it with Apple Messages to an Android, you need to use their phone number<<<, not their email.
Why? Because, they can’t accept it in Apple’s proprietary iMessage format. Only as a text, which uses cell phone technology, not email. I have one friend, who does not use a text app on his Android phone, and only uses FaceBook Messenger. He can’t remember how to set that up to send and receive regular text. What a Royal PITA. Brent On my iPhone Xr On Nov 10, 2023, at 04:09, Debbi <djmcneer@...> wrote:
?Sending text messages through Messages on my MBA didn’t used to be a problem, and I can’t discern when it became one.
I have, of course, scoured the forums for answers/solutions/fixes, and occasionally the suggested cure works. But it doesn’t keep working. (The suggested cure is to make sure Messages is configured properly, select the correct email addresses to send from, make sure forwarding is turned on, etc. I’ve followed every instruction.)
I was able to successfully send texts to Android yesterday morning, for instance, but messages today are flagged “not delivered.”
This is frustrating. I find it much easier to compose a message using my laptop keyboard, and don’t want to limit my contacts to those who own Apple handheld devices.
What could the problem be, and how can I fix it permanently?
Thanks for any insight you can provide.
Debbi McNeer
MacBook Air Apple M2
Sonoma 14.0
|
Re: File /Spreadsheets/ChequeAccount.numbers uploaded
#file-notice
Tony, once you have a blank cell, it may continue to copy a blank cell down the column. Or if you entered a a figure into a cell, without using the formula, it will treat it as a blank cell, down the column. ?
Btw, are you using Excel, Numbers or what? Since this related to Otto’s check register, I think that was Excel.?
toggle quoted message
Show quoted text
On Nov 9, 2023, at 09:14, Jim Saklad via groups.io <jimdoc@...> wrote:
? It is a simple check: Click on the cell in question Look at the “edit line” at the bottom, which shows what is in the cell. That SHOULD show the calculation formula – if so, is that formula correct? If the cell is blank, with no formula in it, that is what you need to fix. On Nov 9, 2023, at 11:51?AM, Tony M via groups.io <nyrngrz@...> wrote:
It did not work. Since the beginning of using the spreadsheet, I have always added line below the last line and it always continued to correctly reduce or increase the balance accordingly. I tried copying & pasting the last line but it still didn’t work properly.
Tony M
On Nov 9, 2023, at 3:49?AM, Otto Nikolaus via groups.io <otto.nikolaus@...> wrote:
I’m concerned that Tony hasn’t replied to this. I’d like to know that the spreadsheet is now working correctly; if not, I’ll try to see what the problem is.?
The download at < /g/macsupportcentral/files/Spreadsheets> includes a general description of spreadsheets and instructions for this particular one. If there’s anything that needs adding or clarifying in that description, I’d be happy to do that.
Otto
(I can’t believe I set this up over a year ago!)
Yes, when you add a new row, you *must* copy the Balance cell from above as it contains the formula to update that balance. It’s easy to rectify this if you forget to do that: simply copy (?-c) the Balance cell where it last worked correctly, and then paste (?-v) into all Balance cells below.
jimdoc@...<Jim logo small.jpg>
|
Re: File /Spreadsheets/ChequeAccount.numbers uploaded
#file-notice
Tony, have you added a column? The original had 7, A-G. That’s fine as long as you intended that.
+1192 doesn’t belong there. What is the formula in the balance cell above that? It should be
H1179 + Credit(date) - Debit(date)
or
Balance(date + Credit(date) - Debit(date)
Otto
toggle quoted message
Show quoted text
On 9 Nov 2023, at 19:37, Tony M via groups.io <nyrngrz@...> wrote:
The last line that worked shows this as Formula: H1180+Credit(Date)-Debit(Date)+1192. the next line under that & all lines after no Formula appears. That is what I do not know how to fix.
|
Re: File /Spreadsheets/ChequeAccount.numbers uploaded
#file-notice
That should not be there at all. The balance is simply previous balance + credit - debit.
toggle quoted message
Show quoted text
On 9 Nov 2023, at 23:21, Christopher Collins via < maclist@...> wrote:
There should be a letter before 1192 in the formula.
|
Sending text from MacBook Air to Android phones
Sending text messages through Messages on my MBA didn’t used to be a problem, and I can’t discern when it became one.
I have, of course, scoured the forums for answers/solutions/fixes, and occasionally the suggested cure works. But it doesn’t keep working. (The suggested cure is to make sure Messages is configured properly, select the correct email addresses to send from, make sure forwarding is turned on, etc. I’ve followed every instruction.)
I was able to successfully send texts to Android yesterday morning, for instance, but messages today are flagged “not delivered.”
This is frustrating. I find it much easier to compose a message using my laptop keyboard, and don’t want to limit my contacts to those who own Apple handheld devices.
What could the problem be, and how can I fix it permanently?
Thanks for any insight you can provide.
Debbi McNeer
MacBook Air Apple M2
Sonoma 14.0
|
Re: File /Spreadsheets/ChequeAccount.numbers uploaded
#file-notice
There should be a letter before 1192 in the formula.
cjc
toggle quoted message
Show quoted text
On 10 Nov 2023, at 7:39 am, Jim Saklad via groups.io <jimdoc@...> wrote:
Click on the cell with the correct formula,
If you then place the cursor into the next cell (in this case below it), it should look like this (with different numbers of course):
<Screenshot 2023-11-09 at 3.32.43?PM.jpg>
Drag that yellow dot down into the cells below it and they will then “inherit” the formula from the chosen cell.
If the cursor was in the cell to the right, the yellow dot would appear on the right edge of the selected cell – say, if you wanted to copy the formula into cells to the right.
The last line that worked shows this as Formula: H1180+Credit(Date)-Debit(Date)+1192. the next line under that & all lines after no Formula appears. That is what I do not know how to fix.
Tony M
Jim Saklad wrote:
It is a simple check:
Click on the cell in question
Look at the “edit line” at the bottom, which shows what is in the cell.
That SHOULD show the calculation formula – if so, is that formula correct?
If the cell is blank, with no formula in it, that is what you need to fix. --
Jim Saklad
jimdoc@...
<Jim logo small.jpg>
|
Re: File /Spreadsheets/ChequeAccount.numbers uploaded
#file-notice
Click on the cell with the correct formula,
If you then place the cursor into the next cell (in this case below it), it should look like this (with different numbers of course):
Drag that yellow dot down into the cells below it and they will then “inherit” the formula from the chosen cell.
If the cursor was in the cell to the right, the yellow dot would appear on the right edge of the selected cell – say, if you wanted to copy the formula into cells to the right. The last line that worked shows this as Formula: H1180+Credit(Date)-Debit(Date)+1192. the next line under that & all lines after no Formula appears. That is what I do not know how to fix.
Tony M
Jim Saklad wrote: It is a simple check:
Click on the cell in question
Look at the “edit line” at the bottom, which shows what is in the cell.
That SHOULD show the calculation formula – if so, is that formula correct?
If the cell is blank, with no formula in it, that is what you need to fix.
--? Jim Saklad jimdoc@...
|
Re: File /Spreadsheets/ChequeAccount.numbers uploaded
#file-notice
The last line that worked shows this as Formula: H1180+Credit(Date)-Debit(Date)+1192. the next line under that & all lines after no Formula appears. That is what I do not know how to fix.
Tony M
toggle quoted message
Show quoted text
On Nov 9, 2023, at 9:14?AM, Jim Saklad via groups.io <jimdoc@...> wrote:
It is a simple check: Click on the cell in question Look at the “edit line” at the bottom, which shows what is in the cell. That SHOULD show the calculation formula – if so, is that formula correct? If the cell is blank, with no formula in it, that is what you need to fix. On Nov 9, 2023, at 11:51?AM, Tony M via groups.io <nyrngrz@...> wrote:
It did not work. Since the beginning of using the spreadsheet, I have always added line below the last line and it always continued to correctly reduce or increase the balance accordingly. I tried copying & pasting the last line but it still didn’t work properly.
Tony M
On Nov 9, 2023, at 3:49?AM, Otto Nikolaus via groups.io <otto.nikolaus@...> wrote:
I’m concerned that Tony hasn’t replied to this. I’d like to know that the spreadsheet is now working correctly; if not, I’ll try to see what the problem is.?
The download at < /g/macsupportcentral/files/Spreadsheets> includes a general description of spreadsheets and instructions for this particular one. If there’s anything that needs adding or clarifying in that description, I’d be happy to do that.
Otto
(I can’t believe I set this up over a year ago!)
Yes, when you add a new row, you *must* copy the Balance cell from above as it contains the formula to update that balance. It’s easy to rectify this if you forget to do that: simply copy (?-c) the Balance cell where it last worked correctly, and then paste (?-v) into all Balance cells below.
|
Re: File /Spreadsheets/ChequeAccount.numbers uploaded
#file-notice
Each cell in the Balance column needs to contain a formula. Place the cursor on the last one that works correctly and you will see that formula in the bar at the bottom of the table. Copy that cell (?-c) and then paste (?-v) into *all* balance cells below that one. Let me know if that now works.
I appreciate that such a spreadsheet contains confidential information or I’d ask you to send me the file, but we should be able to get this sorted out because it’s a very simple table with only one column containing formulae.
Otto
toggle quoted message
Show quoted text
On 9 Nov 2023, at 16:51, Tony M via groups.io <nyrngrz@...> wrote:
It did not work. Since the beginning of using the spreadsheet, I have always added line below the last line and it always continued to correctly reduce or increase the balance accordingly. I tried copying & pasting the last line but it still didn’t work properly.
|
Re: File /Spreadsheets/ChequeAccount.numbers uploaded
#file-notice
It is a simple check: Click on the cell in question Look at the “edit line” at the bottom, which shows what is in the cell. That SHOULD show the calculation formula – if so, is that formula correct? If the cell is blank, with no formula in it, that is what you need to fix. On Nov 9, 2023, at 11:51?AM, Tony M via groups.io <nyrngrz@...> wrote:
It did not work. Since the beginning of using the spreadsheet, I have always added line below the last line and it always continued to correctly reduce or increase the balance accordingly. I tried copying & pasting the last line but it still didn’t work properly.
Tony M
On Nov 9, 2023, at 3:49?AM, Otto Nikolaus via groups.io <otto.nikolaus@...> wrote:
I’m concerned that Tony hasn’t replied to this. I’d like to know that the spreadsheet is now working correctly; if not, I’ll try to see what the problem is.?
The download at < /g/macsupportcentral/files/Spreadsheets> includes a general description of spreadsheets and instructions for this particular one. If there’s anything that needs adding or clarifying in that description, I’d be happy to do that.
Otto
(I can’t believe I set this up over a year ago!)
Yes, when you add a new row, you *must* copy the Balance cell from above as it contains the formula to update that balance. It’s easy to rectify this if you forget to do that: simply copy (?-c) the Balance cell where it last worked correctly, and then paste (?-v) into all Balance cells below.
jimdoc@...
|
Re: File /Spreadsheets/ChequeAccount.numbers uploaded
#file-notice
It did not work. Since the beginning of using the spreadsheet, I have always added line below the last line and it always continued to correctly reduce or increase the balance accordingly. I tried copying & pasting the last line but it still didn’t work properly.
Tony M
toggle quoted message
Show quoted text
On Nov 9, 2023, at 3:49?AM, Otto Nikolaus via groups.io <otto.nikolaus@...> wrote:
I’m concerned that Tony hasn’t replied to this. I’d like to know that the spreadsheet is now working correctly; if not, I’ll try to see what the problem is.?
The download at < /g/macsupportcentral/files/Spreadsheets> includes a general description of spreadsheets and instructions for this particular one. If there’s anything that needs adding or clarifying in that description, I’d be happy to do that.
Otto
(I can’t believe I set this up over a year ago!)
Yes, when you add a new row, you *must* copy the Balance cell from above as it contains the formula to update that balance. It’s easy to rectify this if you forget to do that: simply copy (?-c) the Balance cell where it last worked correctly, and then paste (?-v) into all Balance cells below.
|
Re: File /Spreadsheets/ChequeAccount.numbers uploaded
#file-notice
I’m concerned that Tony hasn’t replied to this. I’d like to know that the spreadsheet is now working correctly; if not, I’ll try to see what the problem is.?
The download at < /g/macsupportcentral/files/Spreadsheets> includes a general description of spreadsheets and instructions for this particular one. If there’s anything that needs adding or clarifying in that description, I’d be happy to do that.
toggle quoted message
Show quoted text
(I can’t believe I set this up over a year ago!)
Yes, when you add a new row, you *must* copy the Balance cell from above as it contains the formula to update that balance. It’s easy to rectify this if you forget to do that: simply copy (?-c) the Balance cell where it last worked correctly, and then paste (?-v) into all Balance cells below.
|
Re: Easyfind - is it still available?
Just downloaded this the other day.
Thanks to Randy’s free software page by the way.
?
Cheers,
? ? ? ? ? ? ? ? ? ?Tod
toggle quoted message
Show quoted text
On Nov 8, 2023, at 2:08 PM, Bob Stern via groups.io <bobbystern@...> wrote:
I wanted to add Easyfind to my newest Mac but can’t find it.
The App Store shows easy funder 2.
According to the easy find info on my other Mac it is a Devon technologies app. I don’t see it on their web page.
|
Re: Easyfind - is it still available?
On Nov 8, 2023, at 11:08 AM, Bob Stern via groups.io <bobbystern@...> wrote:
According to the easy find info on my other Mac it is a Devon technologies app. I don’t see it on their web page.
On the devontechnologies.com <>, click Apps > Needful Things. David
|
Easyfind - is it still available?
I wanted to add Easyfind to my newest Mac but can’t find it.
The App Store shows easy funder 2.
According to the easy find info on my other Mac it is a Devon technologies app. I don’t see it on their web page.
|
Apple Confirms No More 27-inch iMacs
"Apple PR representative Starlayne Meza confirmed the company’s plans to The Verge. The company encourages those who have been holding out hope for a larger iMac to consider the Studio Display and Mac Studio or Mac Mini..."
__________________________________________________
Randy B. Singer
Co-author of The Macintosh Bible (4th, 5th, and 6th editions)
Essential But Hard To Find Macintosh Software and Advice
__________________________________________________
|
Re: File /Spreadsheets/ChequeAccount.numbers uploaded
#file-notice
(I can’t believe I set this up over a year ago!)
Yes, when you add a new row, you *must* copy the Balance cell from above as it contains the formula to update that balance. It’s easy to rectify this if you forget to do that: simply copy (?-c) the Balance cell where it last worked correctly, and then paste (?-v) into all Balance cells below.
Otto
toggle quoted message
Show quoted text
On 7 Nov 2023, at 00:23, Brent via groups.io <whodo678@...> wrote:
It sounds like you are working beyond the range of formatted cells.
|
Apple Confirms No More 27-inch iMacs
"Apple PR representative Starlayne Meza confirmed the company’s plans to The Verge. The company encourages those who have been holding out hope for a larger iMac to consider the Studio Display and Mac Studio or Mac Mini..."
__________________________________________________
Randy B. Singer
Co-author of The Macintosh Bible (4th, 5th, and 6th editions)
Essential But Hard To Find Macintosh Software and Advice
__________________________________________________
|
Re: File /Spreadsheets/ChequeAccount.numbers uploaded
#file-notice
It sounds like you are working beyond the range of formatted cells.?
toggle quoted message
Show quoted text
On Nov 6, 2023, at 14:39, Tony M via groups.io <nyrngrz@...> wrote:
? I have been using this spreadsheet as a checking account balance and it has been working fine for over a year but today all of a sudden when I place a Debit charge it isn’t reducing the balance to reflect the charge. It leaves the balance field blank. If an add a Credit it doesn’t add the amount wither, leaves the balance blank. Any idea what the problem could be?
Tony M
The following files and folders have been uploaded to
the Files area of the [email protected] group.
By: Otto Nikolaus <otto.nikolaus@...> Description:
Basic Numbers spreadsheet for registering cheques (checks) and other payments and credits, with automatic balance. Currency is in ? and date is in UK format (dd.mm.yyyy) so these should be changed as needed.
|
Brent
Debbi
Jim Saklad
todhop
Bob Stern