Scientific notation formatting (in graphs and fields)

[Guillaume]

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.

[Pedro1]

You probably can use this trick created for Excel (ignoring the VBA part)

http://peltiertech.com/Excel/Charts/ScientificNotation.html

[MegaTallDave]

There 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.