fixed : rotate page orientation in MS Excel ( portrait / landscape )

Question :

I have to print (part of) an Excel sheet that has few lines and al lot of columns (so it’s not that height, but rather broad), so I want to print on a landscape-ed paper.

In regular macOS apps (like Preview, Keynote, etc.) I would do this by pressing [CMD]+[P] on my keyboard, so the printing window opens and I can switch the “Preview/Keynote/etc.”-dial to “Page Attributes”, so I can set the Paper Size (e.g. A4 or US Letter) and the Orientation (Portrait or Landscape).

If I do this in MS Excel, I get a similar printing window, but if I click the “Excel”-dial, the list of options doesn’t have “Page Attributes” listed… and I non of the other available options seems to have a setting to change the page orientation either…

Note : Yes, I know that Apple’s counterpart Numbers.app has a different type of printing window with the Page Orientation option listed near the top-right, but that’s to different from what I’m seeing in Excel that I see no way to lear in Numbers.app what I want to do in Excel…

What am I doing wrong ?

Answer :

Yes, Excel is different from the regular macOS-apps regarding setting the page orientation (and it’s even more different from it’s competitor Numbers.app), but the option is hidden in plain sight !

To change the page orientation in Excel, press the [ALT]+[P] key-combo, and then the print window opens, just leave the Excel-dial as-is and look a little below it… there you will see the options “Print”, “Margins” and “Orientation”… That’s it !

Note : there is another option to set the page orientation in Excel : goto the top menu-bar, click on “File” (top-left) and from the pull-down menu select “Page Setup” (just above “Print”) and when the “Page Setup” window opens, make sure the “Page”-tab is selected and at “Orientation” you will see radio buttons for “Portraid” and “Landscape”… That’s it !

enjoy πŸ˜‰

fixed : firmware-update for 70mai A800 dashcam WiFi

Question :

I just bought the best dashcam I could find for an affordable price : the Xiaomi 70mai A800 4K Ultra HD video with WiFi, GPS and ADAS driver assistance built-in.

I want to make sure I have the latest available firmware on the dashcam to enable all available features…

How do I install the latest A800-firmware ?

 

Answer :

Aside from all the great features already included in the Xiaomi 70mai A800 dashcam, user-friendly do-it-yourself firmware upgrades are also available to enable even more new features.

First, make sure you are using the right iOS-app : you need the 70mai (Worldwide) app that can be downloaded here.

Now, connect your iPhone to the 70mai WiFi-network and open the 70mai.app. If you have problems connecting to the 70mai WiFi-network, see this post.

Then, open the 70mai.app and do this to upgrade the firmware :

  • make sure you are on the 70mai.app’s main page (the window labeled “70mai” with a picture of a blue car and your 70mai Dash Cam A800 listed below it)
    • if the 70mai.app opens in the “70mai Dash Cam”-window with the current video stream of the dashcam and the “Take Photo” and “Album”-buttons below it, click the “<“-button top-left and in the “Exit the dash cam homepage?”-popup, click “OK”
  • in the “70mai”-window, make sure that at “Device” it says “Connected”
    • if “Not conneted” is listed, click on it
    • the “70mai Dash Cam”-window will open and the connection will be re-established
    • then, return to the “70mai”-window by clicking on the “<“-button top-left and in the “Exit the dash cam homepage?”-popup, click “OK”
  • back in the “70mai”-window, click the person-icon top-left
  • in the slide-in window click on “My Devices”
  • in the “My Devices”-window, click on “70mai Dash Cam A800”
  • in the next window (also called “My Devices”), click “Firmware Update”
  • when the “Firmware update”-window opens, follow the on-screen instructions to upgrade the firmware to the latest version

…that’s it !

enjoy πŸ˜‰

Note that you can adjust various dashcam settings (like the Speaker Volume, Video Resolution, Parking Surveillance, ADAS Driver Assistance, etc.) by clicking on the 3dot-icon top-right in the “70mai Dash Cam A800”-screen (where you can see the current video stream from the dashcam with the “Take Photo” and “Album”-buttons below it).

Β 

 

 

fixed : 70mai A800 dashcam WiFi connection error

Question :

I just bought the best dashcam I could find for an affordable price : the Xiaomi 70mai A800 4K Ultra HD video with WiFi, GPS and ADAS driver assistance built-in.

I can’t get it to connect properly to my iPhone over WiFi however… I can find the 70mai WiFi network in the list of available WiFi networks in the iOS Settings-app, and I can connect to it, since it is shown as the connected WiFi-network… but the WiFi icon (the pie-shaped triangle) isn’t shown in the upper right corner of my iPhone… and when I startup the 70mai.app and click on the “70mai Dash Cam A800” in the “Please add 70mai devices”-window, I get an error : “Unable to get Wi-Fi connection Please enter [Settings – 70mai] to open location permission and then connect the device.” …and when I click on the “Go to open it”-button, the Settings-app opens …there I can set Wi-Fi, but that is already connected to the 70mai WiFi-network…

What is going on… how can I fix this ?

 

Answer :

