*Without "expand references"*
=SUM(Sheet1.A1:A99)
becomes
=SUM(Sheet1.A2:A100)
after you inserted one new row at Sheet1, row #1. The reference moves down
one row.
When you insert one row between row #2 and row #99 the reference expands by
one row:
=SUM(Sheet1.A1:A100)
Nothing happens when you
postmas...@btinternet.com)
Subject: Re: [libreoffice-users] Calc Options > Libreoffice Calc > General >
Expand references when new columns/rows are inserted
MIME-Version: 1.0
Content-Type: multipart/alternative;
boundary="=_Part_1_1114535632.1483574101274"
X-Mailer: MailDroid/4.49
Peter,
Understood. Thanks.
Gordon.
On 04/01/17 23:22, ptoye wrote:
Gordon,
I am referring specifically to a Dialog(ue), not to text within a file.
-
Peter
--
View this message in context:
At 11:38 04/01/2017 -0500, Charles Marcus wrote:
This doesn't seem to be working for me, and hasn't for a long time,
I just keep forgetting to ask and go file a bug if it is broken. I
have a spreadsheet that has numerous formulas in certain cells in
each row. With the option referenced in this
Hi all,
This doesn't seem to be working for me, and hasn't for a long time, I
just keep forgetting to ask and go file a bug if it is broken.
I have a spreadsheet that has numerous formulas in certain cells in each
row.
With the option referenced in this email subject enabled, when I insert
a
I've run into a couple of issues using conditional formatting and using
conditional formatting with names ranges.
1. I have a range that includes 4 different columns with conditional
formatting. Everything is fine. I insert a row to a a new record in its proper
place in the order, and it ends
OK, I've found the answer from someone on the LO Ask forum (why are there
two?).
It seems that LO doesn't allow you to click on a menu item unless there's an
action associated with it. Seems sensible, but I was designing the user
interface before writing the macros. Once I'd added the actions all
Virgil,
Odd. It seems that your experience is the opposite of mine, but I don't have
a Linux system that I can try it out on.
-
Peter
--
View this message in context:
http://nabble.documentfoundation.org/Why-is-a-custom-menu-item-greyed-out-tp4204211p4204321.html
Sent from the Users
Regina,
See my comments below.
Best regards, and a successful new year,
Peter
mailto:l...@ptoye.com
www.ptoye.com
-
Wednesday, January 4, 2017, 12:31:35 AM, you wrote:
Hi Peter,
ptoye schrieb:
> I wanted to transfer a dialogue from a text document to the live
Gordon,
I am referring specifically to a Dialog(ue), not to text within a file.
-
Peter
--
View this message in context:
http://nabble.documentfoundation.org/Problems-exporting-and-importing-a-dialogue-tp4204239p4204319.html
Sent from the Users mailing list archive at Nabble.com.
--
To
Gabriele,
A Dialogue (or Dialog if you like the US spelling) is a feature of Libre
Office which does not appear to be documented anywhere in the User Guides.
It allows you to display a window with controls (much like a form) so that
the user can interact with the document at runtime. Look in the
11 matches
Mail list logo