First time here? Check out the FAQ!
asked 2012-03-12 14:36:19 +0200Guillaume
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.
answered 2012-03-20 02:48:57 +0200Pedro
You probably can use this trick created for Excel (ignoring the VBA part)
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.
LibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!
Asked: 2012-03-12 14:36:19 +0200
Seen: 662 times
Last updated: Mar 20 '12