When selecting a range of cells, there's a sort of status bar to the left of the zoom slider where you can read by default the sum of the range. If you right click this text, you can choose wether to show the average, the count, max, min, etc. This is great; the request I'm asking for is to show more than one of this indicators. On normal monitor resolutions there's space for adding aditional information, so I think joinig data strings is possible. Maybe the quickest way to develop this is to change the toogle box for a tick box, allowing the user to select more than one option. That's all, thanks.
What's even more, this is a regression of some sort, as a few people were used to seeing both Sum and Average at the same time. I often used this, and it's no longer there. In OpenOffice 3.2 you had only 2 options in that list: Sum/Average None Where the first one would show: Sum=<value> Average=<value> Ideally we could tick more than one option to have it added to the list, but if that's not possible/desired, at least the option "Sum/Average" would need to be restored.
for those interested, I came accross some related identifiers in /svx/source/stbctrls/stbctrls.src
Is this valuable suggestion (which is > a year old) dead? The ability to see multiple values of one's choosing on the status bar is of immense value and can only add a feather to LibreOffice's cap. In the real world, these kinds of "small, non-life threatening" features make a big difference when office software adoption is considered. Please don't let LibreOffice lose out!
Created attachment 74147 [details] screenshot example This screen shot shows the implementation in Excel. Its excellent and useful every day.
I really want this feature.
(In reply to comment #5) > I really want this feature. thanks for the example. If you really want this, pls think about how you would be able to help. Cor
Wish i was a programmer. I will be happy to test the feature in beta if someone codes it. Seems like a pretty easy enhancement if inwas a programmer :p
Hi, I'd recently implemented 'Selection count' feature in the same list of selections : 'Sum', 'Count', ... I feel that having worked on it, I may find myself comfortable working on it. Can I get some pointers for the same please ? Thanks and Regards, Prashant
*** Bug 66220 has been marked as a duplicate of this bug. ***
Not sure how to vote for this, but does anyone know the status? Is this still not implemented due to lack of code contribution for it or lack of agreement that it should indeed be implemented?
Hi, (In reply to comment #10) > Not sure how to vote for this, but does anyone know the status? Is this > still not implemented due to lack of code contribution for it or lack of > agreement that it should indeed be implemented? I don't expect disagreement on this. It's just that developers work on different stuff atm. If you have a little experience: it's not that hard with help of other developers to start working on this..
Team, I am working in a company which need to manage large volume of data. For my case, I need count and sum at the same status bar. Currently all are depending excel to manage the medium sized data, If any one try to use libeO, there are certain difficulties to overcome like this. This is one of those simple bugs to be fixed for libO spread sheet's smooth running. I dont know why, you team is not working on this. This is not a request, a prayer from spread sheet users. Keenly waiting , Regargs; Nikhil India 919946609086
(This is an automated message.) LibreOffice development currently prioritizes bugs with the so called MAB (most annoying bugs) -- as this bug has not run through that process (including writing a short rationale for this bug being a candidate and other who are watching the tracker bug silently approving that rationale etc.) its priority is set to high. Note this is effectively no change in the urgency assigned to this bug, as we are currently not making a difference between high and highest and severity is untouched. You can find out more about MABs and how the process works by contacting libreoffice qa on irc: http://webchat.freenode.net/?channels=libreoffice-qa The QA wiki page also gives you hints on how to get in contact with the team (if IRC fails you, your next best choice is the mailing list): https://wiki.documentfoundation.org/QA
(In reply to Nicolás Adamo from comment #0) > When selecting a range of cells, there's a sort of status bar to the left of > the zoom slider where you can read by default the sum of the range. If you > right click this text, you can choose wether to show the average, the count, > max, min, etc. > This is great; the request I'm asking for is to show more than one of this > indicators. On normal monitor resolutions there's space for adding aditional > information, so I think joinig data strings is possible. Maybe the quickest > way to develop this is to change the toogle box for a tick box, allowing the > user to select more than one option. > > That's all, thanks. I'm not a programmer but a user, and I vote it as an important enhancement request.
Hi all, This is a very valuable enhancement request! Is is an improvement compared to the original OpenOffice.org behaviour. Therefore the version is set to "Inherited from OOo" The field shows the oldest version with the behaviour. Pls don't change that value :)
Hi Prashant, (In reply to Prashant from comment #8) > I'd recently implemented 'Selection count' feature in the same list of > selections : 'Sum', 'Count', ... Thanks a lot for that :) (I've been distracted for some time and missed this news) > I feel that having worked on it, I may find myself comfortable working on > it. Can I get some pointers for the same please ? Do you still have time/interest :) ? Usually entering the developer list is the way to go. If needed.. I could help finding a contact, but that may be superfluous ;) Regards, Cor
I'm not a programmer anymore (unfortunately), but I'd like to see this feature implemented. Could it be a good idea to insert it among "Easy Hacks"? Or it's not that so easy? I know a coder wondering to join TDF…
nice.
hi same topic, but another feature that would be good to implement: when you right-click on the "Sum=XX", it could display the value beside each function. Google spreadsheet does this, it's very pleasurable
It is a really useful feature. I need this. Is not it difficult to implement. Will be implemented in 5.1? :) Come on, come on, come on! :D
(In reply to Giovanni Sardisco from comment #20) > It is a really useful feature. > I need this. > Is not it difficult to implement. Sure :) > Will be implemented in 5.1? :) Well... https://wiki.documentfoundation.org/Development/GetInvolved
*** Bug 94778 has been marked as a duplicate of this bug. ***
I will make an attempt to add this feature.
Submitted a patch for this at https://gerrit.libreoffice.org/#/c/22060/ for review.
Dennis Francis committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=7bc97db5b972f27693161beb9182f8a5850f5551 tdf#42629 : Allow multiple status bar functions at a time It will be available in 5.2.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.
(In reply to Commit Notification from comment #25) > Affected users are encouraged to test the fix and report feedback. For the selected range C6:C9 in the screenshot the ‘Customize Status Bar’ has left justified Average, Count and Sum and right justified 2.5, 4 and 5, respectively. Would it be possible to implement this feature in LibreOffice too? Additionally, would Minimum and Maximum values of 2 and 3 respectively show in the Customize Status Bar for LibreOffice also? Thank you
Great to see this addition ! If I can make a suggestion, currently there is no spacing between functions in the status bar. Which makes it hard to read. E.g. Average=4.5;Count=8;Max=8;Sum=36 I think quadruple-spacing and using colons works out better: Average: 4.5 Count: 8 Max: 8 Sum: 36 This is exactly what Microsoft Office is doing. Spacing may depend on the font, here it seems a lot because of the proportional font.
Hi Dag, (In reply to Dag Wieers from comment #27) > I think quadruple-spacing and using colons works out better: > > Average: 4.5 Count: 8 Max: 8 Sum: 36 Yes, nice. But you don't build LibreOffice yourself (yet ;) ) ? I assume Dennis would not mind if you do that change. But of course: feel free, no obligation :) Cheers - Cor
Cor, Nope, never succeeded :-/ But for this I don't need to be able to compile. https://github.com/LibreOffice/core/pull/6 PS Unfortunately it doesn't seem the project is actually using Github.
BTW Someone needs to revise the instructions at: https://wiki.documentfoundation.org/Development/gerrit I couldn't make Google OpenID work, the OAuth stuff doesn't seem to be available (not sure how it is supposed to work either) and the only other OpenID provider I have from the list is StackExchange and while I authenticated fine, I cannot login or register properly. (4 successful logins according to StackExchange OpenID provider, fails in Gerrit) Sorry, but with GitHub I had it forked, patched and committed in 2 minutes. I now spend 20 minutes (!) trying to make register with Gerrit and failed... Do we really want to alienate drive-by contributors ?
Finally, https://gerrit.libreoffice.org/#/c/23196/ !
@jani: (In reply to Dag Wieers from comment #30) > BTW Someone needs to revise the instructions at: > > https://wiki.documentfoundation.org/Development/gerrit > (read comment #30 ) @dag (In reply to Dag Wieers from comment #31) > Finally, https://gerrit.libreoffice.org/#/c/23196/ ! Hurray :)
@jani: (cfr. comment #30) I succeeded by using my Yahoo ID, which I didn't know I had but apparently was related to my old ICQ account ! So at least that did work. (Never expected to get an email when I tried the "forgot password" link...)
(In reply to Dag Wieers from comment #31) > Finally, https://gerrit.libreoffice.org/#/c/23196/ ! https://gerrit.libreoffice.org/#/c/23196/1/sc/source/ui/view/tabvwsha.cxx You changed aStr += "="; to aStr += ":"; Did you mean aStr += ": "; Your change seems to produce Average:4.5 Count:8 Max:8 Sum:36 Instead of your proposed change at comment #27 Average: 4.5 Count: 8 Max: 8 Sum: 36
There was a second commit adding that space in Gerrit. I don't know how Gerrit works, but I couldn't figure out the equivalent of a pull-request in Github where on can add another commit to the pull-request before it is merged. So I was basically forced to add a second commit to Gerrit...
(In reply to Dag Wieers from comment #35) > There was a second commit adding that space in Gerrit. > > I don't know how Gerrit works, but I couldn't figure out the equivalent of a > pull-request in Github where on can add another commit to the pull-request > before it is merged. > > So I was basically forced to add a second commit to Gerrit... If you do not know how gerrit works, then it is a good idea to read about it, e.g. in our wiki. Here is a link (which you got earlier): https://wiki.documentfoundation.org/Development/GetInvolved that gives you a simple way of using gerrit.
(In reply to Cor Nouws from comment #32) > @jani: > > (In reply to Dag Wieers from comment #30) > > BTW Someone needs to revise the instructions at: > > > > https://wiki.documentfoundation.org/Development/gerrit > > > (read comment #30 ) These instruction are correct, just checked them, the problem here seems different. @dag we do not use github for many reasons, but have a mirror of the code base there. This means you can perfectly pull from github, but need to submit using gerrit. We use gerrit, because it gives a lot better workflow, than the usual push requests in Github. Gerrit is used to review all patches, before they are merged to master, which saves us from quite a lot of problem. When you use gerrit, your patch gets automatically build and verified on all our supported platforms. > > @dag > (In reply to Dag Wieers from comment #31) > > Finally, https://gerrit.libreoffice.org/#/c/23196/ ! > > Hurray :)
(In reply to Dag Wieers from comment #35) > There was a second commit adding that space in Gerrit. > > I don't know how Gerrit works, but I couldn't figure out the equivalent of a > pull-request in Github where on can add another commit to the pull-request > before it is merged. > > So I was basically forced to add a second commit to Gerrit... The trick is to preserve the “Change-Id” line so that it matches the one from the commit you want to amend. I’ve explained it a bit further in your second Gerrit thread. Now I’ve locally squashed both of your patches together and pushed. I’ll close this bug again as FIXED since Dennis has fulfilled the original request (thanks!). A RESOLVED bug doesn’t mean that it won’t accept further tweaks, so no need to reopen it ;-)
Dag Wieers committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=f1ff9375184607b86ae8807d7cf1220962425b51 Related: tdf#42629 Improve the readability of the status bar functions It will be available in 5.2.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.
It is unfortunate that the initial proposal was modified to only use a single space between name-value pairs. That was exactly what made it harder to read. And likely is the reason why Microsoft also choose multiple spaces between name-value sequences. Also adding a semicolon delimiter brings absolutely nothing to the status-bar except for making it harder to read for people with sight-disabilities. Mind you that 4 spaces with a non-proportional font is not that much. I think Microsoft even uses more spacing in between name-value pairs. So we went from the original proposal: Average=4.5;Count=8;Max=8;Sum=36 to an improvement: Average: 4.5 Count: 8 Max: 8 Sum: 36 and almost back to square one: Average: 4.5; Count: 8; Max: 8; Sum: 36 A big mistake IMO
(In reply to Dag Wieers from comment #40) In my opinion it's a waste of spaces to have so four spaces for the calculation result. The space can be used for more functionalities in yhe future.
Of course it is not a waste if it improves readability. Again the spaces in a non-proportional fonts are smaller than what you see here, so it may be deceiving you. Please copy&paste it into LibreOffice with a non-proportional font and look for yourself. Can we maybe have a usability expert involved ? PS If you'd look at Microsoft Office we wouldn't actually be discussing this here...
Dag: Just because Microsoft does it, it doesn’t mean we should as well.
Adolfo, did I just say that ? No I did not. I said that if you would be seeing the difference between the current LibreOffice implementation and what Microsoft has implemented, it is very obvious that what Microsoft is doing is far more readable (less effort to parse it) than with semicolons and a single space. Don't take my word (or your Microsoft-aversion) for it, look at it instead of theorizing. Anyway, this is going nowhere. Good luck.
Bug 42629 +1 for Dag Wieers suggestion at comment #27, i.e. I think quadruple-spacing and using colons works out better: Average: 4.5 Count: 8 Max: 8 Sum: 36 It would seem that Cor Nouws agrees too (comment #28). Whitespace is easier on the eyes than punctuation, aka “Improve the readability of the status bar functions”. This feature would seem most useful with devices which have a larger monitor/screen. Solutions to satisfy the concerns of Samuel Mehrbrodt and Adolfo Jayme Barrientos (https://gerrit.libreoffice.org/#/c/23196/) are: a) Implement comment #26; and/or b) Implement a Tooltip/Popover (http://caolanm.blogspot.com.au/2016/02/current-libreoffice-native-gtk3-elements.html) to show values, i.e. Average: 4.5 Count: 8 Max: 8 Sum: 36 or Average: 4.5; Count: 8; Max: 8; Sum: 36 Please re-implement Dag Wieers patch and if required, provide a: a) patch for comment #26; and/or b) Tooltip/Popover showing the values. Thank you
*** Bug 98951 has been marked as a duplicate of this bug. ***
Hi all, So something sadly derailed here :\ I can only imagine that Adolfo joined here with best intentions and spent efforts to help. However the current state is not looking fair for Dag his work, notably the first he did with all extra efforts involved.. As Óvári makes clear, I see no reason too for not following the initial patch from Dag. @Adolfo, what do you think? Thanks a lot! Cor
True. The formula bar appears to the right of the name box and displays a formula. http://customwritingcompany.com/essay-helper/
Nice one. Check your WAEC Result here https://www.recruitmentbeam.com.ng/waec-timetable-pdf/
https://coderkube.com/ <a href="https://coderkube.com/usa/best-seo-company/">SEO company in USA</a> <a href="https://coderkube.com/services/web-designing/">Web Designing company in USA</a> <a href="https://coderkube.com/services/web-development/">Web Development company in USA</a> <a href="https://coderkube.com/services/android-app-development/">Android App Development company in USA</a> <a href="https://coderkube.com/services/iphone-app-development/">iPhone App Development company in USA</a>
Nice article. Visit Npower recruitment portal https://www.nba.org.ng/federal-fire-service-recruitment/ https://www.nba.org.ng/ https://www.nba.org.ng/npvn-npower-gov-ng-my-profile/
<a href='https://jugaad.az/smm-xidmeti/'> SMM </a> and <a href=' https://jugaad.az/seo-xidmeti/ '> SEO </a> services
The Peryourhealth Medical Billing Portal is a new, streamlined electronic billing program designed by a leading health care billing software and consulting firm. Nowadays everyone wants a flexible and feasible way to finish all their daily needs, no one prefers the time-consuming peryourhealth online payment system at peryourhealth.com https://peryourhealth.ninja
Very Effective Tips. Thanks for sharing. Check your JAMB Result here https://www.downloadpastquestion.com.ng/check-jamb-results/
Thanks for this wonderful piece of article. https://bestschoolnews.com/nigeria-air-force-recruitment-form/
I'll close so people stop using it for spam purposes... Thanks LibreOffice Devs for solving it!
Very informative tips. Thanks for sharing
Thanks for sharing the comprehensive post, your post having informative & valuable content, it will be helpful. <a href="https:/adfilmmakers.com/"> Advertising Companies in Hyderabad</a>