*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 in
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 (A
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:
http://nabble.documentfoundation.org/Problems-exporting-and-importing-a-dialogu
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 new
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 u
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 mailin
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 versio
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 u
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 L
11 matches
Mail list logo