Caused when inserting rows under as yet unknown conditions After much editing of a mid-size worksheet, including inserting and or deleting rows, you notice data validations (DV) and comments (C) have not followed the cell into which they were originally entered. Perhaps there is a programmatic method to relocate data validations and comments, but herein… Continue reading OnlyOffice Desktop Editors Relocate Comments & Data Validations
Author: Dario
OnlyOffice Desktop Editors Workbook Defined Names Export & Import
Excerpt from workbook.xml<definedNames><definedName name=”Energy_of_Cooking” localSheetId=”0″ hidden=”0″>=Lists!$A$247</definedName>
HTML Input Pattern Attribute to Validate Non-Latin International Characters
HTML5’s input pattern attribute in most 2025 browsers invalidated email addresses if they contained non-latin characters. A custom pattern of any complexity could be implemented. Most browsers would apply both the built-in and custom pattern, but the built-in email pattern would invalidate any non-latin characters. The only remaining option was to use input type=”text” to… Continue reading HTML Input Pattern Attribute to Validate Non-Latin International Characters
Replace Caravan/Town & Country Sliding Door Lock Actuator
These instructions were specific to a 2015 Dodge Grand Caravan with fixed glass in the sliding side doors, but may be applicable to other models. General Tips REMOVE Door Lock Actuator To remove the door panel, first remove 2 smaller trim panels: 1st rear lower corner of window (pry front edge up about 1 cm.… Continue reading Replace Caravan/Town & Country Sliding Door Lock Actuator
Subscribed Cloud Calendar Not Displaying All Events
Preamble ‘Internet’ or ‘Cloud’ calendars attract us by their ability to share events with multiple devices or persons. These calendars typically offer two access options: 1) your web browser on the publisher’s website, or 2) your calendar user client application with a subscription. There are many non-Google calendar clients (NGCCs), including Thunderbird. While these principles… Continue reading Subscribed Cloud Calendar Not Displaying All Events
Move/Copy HTTPS Certificate from Apache to IIS
You find yourself in the situation where you have a viable HTTPS certificate running on a Linux, and you would like to run that same server certificate on Internet Information Services (IIS). Most of the documentation assumes you already have the .pfx file, or you can simply export it from your IIS web server, which… Continue reading Move/Copy HTTPS Certificate from Apache to IIS
Add TLS 1.2 to IIS 7.5
After about March of 2020, if you were using IIS 7.5 web server, and you needed to provide content secured by HTTPS, you discovered that SSL was no longer supported by contemporary browsers. They were demanding a connection secured by TLS 1.2, before displaying any web content. On the bright side, TLS 1.2 was built… Continue reading Add TLS 1.2 to IIS 7.5
Add Javascript to a Single Post
Hi WP header
VBA Characters Method Bugs: Comments vs TextBoxes
Vagaries of the Characters() Method In Excel 2010, version 14, the Characters method of Shapes did not, and in newer versions may still not, build and return a character object containing expected property values. The good news: No deficiencies were identified when working with cell contents. With Comments Two issues were observed when argument parameters… Continue reading VBA Characters Method Bugs: Comments vs TextBoxes
Test Hide Title
Heading should go here A single paragraph post!