Hi :)
Sorry about the delay!
It might be best to ask this question on our developers mailing list or irc
(or is it iirc?) or something. It is a bit of an advanced question for
most of us normal users!
Apols and regards from
Tom :)
On 21 April 2015 at 10:02, 林承益 chengyi@keywie.com wrote:
Having sheets named Sheet1, Sheet2, Sheet3 etc. any reference from
Sheet2 to Sheet1 or from Sheet3 to Sheet2 refers to the _previous_
sheet. When you copy this reference to the first sheet, then there is no
previous sheet which is why you get #REF!.X1
Any absolute reference to $Sheet1 refers
Hello,
I had the intention to file a bug report for Calc, but then I thought
that maybe I should first ask for some user's feedback.
I would like to know if the behavior I am about to describe can be
replicated with several versions of LibreOffice and/or under different
configurations /
Having sheets named Sheet1, Sheet2, Sheet3 etc. any reference from
Sheet2 to Sheet1 or from Sheet3 to Sheet2 refers to the _previous_
sheet. When you copy this reference to the first sheet, then there is no
previous sheet which is why you get #REF!.X1
Any absolute reference to $Sheet1 refers to
Sent from my iPhone
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive:
Good night = morning from Japan
I believe I did ask the same question in the past related to an
installation on a Win XP machine:
moving through documents (Writer) in LibreOffice while editing sometimes
(constantly!) sort of blurrs/freezes the screen.
That means, characters/lines/text sections
Hi :)
Maybe increase the memory settings in LibreOffice? The defaults tend to be
extremely low and on such a high-spec machine you can whack them right up.
Tools - Options - Memory
It sounds a bit like rendering issues so maybe the drivers for the
graphics-'card' are not quite right. I'm very
On 2015/04/23 0:44, Tom Davies wrote:
Hi :)
Maybe increase the memory settings in LibreOffice? The defaults tend to be
extremely low and on such a high-spec machine you can whack them right up.
Tools - Options - Memory
It sounds a bit like rendering issues so maybe the drivers for the
Hi Ady,
I have practically zero experience with other spreadsheet programs and such
experience as I do have has me comparing them against LO (or OOo) not vice
versa.
That said, it is my OPINION that intersheet references should be of the class
specified (absolute if entered with a leading $
Replicating your steps, I get a copy of Sheet2 at position #1 and any
relative reference to the previous sheet needs to raise a #REF! error
because you told me to reference a cell on the previous sheet. The error is
perfectly clear, wanted and informative. There is nothing wrong with errors.
Ah! My response was based on entering the whole formula through the keyboard.
That's my modus operandi (sp?).
You're talking about using the mouse to generate references. I'll back away
as I have nothing useful to say about your method.
--
Jim
Apologies for not being clear
Ah! My response was based on entering the whole formula through the keyboard.
That's my modus operandi (sp?).
You're talking about using the mouse to generate references. I'll back away as
I have nothing useful to say about your method.
--
Jim
-Original Message-
From: Ady
I don't know about Andreas, but when I read your original steps:
3_ In Sheet2 - A1 : =Sheet1.A1
I thought you meant type =Sheet1.A1 in cell A1 of Sheet2, and expected
that to behave as an absolute reference (which would be inconsistent
with row and column references). From the above
Sorry Chengyi Lin that i have no answers but your questions raise questions of
my own.
Does LibreOffice for Android have its own mailing list? How far advanced is the
project?
--
Jim
-Original Message-
From: 林承益 chengyi@keywie.com
To: users users@global.libreoffice.org
Sent: Tue,
Ady wrote:
Having sheets named Sheet1, Sheet2, Sheet3 etc. any reference from
Sheet2 to Sheet1 or from Sheet3 to Sheet2 refers to the _previous_
sheet. When you copy this reference to the first sheet, then there is no
previous sheet which is why you get #REF!.X1
Any absolute reference to
Replicating your steps, I get a copy of Sheet2 at position #1 and any
relative reference to the previous sheet needs to raise a #REF! error
because you told me to reference a cell on the previous sheet. The error is
perfectly clear, wanted and informative. There is nothing wrong with errors.
Am 14.04.2015 um 07:03 schrieb bhaumikdave:
I am using US Locale i.e. (English) US so it uses dd-mm-yy format.
But your dates are in mm-dd-yy format. Inorder to convert 04-14-2015 to
14th April, 2015 , I need to change Date and Time settings from Control
panel.
I kept my US locale as
Am 21.04.2015 um 22:44 schrieb Joel Madero:
On Tue, Apr 21, 2015 at 12:19 PM, Cor Nouws oo...@nouenoff.nl wrote:
bhaumikdave wrote on 13-04-15 08:58:
Done. Now Excel will recognize it as date and will allow you to format
cells
any date format as you wish.
No idea what Excel does or not
Hi :)
LibreOffice can already be themed and there are quite a lot out there
already. Tim of Kracked Press made at least one. You can use Firefox ones
but they call them Personas. There are already a couple of space ones
but i think Jorge's is really fantastic and would be a good addition to
19 matches
Mail list logo