There is a control named "DateField" writing to a cell named "DateField"
There is a control named "TimeField" writing to a cell named "TimeField"
There is a control named "CurrencyField" writing to a cell named
"CurrencyField"
etc.
Each control has a "Text Modified" event which calls the macro.
The macro checks if a cell has the same name as the calling control. If so,
it writes an appropriate cell value into that cell.

This is a dirty hack. It applies to single cells only, e.g. you can't fill
columns of time data with this.
I always recommend databases. Most spreadsheet users try to simulate
databases in spreadsheets. Spreadsheet cells are NOT the normal target of
form controls. The controls are made for database records where one control
applies to all records of a whole column.



--
View this message in context: 
http://nabble.documentfoundation.org/Calculating-hours-using-spin-button-tp4203752p4204604.html
Sent from the Users mailing list archive at Nabble.com.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Reply via email to