Description: Currently in Calc links to external data can only be jupdated on a user specified but fixed interval. I would like to be able to specify a more complex update schedule, between two times of day for example. e.g Update every 15 minutes from 6:30am to 1pm but do not update at all between 1pm and 6:30am and do not upate at all on Saturday or Sunday (same schedule as NYSE but adjusted for PST time) Steps to Reproduce: 1. Menu Sheet->Link to External Data 2. Checkbox "Update every and an input box to sepcify seconds 3. Remove this (step 2) and replace it with a more advanced option to configure a realistic update schedule Actual Results: Can only set a fixed repeating interval in seconds Expected Results: Should be able to set a realistic update schedule including update interval within a specified time block including time of day start and end, and days allowed etc etc. Kind of like cron does although please dont make us use that format. A GUI dialog allowing the selection of start stop time interval & days of week etc would be nice Reproducible: Always User Profile Reset: No Additional Info: User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:50.0) Gecko/20100101 Firefox/50.0
I'm afraid this goes into such marginal territory that it would be best served as an extension. Closing as WONTFIX. https://wiki.documentfoundation.org/Development/Extension_Development