Hello Bill, That's an interesting idea for working in Universal Time Coordinates and adjusting for values entered in a local civil time.
I think there are two cases. 1. Allowing Calc to record UTC so that it stays UTC even when interchanged with someone in a different timezone (or when local civil time offset changes with the seasons or, as has happened, changes permanently [;<). 2. Likewise with regard to what Base presents. This may run afoul of what connected databases do with dates and times though, so there is the small problem of knowing what the precision of a database date-time is (just like there is when receiving a spreadsheet where the cells are not timezone or UTC fixed) and, perhaps, what the local dateTime was when the value was created. It may be easier for documents that are only used personally and never interchanged (and so long as computer clock settings stay correct), but I think OpenOffice needs to consider more variations than that. However, a solution should not block evolution to a broader solution that works in interchange across space and time. Both of these cases merit feature requests. The appropriate next step is to create two Bugzilla issues after checking to see whether there are such requests for such features already. Please continue discussion and follow-up on the dev@ openoffice.apache.org list. For Bugzilla, go to <https://issues.apache.org/ooo/>. You can search without creating an account. You will need to register to create an enhancement request, and you'll automatically receive notification of discussion on any issue you file. - Dennis More thoughts on item (1) above. There are complications depending on how a date is recorded in the cell of the spreadsheet table. When a cell is of date or dateTime type, it can carry a precise date (or even carry a date with a specific civil time offset). In many cases, the cell is actually of Number type and the appearance of a date is accomplished in the formatting of how the date is presented and how values are converted when entered. All of these cases are specified to work in ODF Tables and ODF Spreadsheets. It would be useful to confirm how the implementation in Apache OpenOffice works by making some simple Calc test spreadsheets. -----Original Message----- From: bill harrison [mailto:msnplsh...@gmail.com] Sent: Monday, February 2, 2015 03:24 To: dev@openoffice.apache.org Subject: Request for future Hello, I apologize if this is the wrong place to mail this type of request. In Calc one can do just about anything with time. In my case I am wanting to convert local TimeStamp time into (Universal Coordinated time) UTC. In Calc this is so easy, one simply calculates the new UTC time in another cell by taking the (local TimeStamp - 6/24) which results in UTC time. Then apply the proper formatting and it's perfect. However, when you try to convert Local TimeStamp in Base it's certainly not as easy. So I am sticking my old neck out and asking (Requesting) that the developers of Base would look at the possibilities of ammending the Base project to allow users to do these simple time conversions without much effort. Thanks So Much.. cub001 Bill --------------------------------------------------------------------- To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org For additional commands, e-mail: dev-h...@openoffice.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org For additional commands, e-mail: dev-h...@openoffice.apache.org