The solution is simple, but you didn’t understand the given directions… probably because the the error message isn’t really straight forward : it’s in awkwardly translated English and the button only links halfway to where you need to adjust the settings…

First, make sure you are using the right iOS-app : you need the 70mai (Worldwide) app that can be downloaded here.

Then, do this :

  • connect the 70mai A800 dashcam to power
  • open the “System Settings” page (the icon is a hexagram with a dot in it)
    • Note that there’s no touch-screen so you should use the 4 buttons below the screen to navigate through the on-screen menu-structure
  • On the Settings page, you need to set “Wi-Fi hotspot” to “Enable” :
    • select “Disable” (at the top line, right of “Wi-Fi hotspot”)
    • in the “Wi-Fi hotspot”-page that opens you will see the name of the WiFi-network (at “Wi-Fi SSID”) and the WiFi-password (at “Password”)
    • remember these (or leave this screen open)

Then, open the 70mai.app on your iPhone and do this :

  • on the first page (simply called “70mai”) click the “Add device”-button (the only button on-screen)
  • in the “Please add 70mai devices”-page that opens, scroll down to “70mai Dash Cam A800” and click on it
  • when you get the “Unable to get Wi-Fi connection Please enter [Settings – 70mai] to open location permission and then connect the device.” error message, click on “Go to open it”
  • now the Settings.app will open, but it won’t always on the same page inside the Settings.app
  • so, make sure you go to the main Settings-page and clcik on “Wi-Fi” in the list
  • when the “Wi-Fi”-page opens, select the 70mai WiFi-network (with the name that was listed at Wi-Fi SSID”) from the list of “Other Networks” (or “My Networks”)
  • if the WiFi-password is required, use the “Password” that is (or was) displayed on the dashcam’s screen
  • now, even when the 70mai WiFi-network is connected you will still see 4G (or 3G or some other mobile data indication) instead of the WiFi-icon in the top-right corner of your iPhone screen
  • then click on “<Setttings” top-left
  • back in the main Settings-page, scroll all the way down to “70mai” (in the list of apps that starts after “Game Center”) and click on it
  • in the “70mai” page that opens, set “Location” to “While Using the App”
    • you could also set it to “Always”, but that isn’t a great idea since the 70mai WiFi-network is rather poorly protected
  • now, open the 70mai.app again
  • in the “Please add 70mai devices”-page, click on “70mai Dash Cam A800”
  • now, the “Turn on Wi-Fi hotspot”-page will open with a picture that resembles the “Wi-Fi hotspot” page that is displayed on the dashcam
  • there, you should click on “Dash cam WiFi hotspot is turned on” (eventhough it appears to be greyed-out) so a green checkmark will appear
  • then click “Next”
  • on the next page (the “Connect to WiFi hotspot”-page) click “Connect”
  • now the Settings.app will open again, check that the 70mai WiFi-network is listed at “Wi-Fi”
  • then, open the 70mai.app and you will see a countdown-circle on your iPhone and you will hear a voice from the dashcam
  • so, go to the dashcam screen and tap the button bottom-right to confirm
  • now you will see what the dashcam is ‘seeing’ / ‘recording’ in the 70mai.app on your iPhone

…that’s it !

enjoy πŸ˜‰

Note that you can adjust various dashcam settings (like the Speaker Volume, Video Resolution, Parking Surveillance, ADAS Driver Assistance, etc.) by clicking on the 3dot-icon top-right in the 70mai-app screen.

Β 

 

 

fixed : CarPlay option not available on iPhone

Question :

My car doesn’t have buit-in navigation, but the onboard system supports Apple CarPlay. I have connected my iPhone to my car both through USB and Bluetooth, but my car only connects to my iPhone for Contacts and telephone… I can’t get access to my iPhone apps like navigation…

I have looked up info on CarPlay online, and it is said everywhere that there should be a CarPlay option in the General.app listed in the same chapter containing AirDrop, AirPlay&Handoff and Picture-in-Picture… immediately below those Picture-in-Picture… but there is none…

My iPhone is just over a year old and I am running the latest version of iOS, so that shouldn’t be a problem, especially since my friend’s iPhone 6S immediately connects to my car’s CarPlay when he plugs in the lightning-to-USB-cable…

What is wrong ?

 

Answer :

If you have Siri turned off, the CarPlay option won’t show.

So, to fix your problem, do this :

  • on your iPhone, goto the Settings.app > Siri & Search (in the same chapter as General, Control Center and Display&Brightness, just below Wallpaper) > switch ON “Allow Siri When Locked” and preferably also “Listen for Hey Siri” and/or “Press Side Button for Siri”
  • then turn Bluetooth OFF and back ON on your iPhone
  • then turn WiFi OFF and back ON on your iPhone
  • then goto the Settings.app > General > CarPlay
  • if CarPlay isn’t listed, just wait a few minutes or restart your iPhone
    • press&hold the ON/OFF-button and the VolumeUP-button simultaneously until the “Slide to power off” slider appears
    • then slide the PowerOFF-slider so the screen goes black
    • then press&hold the ON/OFF-button until the Apple logo appears and your iPhone restarts and says you SIM must be unlocked
    • then touch the screen and typ your screen unlock code (6 digits) in the first (black) screen
    • then typ your SIM unlock code (4 digits) in the second (white) screen
  • then, again, goto the Settings.app > General and check if CarPlay is now listed
    • if CarPlay still isn’t listed, repeat the entire process
  • now reconnect your iPhone to your car using the Lighting-to-USB-cable and your car’s display will now be able to show your iPhone’s apps also
    • if the app you want to use isn’t listed, goto Settings.app > General > CarPlay and make sure that you add all apps that you would like to use
    • if no apps are available on your car’s display, use another Lightning-to-USB-cable

