Wednesday, November 23, 2022

Apple Numbers appears to display a + instead of a / or ÷ for the division formula

I'm on Mojave for a while (Aperture) so I get to use an old version of Apple's spreadsheet - Numbers 10.1 (6913). It think this is still true however.

If I type a formula that divides one cell by another the Formula bar shows this:


It is actually doing division, but instead of a / or other operator it seems to displays a +.

If you add the same too numbers the formula  bar shows

A 2015 Discussion post explains the problem. This is an artifact of using Numbers on a non-Retina display with the default Numbers font. The first screenshot is actually a ÷ symbol. It's just super hard to see for an Old person using a non-Retina external monitor. (Did they even have Retina displays in 2015? Maybe Apple Devs had them?)

I suspect it's never been fixed -- so I'm gonna call this a bug. Apple is such a weird company and Numbers is weird even for Apple. There are many things I like about it but every so often something like this shows up. (Also, the Help function reminds me how bad macOS Help is.)

FWIW Numbers has an ePub User Guide and an online User Guide (version 12, but you can tweak the URL and seems to show 10.1).

Saturday, November 12, 2022

Migrating from an Apple Store/iTunes shared media Apple ID to a standard Apple ID configuration

I'm putting this up as a peacekeeper. I hope one day I'll fill it in better, but if you are trying to migrate from a shared Apple ID to each family member having only one Apple ID for both iCloud services and media then you will welcome any information.

First, see my prior post. I'll continue with this convention:

Let's say my iCloud Apple ID was "Sam" and my Media Apple ID was "Linda". So my device Apple ID configuration was Sam/Linda.  After the change it was Sam/Sam. 

I think the migration will more or less work. This is what I did so far, omitting errors and redirections:

  1. Let my Apple Music subscription lapse and cleaned up other subscriptions. These were owned by "Linda".
  2. Subscribed to Apple Music one day after the lapse using Sam. I'd seen hints Apple keeps iCloud media data (playlists) around for at least 1 month post lapse of subscriptions. I can confirm they last at least 1 day.
  3. Changed my devices to be Sam/Sam (maybe this would best be done later)
  4. In iCloud Family Sharing settings opened settings for Sam.  Even though my device might be Sam/Sam when I inspected details on my Family Organizer Apple ID I could see shared access was mediated by Linda. I changed that to Sam in Family Sharing.


I ran into too many issues to enumerate. A few tips:
  1. Changes to media rights seem to take time to be effective. After starting a subscription give it at least 30-60 minutes.
  2. iTunes classic allowed import/export of XML playlist files. These are useless. The key identifier is the track ID so they only have meaning for the Library they came from.
  3. Sharing a playlist by URL from Monterey worked -- but not at first. It got hung up in the subscription translation.
  4. Even after family members had renewed subscription access they needed to do something to get Apple Music.app to synchronize. Sometimes this was clicking on the sign-up add for Apple Music then choosing the subtle link for "already have a subscription". Sometimes shutting down and restarting. Sometimes looking at Music.app preferences and turning on iCloud library synch. (Sorry, there were so many issues!)
Extra comments
  1. There are two kinds of Playlists - "Apple Music Playlists" and traditional iTunes/Music playlists. I think when you migrate an old iTunes library to Monterey the app turns legacy playlists into Apple Music Playlists. Not 100% sure about this.
  2. I'm not gonna talk about this more, but I'm still running iTunes on Mojave and I'm amazed it works at all. It more or less survived the process. I have future work to do around migrating things out of iTunes on Mojave. (That machine will be an Aperture machine until I migrate that -- an even greater challenge. Then it will likely be replaced.
  3. Post migration it's not clear how to identify what a Family Member purchased from the days of the shared Apple ID. Apple suggests going to reportaproblem.apple.com; it only goes back 90 days though. Before doing the Apple ID migration the Family Organizer view had data broken down by family member, but after the migration that was very limited.
Update 11/15/2022 - the dreaded Apple ID for purchases". 

Only my #1 son still had the "Linda" Apple ID for purchases (Store, Media). He's on iOS 16.1.1. Even after switching his Media Apple ID to be his iCloud Apple ID, and despite his Settings Family Sharing saying he had access to the Apple Music subscription, both iTunes.app and Music.app said he didn't have family sharing access.

I found https://support.apple.com/en-us/HT201454. There are 3 Apple ID settings in iOS, not 2. There's iCloud Apple ID, Media and App Purchase Apple ID, and for the Family Organizer there's also Apple ID:Family Sharing:Purchase Sharing:Purchases:Apple ID for Purchases! The last is not updated when a user changes Media Apple ID. It's a "secondary Apple ID".

I don't think the Apple ID for purchases always exists. On my son's phone it can be changed. On my personal family organizer phone it appears it cannot be changed and it's incorrect. There can be significant timing delays when it's changed, the Done button may appear not to work but on screen refresh it may work.

After I removed the secondary Apple ID for purchases from his phone he was able to access Apple Music. Then I could enable "Sync Library" in Music Settings.


Update 11/18/2022: Article on the secondary Apple ID and purchase sharing. This article changed 9/2022. It feels like Apple's attempt to mitigate the multiple Apple ID curse. You can only change this every 90 days. I changed it from "Linda" to "Sam" but in 3m I might change it back again -- after some research.

Update 11/19/2022
After doing the Apple ID separation I needed to recreate a Library for my son that identified what he'd actually purchased over the years that his purchase were on the family shared Media Apple ID. The Media Apple ID had its own account on one of our Macs, so I could create a Playlist from that to share, then open that shared url in his current Library. That worked pretty well in the end, but there were many issues and steps. I used many macOS Music app queries and sorts to reconstruct which things were his (He still purchases Music from Apple. That's a longer story.)

Once he had the Playlist I created open in his macOS Music app I had to select all songs and use "Add to Library" to actually make them part of his Library. Note you can download songs for a Playlist but that doesn't make them part of the Library. I needed his Library to reflect his purchases and preferences.

As a part of this process I found the best way to view purchase history was to enable iTunes in Apple Music, then in iTunes click the Purchases link.

Incidentally I ran into many UI bugs and issues with Apple Music. The worst is the insane and inexplicably persistent Apple Music product manager decision to use an enormous Playlist header section that makes the essential column browser very inefficient. There were problems with Authorizations, with downloads, with list row selection and more. It's just a buggy and flaky app. At one point I was trying to download locally and nothing happened. Only by showing the Activity window could I see that my device authorization wasn't working. I had to use my son's Apple ID to authorize Music / iTunes in his user account -- perhaps the Apple ID I first used had too many authorizations on it. There was no error message.