simple ideas
Eric Kindig <[email protected]> Mon, 27 Jun 2011 17:55:41 -0400
| Newsgroups | gmane.comp.openoffice.devel.general |
|---|---|
| Message-ID | <[email protected]> |
--0015174017aef54e0a04a6b89dc2 Content-Type: text/plain; charset=ISO-8859-1 Hi, I've just begun using the spreadsheet program in Open Office, and I've found a few little things I wish it could do. I might even be able to write some of it in C++. These don't necessarily have to be in everyone's version of the software, I just wish it were available to me. But these are simple: ----Icon for "number format: time": There are icon sets at the tops of the screen, some of which apply number formats to your cells: one for currency (you can set this to your local default, it seems), one for percent, one for dates, etc. I wanted one for time, so found it in the "customize icon sets" menu, but it had no icon associated with it. So I chose "modify > change icon..." and searched around to find a little clock, and it's perfect. Maybe you should make the clock a default instead of the words "number format: time". ----Choose default date and time formats: The above-mentioned icons for date and time formats automatically change numbers into dates or times, which is great, but it always does it in the same format: 08/29/09 or 12:34:56 PM (respectively). I want to be able to choose the default formats, which are not those ones. ----Option to remove or hide extraneous options: What prompts this for me specifically was that I was scrolling through the available date formats to find my favorite, and I had to scroll past all of these Jewish date formats to discover that my favorite was not on your list. I was able to create my own format to use, which is great, but it now appears at the very bottom of the list, so every time I want to choose it, I have to scroll past all those Jewish dates again. Now, I have no problem with Jewish dates (or any other calendars, for that matter), but I'm almost certainly never going to use them, so I wish I could just remove them from the list, or hide them somewhere out of the way. Or re-arrange the list to my liking, so I don't have to keep scrolling past them. ----Change date codes: In writing my own date code, I was happily impressed with the options available to me, and I went to your help file to see what all of my choices were. However, I encountered an interesting decision by whomever wrote the codes for what would appear when you made dates. Specifically: D -- Day as 2 DD -- Day as 02 NN or DDD -- Day as Sun-Sat NNN or DDDD -- Day as Sunday to Saturday NNNN -- Day followed by comma, as in "Sunday," Now, I like that typing either 'N's or 'D's will get you the day of the week, but who decided that 3 D's is the same as 2 N's? Sometimes it's very important to know the day of the week, and not just the calendar date, so I'm happy we have the option of showing the day of the week within the date. However, in the spirit of minimizing space, it's good to be able to abbreviate, showing "Sat" instead of "Saturday," for instance. But this can be further abbreviated, as I'm sure you've seen on office calendars and schedules and such: M - Monday T - Tuesday W - Wednesday R or H - Thursday F - Friday Obviously, this is not an ideal system, since there are several days containing an "R", and this system doesn't do much for the non-work days of Saturday and Sunday. Nevertheless, this is a system in use by some people, so I believe it should be represented by typing one "N". Another alternative to this one-letter abbreviation system is a two-letter system which is far more understandable: Mo, Tu, We, Th, Fr, Sa, Su. This is what I like to use, because it clearly shows the day of the week while using the smallest space possible. So I would like 2 N's to show this format, rather than 2 N's giving you a 3-letter day of the week. It seems far more sensible that one N give you a one-letter day-name, 2 N's give you a two-letter name, 3 N's give you a three-letter name, and 4 N's give you a long name. Again, I could easily write some of this into C++, but I mostly wish I could just make it work this way on my computer so I don't have to bother all of the other millions of users if they don't want these changes. So please let me know how I can help, or how you can help me. Oh, and also let me know where the best repository is for these types of requests: I searched around on your web-site and this was the best thing I came up with. Thanks so much! --Eric ---------------------------------------------- Eric Kindig [email protected] www.FaceBook.com/EKindig ---------------------------------------------- -- ----------------------------------------------------------------- To unsubscribe send email to [email protected] For additional commands send email to [email protected] with Subject: help --0015174017aef54e0a04a6b89dc2 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Hi,<div><br></div><div>I've just begun using the spreadsheet program in= Open Office, and I've found a few little things I wish it could do. = =A0I might even be able to write some of it in C++. =A0These don't nece= ssarily have to be in everyone's version of the software, I just wish i= t were available to me. =A0But these are simple:</div> <div><br></div><div>----Icon for "number format: time":=A0There a= re icon sets at the tops of the screen, some of which apply number formats = to your cells: one for currency (you can set this to your local default, it= seems), one for percent, one for dates, etc. =A0I wanted one for time, so = found it in the "customize icon sets" menu, but it had no icon as= sociated with it. =A0So I chose "modify > change icon..." and = searched around to find a little clock, and it's perfect. =A0Maybe you = should make the clock a default instead of the words "number format: t= ime".</div> <div>----Choose default date and time formats: The above-mentioned icons fo= r date and time formats automatically change numbers into dates or times, w= hich is great, but it always does it in the same format: 08/29/09 or 12:34:= 56 PM (respectively). =A0I want to be able to choose the default formats, w= hich are not those ones. =A0<br clear=3D"all"> ----Option to remove or hide extraneous options: What prompts this for me s= pecifically was that I was scrolling through the available date formats to = find my favorite, and I had to scroll past all of these Jewish date formats= to discover that my favorite was not on your list. =A0I was able to create= my own format to use, which is great, but it now appears at the very botto= m of the list, so every time I want to choose it, I have to scroll past all= those Jewish dates again. =A0Now, I have no problem with Jewish dates (or = any other calendars, for that matter), but I'm almost certainly never g= oing to use them, so I wish I could just remove them from the list, or hide= them somewhere out of the way. =A0Or re-arrange the list to my liking, so = I don't have to keep scrolling past them.</div> <div>----Change date codes: In writing my own date code, I was happily impr= essed with the options available to me, and I went to your help file to see= what all of my choices were. =A0However, I encountered an interesting deci= sion by whomever wrote the codes for what would appear when you made dates.= =A0Specifically:</div> <div><p style=3D"margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Times N= ew Roman'">D --=A0Day as 2</p> <p style=3D"margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-= left: 0px; font: normal normal normal 12px/normal 'Times New Roman'= ; ">DD --=A0Day as 02</p> <p style=3D"margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-= left: 0px; font: normal normal normal 12px/normal 'Times New Roman'= ; ">NN or DDD --=A0Day as Sun-Sat</p> <p style=3D"margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-= left: 0px; font: normal normal normal 12px/normal 'Times New Roman'= ; ">NNN or DDDD --=A0Day as Sunday to Saturday</p> <div><p style=3D"margin-top: 0px; margin-right: 0px; margin-bottom: 0px; ma= rgin-left: 0px; font: normal normal normal 12px/normal 'Times New Roman= '; ">NNNN --=A0Day followed by comma, as in "Sunday,"</p></di= v> <p style=3D"margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Times New Ro= man'"><font class=3D"Apple-style-span" face=3D"arial"><span class=3D"Ap= ple-style-span" style=3D"font-size: small;"><font class=3D"Apple-style-span= " face=3D"'Times New Roman'" size=3D"3"><span class=3D"Apple-style-= span" style=3D"font-size: 12px;"><br> </span></font></span></font></p><p style=3D"margin: 0.0px 0.0px 0.0px 0.0px= ; font: 12.0px 'Times New Roman'"><font class=3D"Apple-style-span" = face=3D"arial"><span class=3D"Apple-style-span" style=3D"font-size: small;"= ><font class=3D"Apple-style-span" face=3D"'Times New Roman'" size= =3D"3"><span class=3D"Apple-style-span" style=3D"font-size: 12px;"><span cl= ass=3D"Apple-style-span" style=3D"font-family: arial; font-size: small; ">N= ow,=A0I like that typing either 'N's or 'D's will get you t= he day of the week, but who decided that 3 D's is the same as 2 N's= ? =A0Sometimes it's very important to know the day of the week, and not= just the calendar date, so I'm happy we have the option of showing the= day of the week within the date. =A0However, in the spirit of minimizing s= pace, it's good to be able to abbreviate, showing "Sat" inste= ad of "Saturday," for instance. =A0But this can be further abbrev= iated, as I'm sure you've seen on office calendars and schedules an= d such:</span></span></font></span></font></p> <p style=3D"margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Times New Ro= man'"><font class=3D"Apple-style-span" face=3D"arial"><span class=3D"Ap= ple-style-span" style=3D"font-size: small;"><font class=3D"Apple-style-span= " face=3D"'Times New Roman'" size=3D"3"><span class=3D"Apple-style-= span" style=3D"font-size: 12px;"><span class=3D"Apple-style-span" style=3D"= font-family: arial; font-size: small; ">M - Monday</span></span></font></sp= an></font></p> <p style=3D"margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Times New Ro= man'"><font class=3D"Apple-style-span" face=3D"arial"><span class=3D"Ap= ple-style-span" style=3D"font-size: small;"><font class=3D"Apple-style-span= " face=3D"'Times New Roman'" size=3D"3"><span class=3D"Apple-style-= span" style=3D"font-size: 12px;"><span class=3D"Apple-style-span" style=3D"= font-family: arial; font-size: small; ">T - Tuesday</span></span></font></s= pan></font></p> <p style=3D"margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Times New Ro= man'"><font class=3D"Apple-style-span" face=3D"arial"><span class=3D"Ap= ple-style-span" style=3D"font-size: small;"><font class=3D"Apple-style-span= " face=3D"'Times New Roman'" size=3D"3"><span class=3D"Apple-style-= span" style=3D"font-size: 12px;"><span class=3D"Apple-style-span" style=3D"= font-family: arial; font-size: small; ">W - Wednesday</span></span></font><= /span></font></p> <p style=3D"margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Times New Ro= man'"><font class=3D"Apple-style-span" face=3D"arial"><span class=3D"Ap= ple-style-span" style=3D"font-size: small;"><font class=3D"Apple-style-span= " face=3D"'Times New Roman'" size=3D"3"><span class=3D"Apple-style-= span" style=3D"font-size: 12px;"><span class=3D"Apple-style-span" style=3D"= font-family: arial; font-size: small; ">R or H - Thursday</span></span></fo= nt></span></font></p> <p style=3D"margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Times New Ro= man'"><font class=3D"Apple-style-span" face=3D"arial"><span class=3D"Ap= ple-style-span" style=3D"font-size: small;"><font class=3D"Apple-style-span= " face=3D"'Times New Roman'" size=3D"3"><span class=3D"Apple-style-= span" style=3D"font-size: 12px;"><span class=3D"Apple-style-span" style=3D"= font-family: arial; font-size: small; ">F - Friday</span></span></font></sp= an></font></p> <p style=3D"margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Times New Ro= man'"><font class=3D"Apple-style-span" face=3D"arial"><span class=3D"Ap= ple-style-span" style=3D"font-size: small;"><font class=3D"Apple-style-span= " face=3D"'Times New Roman'" size=3D"3"><span class=3D"Apple-style-= span" style=3D"font-size: 12px;"><span class=3D"Apple-style-span" style=3D"= font-family: arial; font-size: small; ">Obviously, this is not an ideal sys= tem, since there are several days containing an "R", and this sys= tem doesn't do much for the non-work days of Saturday and Sunday. =A0Ne= vertheless, this is a system in use by some people, so I believe it should = be represented by typing one "N". =A0</span></span></font></span>= </font></p> <p style=3D"margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Times New Ro= man'"><font class=3D"Apple-style-span" face=3D"arial"><span class=3D"Ap= ple-style-span" style=3D"font-size: small;">Another alternative to this one= -letter abbreviation system is a two-letter system which is far more unders= tandable: Mo, Tu, We, Th, Fr, Sa, Su. =A0This is what I like to use, becaus= e it clearly shows the day of the week while using the smallest space possi= ble. =A0So I would like 2 N's to show this format, rather than 2 N'= s giving you a 3-letter day of the week. =A0It seems far more sensible that= one N give you a one-letter day-name, 2 N's give you a two-letter name= , 3 N's give you a three-letter name, and 4 N's give you a long nam= e. =A0</span></font></p> <p style=3D"margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Times New Ro= man'"><font class=3D"Apple-style-span" face=3D"arial"><span class=3D"Ap= ple-style-span" style=3D"font-size: small;"><br></span></font></p><p style= =3D"margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Times New Roman'= "> <font class=3D"Apple-style-span" face=3D"arial"><span class=3D"Apple-style-= span" style=3D"font-size: small;"><br></span></font></p><p style=3D"margin:= 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Times New Roman'"><font cla= ss=3D"Apple-style-span" face=3D"arial"><span class=3D"Apple-style-span" sty= le=3D"font-size: small;">Again, I could easily write some of this into C++,= but I mostly wish I could just make it work this way on my computer so I d= on't have to bother all of the other millions of users if they don'= t want these changes. =A0So please let me know how I can help, or how you c= an help me. =A0Oh, and also let me know where the best repository is for th= ese types of requests: I searched around on your web-site and this was the = best thing I came up with.</span></font></p> <p style=3D"margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Times New Ro= man'"><font class=3D"Apple-style-span" face=3D"arial"><span class=3D"Ap= ple-style-span" style=3D"font-size: small;"><br></span></font></p><p style= =3D"margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Times New Roman'= "> <font class=3D"Apple-style-span" face=3D"arial"><span class=3D"Apple-style-= span" style=3D"font-size: small;"><br></span></font></p><p style=3D"margin:= 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Times New Roman'"><font cla= ss=3D"Apple-style-span" face=3D"arial"><span class=3D"Apple-style-span" sty= le=3D"font-size: small;">Thanks so much!</span></font></p> <p style=3D"margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Times New Ro= man'"><font class=3D"Apple-style-span" face=3D"arial"><span class=3D"Ap= ple-style-span" style=3D"font-size: small;"><br></span></font></p><p style= =3D"margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Times New Roman'= "> <font class=3D"Apple-style-span" face=3D"arial"><span class=3D"Apple-style-= span" style=3D"font-size: small;">--Eric</span></font></p><p style=3D"margi= n: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Times New Roman'"><font c= lass=3D"Apple-style-span" face=3D"arial"><span class=3D"Apple-style-span" s= tyle=3D"font-size: small;"><font class=3D"Apple-style-span" face=3D"'Ti= mes New Roman'" size=3D"3"><span class=3D"Apple-style-span" style=3D"fo= nt-size: 12px;"><span class=3D"Apple-style-span" style=3D"font-family: aria= l; font-size: small; "><br> </span></span></font></span></font></p><p style=3D"margin: 0.0px 0.0px 0.0p= x 0.0px; font: 12.0px 'Times New Roman'"><font class=3D"Apple-style= -span" face=3D"arial"><span class=3D"Apple-style-span" style=3D"font-size: = small;"><font class=3D"Apple-style-span" face=3D"'Times New Roman'"= size=3D"3"><span class=3D"Apple-style-span" style=3D"font-size: 12px;"><sp= an class=3D"Apple-style-span" style=3D"font-family: arial; font-size: small= ; "><br> </span></span></font></span></font></p><p style=3D"margin: 0.0px 0.0px 0.0p= x 0.0px; font: 12.0px 'Times New Roman'"><font class=3D"Apple-style= -span" face=3D"arial"><span class=3D"Apple-style-span" style=3D"font-size: = small;"><font class=3D"Apple-style-span" face=3D"'Times New Roman'"= size=3D"3"><span class=3D"Apple-style-span" style=3D"font-size: 12px;"><sp= an class=3D"Apple-style-span" style=3D"font-family: arial; font-size: small= ; "><br> </span></span></font></span></font></p><p style=3D"margin: 0.0px 0.0px 0.0p= x 0.0px; font: 12.0px 'Times New Roman'"><span class=3D"Apple-style= -span" style=3D"font-family: arial; font-size: small; ">-------------------= ---------------------------</span></p> </div><div>Eric Kindig<br>[email protected]<br><a href=3D"http://www.FaceBo= ok.com/EKindig">www.FaceBook.com/EKindig</a><br>---------------------------= -------------------<br> </div> --0015174017aef54e0a04a6b89dc2--