I think it would be very helpful if these features would be added to the Calc application 1. Add a cell format to recognize data capacity sizes (bit, byte, kilobyte etc.), just like time, phone and others. 2. Recognize lower case 'b' as bit and upper case 'B' as Byte 3. Recognize KB as KiloByte (x1000) and KiB as KibiByte (x1024) 4. when creating a sum function, add the option to choose the display meter (so when the sum is 2,040 KiloBytes, I can choose to display 1.9 MiB or 2,040 KiB) Thanks for the good job Yehuda
kohei->requirements? I would say, kb for 1000 bits, kB for 1000 Bytes Kb for 1024 bits and KB for 1024 bytes and so on... It could also be a candidate for EasyHacks. Adding a new number format: Start code: svl/inc/nfsymbol.hxx svl/source/numbers/zforlist.cxx
oh noes, take cover before the kibibyte crowd notices this bug report.
Actually we don't use prefixes in the title, but prefer whiteboard instead.
[This is an automated message.] This bug was filed before the changes to Bugzilla on 2011-10-16. Thus it started right out as NEW without ever being explicitly confirmed. The bug is changed to state NEEDINFO for this reason. To move this bug from NEEDINFO back to NEW please check if the bug still persists with the 3.5.0 beta1 or beta2 prereleases. Details on how to test the 3.5.0 beta1 can be found at: http://wiki.documentfoundation.org/QA/BugHunting_Session_3.5.0.-1 more detail on this bulk operation: http://nabble.documentfoundation.org/RFC-Operation-Spamzilla-tp3607474p3607474.html
Dear bug submitter! Due to the fact, that there are a lot of NEEDINFO bugs with no answer within the last six months, we close all of these bugs. To keep this message short, more infos are available @ https://wiki.documentfoundation.org/QA/NeedinfoClosure#Statement Thanks for understanding and hopefully updating your bug, so that everything is prepared for developers to fix your problem. Yours! Florian
reopening because it is RFE and easy hack
Marking as NEW as it's a valid request, not sure if it's an EasyHack, someone else can look into that. Prioritizing: Enhancement (already done) Low - Not much use for the average user but it'd be a nice addition Regards, Joel
In order to make this a real 'easy hack' - we need some code pointers (not terribly hard to create), but we also need some sample number formats for kB etc. How does that fit into the existing number format syntax ? We can do something like: [<1000000]0.00," kB";[<1000000000]0.00,," mB";0.00,,," gB" And create an easy-to-use entry for that. But of course that is all decimal; failing that we would need to extend the number format syntax to handle different bases: something that needs to be done carefully and with a view to standardization. Either way the code pointers are: cui/uiconfig/ui/numberingformatpage.ui and: cui/source/tabpages/numfmt.cxx with relevant code in: svl/source/numbers/zforlist.cxx It looks like: i18npool/source/localedata/data/ has locale dependent number formatting entries too, and no doubt Eike has more thoughts here :-)
Adding a number format code like [<1000000]0.00," kB";[<1000000000]0.00,," mB";0.00,,," gB" is certainly possible and would needed only to be done in the locale data files. Suitable for an EasyHack :-) Extending the number format syntax to allow different bases is difficult. While doable in the number formatter itself the problems are: * There are no means to store this in ODF file format yet, so we'd need to come up with a proposal to the OASIS TC. * Until accepted we'd need to store such a thing in an extension namespace. * The format codes strive to be compatible with the ones Excel uses and are mostly written as is to MS file formats, or with minor conversions involved. If Excel does not know such base N feature (I think it does not, please correct me if I'm wrong) the format would be lost on export / reimport.
adding LibreOffice developer list as CC to unresolved EasyHacks for better visibility. see e.g. http://nabble.documentfoundation.org/minutes-of-ESC-call-td4076214.html for details
Removing comma from whiteboard (please use a space to delimit values in this field) https://wiki.documentfoundation.org/QA/Bugzilla/Fields/Whiteboard#Getting_Started
I like give this a try. But I dont get "4. when creating a sum function, add the option to choose the display meter (so when the sum is 2,040 KiloBytes, I can choose to display 1.9 MiB or 2,040 KiB)". What is meant from this??
I'd ignore 4. for now =)
Ah OK. Thanks :) On Sun, Jan 26, 2014 at 12:23 AM, <bugzilla-daemon@freedesktop.org> wrote: > *Comment # 16 <https://bugs.freedesktop.org/show_bug.cgi?id=36864#c16> > on bug 36864 <https://bugs.freedesktop.org/show_bug.cgi?id=36864> from > Michael Meeks <michael.meeks@collabora.com> * > > I'd ignore 4. for now =) > > ------------------------------ > You are receiving this mail because: > > - You are on the CC list for the bug. > > > _______________________________________________ > LibreOffice mailing list > LibreOffice@lists.freedesktop.org > http://lists.freedesktop.org/mailman/listinfo/libreoffice > >
Im kind of stuck . There are two lists on this tab and one is category and its items comes from numberingformatpage.ui. The second list is format(m_pLbCurrency) and I cant figure out from where it gets its contents. Can anyone please help? On Sun, Jan 26, 2014 at 1:56 AM, <bugzilla-daemon@freedesktop.org> wrote: > *Comment # 17 <https://bugs.freedesktop.org/show_bug.cgi?id=36864#c17> > on bug 36864 <https://bugs.freedesktop.org/show_bug.cgi?id=36864> from > Ayantha Randika <randika.deultima@gmail.com> * > > Ah OK. Thanks :) > > > On Sun, Jan 26, 2014 at 12:23 AM, <bugzilla-daemon@freedesktop.org> wrote: > > > *Comment # 16 <https://bugs.freedesktop.org/show_bug.cgi?id=36864#c16> <https://bugs.freedesktop.org/show_bug.cgi?id=36864#c16> > > on bug 36864 <https://bugs.freedesktop.org/show_bug.cgi?id=36864> <https://bugs.freedesktop.org/show_bug.cgi?id=36864> from > > Michael Meeks <michael.meeks@collabora.com> * > > >> I'd ignore 4. for now =) > > > > ------------------------------ > > You are receiving this mail because: > >> - You are on the CC list for the bug. > > > > >> _______________________________________________ > > LibreOffice mailing list > > LibreOffice@lists.freedesktop.org > > http://lists.freedesktop.org/mailman/listinfo/libreoffice > > > > > > ------------------------------ > You are receiving this mail because: > > - You are on the CC list for the bug. > > > _______________________________________________ > LibreOffice mailing list > LibreOffice@lists.freedesktop.org > http://lists.freedesktop.org/mailman/listinfo/libreoffice > >
I played with the code for about 8-9 hours and couldn't figure out how items in the format list are generated. Can someone give me little help? Is there a documents I should read to understand the code here? On Sun, Jan 26, 2014 at 2:22 AM, <bugzilla-daemon@freedesktop.org> wrote: > *Comment # 18 <https://bugs.freedesktop.org/show_bug.cgi?id=36864#c18> > on bug 36864 <https://bugs.freedesktop.org/show_bug.cgi?id=36864> from > Ayantha Randika <randika.deultima@gmail.com> * > > Im kind of stuck . There are two lists on this tab and one is category and > its items comes from numberingformatpage.ui. The second list is > format(m_pLbCurrency) and I cant figure out from where it gets its > contents. Can anyone please help? > > > On Sun, Jan 26, 2014 at 1:56 AM, <bugzilla-daemon@freedesktop.org> wrote: > > > *Comment # 17 <https://bugs.freedesktop.org/show_bug.cgi?id=36864#c17> <https://bugs.freedesktop.org/show_bug.cgi?id=36864#c17> > > on bug 36864 <https://bugs.freedesktop.org/show_bug.cgi?id=36864> <https://bugs.freedesktop.org/show_bug.cgi?id=36864> from > > Ayantha Randika <randika.deultima@gmail.com> * > > >> Ah OK. Thanks :) > > > >> On Sun, Jan 26, 2014 at 12:23 AM, <bugzilla-daemon@freedesktop.org> wrote: > > > > > *Comment # 16 <https://bugs.freedesktop.org/show_bug.cgi?id=36864#c16> <https://bugs.freedesktop.org/show_bug.cgi?id=36864#c16> <https://bugs.freedesktop.org/show_bug.cgi?id=36864#c16> > > > on bug 36864 <https://bugs.freedesktop.org/show_bug.cgi?id=36864> <https://bugs.freedesktop.org/show_bug.cgi?id=36864> <https://bugs.freedesktop.org/show_bug.cgi?id=36864> from > > > Michael Meeks <michael.meeks@collabora.com> * > > >> >> I'd ignore 4. for now =) > > > > > > ------------------------------ > > > You are receiving this mail because: > > >> - You are on the CC list for the bug. > >> > > > >> _______________________________________________ > > > LibreOffice mailing list > > > LibreOffice@lists.freedesktop.org > > > http://lists.freedesktop.org/mailman/listinfo/libreoffice > > > > > > > >> ------------------------------ > > You are receiving this mail because: > >> - You are on the CC list for the bug. > > > >> _______________________________________________ > > LibreOffice mailing list > > LibreOffice@lists.freedesktop.org > > http://lists.freedesktop.org/mailman/listinfo/libreoffice > > > > > > ------------------------------ > You are receiving this mail because: > > - You are on the CC list for the bug. > > > _______________________________________________ > LibreOffice mailing list > LibreOffice@lists.freedesktop.org > http://lists.freedesktop.org/mailman/listinfo/libreoffice > >
Ayantha Randika - couple things (1) when replying on FDO please come to the website and post, we don't like all the extra stuff that comes with email replies (clogs up the bug report) (2) for your questions it might be a lot easier to mail the dev list and jump into the IRC channel as then you'll be contacting hundreds of devs not the couple that are on this bug report and likely get hundreds of FDO emails a day
Thanks fro the advice. I'm really new here and don't have many experiences using this kind of forums :) thanks.
This ain't an EasyHack, removing flags.
Setting Assignee back to default. Please assign it back to yourself if you're still working on this issue