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
Category: Hacks
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
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
Add Javascript to a Single Post
Hi WP header
Unmask masked “password” form fields with Javascript link
Add this as the properties of a favorite or bookmark. javascript:var%20els%20=%20document.getElementsByTagName(‘input’);%20for(var%20x=0;%20x<els.length;%20x++){if(els[x].type.toLowerCase()==’password’){var%20test=els[x].type=’text’;}}
understanding html5 meter behavior
Discounting the gray background, the default meter element was able to display three colors: red, yellow, and green. Zones or ranges are the key to understanding which values will result in which color. Assuming values min < low < high < max, three zones can be created by setting values for the low and high… Continue reading understanding html5 meter behavior