I recently noticed that a complicated spreadsheet that had previously
functioned correctly was giving wrong answers without warning. After the usual
wailing and gnashing of teeth, I traced the problem to a cell containing
=C4-SUM(G11:G1016)”. Further experimentation produced the following
Hi Gary,
Le 12/02/2015 11:33, Gary Collins a écrit :
Hi,
Hopefully an easy question for someone :-)
How to I turn off auto-generation of list entries (preferably without
altering any other settings?
I generally tend to find this feature a pain in the proverbials, and would
much rather
Hi,
Hopefully an easy question for someone :-)
How to I turn off auto-generation of list entries (preferably without altering
any other settings?
I generally tend to find this feature a pain in the proverbials, and would much
rather apply list formatting, etc using styles, after a document
Thanks for your relpy, Simos.
I had assumed that I was (or should be) getting single Unicode characters, and
I think you have confirmed that in your reply.
I was wondering if the language input setting should be regarded as local or
global; I had assumed global, but a few tests have shown
Hi :)
I don't seem to be able to get the (wrong) results as described. I'm
attaching a quick little simple example file to give a few examples of
what it sounds like you are doing - and a table method. Obviously i
have missed something from the description so hopefully you'll be able
to clarify
Hi Andreas,
thanks for your reply.
I've a Calc-Sheet with address data (linked with Writer it was transformed
to a database).
In my used Writer (LO 4.4) the query does no work properly.
The query described by you would be in my case [my calc
sheet].members.title != but only [title] != is
Hi Sophie,
Thanks for the link; yes, I looked at that menu as well, but couldn't see
anything pertinent to generation of list entries. Perhaps I have a blind spot?
/Gary
From: Sophie gautier.sop...@gmail.com
To: users@global.libreoffice.org
Sent: Thursday, 12 February 2015, 10:41
On Tue, 10 Feb 2015 09:43:20 -0700 (MST)
V Stuart Foote vstuart.fo...@utsa.edu wrote:
Jim Seymour wrote
[snip]
Question: Do recent (i.e. 4.3.x.x and later) versions of LO
*capably* allow the opening/editing/saving of PDF files that are
writable and not encrypted or otherwise protected?
Hi :)
I think post as a Feature Request. If at all possible i think it's
best to post Feature Requests instead of bug-reports. They have a
much bigger feel-good factor and i suspect they are more likely to
attract new devs.
I think there has got to be a default and i tend to prefer it if there
There are times when I copy paste from websites to Calc. Things like
lists of TV stations or Twitter followers.
When I do so it also captures all the images and pastes them to the
document.
This causes a big mess since most of the images cover each other and do
not align with their
Brian Barker wrote:
At 12:14 12/02/2015 -0800, Spencer Graves wrote:
I recently noticed that a complicated spreadsheet that had previously
functioned correctly was giving wrong answers without warning. After
the usual wailing and gnashing of teeth, I traced the problem to a
cell containing
Hi :)
I was going to suggest that answer too but Brian beat me and gave a
better answer too :)) I felt like i really learned something that i
could possibly remember and probably even find useful myself. Usually
my usage is tooo basic to make much advantage of most of the answers
here but it's
Hi :)
Hmm, i am not sure. Have you made sure you have
administrator/SuperUser rights? Sudo perhaps?
Regards from
Tom :)
On 12 February 2015 at 17:00, sqroot sqr...@zoho.com wrote:
hallo!
I was curious to test LO4.4, so i tried to install it on Linux Mint 17 Qiana.
I followed the
Emil Payne wrote:
There are times when I copy paste from websites to Calc. Things like
lists of TV stations or Twitter followers.
When I do so it also captures all the images and pastes them to the
document.
This causes a big mess since most of the images cover each other and do
not align
At 12:14 12/02/2015 -0800, Spencer Graves wrote:
I recently noticed that a complicated spreadsheet that had
previously functioned correctly was giving wrong answers without
warning. After the usual wailing and gnashing of teeth, I traced the
problem to a cell containing =C4-SUM(G11:G1016).
I think have a wee difficult to understand what you are doing, as I do
not see any error. You put constants 1 and 2 in the cells A1 and A2 and
a sum formula in A3. Then you insert an empty cell in A1 while moving
the existing content in the cells one step to the right. Hence after the
Hi :)
I'm guessing you are a fairly logical and astute thinker rather than a
typical office drone or a typically tech-averse accountancy person.
Yes there is no problem unless the user is a moron. Sadly many of us
often are a bit moronic from time to time.
The suggestion was to maybe write a
PLEASE TAKE ME OFF OF ALL OF YOUR LISTS! THANK YOU.
--
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:
At 15:14 12/02/2015 -0600, Emil Payne wrote:
There are times when I copy paste from websites to Calc. Things
like lists of TV stations or Twitter followers. When I do so it also
captures all the images and pastes them to the document. This causes
a big mess since most of the images cover each
Hello. I just installed 4.4.03 on Windows 7.
I'd like to use Base.
When I click on the LibreOffice icon on my desktop, I see a screen with list
of buttons on the left under Create. I select Base Database but nothing
happens.
The only buttons that work are Writer and Calc.
What am I doing
Hi :)
PDF Editor or PDF Editing can mean many different things. It
rarely means editing in the way you would edit a .doc or .odt.
In a word-processor format when you delete words or add words to a
sentence the whole line reflows to avoid leaving a gap or having words
over-writing each other.
Hi :)
There are various different layers of hidden codes. Ctrl A, Delete
only gets rid of a few of them.
Some can be seen by pressing the backwards sort of double-struck P in
the toolbar icons. This shows non-printing characters, such as tabs
and end-of-paragraphs, that don't get printed out.
At 10:33 12/02/2015 +, Gary Collins wrote:
Hopefully an easy question for someone :-)
Yup: so easy that there are two answers!
How to I turn off auto-generation of list
entries (preferably without altering any other
settings? I generally tend to find this feature
a pain in the
Hi :)
I think this is a nice idea. Most people on these mailing list
already do quite a lot of work and are under-appreciated. It would be
nice to see this idea formally extended to cover all the non-devs who
do fantastic work in 'User' / Client Support, Documentation,
Translation.
I think that
Hi Tom,
A lot of people seem to open an old document and then use that to
create new documents
[sometimes that's the easiest way in windows]
but that way tons of hidden formatting codes and
stuff seem to lurk and sometimes do some really odd things.
[I'd have thought that selecting all
From: Brian Barker b.m.bar...@btinternet.com
To: users@global.libreoffice.org
Sent: Thursday, 12 February 2015, 13:12
Subject: Re: [libreoffice-users] Writer: how to turn off auto-generated lists?
At 10:33 12/02/2015 +, Gary Collins wrote:
Hopefully an easy question for someone
Hi :)
Yes, you are doing the correct thing.
So, my answer doesn't explain why you are running into the problems
you are having. My advice might still have helped but more by
accident than for the reasons i gave. Errr, of course LibreOffice
also puts tons of stuff in that underlaying coding but
So it's a Calc sheet actually. I would simply use Calc to concatenate the
proper field contents and then use that calculated field for the mail merge.
Something like =TRIM($A2 $B2 $C2) with a column title in the firs
row copied down along the list.
A database query would be easier to handle
Hi Andreas,
thank you for your effort. :)
I got the fail.
Our concluded condition is working correctly.
Field type - Conditional Text
Condition: [Titel] !=
Then:
Else:
Now the big BUT!
If I click me through the mail merge assistant I got a document preview
where I can scroll through the
ha ha!I guess it doesn't surprise me. Thinking about it though, that's not what
I normally do. What I do is to open a document, then create a new one from the
filenew menu entry. This seems to me to be the best way to do it - but maybe
I'm wrong.
Anyway, I'm probably going to install the latest
hallo!
I was curious to test LO4.4, so i tried to install it on Linux Mint 17 Qiana. I
followed the installation instructions, first purged the old LO-version,
downloaded the file, checked it, etc... installation worked fine. but when I
try to start it, wheter from the icons or from the
That wizard is counter productive and irritating for several reasons. You can
create serial letters easier without it. Once you have a registered database
connection to your list (F4 shows your database and tables), all you need to
do is this:
Select your table or query in the left pane and then
32 matches
Mail list logo