The Wiert Corner – irregular stream of stuff

Jeroen W. Pluimers on .NET, C#, Delphi, databases, and personal interests

  • My badges

    Mastodon

  • Twitter Updates

  • My Flickr Stream

    20140508-Delphi-2007--Project-Options--Cannot-Edit-Application-Title-HelpFile-Icon-Theming20140430-Fiddler-Filter-Actions-Button-Run-Filterset-now20140424-VMware-Fusion-6.0.3.-no-reclaimable
    More Photos

  • Pages

  • All categories

  • Enter your email address to subscribe to this blog and receive notifications of new posts by email.

    Join 1,839 other subscribers

Archive for the ‘Office’ Category

« Previous Entries
Next Entries »

Unprotect a Word Doc on Mac – YouTube

Posted by jpluimers on 2024/04/22

Needed these (in retrospect) simple steps because someone made a form with so much whitespace under the fields on a document that had to be printed for a physical signatures that otherwise too many trees would die.

[Wayback/Archive] Unprotect a Word Doc on Mac – YouTube.

Via [Wayback/Archive] word 2011 macos unprotect document – Recherche Google.

  1. In the menu, choose “File” -> “Save As…”
  2. Click “Options…”
  3. Click “Show All”
  4. Click “Security”
  5. Click “Unprotect Document…”
  6. Click “OK”
  7. Click “Save”

–jeroen

Read the rest of this entry »

Posted in Apple, Mac OS X / OS X / MacOS, Office, Office 2011 for Mac, Power User | Leave a Comment »

Convert TSV to HTML Table Online | WTOOLS

Posted by jpluimers on 2024/02/20

Great for converting tab separated data (for instance when copied from Excel) into HTML:

[Wayback/Archive] Convert TSV to HTML Table Online | WTOOLS

–jeroen

Posted in Development, Excel, HTML, Office, Power User, Software Development, Web Development | Leave a Comment »

For older Excel versions that do not have the =ISOWEEKNUM(date) function, use =WEEKNUM(date,21)

Posted by jpluimers on 2024/02/14

Calculating an ISO-8601 based WEEKNUM

From [Wayback/Archive] ISOWEEKNUM Function – How to Get the Week Number in Excel:

  • If we are using an older version of MS Excel, we can use the function WEEKNUM. By default, the WEEKNUM function uses an arrangement where Week 1 begins on January 1, and Week 2 begins on the next Sunday (when the return_type argument is omitted, or supplied as 1).
    However, with MS Excel 2010 for Windows and MS Excel 2011 for Mac, we can generate an ISO week number using 21 as the return_type: =WEEKNUM(date,21).
  • There is no built-in worksheet function for ISO weeks before MS Excel 2010.

I tested that ISO-8601 week number calculation in with Excel 2011 on MacOS and Excel 2010 on Windows: the workaround works well for the dates mentioned in ISO week date – Wikipedia.

Read the rest of this entry »

Posted in Excel, Office, Office 2010, Office 2011 for Mac, Power User | Leave a Comment »

Excel 2011/2010: Conditional formatting of TRUE / FALSE values in an Excel range

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):

Read the rest of this entry »

Posted in Apple, Excel, Mac, Mac OS X / OS X / MacOS, Office, Office 2010, Office 2011 for Mac, Power User, Windows | Leave a Comment »

Remember Excel import issues causing a change in Guidelines for human gene nomenclature | Nature Genetics

Posted by jpluimers on 2023/10/23

Remember [Wayback/Archive] Guidelines for human gene nomenclature | Nature Genetics?**

You might not, but this was what pointed me to it back in 2020: [Wayback/Archive] Scientists rename human genes to stop Microsoft Excel from misreading them as dates – The Verge.

The article was a result of Excel mangling import data for decades. Somehow finally it did get Microsoft’s attention and more than 3 years later, they issued options (with mangling still being the default) to help workaround the problems.

The 2004 article [Wayback/Archive] Mistaken Identifiers: Gene name errors can be introduced inadvertently when using Excel in bioinformatics | BMC Bioinformatics | Full Text demonstrated this import problem which had been present for quite a while already (it even has a csh Script to scan for SymbolMutation error).

The gene nomenclature people by now have moved to a different naming scheme, but maybe other people can benefit from the Excel updates of which you can find more through these links:

Read the rest of this entry »

Posted in CSV, Development, Excel, Office, Power User, Software Development | Leave a Comment »

Elle Cordova on Twitter: “Alexa, Siri and the other bots hanging out in the server break room again”

Posted by jpluimers on 2023/09/23

