Ask Your Question

Scientific notation formatting (in graphs and fields) [closed]

asked 2012-03-12 14:36:19 +0100

Guillaume gravatar image

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.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-11-12 03:46:26.434328

2 Answers

Sort by » oldest newest most voted

answered 2012-03-20 02:48:57 +0100

Pedro gravatar image

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

edit flag offensive delete link more

answered 2012-03-19 23:29:36 +0100

MegaTallDave gravatar image

updated 2012-03-19 23:30:18 +0100

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.

edit flag offensive delete link more

Question Tools


Asked: 2012-03-12 14:36:19 +0100

Seen: 7,542 times

Last updated: Oct 20 '13