In a form, you often want to suggest a default date. It just became very easy to suggest a perfect default date in the correct local date format.
Nov 26, 2018 — SpreadsheetConverter is an add-on to Microsoft Excel that converts spreadsheets to live, calculating web pages. The new version 10.2 recently became available at SpreadsheetConverter.com.
Many electronic forms contain dates, either in the past, in the future or for the current day. Dates may be fully visible in the form, e.g. for a requested period of absence, or used in hidden timestamps, e.g. to record on what date a particular request was submitted. The formula required to properly calculate a perfect default date to suggest in the form can be quite complicated.
“Let’s say you want a date field to suggest Thursday, next week. It’s hard to find a form editor that handles even that minor complexity. We support almost all Excel functions, so you can calculate a default date in just about any way you can come up with”, says Anna Winter, sales manager for SpreadsheetConverter.
A common problem is to format dates properly for a global audience. Americans are used to the month/day/year notation, but Europeans often prefer day/month/year and the ISO standard even suggests year-month-day for written dates.
“Eventually, we will find a way show all dates in the format that each individual user prefers. Until then, we allow the developer to select the target country and language before we create the web page”, says Winter.
Selecting a language for the web page also allows SpreadsheetConverter to translate the calendar to the local language.
“Spanish users may not immediately understand common English calendar abbreviations like ‘Su’, ‘Mo’ or ‘Tu’. When converted for Spain, the calendar will first of all start on a Monday, with the weekdays correctly referred to as ‘Lu’, ‘Ma’ and ‘Mi'”, she says.
SpreadsheetConverter is available for free trial at spreadsheetconverter.com/buy/free-trial/. It creates web pages that are completely standalone, do not use Excel and run on all web servers. You only need Excel and the Spreadsheet Converter add-on for the actual conversion from spreadsheet to web page format. There is a one-time fee for the conversion program, with no extra fees per page, user or server. You may use the program and the web pages it creates for as long as you like. Full versions start at $127.
Media contact: Anna Winter, firstname.lastname@example.org