Posted by jpluimers on 2024/02/13
The conditional formatting feature in Excel is so cool!
If you use FALSE and TRUE expressions to check validity, you can easily make these red and green.
[Wayback/Archive] Conditional formatting of TRUE / FALSE values in an Excel 2010 range – Super User (thanks [Wayback/Archive] tbone for asking and [Wayback/Archive] digitxp for answering):
Posted in Apple, Excel, Mac, Mac OS X / OS X / MacOS, Office, Office 2010, Office 2011 for Mac, Power User, Windows | Leave a Comment »
Posted by jpluimers on 2024/02/01
Not long after Figuring out which processes are preventing to eject/unmount my MacOS Time Machine backup USB drive, I wanted to do the opposite: prevent /Volumes/Sandisk1TB from being ejected, as this is the “built-in” MicroSD card I use to store large or infrequently used files on (ISO and other disk images, drivers, hardware and software documentation, stuff to be installed on a fresh machine).
The opposite is straightforward: have a process keep at least one handle open on the Volume as per [Wayback] macos – How do I not accidentally eject external drives? – Ask Different (thanks [Wayback] kLy, [Wayback] dan and [Wayback] gerlos):
If your important external drive is mounted on the following mount point:
/Volumes/important_diskThen you can protect it against an accidental removal by locking this mount point as opened. For this one very simple method consists in opening
Terminaland doing this basic command:$ cd /Volumes/important_diskTo get rid of this locking, you might type within the same
Terminalwindow:$ cd /or you might as well just close this
Terminalwindow ($ exit, or ⌃+D, or ⌘+W).…
An even more elegant way to do it is open a
screensession (just typescreeninTerminal) and open the mount point from that session. This way you can even closeTerminal, since the session will keep running in the background, until you reattach it and stop it (so there’s no need to keep a window open if you don’t need it). I guess you can even create anAutomatoraction for it. For tips onscreensee: [Wayback] kinnetica.com/2011/05/29/using-screen-on-mac-os-x
–jeroen
Posted in *nix, *nix-tools, Apple, Mac OS X / OS X / MacOS, Power User, screen, Terminal | Leave a Comment »
Posted by jpluimers on 2024/01/26
The drawback of evening live USA broadcasts is that most of Europe and Africa are asleep.
The Americas, Asia and Australia are awake, so I get it that [Wayback/Archive] Insanely Great – CHM – The Apple Mac at 40 was streamed live at 04:00 UTC at [Wayback/Archive] Computer History Museum – YouTube: live.
Hopefully the capture will be available soon.
Not holding my breath though as not response whatsoever from the moderator when I asked for it.
Via [Wayback/Archive] David Pogue on X: “40 years ago today, Steve Jobs unveiled the Macintosh. Tonight, I’m hosting an astonishing event that reunites many of its creators: Bill Atkinson, Andy Hertzfeld, Susan Kare, Steve Capps, Bruce Horn, Guy Kawasaki, many more. Free livestream at 7 pm PT:”.
Posted in Apple, Classic Macintosh, History, Power User | Leave a Comment »
Posted by jpluimers on 2023/12/22
Summary of [Wayback/Archive] Print large PDF in Preview over several pages… – Apple Community:
Via [Wayback/Archive] macos print pdf scaled over two pages – Google Search.
–jeroen
Posted in Adobe, Adobe Acrobat, Apple, Mac OS X / OS X / MacOS, PDF, Power User, Windows | Leave a Comment »
Posted by jpluimers on 2023/09/19
Boy, two extra modifier keys: [Wayback/Archive] How to Strip Formatting When You Copy and Paste Text: 5 Ways
To paste as plain text on a Mac, you can use the somewhat cumbersome shortcut
Option+Cmd+Shift+Vto paste without formatting. This is a system-wide shortcut, so unlike Windows, it should work everywhere. Technically, the shortcuts pastes and matches the formatting, but this has the same effect of removing the original formatting.
Via [Wayback/Archive] macos word microsoft office paste without formatting – Google Search.
Paste without formatting is an issue on Windows as well. The default should be “paste without formatting” instead of the current “paste with source formatting”. See for instance these tweets:
Posted in Apple, Classic editor, Development, Gutenberg editor, Mac OS X / OS X / MacOS, Office, Office 2011 for Mac, Power User, Software Development, Web Development, WordPress | Leave a Comment »
Posted by jpluimers on 2023/07/24
Still need to test this out, but I got a new in box “Super Serial Card – Apple Computer”
Details: Apple II serial cards – Wikipedia
Apple Computer’s Super Serial Card, sometimes abbreviated as “SSC”, is the most well known communication card made for the Apple II. Apple called it “Super” because it was able to function as both of Apple’s previous cards, the Apple II Communications Card for modem use and the Apple II Serial Interface Card for printer use. A jumper block was used to configure the card for each of the two modes. The card has a maximum speed of 19,200 bit/s and is compatible with both ROM revisions of the Apple II Serial Interface Card. Reliable communications at 9600 bit/s and higher required disabling of interrupts. The card can actually run at 115,200 bit/s as well, using undocumented register settings; but speeds between 19,200 and 115,200 are not possible using this technique. The Super Serial Card was released in 1981 and utilizes the MOS Technology 6551 ACIA serial communications chip.
Manual: [Wayback] a2_Super_Serial_Card_user’s_manual.pdf via [Wayback/Archive.is] Apple II Super Serial Card – Google Search
Image:
Posted in //e, Apple, Apple ][, History, Power User | Leave a Comment »
Posted by jpluimers on 2023/07/10
That was more difficult than I anticipated: [Wayback/Archive] how do I merge the tabs of two open Preview windows if I have more than two open? – Ask Different
First of all, make sure that the “tab bar” is displayed by choosing “view”->”Show Tab Bar”. Then, you should be seeing the tab bar, which displays the file name:Then, in the other preview window, click and hold the tab bar, and drag it onto the tab bar of the target preview window. Using this method, you can merge as many tabs as you want.Tested on MacOS Catalina 10.15.4
Posted in Apple, Mac OS X / OS X / MacOS, macOS 10.12 Sierra, macOS 10.13 High Sierra, Power User, Uncategorized | Leave a Comment »
Posted by jpluimers on 2023/05/25
A while ago, I learned that MacOS has had a Unicode Hex Input keyboard since ages.
It is not installed by default, so you have to manually add it:
System Preferences.appKeyboard iconInput Sources tab+) iconUnicode Hex Input is the only entry in the listAdd buttonKeyboard tabNow in the menu bar, you can select the Unicode Hex Input.
After that, when holding the Option key, any 4-digit Unicode sequence will get you a Unicode character.
Posted in Apple, Development, Encoding, Mac OS X / OS X / MacOS, Power User, Software Development, Unicode | Leave a Comment »
Posted by jpluimers on 2023/04/21
SwiftOnSecurity posted this interesting tweet in 2021: [Archive] SwiftOnSecurity on Twitter: “Lenovo P1 Gen3 with 12core Xeon, 64GB RAM, two 1TB M.2 SSDs. Running Windows Server 2022 with the Hyper-V role. All hardening applied to host OS, almost nothing happens here except managing guest VMs. On the second SSD I then have Win10 VMs joined to the corporate domain.” / Twitter.
I wonder if a similar setup can be done using an Apple M1 based machine as host and running all work in virtual machines.
Swift had some issues getting cameras and microphones to work: [Archive] SwiftOnSecurity on Twitter: “The problem here is Teams. If I want to pass through my webcam and microphone that could get a bit dicey, despite HyperV Enhanced Session being essentially an RDP session. For now I’m using my phone for Teams microphone. Also I’m not sure how well thermal management will work….” / Twitter
This resulted in some answers and interesting links:
Some more interesting tweets in that thread:
–jeroen
Posted in Apple, M1 Mac, Mac, Power User, Windows | Leave a Comment »
Posted by jpluimers on 2023/03/13
The links found via [Wayback/Archive] macos kernel_task high cpu dual screen – Google Search were daunting.
In the end, the issue ways way easier to fix than I thought: open up your Intel MacBook (you need pentalobe screwdrivers for that), then with some compressed air, clean the dust (especially from the fans).
This post saved my day [Wayback/Archive] kernel_task takes up 500% of my CPU when plugging in external monitor – MacBook Pro 15″ Retina Display Mid 2015 – iFixit
Things I haven’t tried yet:
- Cleaning out more free space from HDD
- Using plain HDMI cable into the HDMI cable port
- Taking MBP apart and cleaning any potential dust
…
I faced the very same issue that you guys are facing and based on input from another forum decided to get my 2016 MPB fans cleaned out.
This made an immediate impact where when I connected my external display to the MBP.pre-cleaning, it would overheat causing the fans to spin at 6000 rpm or thereabout and the kernel_task would eat up 500%-900% of the CPU rending the system unusable.
This simple cleanup of the fans has allowed me to connect the monitor with no kernel panic anymore and even though the fans run around 5000 rpm now the CPU and GPU are running around 10 degrees cooler now.
The same picture is in [Wayback/Archive] macos – MacBook Pro high CPU with external monitors – Ask Different.
An even dirtier MacBook was at [Wayback/Archive] External Display – High CPU Usage – MacBo… – Apple Community.
Links that were interesting but unhelpful:
–jeroen
Posted in Apple, Mac, MacBook, MacBook Retina, MacBook-Air, MacBook-Pro, Power User | Leave a Comment »
The Wiert Corner - irregular stream of stuff 