Pergunte aqui

Perfil de James Haigh - atividade

2015-10-26 22:19:08 +0200 Medalha recebida  Pergunta famosa (fonte)
2015-10-26 22:19:08 +0200 Medalha recebida  Pergunta notável (fonte)
2015-10-26 22:19:08 +0200 Medalha recebida  Pergunta popular (fonte)
2014-07-06 23:36:02 +0200 Medalha recebida  Pergunta famosa (fonte)
2014-07-06 23:36:02 +0200 Medalha recebida  Pergunta notável (fonte)
2014-06-27 22:45:33 +0200 Medalha recebida  Pergunta notável (fonte)
2014-06-27 22:45:33 +0200 Medalha recebida  Pergunta famosa (fonte)
2013-10-01 19:59:49 +0200 Marcada como a melhor resposta How do I prevent 'E' from automatically formatting as standard form

Background: I made a spreadsheet and one of the columns is in units of V (volts). Since 0.224 is easier to read than 2.24E-001, for example, I have formatted this particular column as General (most of the columns are formatted as 0.00E+0). However, the data I'm entering is easier to enter using 'E' (or just 'e'). For example 41.5µA (microamps) is best entered as 41.5e-6, and 224mV (millivolts) can be entered as 224e-3. Unfortunately though, using E when entering data automatically changes the number format to 0.00E+000.

So the question is, how do I prevent the use of E when entering data from changing the number format?

2013-09-28 22:21:47 +0200 Medalha recebida  Pergunta popular (fonte)
2013-09-17 20:17:01 +0200 Medalha recebida  Taxonomista
2013-04-22 21:57:08 +0200 Medalha recebida  Pergunta popular (fonte)
2013-02-23 10:00:00 +0200 Medalha recebida  Pergunta famosa (fonte)
2013-02-18 12:37:19 +0200 Medalha recebida  Pergunta popular (fonte)
2013-02-18 12:37:19 +0200 Medalha recebida  Pergunta notável (fonte)
2013-02-12 23:40:14 +0200 Medalha recebida  Torcedor (fonte)
2013-02-12 22:11:13 +0200 Perguntou Is LibreOffice 4 available for Android?

With the recent release of LibreOffice 4, I thought I should bring up this old question again.

Please let the community know if there are any nightly, alpha or beta pre-releases for early-adopters. I don't mind if it's not currently stable, I just at least want to see the state of it rather than getting vague old rumours of ETAs such as "late 2012" or "early 2013".

I'm going to make donations for each of the first alpha, the first beta, and the first stable when they are available on F-Droid or Google Play.

2012-11-09 18:57:15 +0200 Resposta comentada Number format code to display x significant figures

I've added some more examples.

2012-11-09 18:46:26 +0200 Resposta comentada Number format code to display x significant figures

4SF is an abreviation for 4 significant figures. None of the first block of examples given above can be achieved with 0.####, nevermind all of them.

2012-11-09 14:28:43 +0200 Perguntou Number format code to display x significant figures

I know that the number of decimal places can be given by using 0's. However, I want to be able to display values to 4SF.

1.2345 -> '1.235'
12.345 -> '12.35'
123.45 -> '123.5'
1234.5 -> '1235'
12345  -> '12350'
0.1    -> '0.1000'
1      -> '1.000'
10     -> '10.00'
100    -> '100.0'
1000   -> '1000'

Used in combination with this, I want to ultimately be able to express any value in this way:

1.2345         -> '1.235 '
123456         -> '123.5k'
12345678900000 -> '12.35T'
0.0000012345   -> '1.235μ'

This is for SI units. See metric prefix.

2012-11-09 13:23:17 +0200 Resposta comentada Number format code that multiplies by powers of 1000

If you could attach your test spreadsheet to this answer, that would be great, thanks.

2012-11-09 13:18:51 +0200 Medalha recebida  Palpiteiro
2012-11-09 13:18:51 +0200 Resposta comentada Number format code that multiplies by powers of 1000

However, I do not understand what you mean by "<crt j="">". The double quotes around k may indeed not be necessary in this case, but without knowing with certainty every single format code character, it is a good idea to quote any text characters just in case they get interpreted as format code.

2012-11-09 13:10:14 +0200 Resposta comentada Number format code that multiplies by powers of 1000

I do understand 0 and #. As I explained in a previous comment, the site crashed when I was trying to correct myself. Grrr! When the site came back online, I was no longer able to edit the comment. To avoid further confusion, I've just deleted the comment.

2012-11-08 14:28:38 +0200 Pergunta comentada Number format code that multiplies by powers of 1000

I removed the line beginning "Ideally..." because m$ compatibility is no longer required since the person I'm working with on a project has installed LibO. I also think some of the issues with LibO come from copying issues and quirks in m$ office for best compatibility - I'm a bit resentful of this.

2012-11-08 14:16:42 +0200 Pergunta editada Number format code that multiplies by powers of 1000

I want to keep the values in the cells in plain metric units such that all formulas are the basic relations as would be found in a textbook, with no unnecessary, confusing, and mistake-prone constants in the formulas.

However, I want to display the values scaled to an easier to read order of magitude.

For division by powers of 1000, I can use commas, so I can use the format codes:

0.###,,,"G"
0.###,,"M"
0.###,"k"
0.###

Or I could even construct something more generic like this:

[>=1000000]0.###,,"M";[>=1000]0.###,"k";0.###

(There seems to be a bug that prevents me from using more than 3 conditions, so for now G is omitted.)

But for m, μ, n, etc., I cannot find a way.

I found this clever looking hack but the percents don't seem to work properly:

http://chandoo.org/wp/2012/01/31/custom-number-formats-multiply-divide-by-any-power-of-10/

2012-11-08 14:06:57 +0200 Pergunta comentada Number format code that multiplies by powers of 1000

@ROSt52: And yes, I meant m$'s spreadsheet program, which I got rid of years ago and switched to OOo, long before Oracle bought Sun and LibO had forked off OOo.