I think it might be nice if the add decimal place and delete decimal place commands (.uno:NumberFormatIncDecimals, .uno:NumberFormatDecDecimals) also worked with additional commands like date and time number formats. For example, if a user entered '09:00 AM', it is automatically set to number format HH:MM:SS AM/PM ('09:00:00 AM') and then it would be nice to be able to press delete decimal to change it to HH:MM AM/PM and pressing delete decimal again and it changes to HH AM/PM. It would work in a similar but reverse way when pressing add decimal, all the way to HH:MM:SS.00 AM/PM. Adding and deleting decimals for dates would work in a similar way to add or remove the day, month, etc. (e.g. YYYY-MM-DD -> YYYY-MM -> YYYY) and it would also work with date + time combos like 'MM/DD/YY HH:MM AM/PM'.
Question would have to be if the styling of the number format for any other data classes affects its actual stored value. If so, then should not go that route for that data type.
(In reply to V Stuart Foote from comment #1) > Question would have to be if the styling of the number format for any other > data classes affects its actual stored value. The number format never affects the actual stored value, or a misunderstanding what you are saying.
First of all the increase/decrease function for date would be limited in contrast to numbers, which could be done easily I guess. More relevant is the variable type of datetime values. Users can have MM-YY or YY-MM, how would you increase the precision here? And for the time part it's mostly to add seconds or not since hours alone are useless and milliseconds not so relevant for the average user (otherwise needed rather than "deciseconds" or "centiseconds"). On the other hand it's a typical task for me. Looking forward more opinions.
(In reply to Heiko Tietze from comment #3) > First of all the increase/decrease function for date would be limited in > contrast to numbers, which could be done easily I guess. True. > More relevant is the variable type of datetime values. Users can have MM-YY > or YY-MM, how would you increase the precision here? With YY-MM it would increase to YY-MM-DD, with MM-YY it would increase to DD-MM-YY. > And for the time part > it's mostly to add seconds or not since hours alone are useless and > milliseconds not so relevant for the average user (otherwise needed rather > than "deciseconds" or "centiseconds"). It is mainly to easily add and remove minutes, seconds. If i type '9 am', it will change the input and format it to '09:00:00 AM' (HH:MM:SS AM/PM), so easily removing the seconds and minutes is quite useful.
(In reply to Yousuf Philips (jay) from comment #4) > (In reply to Heiko Tietze from comment #3) > > First of all the increase/decrease function for date would be limited in > > contrast to numbers, which could be done easily I guess. > > True. > > > More relevant is the variable type of datetime values. Users can have MM-YY > > or YY-MM, how would you increase the precision here? > > With YY-MM it would increase to YY-MM-DD, with MM-YY it would increase to > DD-MM-YY. According to his localization, user may expect MM-DD-YY or D-MM-YY. (In reply to Heiko Tietze from comment #3) > On the other hand it's a typical task for me. Looking forward more opinions. As I enhanced "Add/Delete decimal place" button for scientific format, I can give you some pointer if you need. See bug 88960
Reasonable request. If you add the code pointers, LBP, we get a fully qualified easyhack.
As said in comment 5 all pointers can be found in resolution of bug 88960 https://gerrit.libreoffice.org/14264/ void ScViewFunc::ChangeNumFmtDecimals( bool bIncrement ) https://opengrok.libreoffice.org/s?defs=ChangeNumFmtDecimals&project=core if bIncrement ==> positive increment Date and time formats are not treated yet.
I'm interested to work on this with 2 co-workers of mine. I'm not sure which function displays the dialog window to add/delete decimal places but I hope I will find it. If someone knows the function, please let me know. I have started working on that so I am assigning this to me.
A polite ping, still working on this bug?
Yes, I'm still working on it. I think I've done everything needed for the "Time accuracy" with my co-worker. We still have an issue though So we are trying to fix it and proceed with "Date"
Dear Kyrama Styliani, This bug has been in ASSIGNED status for more than 3 months without any activity. Resetting it to NEW. Please assigned it back to yourself if you're still working on this.
I've got a solution for 100th second
Laurent BP committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/1861363d623963461905f42aa0b9dc2301f2eaaa tdf#103414 Add/Delete decimal for 100th second It will be available in 7.1.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Laurent BP committed a patch related to this issue. It has been pushed to "libreoffice-7-0": https://git.libreoffice.org/core/commit/82365fe69c15c65589f709d539ed8e9c4f86a48e tdf#103414 Add/Delete decimal for 100th second It will be available in 7.0.0.1. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
@Laurent, the patch is in both branches, master ( 7.1 ) and 7.0
(In reply to Xisco Faulí from comment #16) > @Laurent, the patch is in both branches, master ( 7.1 ) and 7.0 I though that target should be only the oldest branch. Sorry for the noise. I plan to next fix Add/Delete seconds, if minutes and hours are present. I have some doubt about doing the same with minutes, days, months.
A polite ping to Laurent BP: Is this bug fixed? if so, could you please close it as RESOLVED FIXED ? Otherwise, Could you please explain what's missing? Thanks
My patch was rejected by Eike because it does not consider sidebar parameters: https://gerrit.libreoffice.org/c/core/+/96980