That’s it !

enjoy πŸ˜‰

Β 

 

fixed : AppleTV keeps getting new IP address continuously

Question :

I am using the IP Scanner (and LANscan) software to check my network performance whenever I encounter network problems. I have found that my AppleTV keeps getting multiple IP addresses from my router using DHCP…

What is going on and how can I fix this ?

 

Answer :

The most probable cause of your problem is that you are connection over WiFi and the AppleTV is positioned somewhere where WiFi-reception isn’t optimal, and where multiple base stations are giving an equally strong WiFi-signal, which is causing the AppleTV to constantly switch from a connection to the one WiFi-base station to the other and back again.

There is a slight chance that you have this problem when connecting over Ethernet LAN-cable also… in that case you might have some interference or data-loss on the cable which usually isn’t problematic, but still is sub-optimal…

The best and easiest way to fix this is to give the AppleTV a fixed IP-address.

To do so, do this (in tvOS 7.4 – for other versions of tvOS the actual screens may differ) :

  • unplug the AC-power cable from your AppleTV
  • restart your router (or unplug it from power for 30 seconds)
  • plug the AC-power cable back into your AppleTV
  • turn on your TV (the one that’s connected to your AppleTV)
  • turn on your AppleTV
  • goto Settings (the app that has a Sprocket/Gear-icon)
  • in the Settings-window, click on General
  • in the General-window, click on Network
  • in the Network-window, click on WiFi (or Ethernet if you use it)
  • in the WiFi-window (or Ethernet-window), click on Configure IP
  • in the ConfigureIP-window, make a photo of all settings or write them down (because this exact info is what you are going to enter manually), then click on Manual
  • in the IP-configuration window, roll the dials until the IP is set, then click OK
  • in the Subnetmask-configuration window, roll the dials until the Subnetmask is set, then click OK
  • in the Router-configuration window, roll the dials until the Router IP is set, then click OK
  • in the DNS-configuration window, roll the dials until the DNS is set (or use 008.008.008.008), then click OK
  • then wait for the setting so be accepted while the wheel spins
  • then exit, exit, exit until you’re back on the Home screen

That’s it !

Note : if you want to be completely sure that your AppleTV has accepted all settings, you can unplug and replug your AppleTV from power, but that is not as important as it used to be in older versions of tvOS – and you need to check afterwards in Settings to be completely sure

enjoy πŸ˜‰

fixed : account info greyed out in iOS 12

Question :

I have just upgraded my child’s iPhone from iOS 11 to iOS 12, but I can’t access his/her iCloud settings, since his/her account name is greyed out in Settings.app and nothing happens when I click on it…

How can I solve this ?

 

Answer :

The problem is that you have had Restrictions-setting active on iOS 11, and it is still active on iOS 12…

However : the Restrictions-setting is no longer in the “General”-chapter of Settings.app, starting in iOS 12, the Restrictions-setting is in the “Screen Time”-chapter (the purple hourglass icon just above the grey sprocket/gear-wheel icon of the “General”-chapter) and the setting is now called “Content & Privacy Restrictions”

So, do this :

  • open the Settings.app
  • in the window that opens, click on “Screen Time” (the chapter just above “General”)
  • in the next window, click on “Content & Privacy Restrictions”
  • when asked, type the Restrictions-password-code (4 digits) you previously used on iOS 11
  • then scroll down to “ALLOW CHANGES:” and “Account Changes” and adjust the setting to allow changes
  • now, the account-info in Settings will no longer be greyed out and you can also login on additional iCloud services like Messages (a.k.a. iMessage)

that’s it !

enjoy πŸ˜‰

fixed : can’t find Restrictions setting in iOS 12

Question :

I’ve just upgraded my child’s iPhone from iOS11 to iOS12, which went without any problems. Or so it seemed…

In iOS11 I had set some Restrictions on my child’s iPhone because (s)he is underaged. I used to be able to find the Restrictions setting in Settings.app under General… but now, in iOS12, it’s no longer there…

Where has the Restrictions setting gone ?

 

Answer :

In iOS12, the Restrictions setting can be found in Settings.app under Screen Time. It’s now called “Content & Privacy Restrictions” instead of just “Restrictions”, but your options for setting restrictions are still generally the same.

You even have more options now. You can also set the amount of time your child will be able to use any specific app or service now.

enjoy πŸ˜‰