[sc-issues] [Issue 5930] Engineering Notation
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5930 --- Additional comments from thomas...@openoffice.org Fri Nov 26 23:11:54 + 2010 --- Yes, it could be done that way, however, no one cares to make the change. Absolutely no one amongst the devs could be bothered to make this change because it is of no importance to them. Since 2002 this minor feature request has been languishing for want of attention from anyone in the dev community. It would help to set Calc apart from Excel if it was done right. It's a shame no one cares!!! - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 5930] Engineering Notation
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5930 --- Additional comments from thomas...@openoffice.org Sat Nov 13 07:32:04 + 2010 --- Will there come a day when someone will wake up and decide to do something about this. I was looking into adding it as an add-on, however, I do not have the required SDK and since I am using a slightly older version the 3.2.1, I have no access to the current SDK. If someone out there can take the .py file and create an add-on please let me know. Thank you! - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 5930] Engineering Notation
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5930 --- Additional comments from thomas...@openoffice.org Sat Nov 6 23:22:24 + 2010 --- Calc already has Scientific Numbering. What is lacking is a way to constrain the exponents to multiples of 3, (e.g., 9, 6, 3, 0, -3, -6, -9, ... etc). I agree that the Alpha version can wait on the appearance of the Engineering Notation for multiples of 3. This constraint to multiples of 3 is not currently possible except accidentally when it just occurs due to the integer being limited to one digit. Currently there is NO WAY to constrain the exponents to multiples of 3 consistently!!! The Python code has two parts, the first of which is used alter the display values of the exponents, while the second displays the results. This is strictly to show how the code works. Anyone who wants just the code version let me know. Thank you! - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 5930] Engineering Notation
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5930 --- Additional comments from thomas...@openoffice.org Wed Oct 20 08:02:34 + 2010 --- Created an attachment (id=72110) Python runable file showing Alpha SI Engineering Notation - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 5930] Engineering Notation
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5930 --- Additional comments from thomas...@openoffice.org Tue Sep 7 05:57:07 + 2010 --- Created an attachment (id=71592) Python code runable displaying Engineering Notation in numeric format - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 5930] Engineering Notation
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5930 --- Additional comments from thomas...@openoffice.org Tue Sep 7 05:56:03 + 2010 --- Created an attachment (id=71591) Python code runable file - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 5930] Engineering Notation
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5930 --- Additional comments from thomas...@openoffice.org Sun Aug 1 20:25:35 + 2010 --- Lars, You seem to have missed entirely the point to Engineering Notation. All exponents must be constrained to those divisible by 3, whether positive or negative. Secondly, some engineers would prefer the letter designation (m, k, M, p, G, etc.) to use when doing their calculations. Making the letter designations available would certainly make Calc more attractive to many engineers than Excel. Offering a better product than M$ is not something we should sneer at. Thank you! - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 5930] Engineering Notation
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5930 --- Additional comments from thomas...@openoffice.org Tue Jul 6 07:44:42 + 2010 --- I saw no way to attach a file that would survive the maillist. I know this is not a normal reply maillist, however, these comments are sent out to everyone subscribed to this particular bug report. It has been about 8 years since this was first requested and no one has even looked at it. There is no interest in doing this by the developers that I can see, even though it is something that all engineers who employ a spreadsheet in their work/research would gladly use. It would also put OOo one up on Excel. It is a shame that the developers do not care at all about this issue. Both issues(numeric and alpha)! $.02 - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 5930] Engineering Notation
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5930 --- Additional comments from thomas...@openoffice.org Mon Jul 5 18:44:59 + 2010 --- # eng_alpha.py # def eng (F = 0, fmt = %f): Formats a floating point number (F) according to the format provided (fmt). Tries to use engineering notation (i.e. the exponent is in powers of three). Dean Provins, June, 2010 LExp = ['0','1','2','m',' ',' ','%mu',' ',' ','n',' ',' ','p'] HExp = ['0',' ',' ','k',' ',' ','M',' ',' ','G',' ',' ','T'] f = abs (F) n = 0 s = +1 if F 0: s = -1 if f != 0: if f = 1.: while (f = 100): f /= 10. n += 1 f *= 10. n -= 1 while (n % 3): n += 1 f /= 10. else: while (f 99): f *= 10. n -= 1 while (n % 3): n += 1 f /= 10. # Uncomment these if you want a leading '0.' #f /= 10. #n += 1 #S = fmt % (s * f, n) # store this result in a cell if F 1: if s 0: return fmt % (f) + LExp[-s * n] # return the formatted string to store in a cell else: return fmt % (s * f) + LExp[s * n] else: return fmt % (s * f) + HExp[n * s] # -end of the function - if __name__ == __main__: # Some tests... Try them by running python eng.py print some tests print -- print 0:, eng () print print 1.:, eng (1.) print 1.23:, eng (1.23) print 123:, eng (123) print 1234.567:, eng (1234.567) print print 11:, eng (11) print print * * * Less than One Positive * * * print print 0.4:, eng (0.4) print 0.0004:, eng (0.0004) print 0.004:, eng (0.004) print print 0.004:, eng (0.004) print # print 0.001234567E-7:, eng (0.001234567E-7) print 6,000,000:, eng (600) print 6,000,000,000:, eng (60) print 6,000,000,000,000:, eng (6) print print * * * * 1,000, 1 * * * * * * * * * * print 111:, eng (111) print 222:, eng (222) print 333:, eng (333) print 444:, eng (444) print 555:, eng (555) print 666:, eng (666) print 777:, eng (777) print 888:, eng (888) print 999:, eng (999) print print * * * * * * Negatives! * * * * * * * * print print -111:, eng (-111) print -222:, eng (-222) print -333:, eng (-333) print -444:, eng (-444) print -555:, eng (-555) print -666:, eng (-666) print -777:, eng (-777) print -888:, eng (-888) print -999:, eng (-999) print print * * * * * Less than One Negative* * * print print -0.4:, eng (-0.4) print -0.0004:, eng (-0.0004) print -0.004:, eng (-0.004) print -0.04:, eng (-0.04) print print -0.004:, eng (-0.004) print print * * * * * * Just over One Thousand * * * * print print :, eng () print :, eng () print :, eng () print :, eng () print :, eng () print :, eng () print :, eng () print :, eng () print :, eng () - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 5930] Engineering Notation
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5930 --- Additional comments from thomas...@openoffice.org Mon Jul 5 18:48:20 + 2010 --- # eng.py # def eng (F = 0, fmt = %fe%d): Formats a floating point number (F) according to the format provided (fmt). Tries to use engineering notation (i.e. the exponent is in powers of three). Dean Provins, June, 2010 f = abs (F) n = 0 s = +1 if F 0: s = -1 if f != 0: if f = 1.: while (f = 100): f /= 10. n += 1 f *= 10. n -= 1 while (n % 3): n += 1 f /= 10. else: while (f 99): f *= 10. n -= 1 while (n % 3): n += 1 f /= 10. # Uncomment these if you want a leading '0.' #f /= 10. #n += 1 #S = fmt % (s * f, n) # store this result in a cell return fmt % (s * f, n) # return the formatted string to store in a cell # -end of the function - if __name__ == __main__: # Some tests... Try them by running python eng.py print some tests print -- print 0:, eng () print print 1.:, eng (1.) print 1.23:, eng (1.23) print 123:, eng (123) print 1234.567:, eng (1234.567) print print 11.:, eng (11.) print print 0.4:, eng (0.4) print print 0.004:, eng (0.004) print 0.04:, eng (-0.04) print print 0.001234567E-7:, eng (0.001234567E-7) print print 6,000,000:, eng (600) print 6,000,000,000:, eng (60) print 6,000,000,000,000:, eng (6) print print * * * * 1,000, 1 * * * * * * * * * * print print 111:, eng (111) print 222:, eng (222) print 333:, eng (333) print 444:, eng (444) print 555:, eng (555) print 666:, eng (666) print 777:, eng (777) print 888:, eng (888) print 999:, eng (999) print print * * * * * * * * * * * * * * print print -111:, eng (-111) print -222:, eng (-222) print -333:, eng (-333) print -444:, eng (-444) print -555:, eng (-555) print -666:, eng (-666) print -777:, eng (-777) print -888:, eng (-888) print -999:, eng (-999) print print * * * * * * * * * * * * * * print print -0.4:, eng (-0.4) print -0.0004:, eng (-0.0004) print -0.004:, eng (-0.004) print print -0.004:, eng (-0.004) print :, eng () print :, eng () print :, eng () print :, eng () print :, eng () print :, eng () print :, eng () print :, eng () print :, eng () - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 5930] Engineering Notation
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5930 --- Additional comments from thomas...@openoffice.org Sat Jul 3 06:55:59 + 2010 --- I have two files that I need to convert to addins or addons or whatever. One constrains all exponents to be divisible by 3, except for 0, of course. The other works much the same except it converts to alpha character values, i.e., m, k, M, T, p, etc, in the place of exponents. If someone can help me put a wrapper on this to get OOo Calc to recognize it, we can all enjoy the results and be one up on M$ Excel. Thank you! Tom - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 5930] Engineering Notation
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5930 --- Additional comments from thomas...@openoffice.org Fri May 28 01:44:13 + 2010 --- I found this snippet of code. Can someone use it to create the necessary macro? import math for exponent in xrange(-10, 11): flt = 1.23 * math.pow(10, exponent) l = math.log10(flt) if l 0: l = l - 3 p3 = int(l / 3) * 3 multiplier = flt / pow(10, p3) print '%e = %fe%d' % (flt, multiplier, p3) It was on this page: http://coding.derkeiler.com/Archive/Python/comp.lang.python/2007-03/msg01958.html - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 5930] Engineering Notation
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5930 --- Additional comments from thomas...@openoffice.org Fri May 21 22:50:42 + 2010 --- I find it hard to believe that no one is taking this deficiency seriously! It is most important to engineers. How many years will it be before someone acts on this? This is the 21st century OOo should join it. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
