Hiding paragraphs not working

users
#1

I was using OpenOffice rather than LibreOffice last year, and
constructed an address label file that could omit a blank field from a
label, or omit it if it was equal to a certain value, and in fact it did
one of each, quite successfully. However, when I came to use this file
this year, with LibreOffice 3.4.3 (OOO340m1 (Build 302), as supplied in
the Debian squeeze backports, I discovered that the hiding did not work
any more.

I tried reconstructing the conditions, using full Database.Table.Field
names, but it made no difference.

Is this a known problem? If so, is there a workaround or fix?

Please get back to me (on the list is fine) if you need more information.

#2

Phil Reynolds wrote:

I was using OpenOffice rather than LibreOffice last year, and
constructed an address label file that could omit a blank field from a
label, or omit it if it was equal to a certain value, and in fact it did
one of each, quite successfully. However, when I came to use this file
this year, with LibreOffice 3.4.3 (OOO340m1 (Build 302), as supplied in
the Debian squeeze backports, I discovered that the hiding did not work
any more.

I tried reconstructing the conditions, using full Database.Table.Field
names, but it made no difference.
[...]
Please get back to me (on the list is fine) if you need more information.

Could you upload a simplified sample document (with all sensitive
information removed)? This list does not support attachments, so
you'll have upload to internet (something like www.2shared.com).

Regards
Stephan

#3

Hi :slight_smile:
You can always upload to Nabble and that would keep the file closer to the
thread for the archives.

In Nabble click on Reply and then the "More" drop-down gives you the option
to "upload" and works very much the same as adding an attachment to an
email.
Regards from
Tom :slight_smile:

#4

The file I'm actually using is not in the least bit sensitive.

#5

The file I'm using is not in the least bit sensitive.

I've followed the suggestion to use Nabble to send it.

http://nabble.documentfoundation.org/file/n3565125/Christmas_labels.odt
Christmas_labels.odt

#6

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

I was using OpenOffice rather than LibreOffice last year, and
constructed an address label file that could omit a blank field from a
label, or omit it if it was equal to a certain value, and in fact it did
one of each, quite successfully. However, when I came to use this file
this year, with LibreOffice 3.4.3 (OOO340m1 (Build 302), as supplied in
the Debian squeeze backports, I discovered that the hiding did not work
any more.

I got your document and I'm looking it over, but can't figure out which
fields are supposed to be omitted. Can you clarify?

(I am actually interested in this, too, because I've been trying to
figure out a way to omit paragraphs when there is no suite number, for
instance, so I want to see how you did it and figure out how to fix your
problem at the same time.)

- --
Steven Shelton

#7

The county, when empty. The country, when equal to "United Kingdom".

#8

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

I got your document and I'm looking it over, but can't figure out which
fields are supposed to be omitted. Can you clarify?

The county, when empty. The country, when equal to "United Kingdom".

I don't see a hidden paragraph field set there at all on the copy you
sent me. Perhaps the fields got stripped somehow?

- --
Steven Shelton

#9

I am a new Mac and LibreOffice user. A bad combination, no doubt.

In any case, after a number of days of trouble-free use, I tried to shut down a LibreOffice window and, in due course, ended up with a popup containing the message:

  "The application "LibreOffi," unexpectedly quit while trying to restore its windows. Do you want to try to restore its windows again?"

The options are "don't restore windows" and "restore windows."

Selecting either had no effect and my computer was hamstrung. I spoke with Mac support several times. They helped me recover use of the computer.

Subsequently, I uninstalled LibreOffice and installed it again, but the message persists.

Can anyone tell me how to clear this situation.

Thanks very much for any assistance that can be provided.

Russ Peterson

#10

Sorry. Didn't change the subject on my first mailing.

#11

Hi Russell,

Can anyone tell me how to clear this situation.

Look for the presence of *.lck files on your desktop, or in your user directories. These files are hidden so are not directly visible in your Finder (or with locate for that matter). There are several apps or scripts available on the internet for revealing hidden files on Mac.

Alternatively/additionally, delete or rename your /Users<username>/Library/Application Support/LibreOffice folder, then restart the application.

Alex

#12

Sorry. Didn't change the subject on my first mailing.

> I am a new Mac and LibreOffice user. A bad combination, no doubt.

The combination isn't bad at all... I've used LibO (and OOo before it) on
my Mac for several years now.

>
> In any case, after a number of days of trouble-free use, I tried to shut
down a LibreOffice window and, in due course, ended up with a popup
containing the message:
>
> "The application "LibreOffi," unexpectedly quit while trying to
restore its windows. Do you want to try to restore its windows again?"
>
> The options are "don't restore windows" and "restore windows."
>
> Selecting either had no effect. I spoke with Mac support several times
and was able to get control of the computer using force quit on LibreOffice.
>
> Subsequently, I uninstalled LibreOffice and installed it again, but the
message persists, and when I used LibreOffice, I still have to use force
quit to close it down.
>
> Can anyone tell me how to clear this situation.
>
> Thanks very much for any assistance that can be provided.
>
> Russ Peterson

The problem is some conflict between Lion and LibO, and not even on all
Macs with Lion. I have it from time to time on a MBP, not on my iMac.
How to avoid it: closing LibO before shutting down your computer.
It will still occur when LiboO hangs and you have to Force Quit.

Remedy: use Terminal to throw away the savedState file that seems to cause
the problem of the obstinate restore/don't restore window.

Open Terminal (in your Applications/Programs folder > Auxiliaries or Help
Programs)
after the prompt ($) type:

rm -fr ~/Library/Saved\ Application\ State/org.libreoffice.script.savedState/

followed by a return and the problem should be solved...

You can find the Terminal command solution in bug report 39007.
https://bugs.freedesktop.org/show_bug.cgi?id=39007

It was discussed on this list a few months ago, but the bug still isn't
solved in 3.4.4, probably causing quite a few Mac-users to abandon LibO!

#13

Dear Guy,

Thank you so much for your guidance. Your solution worked wonderfully. I'm now back to using LibreOffice on my Mac. Hooray!

Kindest regards,

Russ