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 [email protected] Tue Jan 25 19:43:47 +0000 2011 ------- Picking up again on the point: "it is important that the engineering notation have a stable and specifiable number of signifiant figures" Excel can display a minimum number of significant digits, with or without trailing (unnecessary zeros) using the # format character in engineering notation. To display numbers in engineering format, ie the exponent in multiple powers of three, using a custom format, some examples are: The example 1 below will be in engineering format with: two numbers after the decimal point can display up to at least 3 significant digits one number in the exponent ##0.00E+0 The example 2 below will be in engineering format with: two numbers after the decimal point can display up to at least 3 significant digits two numbers in the exponent ##0.00E+00 The example 3 below will be in engineering format with: three numbers after the decimal point can display up to at least 4 significant digits one number in the exponent ##0.000E+0 The example 4 below will be in engineering format with: three numbers after the decimal point can display up to at least 4 significant digits two numbers in the exponent ##0.000E+00 The example 5 below will be in engineering format with: At least one and up to three numbers after the decimal point, but excluding trailing zeros can display at up to at least 4 significant digits one number in the exponent ##0.0##E+0 I also found a reference at: http://people.stfx.ca/bliengme/ExcelTips/EngineeringNotation.htm Engineers like to display numbers with the exponent as a power of three. This can be done with a custom format such as ##0.00E+0 or ##0.0E+0 but this gives poor results with number less than 1,000. This custom format works better: [<0.001]##0.00E+0;[<1000] #0.00;##0.00E+0 Alternatives on this theme are: [<0.001]##0.00E+00;[<1000]#0.00;##0.00E+00 [<0.001]##0.0###E+00;[<1000]#0.0###;##0.0###E+00 Gnumeric (v1.10.8) pretty much displays an Excel 2007 worksheet, formatted as described above, the same as Excel. Calc (v3.2.1) does not. I have created a simple test worksheet in Excel 2007 excel_engineering_notation_examples.xlsx And captured pdfs of how this displays in Excel 2007, Gnumeric v1.10.8 and calc v3.2.1. excel_engineering_notation_examples.pdf gnumeric_v1.10.8_engineering_notation_output_of_excel_Import.pdf calc_v3.2.1_engineering_notation_output_of_excel_import.pdf Hopefully I will be able to attached these files to this ticket (I think they appear right at the top?). --------------------------------------------------------------------- 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: [email protected] For additional commands, e-mail: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
