Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenSun, 20 Oct 2013 22:48:23 +0200Scientific notation formatting (in graphs and fields)https://ask.libreoffice.org/en/question/1124/scientific-notation-formatting-in-graphs-and-fields/Hi Libreoffice community, impressive work and great product.
I regularly use libreoffice for my scientific work. I produce figures in calc and reports in writer, with a lot of numbers as "fields". The Scientific number format in libreoffice (1.23E+002) is ok for some kinds of work, *but some publications require that the numbers be formatted differently*: **1.23x10²**.
Any idea how to create a number format like that?
I know that in normal text I can go around and edit manually, but I cannot do this for axes in figures or fields in writer.
The 0.00"x10"0 number definition gets me half way, but I do not know how to indicate that the numbers after "x10" should be superscript.Mon, 12 Mar 2012 14:36:19 +0100https://ask.libreoffice.org/en/question/1124/scientific-notation-formatting-in-graphs-and-fields/Answer by jobforp for <p>Hi Libreoffice community, impressive work and great product.</p>
<p>I regularly use libreoffice for my scientific work. I produce figures in calc and reports in writer, with a lot of numbers as "fields". The Scientific number format in libreoffice (1.23E+002) is ok for some kinds of work, <em>but some publications require that the numbers be formatted differently</em>: <strong>1.23x10²</strong>.</p>
<p>Any idea how to create a number format like that?</p>
<p>I know that in normal text I can go around and edit manually, but I cannot do this for axes in figures or fields in writer.</p>
<p>The 0.00"x10"0 number definition gets me half way, but I do not know how to indicate that the numbers after "x10" should be superscript.</p>
https://ask.libreoffice.org/en/question/1124/scientific-notation-formatting-in-graphs-and-fields/?answer=24234#post-id-24234Choose Format - Character - Position, and then select Superscript or Subscript.
Press Ctrl+Shift+P to make the text superscript, and Ctrl+Shift+B to make the text subscript.
[https://help.libreoffice.org/Writer/Making_Text_Superscript_or_Subscript](https://help.libreoffice.org/Writer/Making_Text_Superscript_or_Subscript)Sun, 20 Oct 2013 22:48:23 +0200https://ask.libreoffice.org/en/question/1124/scientific-notation-formatting-in-graphs-and-fields/?answer=24234#post-id-24234Answer by MegaTallDave for <p>Hi Libreoffice community, impressive work and great product.</p>
<p>I regularly use libreoffice for my scientific work. I produce figures in calc and reports in writer, with a lot of numbers as "fields". The Scientific number format in libreoffice (1.23E+002) is ok for some kinds of work, <em>but some publications require that the numbers be formatted differently</em>: <strong>1.23x10²</strong>.</p>
<p>Any idea how to create a number format like that?</p>
<p>I know that in normal text I can go around and edit manually, but I cannot do this for axes in figures or fields in writer.</p>
<p>The 0.00"x10"0 number definition gets me half way, but I do not know how to indicate that the numbers after "x10" should be superscript.</p>
https://ask.libreoffice.org/en/question/1124/scientific-notation-formatting-in-graphs-and-fields/?answer=1348#post-id-1348There doesn't appear to be a format code for this sort of scientific notation. The obvious code would be a "^" instead of an e. This doesn't work.
There's a workaround that might help.
Equations created with Math (I used an equation I created in Write) can be copied and pasted into Excel Cells or Graphs. They can't be pasted into the title element itself, but it can be pasted to the graph, they appear in the upper left hand corner and then moved where ever you want.
Mon, 19 Mar 2012 23:29:36 +0100https://ask.libreoffice.org/en/question/1124/scientific-notation-formatting-in-graphs-and-fields/?answer=1348#post-id-1348Answer by Pedro for <p>Hi Libreoffice community, impressive work and great product.</p>
<p>I regularly use libreoffice for my scientific work. I produce figures in calc and reports in writer, with a lot of numbers as "fields". The Scientific number format in libreoffice (1.23E+002) is ok for some kinds of work, <em>but some publications require that the numbers be formatted differently</em>: <strong>1.23x10²</strong>.</p>
<p>Any idea how to create a number format like that?</p>
<p>I know that in normal text I can go around and edit manually, but I cannot do this for axes in figures or fields in writer.</p>
<p>The 0.00"x10"0 number definition gets me half way, but I do not know how to indicate that the numbers after "x10" should be superscript.</p>
https://ask.libreoffice.org/en/question/1124/scientific-notation-formatting-in-graphs-and-fields/?answer=1350#post-id-1350You probably can use this trick created for Excel (ignoring the VBA part)<br>
http://peltiertech.com/Excel/Charts/ScientificNotation.htmlTue, 20 Mar 2012 02:48:57 +0100https://ask.libreoffice.org/en/question/1124/scientific-notation-formatting-in-graphs-and-fields/?answer=1350#post-id-1350