Long live the Clippy bot!

[Waybacksave/Archive] Elle Cordova on X: “Alexa, Siri and the other bots hanging out in the server break room again”

Read the rest of this entry »

Posted in AI and ML; Artificial Intelligence & Machine Learning, Bookmarklet, ChatGPT, Development, GPT-3, GPT-4, JavaScript/ECMAScript, Office, Power User, Scripting, Software Development, Web Browsers | Leave a Comment »

I recently learned about the MacOS universal Shift-Option-Command-V keyboard shortcut: paste without formatting

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+V to 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:

Read the rest of this entry »

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 »

Using Fields in Microsoft Word – a Tutorial in the Intermediate Users’ Guide to Microsoft Word

Posted by jpluimers on 2023/09/15

This page has a truckload of information, but has a short index and few anchor targets: [Wayback/Archive] Using Fields in Microsoft Word – a Tutorial in the Intermediate Users’ Guide to Microsoft Word.

I found it doing these searches:

I needed them because I misread it at first and replaced { SAVEDATE \* MERGEFORMAT } with { SAVEDATE \* "dd-mm-yyyy" } which resulted in the field to become displayed as needed Error! Unknown switch argument.. and at first thought this might be a Windows versus MacOS thing.

Fixing the error with { SAVEDATE \@ "dd-mm-yyyy" }) almost solved the problem, as the actual format should be { SAVEDATE \@ "dd-MM-yyyy" } (which displays month number instead of minute number).

So I learned that Word date formatting is almost the same as Excel date formatting.

I was specifically looking for these bits (the first luckily has the #Charformat anchor and was immediately followed by the latter):

Read the rest of this entry »

Posted in Office, Power User, Word | Leave a Comment »

Belastingaangifte 2022 met Excel gratis downloaden | Computer Idee

Posted by jpluimers on 2023/08/31

Net op tijd gelukt met de Excel tool van Computer Idee die dit jaar wat lastiger te vinden was dan vorig jaar

Vorig jaar blogde ik dit: Belastingaangifte 2021 met Excel gratis downloaden | Computer Idee

De links van dit jaar:

Read the rest of this entry »

Posted in Excel, LifeHacker, Office, Power User | Leave a Comment »

Excel for MacOS seems to have no post-paste shortcut to modify the paste options

Posted by jpluimers on 2023/02/24

Excel on Windows has a neat trick where you can press the Ctrl key after a paste operation.

This lets you determine after pasting if you want to change the [Wayback/Archive] Paste options in a similar way “Paste Special” will modify this while pasting as shown for instance at [Archive] What is the Excel keyboard shortcut for ‘paste special’? – Quora (excluded from the WayBack machine)

  1. Copy your source (Ctrl + C)
  2. Press Ctrl + V – Pastes as usual
  3. Press Ctrl – Paste options get displayed
  4. Press ‘P’ for paste special /‘V’ for values/’F’ for formulas etc

and [Wayback/Archive] Shortcut in Word or Excel for Special Paste?

Word 2013:

After having copied something go where you want to paste it (without pasting the format). CTRL+V (it will temporarily paste the format too) then CTRL (push and release the control key) then T (the last T means “keep text only”).

Excel 2013:

After having copied something go where you want to paste it (without pasting the format). CTRL+V (it will temporarily paste the format too) then CTRL (push and release the control key) then V (the last V means “paste Values”).
It’s important that the second CTRL key is released before typing the last letter.
This method requires just 4 keyboard hits, no macros and no use of the mouse in a dialog window.

The cool thing about this feature is that you can visually see the original paste, then determine how you want to modify it.

On MacOS, there is the post-paste glyph you can click, but no keyboard shortcut.

Basically, here are three ways I now work on MacOS while pasting:

  • When I really want to paste all properties on the ckipboard:
    • Command–V: Paste
  • When I want to decide which properties to copy:
    • Ctrl–Command–V: Paste Special
  • When I want just text:
    • Ctrl–U, Command–V: Edit cell, Paste

On MacOS, Ctrl–U is the equivalent of F2 on Windows (similarly, Command–T is the equivalent of F4) and brings the cell into edit mode before pasting. The mouse-equivalent is double clicking the cell before pasting.

I got that Ctrl–U / F2 trick from [Wayback/Archive] Always Match Destination Formatting | PCMag via [Wayback/Archive] Excel copy-paste: always match destination formatting – Super User.

Related

All based on [Wayback/Archive] macos excel “paste options” shortcut – Google Search

–jeroen

Posted in Excel, Office, Power User | Leave a Comment »

« Previous Entries
Next Entries »