Sorry. I didn't study every detail of this thread before I posted my suggestions.
Somehow related:
On 2020-03-13 there was a question in a different community site, and since I wasn't fully mobile at that time, I felt a bit bored, and took the time to design a solution.
You may visit the mentioned topic:
https://ask.libreoffice.org/t/add-short ... -day/50306.
On 2020-07-08 there was another attack of boredom, and I made an enhanced version including additional information.
Based on this version I just did a little bit of superficial updating, and you find the result attached here:
Please don't miss to read:
Already the first version accepted as a fact that there are no "floating buttons" and that a workaround implementing them is possible (based on a
onSelectionChanged handler), but rather complicated: much ado about little functionality.
Since "default" incrementing / decrementing isn't the same for everybody in every case, and since breaking boredom by programming requires a credible challenge, I first considered the desirable flexibility. This lead to some decisions:
- Shortcuts aren't an option because they (1)cannot be defined for a document, and (2)too many would be needed.
- Even "floating buttons" wouldn't be good. Again too many needed, because no sufficient modification is supported.
- The sensitive element must be a toolbar (floating probably) therefore.
- The functionality can then be modified by using the keys rightfully called
modifiers.
-
The stepwidth should depend on the NumberFormat of the addressed cell. (No sense in incrementing a date by 100 days, e.g.)
Visitors considering to use a floating toolbar stored to the document should know that the
floating may need to be re-eastablished after opening the document in a different environment. The attached example was stored with the toolbar shown in the merged area Q3:S3.
Considerations and development of the used code were a lot of fun. However, I never
used it myself. It doesn't suit my style of working. What I have to offer here isn't suitable for a tablet. In my world tablets are a plague anyway, but my world isn't yours. If you want to apply the principles of the solution, but to adapt it to your needs, the simplest way to replace the modifier functionality would be to omit (not use) the related code, and to add sensitive areas to your document toolbar including the modifications. You will need then an additional one-line-caller per area.
Finally: AOO doesn't support the
Alt modifyer with toolbar clicks.
On Windows 10: LibreOffice 24.2 (new numbering) and older versions, PortableOpenOffice 4.1.7 and older, StarOffice 5.2
---
Lupp from München