Problem description: Mac Problem: This combination is used for making a picture of a selected area. Steps to reproduce: 1. .... 2. .... 3. .... Current behavior: The combination does not work to change numbers into the currency Euro. Expected behavior: A combination to change into the currency Euro. cmd+4 is free :o) Operating System: Mac OS X Version: 4.1.6.2 release
I'm sorry, what do you mean by "changing numbers to the Euro currency" ?
HI Alex, with the combination "Shift+cms+4" you can make a picture of the window under mac. But as long as this combination changes numbers into the currency euro, you can’t use it any longer to make a picture of the window. What you could do is, that you should leave the combination free and change the combination for this currency change :o) I hope that you understand what I mean. My English is not so good, sorry. Take care Eva Lächeln ist ein Miniurlaub für die Seele ;o) -----Ursprüngliche Mitteilung----- Von: bugzilla-daemon <bugzilla-daemon@freedesktop.org> An: eva.friedrich2 <eva.friedrich2@aol.com> Verschickt: Di, 30 Sept 2014 11:25 am Betreff: [Bug 78777] FORMATTING: Combination Shift+cmd+4 (Currency: Euro) " Alex Thurgood changed bug 78777 What Removed Added Status UNCONFIRMED NEEDINFO Ever confirmed 1 Comment # 1 on bug 78777 from " Alex Thurgood I'm sorry, what do you mean by "changing numbers to the Euro currency" ? You are receiving this mail because: You reported the bug.
Setting to UNCONFIRMED.
Hi Eva, Testing with LO 4400 alpha 2 : 1) Open a new Calc document 2) Type in some data 3) Press Shift Cmd 4 Expected : screenshot definable by user dragging mouse to define capture area Obtained : screenshot definable by user dragging mouse to define capture area So this worksforme on my Macbook. The key combo doesn't attempt to convert the cell format to Euro monetary currency. So I can not reproduce your problem.
Okay, so are you saying that Euro currency cell formatting style doesn't work with the Apple OS-defined keyboard shortcut ? If so, I agree.
Confirming that LO shouldn't use OSX predefined shortcuts to apply formatting styles.
** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present on a currently supported version of LibreOffice (5.0.4 or later) https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the version of LibreOffice and your operating system, and any changes you see in the bug behavior the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a short comment that includes your version of LibreOffice and Operating System Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to "inherited from OOo"; 4b. If the bug was not present in 3.3 - add "regression" to keyword Feel free to come ask questions or to say hello in our QA chat: http://webchat.freenode.net/?channels=libreoffice-qa Thank you for your help! -- The LibreOffice QA Team This NEW Message was generated on: 2015-12-20
Confirming on Version: 5.2.0.0.alpha0+ Build ID: ce3d3f5543e3e132a3473af27aa2c827336add0f CPU Threads: 2; OS Version: -; UI Render: default; Locale : fr-FR (fr.UTF-8)
Steps to reproduce : 1) Open a Calc document in cell A1 type 23,45 (French UI / locale) press enter in cell B1 type 76,89 (Fren UI /locale) press enter 2) Select both cells with the mouse / cursor keys 3) Press the keyboard shortcut - Shift+Cmd+4 What happens in Linux : the automatic number format Euro currency is applied What happens in Mac : the OSX screenshot utility is activated. Steps needed to correct this behaviour : LO should not try to assign system OS shortcuts to internal functions as these will fail on OSX. There is thus no shortcut for LibreOffice on OSX that allows this currency format to be applied quickly.
** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present on a currently supported version of LibreOffice (5.1.6 or 5.2.3 https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the version of LibreOffice and your operating system, and any changes you see in the bug behavior If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a short comment that includes your version of LibreOffice and Operating System Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to "inherited from OOo"; 4b. If the bug was not present in 3.3 - add "regression" to keyword Feel free to come ask questions or to say hello in our QA chat: http://webchat.freenode.net/?channels=libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug-20170103
Still present, cmd+shift+4 is a system shortcut used for screenshots, and can not be used to format as currency Raising importance as keyboard shortcuts are crucial for professionals. This also applies to format as date (cmd+shift+3, also screenshots) I think the UX team needs to take a look at this
Keyword needs CC
Shift+cmd+1,2,3,4,5,6 are assigned to the different value formats (3,4,6 are assigned to screenshots). We can go with a) Shift+alt+1..6, b) modify it to 1,2,5,7,8,9, or d) keep them empty for user customization. What would a macOS user prefer?
No dispute over confirming, so NEEDINFO is incorrect status
Comment received per mail votes for a).
Was just commenting on this, shift+alt can not be used as that is used to type symbols on a mac --- Mac Excel uses ctrl+shift+different keys for the formatting, and the alt+shift combo is actually used to type signs like ¡®¥¢‰¶, so it should be ctrl+shift that is used. Numbers don't have shortcuts for this. Excel uses the following (in parantheses the key it represents on a mac US keyboard layout) Apply the general number format: ~ (key above tab) Apply the currency format with two decimal places (negative numbers appear in red with parentheses): $ (4) Apply the percentage format with no decimal places: % (5) Apply the exponential number format with two decimal places: ^ (6) Apply the date format with the day, month, and year: # (3) Apply the time format with the hour and minute, and indicate AM or PM: @ (2) Apply the number format with two decimal places, thousands separator, and minus sign (-) for negative values: ! (1) So the logic is to use the first 7 keys on the top row with logical placement according to the signs (e.g., percent symbol to format as percent) Is it possible to localize the shortcuts? It can be quite annoying that keyboard layouts differ, and then the US keyboard logic fails. E.g., ~ is not on a Norwegian keyboard, you have to press alt+^ next to the return key to type it. If the shortcuts are defined with numbers instead of the symbol you actually type when holding down the shift key, then it is easier, and just an issue with the general number format.
heiko tietze committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=eb6531dcb19e61baff69356eda5fd7f2a5d46458 tdf#78777 - Keyboard shortcut for number format interfers with macOS defaults It will be available in 6.1.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Shortcuts are now assign by default to Shift+Alt+1..6
Sorry for being late in giving input on this, but the commit should be reverted and the shortcut be made the same as Windows/Linux to use ctrl+shift. Otherwise we will have bug reports from users who can't type ¡, ®, ¥, ¢, ‰, ¶ (which would be a valid new bug)
(In reply to eisa01 from comment #19) > Sorry for being late in giving input on this, but the commit should be > reverted and the shortcut be made the same as Windows/Linux to use > ctrl+shift. Otherwise we will have bug reports from users who can't type ¡, > ®, ¥, ¢, ‰, ¶ (which would be a valid new bug) On my German keyboard it's ¬ ” # £ fi ^ for shift+opt+1..6. Reverting is not an option. If you find people agreeing on the premise of being able to type very special characters over having a shortcut for number format I will clear the assignment (option c) from comment 13). Otherwise the workaround is to use the special character dialog.
(In reply to Heiko Tietze from comment #20) > Reverting is not an option. If you find people agreeing on the premise of > being able to type very special characters over having a shortcut for number > format I will clear the assignment (option c) from comment 13). Otherwise > the workaround is to use the special character dialog. The other option would be to use ctrl+shift which is what LO Win/Linux already uses, and what Mac Excel also uses. Being consistent across platforms would be even friendlier for users as it increases the discoverability of the shortcuts ;) And it still enables entry of special symbols (I fundamentally disagree that alt+shift is a good option for Mac as it breaks entry of these symbols and leaves LO as a second class citizen on Mac) I know we're all volunteers here with limited time on our hands, so if you don't feel like prioritizing this, I can see if I can find the time to write the patch (didn't seem too complicated) in the coming weeks :)
(In reply to eisa01 from comment #21) > The other option would be to use ctrl+shift which is what LO Win/Linux... Shift+cmd+1..6 are mostly occupied by shortcut functions, that's why the issue was filed. And those shortcuts are more known and used than very special characters.
Read through the bug, no strong feelings on this as I personally do not use this, but agree with eisa01: - shift+alt+1-6 not good since it - alters platform compatibility - overwrites existing functionality So shift+ctrl+1-6 would be the better solution. Disclaimer: I am not an expert on shortcuts :) But I take the liberty to re-open this to NEW. Hope that is ok. @Heiko if you strongly disagree, feel free to revert to fixed. Not sure about your comment 22, since you talk about shift+cmd+1-6 but eisa01 suggested shift+ctrl+1-6
(In reply to steve -_- from comment #23) > @Heiko if you strongly disagree, feel free to revert to fixed. Not sure > about your comment 22, since you talk about shift+cmd+1-6 but eisa01 > suggested shift+ctrl+1-6 Yes, I do. Ctrl=Cmd, shortcuts are universally assigned to those shortcuts.
Yes, cmd is the equivalent to Ctrl on Mac. But, there can still be valid reasons for deviating which LO Mac already does: The shortcut for selecting a row is ctrl+space across all platforms as Cmd+space is used for spotlight on Mac (not all localizations). MOD3 would indicate the Ctrl key on Mac in the accelerator configuration as far as I can tell Aside, alt (option) key shortcuts are not standard at all on Macs. They’re sometimes used together with cmd, but I can not recall any shortcut using option standalone in my life as a Mac user In fact, the option key is used for special signs, with and without shift
For clarification: we can use ctrl/cmd = mod1 and alt = mod2 but not the mac ctrl key. At least not out of the box.
Thanks for the tip with MOD3. That works (patch is submitted), though it breaks customization a bit (bug 34704) and the tooltip shows the alt symbol. I'll look into the issue.
New patch at https://gerrit.libreoffice.org/#/c/52966/ (customization for ctrl and correct symbol also submitted)
heiko tietze committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=a616d1e52fdf5f5ace39f8d706d89f4d28228dec tdf#78777 - Keyboard shortcut for number formatting on macOS It will be available in 6.1.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Shortcuts are not the macOS ctrl (^) + shift + 1..6