Ask Your Question

hernan's profile - activity

2017-05-20 01:16:45 +0100 received badge  Famous Question (source)
2015-11-13 09:02:00 +0100 received badge  Famous Question (source)
2015-11-13 09:02:00 +0100 received badge  Notable Question (source)
2015-11-12 14:39:24 +0100 received badge  Famous Question (source)
2015-11-12 14:39:24 +0100 received badge  Notable Question (source)
2015-10-05 01:23:40 +0100 received badge  Notable Question (source)
2015-10-05 01:23:40 +0100 received badge  Popular Question (source)
2013-11-20 21:52:35 +0100 asked a question Behaviour of charts in sheets with protected cells

I wished to protect some cells of my sheet. I did the documented steps ... IMO quite cumbersome and counter intuitive:

  1. unprotect all cells -which are by default "protected" (!)
  2. set the desired cells as protected... via the "Cell format" (!)
  3. set the sheet as protected

(all this, mind you, to protect a single cell)

Now, the sheet had a chart. After doing the above, the chart cannot be activated, selected or even moved. IF one clicks over it, all happens as if the chart didn't exist: the underying cell is selected, one can edit it, etc. This feels wrong, and I actually spent some time clicking as an idiot over the chart, before remebering that the sheet was "protected" and discovering that this was the cause.

Is this the expected behaviour?

I'm using LO, Windows-7.

2013-11-10 18:05:04 +0100 received badge  Popular Question (source)
2013-11-10 13:36:46 +0100 received badge  Famous Question (source)
2013-11-05 20:13:49 +0100 received badge  Enthusiast
2013-11-04 17:35:08 +0100 asked a question Is it possible to use disjoint cells for IRR range?

IRR(range;guess) does not seem to accept a list of non-contiguous cells as first argument. Am I mistkaken, or there is some workaround?

What I'd want to accomplish is basically the same that is asked here for Excel.

2013-10-29 15:03:35 +0100 commented question Why won't calc calculate...anything?

Enter "=10*9" .... I hope you are not typing the quotes, no?

2013-10-28 23:19:22 +0100 received badge  Notable Question (source)
2013-10-28 16:24:40 +0100 received badge  Popular Question (source)
2013-10-28 04:40:08 +0100 asked a question Formulas copied are sometimes not recomputed - known issue?

This is difficult to reproduce, but I've experienced it many times with a Calc spreadsheet ( with several sheets; most sheets were initially created via a copy-paste (formulas included) from a "mother" sheet. Now, when I change the sheet data, the formulas are (sometimes) not updated, even if I turn off "autorecalc" and I run a explicit "recalculate".

Here's a video I made:

Notice how the calculated cell should display 0 (it shows that result if I copy the formula verbatim into another cell), but it sticks to the original value, even after I change the cell format, or reference the cell in another cell; it recalculates the correct value only when I make some trivial change to the formula (eg, append "+ 0")

This is extremely annoying, it basically means you cannot trust your data in the spreadsheet. Is this a known issue? Is there some workaround?

2013-10-27 22:16:24 +0100 answered a question How do I insert named ranges in charts?

It is not currently possible to use named ranges in charts. The related enhancement request is fdo#66250 (Apache OO issue aoo#64604). Refer related question here.

2013-10-27 14:10:08 +0100 received badge  Popular Question (source)
2013-10-25 16:23:00 +0100 received badge  Editor (source)
2013-10-25 16:21:57 +0100 asked a question Should (could) the locale be a document property?

I'm interested in using different locales (specifically, decimal separators and thousands grouping) for different documents.

Correct me if I'm wrong: Currently (4.1) in Calc the locale is a global installation-wide setting. Let's assume I have a English global locale (so that 1/3 => 0.3333) and I wish to use a Spanish locale for a single document (so that 1/3 => 0,3333). The standard recipe (and, it seems, the only way) is to apply a specific number format to some cells (eventually the whole sheet). If don't consider this very satisfactory, for several reasons.

For one thing, this only applies to the "formatting", which is a different concept. The confusion of concepts shows in strange behaviours: the format is used for input/output, but not for the formulas. Assume the scenario above, using English local I've formatted all the cells to use Spanish locale. If I type (without quotes) "=1/4+1" I see 1,25 (that's ok), if I type "1,25" it is rightly interpreted as the same as 1/4, all right.
But if I type "=0,25+1" or "=1,25" I get an error, th formula expects the literal number in the global locale: "=0.25+1" Or, if I want to use a function "=MAX(0,25;A1)" , again, is wrong, the number is expected in the global locale, and, further, the formula wants the comma as argument separator (so it couldn't accept literal numbers with comma separators, of course).

The last issue makes more evident that this recipe: "format all the cells with a different locale" is not what I want. I want a different locale for the document, so that it really overrides the global one. Ideally, this would allow to work, in the same machine with same LO installation, with simultaneously in two opened Calc documents with different locales.

I don't know about LO internals, perhaps I'm expecting too much, is this too difficult to implement?