Rules for pasting large text to Gutenberg / WordPress

Here’s the rule of thumb:

  1. Gutenberg changes pasted large text into separate blocks, if you have two line separation between paragraphs,
  2. If you have single line paragraph separation then Gutenberg will paste whole text into single block.

If you’re pasting from Word or other rich editor then everything should be OK. But, if you’re pasting from some non-rich text editor (I am using Notepad++) and you have a single line paragraph separation then a short trick must be done prior pasting text to Gutenberg.

Read more

“Unprotect” a sheet or a workbook in Excel

Microsoft developers’ ignorance has hit jackpot one more time. If you “protect” a sheet or workbook, Excel only places a special tag inside .xlsx file. Changing it and thus “unprotecting” such file is a piece of cake.

You can remove it in a matter of two minutes using software like Total Commander or 7-Zip. By doing so, you can gain access to “protected” sheet or workbook without knowing a password. Something that in theory should never happen.

In previous versions of Excel (Office) that were using old .xls file you had to work with some nasty, multi-level macro to unprotect a protected file. Now they have made even easier. Instead of using some dully macros all you need is a text editor and a file to unpack and repack archive.

Read More ““Unprotect” a sheet or a workbook in Excel”