[libreoffice-users] Expanding top cell of table

[James Wilde]

Discovered two interesting 'features' by accident this weekend.  This is one of 
them.

I have given up on using mailmerge.  The labels never print out as you want 
them.  So I decided to create a table looking like the template for a sheet of 
mailing labels.  I got one very unexpected result.  Try this:

Create a table with three columns and eight rows.
Place cursor in the first cell on the SECOND row and press return six times.  
The cell expands
Place cursor in the third, fourth, etc, to eighth row and press return six 
times.  The cells expand.
Now place the cursor in the first cell on the FIRST row and press return six 
times.

The table moves six rows down, and the first row is still only one line deep.

To open up the first row, you have to press return once (moving the table down 
one unnecessary row) then move the cursor again into the first cell and press 
return the six times you need.  Finally you can go outside the table and delete 
the extra row by which you moved the table down.

Not something one does every day, but someone might like to take a look at it.

//James
-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

[libreoffice-users] OOo user profile migration

[Sean Fenton]

Please add an entry to the FAQ [1] about migrating an OpenOffice.org user
profile [2]. I need to do so on Mac and Windows.

[1] http://www.libreoffice.org/get-help/faq/
[2] http://user.services.openoffice.org/en/forum/viewtopic.php?f=6&t=34858

Thank you,


Sean Fenton

-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

[libreoffice-users] 100% zoom is huge in Snow Leopard

[mr9times]

Hi,
I have LO installed on my Win7 laptop and Mac Pro running 10.6.6. I use a
24.6" 1920x1080 monitor for both (using KVM).
On my laptop everything looks good, but on my Mac, 100% zoom is HUGE. I have
to scale the Mac version down to 45% to make the workspace nearly 1:1 with a
sheet of 8.5x11 paper. Win7 is near 1:1 at 95% zoom. FWIW, Office 2004 was
displaying near 1:1 at 100% on the Mac.

Are others experiencing this as well? I did some searching on the web and
the mail list archive but didn't find anything.


-- 
View this message in context: 
http://nabble.documentfoundation.org/100-zoom-is-huge-in-Snow-Leopard-tp2600789p2600789.html
Sent from the Users mailing list archive at Nabble.com.

-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

[libreoffice-users] Re: blocks of cells have no borders (old openoffice user)

[NoOp]

On 02/28/2011 07:09 PM, fhd...@unm.edu wrote:
> 
> Hello,
> 
> I converted from openoffice 3.2.1 to libreoffice 3.3.1 (final)
> 
> I've been using oo for a long time.
> 
> When I open the calc .ods  with libreoffice, some cells
> are borderless.  i.e. in some .ods file I open
> parts of some rows are like that. in other .ods file
> I open,  a block, let say 4x8, is like that. in some
> .ods files  misc cells in various locations are like that.
> 
> I can right-click and tell it to revert back to
> default formatting and that fixes the borderless issue but I will
> also lose all the formattings.
> 
> 
> I did play with all the calc options (even openoffice legacy ,etc)

Perhaps related?

[[BUG] Background colors remove cell lines]
https://bugs.freedesktop.org/show_bug.cgi?id=30800
[grid lines disappeared in Calc for cells with background colour]



-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

Re: [libreoffice-users] blocks of cells have no borders (old openoffice user)

[Don Myers]

I've been using OO for about 10 years. The first 8 was using it in 
windows, and the last 2 using it in Ubuntu. Now I'm in LibreOffice. When 
I switched to Ubuntu, files I had saved in OO calc in windows when 
opened in Ubuntu had cells with data with a white background (fill) 
instead of showing the cell borders. They did not have a background 
color (fill) selected in Windows. I simply selected the group of  white 
cells (sometimes complete columns), right clicked, selected format, then 
background, and then changed the fill from white to no fill. Everything 
was fine then. I've not used OO or LibreOffice in Windows since I 
switched to Ubuntu so I don't know what would happen if I opened a 
document I had created in Ubuntu in Windows. Maybe this will solve your 
problem.



On 02/28/2011 10:09 PM, fhd...@unm.edu wrote:


Hello,

I converted from openoffice 3.2.1 to libreoffice 3.3.1 (final)

I've been using oo for a long time.

When I open the calc .ods  with libreoffice, some cells
are borderless.  i.e. in some .ods file I open
parts of some rows are like that. in other .ods file
I open,  a block, let say 4x8, is like that. in some
.ods files  misc cells in various locations are like that.

I can right-click and tell it to revert back to
default formatting and that fixes the borderless issue but I will
also lose all the formattings.


I did play with all the calc options (even openoffice legacy ,etc)

This is something I did not expect since my calc files are rather simple.

Any ideas,
Thanks,
F-





--

*~~*
Don C. Myers
e-PRO Certified by the National Association of Realtors
Manager, Farm and Rural Property Division
*Coldwell Banker University Realty
*126 East Foster Avenue, State College, PA 16801
Phone: 814-237-6543 Fax: 814-237-6502
Visit the Farm and Rural Property Division Website at 
www.cbur-ruralproperty.com _

_View Don's farm website: www.myersfarm.com 
*~~*


--
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

[libreoffice-users] Re: LibO for Ubuntu

[NoOp]

On 02/28/2011 06:52 AM, James Wilde wrote:
> 
> On Feb 28, 2011, at 00:50 , NoOp wrote:
...
>> 
>> I'd be willing to bet that you have the Ubuntu libreoffice PPA.
>> What do you show for:
>> 
>> $ cat /etc/apt/sources.list | grep libreoffice
>> 
>> Can you also show the output of:
>> 
>> $ apt-cache policy libreoffice
>> 
> Thanks, NoOp.  I decided to google on it, and discovered that I was
> lacking a repository in my Synaptic.  Fixed that last night, and now
> I have LioB installed.  Must just update it with the UK, Swedish and
> Chinese dictionaries and stuff.

Hope that works for you. Personally, unless I were testing/contributing
for Ubuntu, I'd take ZenWiz's advise and install from the libreoffice
.debs.

I have issues with a PPA/package that insists on uninstalling (or
insisting that I uninstall) an existing OOo install simply because the
packager can't figure out how to install (or is too lazy to do so) the
LO package without affecting existing office packages.
  I wonder just how many would find it acceptable if the LO PPA also
removed all other office packages (Abiword for instance) in the process?
Or if the TDF .deb required that you uninstalled your distro OOo before
installing. Amazing...

Please remember to report issues in launchpad & specify that you are
running the PPA version. Also, if you report issues here, please do the
same (specify that you are running a distro PPA version).






-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

[libreoffice-users] blocks of cells have no borders (old openoffice user)

[fhdata]

Hello,

I converted from openoffice 3.2.1 to libreoffice 3.3.1 (final)

I've been using oo for a long time.

When I open the calc .ods  with libreoffice, some cells
are borderless.  i.e. in some .ods file I open
parts of some rows are like that. in other .ods file
I open,  a block, let say 4x8, is like that. in some
.ods files  misc cells in various locations are like that.

I can right-click and tell it to revert back to
default formatting and that fixes the borderless issue but I will
also lose all the formattings.


I did play with all the calc options (even openoffice legacy ,etc)

This is something I did not expect since my calc files are rather simple.

Any ideas,
Thanks,
F-



--
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

Re: [libreoffice-users] Re: Send document from LO 3.3.1 on OSX seems to produce no response

[Tom Davies]

From: Larry Gusaas 
To: users@libreoffice.org
Sent: Mon, 28 February, 2011 20:13:40
Subject: [libreoffice-users] Re: Send document from LO 3.3.1 on OSX seems to 
produce no response

On 2011/02/28 12:47 PM  Marc Grober wrote:
> Nope,  tried all those variations - two real options; a) you invoke the
> package which results in TBird coming forward, but no envelope, or b)
> you invoke the binary, in which case you get an error message no matter
> the flags indicatin that there is already a copy running. OSX does not
> have a shell file I believe (at least not a thunderbird.sh like unix.)
There is a long standing bug report on this for Thunderbird. It is now marked 
as 
"Resolved Fixed" but doesn't seem to be integrated into current version of 
Thunderbird. (or not actually fixed) See:
https://bugzilla.mozilla.org/show_bug.cgi?id=287345

Larry


Hi :)
It looks as though there are still 2 more steps.  
1. The fix/patch needs to be beta tested or QA have to "Verify" it.  There 
might 
be a way for you to be one of the  beta testers but i don't know how.
2. The fix/patch needs to be released.

Regards from
Tom :)



  
-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

Re: [libreoffice-users] Re: Send document from LO 3.3.1 on OSX seems to produce no response

[Marc Grober]

On 2/28/11 11:13 AM, Larry Gusaas wrote:
> On 2011/02/28 12:47 PM  Marc Grober wrote:
>> Nope,  tried all those variations - two real options; a) you invoke the
>> package which results in TBird coming forward, but no envelope, or b)
>> you invoke the binary, in which case you get an error message no matter
>> the flags indicatin that there is already a copy running. OSX does not
>> have a shell file I believe (at least not a thunderbird.sh like unix.)
> There is a long standing bug report on this for Thunderbird. It is now
> marked as "Resolved Fixed" but doesn't seem to be integrated into
> current version of Thunderbird. (or not actually fixed) See:
> https://bugzilla.mozilla.org/show_bug.cgi?id=287345
> 
> Larry

@Larry

OK - I posted a comment on that bug and referenced the similar POWERPC
bug that was mentioned there as well as the current issue with acrobat

It seems like they marked it resolved because the underlying open -a
command worked, but as noted by others in October of last year, this
does not always work, and I could get an envelope to come up in some
cases from the command line, but never with an attachment I don;t
know whether this is a matter of passing the correct location or
something else, but it is clearly a continuing problem that effects a
broad range of software.

-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

[libreoffice-users] Re: MS Office 97 Template files fail to open (re-posting previously wrong subject)

[NoOp]

On 02/28/2011 12:30 PM, NoOp wrote:
> o Word97/2003 Word - opens fine
> o OOo 3.3.0 (Windows 2000/XP/7) - opens fine
> o OOo 3.3.0 (linux - standard version from openoffice.org) - opens fine
> o (U)OOo 3.3.0 (linux - Ubuntu/go-oo version) - fails & crashes
> o LO 3.2.1 (linux - from libreoffice.org) - fails "Read-Error. This is
> not a WinWord97 file."
> o LO 3.2.1 (Windows XP/7) - fails "Read-Error. This is not a WinWord97 file.

Correction:
Tested a Word97 .dot file (attached) provided by a user on the user
mailing list (E_Base.dot) with the following results:
o Word97/2003 Word - opens fine
o OOo 3.3.0 (Windows 2000/XP/7) - opens fine
o OOo 3.3.0 (linux - standard version from openoffice.org) - opens fine
o (U)OOo 3.2.1 (linux - Ubuntu/go-oo version) - fails & crashes
o LO 3.3.1 (linux - from libreoffice.org) - fails "Read-Error. This is
not a WinWord97 file."
o LO 3.3.1 (Windows XP/7) - fails "Read-Error. This is not a WinWord97 file.




-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

[libreoffice-users] Re: MS Office 97 Template files fail to open (re-posting previously wrong subject)

[NoOp]

On 02/28/2011 04:13 AM, Derry Birse wrote:
> Thanks I will try 3.2.1. Do you know how you install these filters manually?
...

See Charles' reply.

You need to reinstall LO and select 'Custom' and then
'Optional Components':
http://www.libreoffice.org/get-help/installation/windows/
That link doesn't show the expanded 'Optional Components', but if you
click on it when you get to that screen you will see 'Legacy Filters'.
If there is a red X next to it, click to have it included on the
install/reinstall.

Note: I just tested your E_base.dot file.

o Word97/2003 Word - opens fine
o OOo 3.3.0 (Windows 2000/XP/7) - opens fine
o OOo 3.3.0 (linux - standard version from openoffice.org) - opens fine
o (U)OOo 3.3.0 (linux - Ubuntu/go-oo version) - fails & crashes
o LO 3.2.1 (linux - from libreoffice.org) - fails "Read-Error. This is
not a WinWord97 file."
o LO 3.2.1 (Windows XP/7) - fails "Read-Error. This is not a WinWord97 file.

Note: OOo & LO installs included the Optional Components legacy filters
etc., so it won't make a difference if you install. I reckon that you've
come across a bug that should be reported. Please see:
http://wiki.documentfoundation.org/BugReport

I did a search:

and it appears there already is a bug report opened:
https://bugs.freedesktop.org/show_bug.cgi?id=34023
[FILEOPEN: Particular WORD (97?) document can not be opened]
You can add your comments to that bug report (I'll do the same).

Until that bug is fixed, your best bet (IMO) is to install OOo 3.3.0 and
use that.


-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

Re: [libreoffice-users] Problem with spellcheck

[Andrew McLean]

On 28/02/2011 16:58, Richard Hainsworth wrote:
> This only causes problems if you have more than one possible module 
(I have en-gb and ru in addition to en-us).


How can I check which modules I have ?



But if a spellcheck has completed with nothing happening then no 
language module has been chosen. Type F7 and there is a box at the top 
which says which language has been selected. If there is nothing 
there, then suggestion below will work.


This encapsulates my problem. I can't get at this box because there is 
anothe d. box in front of it which tells me that the spellcheck is 
complete. When I hit OK, BOTH db's disappear. I need to be able to 
access the

'F7' box and make use of it...I can't find out how to do this.
AM


--
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

[libreoffice-users] Re: Send document from LO 3.3.1 on OSX seems to produce no response

[Larry Gusaas]

On 2011/02/28 12:47 PM  Marc Grober wrote:

Nope,  tried all those variations - two real options; a) you invoke the
package which results in TBird coming forward, but no envelope, or b)
you invoke the binary, in which case you get an error message no matter
the flags indicatin that there is already a copy running. OSX does not
have a shell file I believe (at least not a thunderbird.sh like unix.)
There is a long standing bug report on this for Thunderbird. It is now marked as "Resolved 
Fixed" but doesn't seem to be integrated into current version of Thunderbird. (or not actually 
fixed) See:

https://bugzilla.mozilla.org/show_bug.cgi?id=287345

Larry
--
_
Larry I. Gusaas
Moose Jaw, Saskatchewan Canada
Website: http://larry-gusaas.com
"An artist is never ahead of his time but most people are far behind theirs." - 
Edgard Varese



--
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

[libreoffice-users] wmv video in existing power point slide show

[roman76aut]

Hello!

I have an existing slide show from powerpoint including some video files.
Those video files are not started as they are on WinXP in PowerPoint.

Not working system is Ubuntu Linux 9.10 and Openoffice 3.2 and second PC is
WinXP with LibreOffice (same PC with PowerPoint is working)

I'm surprised not finding thousends of articles about this issue (or better
solving this issue :) )

What else is needed?

I installed extended media formats and videos can be played in a mediaplay
on linux. I'm not sure how those videos are integrated in the slideshow
because they are attached in the same directory and I'm not an expert in
slideshows.

Thanks for any help!

BR
Roman

-- 
View this message in context: 
http://nabble.documentfoundation.org/wmv-video-in-existing-power-point-slide-show-tp2597564p2597564.html
Sent from the Users mailing list archive at Nabble.com.

-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

Re: [libreoffice-users] Problem with spellcheck

[Manfred J. Krause]

Hi,

On Mon, Feb 28, 2011 at 19:47, am577  wrote:

>> [...]
>> Documentation | OOo3 User Guides | Writer Guide
>> Chapter 3: Working with Text
>> Using language tools
>>
>> 
>>
>>[...]
>>
> OK - I was already familiar with this, and I think I am following the
> recommendations correctly.
> But I do notice another symptom which may be relevant.
> The document you refer to here shows that when you select a particular
> language from the
> Tools/Language menu, it adds a tick to the selection, implying that it will
> remember that setting
> for the future. On my system, this only works for the first menu item 'For
> selection'. With the next two menu items ('For paragraph' and 'For all
> text') the tick doesn't appear - it's as if it won't allow me to
> set the language.

Tools > Language > For Selection
shows the language attribute of the selected text at the cursor
position (with a check mark).
There you can change the language attribute for the selection.

With Tools > Language > For Paragraph / For all Text
you can change the language attribute (at the cursor position) for the
paragraph or for all text.
There are no check marks.

The language attribute at the cursor position is shown in the status bar.
Please set the cursor in a part of your text, where spell check isn't available.
What language is shown in the status bar?

Open the Styles and Formatting window (F11).
What language attribute is shown in the Font tab for the "Default"
paragraph style
(Right click > Modify)?

Set the cursor in a part of your text, where spell check isn't available.
What paragraph style is highlighted in the Styles and Formatting window?
What language attribute is there shown in the Font tab?

Tools > Language > For all Text > (select) English (UK) -
does it work?

Tools > Language > For all Text > (select) Reset to Default Language -
does it work?

> You might think that suggests that I don't have the
> English UK dictionary installed,
> but I do, and for a few documents it works OK.
> Something is broken, and has been for some months (when I first noticed this
> problem in OpenOffice), and hasn't changed with replacing OO with LO.

Could you upload (somewhere - not to the mailing list) a sample
document with broken spell check?

mjk

-- 
Mu


-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

Re: [libreoffice-users] LibO for Ubuntu

[MR ZenWiz]

On Sun, Feb 27, 2011 at 4:50 AM, David Nelson  wrote:
> Hi, :-)
>
> On Sun, Feb 27, 2011 at 20:29, James Wilde  
> wrote:
>> Have I missed something, or is LibO really not to be found amongst the apps 
>> available via Synaptic or the new Ubuntu Software Centre?
>
> Search for "libreoffice" rather than "LibO"... It's there in 10.10...
>
Only if a) you already have it installed or b) you have added the PPA
to your apt-* configuration.  It is not there by default.

Also, I recommend using the official release *.debs from TDF.  Read
back entries in this list's archives for the pros and cons of why or
why not.

-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

Re: [libreoffice-users] Re: Find/Replace non printing characters

[MR ZenWiz]

On Sat, Feb 26, 2011 at 5:09 PM, dsmithnc  wrote:
> Thanks, folks, exactly what I was looking for.  Just have to remember the
> location of that table!
>

Help->Contents, search for regular expressions?

-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

Re: [libreoffice-users] Re: Welcome to users@libreoffice.org

[MR ZenWiz]

On Mon, Feb 28, 2011 at 2:33 AM, Derry Birse  wrote:
> We are looking at OpenOffice as a potential corporate tool, however we have...

Did you mean LibreOffice?  If not, you might want to go to an
OpenOffice list or forum with this question

-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

Re: [libreoffice-users] Re: Send document from LO 3.3.1 on OSX seems to produce no response

[Marc Grober]

On 2/28/11 9:03 AM, NoOp wrote:
> On 02/28/2011 01:32 AM, Alexander Thurgood wrote:
>> Le 28/02/11 05:39, Marc Grober a écrit :
>>
>> Hi Marc,
>>
>>> On OSX having installed 3.3.1 choosing Send Document or other send
>>> options produces no response and no log entries. Thunderbird was
>>> selected from Internet options.
>>>
>>
>> Yes, this doesn't quite work as intended...or at least, not as its
>> alleged to work on other platforms. From what I understand, you can not
>> simply point to the TB application bundle in your list of applications,
>> but have to drill down through the bundle's contents to point to the
>> thunderbird executable binary.
> 
> If TB on OSX (unix) is like linux, you'd do the full path the the
> thunderbird shell file rather than the thunderbird-bin.
> 
>>
>> You also have to make sure when you want to send the document via e-mail
>> that TB is not already running, otherwise you will get an error message,
>> and nothing will happen.
> 
> Should work (I think - I do not have OSX) if you use the shell file
> rather than the bin. If not, you might try '-compose':
> 
> //thunderbird -compose

@NoOp
Nope,  tried all those variations - two real options; a) you invoke the
package which results in TBird coming forward, but no envelope, or b)
you invoke the binary, in which case you get an error message no matter
the flags indicatin that there is already a copy running. OSX does not
have a shell file I believe (at least not a thunderbird.sh like unix.)

-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

Re: [libreoffice-users] Problem with spellcheck

[am577]

Please have a look at:

Documentation | OOo3 User Guides | Writer Guide
Chapter 3: Working with Text
Using language tools



HTH
mjk

OK - I was already familiar with this, and I think I am following the 
recommendations correctly.

But I do notice another symptom which may be relevant.
The document you refer to here shows that when you select a particular 
language from the
Tools/Language menu, it adds a tick to the selection, implying that it 
will remember that setting
for the future. On my system, this only works for the first menu item 
'For selection'. With the next two menu items ('For paragraph' and 'For 
all text') the tick doesn't appear - it's as if it won't allow me to
set the language. You might think that suggests that I don't have the 
English UK dictionary installed,

but I do, and for a few documents it works OK.
Something is broken, and has been for some months (when I first noticed 
this problem in OpenOffice), and hasn't changed with replacing OO with LO.

AM


--
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

Re: [libreoffice-users] Re: Send document from LO 3.3.1 on OSX seems to produce no response

[Marc Grober]

On 2/28/11 12:32 AM, Alexander Thurgood wrote:
> Le 28/02/11 05:39, Marc Grober a écrit :
> 
> Hi Marc,
> 
>> On OSX having installed 3.3.1 choosing Send Document or other send
>> options produces no response and no log entries. Thunderbird was
>> selected from Internet options.
>>
> 
> Yes, this doesn't quite work as intended...or at least, not as its
> alleged to work on other platforms. From what I understand, you can not
> simply point to the TB application bundle in your list of applications,
> but have to drill down through the bundle's contents to point to the
> thunderbird executable binary.
> 
> You also have to make sure when you want to send the document via e-mail
> that TB is not already running, otherwise you will get an error message,
> and nothing will happen.
> 
> 
> Alex
> 
> 

@Alex,

I just determined that Acrobat has the same issue.

> The SendMail doesn't know how to talk to your default mail client. 
> Please select a different mail application to use.

Adobe points the finger at Mozilla, and mozilla reciprocates. Moreover,
setting thunderbird as your default mail client on OSX from MacMail will
NOT result in TBird being regarded as the default mail client by some
applications, lol.

There may in fact be a command line option for invoking a Tbird envelope
from inside the package without invoking a new instance of Tbird - seems
to me I had to address something like that on aix quite a few years ago.
Unfortunately I tried
/Applications/Thunderbird.app/Contents/MacOS/thunderbird-bin -silent
-compose
and that did not work (resulted in the behavior you mention) and adding
quotes results in LO not being able to find an e-mail app.

Went back to look at my ancient version of NeoOffice and that won't even
start now

Marc

-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

[libreoffice-users] Re: Send document from LO 3.3.1 on OSX seems to produce no response

[NoOp]

On 02/28/2011 01:32 AM, Alexander Thurgood wrote:
> Le 28/02/11 05:39, Marc Grober a écrit :
> 
> Hi Marc,
> 
>> On OSX having installed 3.3.1 choosing Send Document or other send
>> options produces no response and no log entries. Thunderbird was
>> selected from Internet options.
>> 
> 
> Yes, this doesn't quite work as intended...or at least, not as its
> alleged to work on other platforms. From what I understand, you can not
> simply point to the TB application bundle in your list of applications,
> but have to drill down through the bundle's contents to point to the
> thunderbird executable binary.

If TB on OSX (unix) is like linux, you'd do the full path the the
thunderbird shell file rather than the thunderbird-bin.

> 
> You also have to make sure when you want to send the document via e-mail
> that TB is not already running, otherwise you will get an error message,
> and nothing will happen.

Should work (I think - I do not have OSX) if you use the shell file
rather than the bin. If not, you might try '-compose':

//thunderbird -compose





-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

Re: [libreoffice-users] Problem with spellcheck

[Manfred J. Krause]

Hi,

On Mon, Feb 28, 2011 at 15:15, Andrew McLean wrote:
> On 28/02/2011 12:41, Sigrid Carrera wrote:
>> On Mon, 28 Feb 2011 12:22:02 + am577 wrote:
>>
>>> I have installed Libreoffice 3.3.1 on Windows 7, and I still have a
>>> problem which was there with OpenOffice:
>>>
>>> 1. Spellchecking usually does nothing. It says 'spellcheck complete'
>>>     but it hasn't actually checked anything.
>>> 2. On a few documents, it works OK i.e. it is to do with a document
>>> setting, but I
>>>     can't spot any difference between the option settings in the
>>> documents.
>>
>> [...] go to "Tools>  Options>  Language" there you can set the UI
>> language as well as the default language used in your documents. Check that
>> everything is set to your preferred language. [...]
>>
> Thanks
> Spellcheck for English UK. The required dictionary IS installed - or it
> wouldn't work for the documents where it does work.
> I believe that the problem is that for most of my documents the 'Text
> Language' is not set.
> When I spellcheck and it doesn't do anything, I can see that behind the DB
> which says '"The spell check is complete. OK" is another DB titled
> "Spelling:[None]" which then says "Text language" and the drop-down
> field next to that is blank. I can't use that DB to change this setting
> because when I click on "OK" both
> DB's disappear. For the document where spellchecking works, the "Text
> Language" field is set to English UK.
> So I need to know how to change the "Text Language" field for a document
> where it is blank, and to
> ensure that new documents also have the correct setting.
> Advice welcome !

Please have a look at:

Documentation | OOo3 User Guides | Writer Guide
Chapter 3: Working with Text
Using language tools



HTH
mjk

-- 
Putting your money where your mouth is


-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

[libreoffice-users] How to switch from apt-get to ppa install

[Olwe Melwasul]

I've looked around some, but I'm getting mixed messages. I currently
have LibreOffice 3.3.0 OOO330m19 (Build:6) installed on my computer, but I
would like to go with PPA.

Here's one advisor's advice:

sudo apt-get purge libreoffice*.*
sudo add-apt-repository ppa:libreoffice/ppa
sudo apt-get update
sudo apt-get install libreoffice

My current install was done with apt-get:

sudo dpkg -i ~/Desktop/en-US/DEBS/*.deb
sudo dpkg -i
~/Desktop/en-US/DEBS/desktop-integration/libreoffice3.3-debian-menus_3.3-9526_all.deb
etc.

What should I do to switch over to PPA install/updating. I'm on Ubuntu
10.04/Gnome, BTW.

-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

[libreoffice-users] Advanced Spreadsheet

[drew einhorn]

I've read about doing stuff sorta like what I need to do now.  But I said to
myself that's too complicated for now, I come back to this when I need it.

Right I can't even come up with the right terminology to use in an effective
google search.

The first spreadsheet will function as a data entry form,

Sheet1 is to be protected and is a template for all data entry
Column A has names of fields
Column B is reserved for entry of the values
Column C is notes for the person doing the entry

When the users add data, they:

Select Sheet1 (tab at the bottom),
Select All (Ctrl+A),
Copy (Ctrl+C),
Create new Sheet (Green-Plus tab on bottom)
Paste (Ctrl+V)
Fill in Column B, Columns A and C should be protected

I need a second spread sheet for the folks doing the analysis
it refers to the spread sheet used for data entry
Column A is Column A from Sheet1
Column B is Column B from Sheet2
Column C is Column B from Sheet3
Column D is Column B from Sheet4
Column E is Column B from Sheet5
etc.

A button/macro for new sheet in the first spreadsheet would be nice.

The external data references are essential.

pointers to the relevant documentation and/or examples would be very
helpful.



-- 
Drew Einhorn

"You can see a lot by just looking."
  --  Yogi Berra

-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

[libreoffice-users] Re: Day zero is 1904-01-01 for new spreadsheets

[NoOp]

On 02/27/2011 03:48 PM, Andreas Säger wrote:
> Am 28.02.2011 00:25, NoOp wrote:
> 
> 
>> You might try renaming ~/.libreoffice.org and let LO build a new profile
>> to see if that makes any difference.
>>
> 
> Resetting the profile cures the problem. No, I don't want to reset my 
> user profile. I'm going to reestablish my default template.
> 
> Thanks,
> Andreas
> 
> 

You may be able to check/modify the
~/.libreoffice/3/user/registrymodifications.xcu file. From my testing
yesterday I see the changes in mine that refer to the Date test:

oor:name="CaseSensitive"
oor:op="fuse">true301218991899" - this value
changes when I make the changes (1904) in Tools|Options.

The file does not open well in gedit, so I used (U)OOo to open to view &
then used gvim to modify. I changed the 1899 value to 1904, saved, and
then opened Calc - the date value was then set to 1904 in the spreadsheet.

The usual warnings apply (backup, use at your own risk, etc) :-)

Gary



-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

Re: [libreoffice-users] Problem with spellcheck

[Richard Hainsworth]

Language can be set in several places - default for all documents, 
default for document, and also for paragraph. This only causes problems 
if you have more than one possible module (I have en-gb and ru in 
addition to en-us).


But if a spellcheck has completed with nothing happening then no 
language module has been chosen. Type F7 and there is a box at the top 
which says which language has been selected. If there is nothing there, 
then suggestion below will work.


On 28/02/11 15:41, Sigrid Carrera wrote:

Hi,

On Mon, 28 Feb 2011 12:22:02 +
am577  wrote:


I have installed Libreoffice 3.3.1 on Windows 7, and I still have a
problem which
was there with OpenOffice:

1. Spellchecking usually does nothing. It says 'spellcheck complete'
 but it hasn't actually checked anything.
2. On a few documents, it works OK i.e. it is to do with a document
setting, but I
 can't spot any difference between the option settings in the documents.

spellcheck for which language? If you want to have anything other than en-US, you'll have to 
install the appropriate languagepack and helpfile in addition to the software package. Once 
you've installed all those packages, start LibO and go to "Tools>  Options>  
Language" there you can set the UI language as well as the default language used in your 
documents. Check that everything is set to your preferred language.

I think this helps.

Sigrid



--
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

Re: [libreoffice-users] ODG file into Impress

[Regina Henschel]

Hi "am577",

am577 schrieb:

Can I import a diagram created with LO Draw (xxx.odg) into an Impress
presentation ?
If so, how ? If not, what can I do ? Export to .JPG ?
AM




Have you tried a simple copy&paste? In most cases this works well.

Another way is this:
While you in Draw name the diagram so that it is shown in the navigator. 
Save the file.
In Impress use Insert > File. Select your file and open it. After a 
while you will see the file name in the window. Open the plus to get 
access to the single pages. Open the plus for the page where your object 
is. The name of the object should be there. Select it and click OK.


Kind regards
Regina

--
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

[libreoffice-users] ODG file into Impress

[am577]

Can I import a diagram created with LO Draw (xxx.odg) into an Impress 
presentation ?

If so, how ? If not, what can I do ? Export to .JPG ?
AM


--
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

Re: [libreoffice-users] Re: LibO for Ubuntu

[James Wilde]

On Feb 28, 2011, at 00:50 , NoOp wrote:

> On 02/27/2011 10:01 AM, Robert Holtzman wrote:
>> On Sun, Feb 27, 2011 at 08:50:01PM +0800, David Nelson wrote:
>>> Hi, :-)
>>> 
>>> On Sun, Feb 27, 2011 at 20:29, James Wilde
>>>  wrote:
 Have I missed something, or is LibO really not to be found
 amongst the apps available via Synaptic or the new Ubuntu
 Software Centre?
>>> 
>>> Search for "libreoffice" rather than "LibO"... It's there in
>>> 10.10...
>> 
>> Also in 10.04.
>> 
> 
> I'd be willing to bet that you have the Ubuntu libreoffice PPA. What do
> you show for:
> 
> $ cat /etc/apt/sources.list | grep libreoffice
> 
> Can you also show the output of:
> 
> $ apt-cache policy libreoffice
> 
Thanks, NoOp.  I decided to google on it, and discovered that I was lacking a 
repository in my Synaptic.  Fixed that last night, and now I have LioB 
installed.  Must just update it with the UK, Swedish and Chinese dictionaries 
and stuff.

//J
-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

Re: [libreoffice-users] Re: copy paste problem

[Benoît Majerus]

Is indeed a problem that was already present with OOo 3.2. but I hope
LibreOffice will solve it because it is quite time-consuming


On Mon, Feb 28, 2011 at 12:15, Alexander Thurgood
wrote:

> Le 28/02/11 11:47, Benoît Majerus a écrit :
>
> Hi,
>
> > I'm using Libre Office 3.3.1., Mac OS X Version 10.6.6. and Firefox
> 4.0b11.
> > When I copy text from LibreOffice to Firefox (for example Gmail), the
> > following
> > line precedes my copied text: "Version:1.0 StartHTML:000167
> > EndHTML:000709 StartFragment:000454 EndFragment:000693".
> > Thanks for your help.
>
>
>
>
> I can confirm, but this is not a new problem, I seem to recall that I
> had the same problem with OOo 3.2. BTW, Firefox 3.6.
>
>
> Alex
>
>
> --
> Unsubscribe instructions: E-mail to users+h...@libreoffice.org
> List archive: http://listarchives.libreoffice.org/www/users/
> *** All posts to this list are publicly archived for eternity ***
>

-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

Re: [libreoffice-users] Problem with spellcheck

[Andrew McLean]

On 28/02/2011 12:41, Sigrid Carrera wrote:

Hi,

On Mon, 28 Feb 2011 12:22:02 +
am577  wrote:


I have installed Libreoffice 3.3.1 on Windows 7, and I still have a
problem which
was there with OpenOffice:

1. Spellchecking usually does nothing. It says 'spellcheck complete'
 but it hasn't actually checked anything.
2. On a few documents, it works OK i.e. it is to do with a document
setting, but I
 can't spot any difference between the option settings in the documents.

spellcheck for which language? If you want to have anything other than en-US, you'll have to 
install the appropriate languagepack and helpfile in addition to the software package. Once 
you've installed all those packages, start LibO and go to "Tools>  Options>  
Language" there you can set the UI language as well as the default language used in your 
documents. Check that everything is set to your preferred language.

I think this helps.

Sigrid


Thanks
Spellcheck for English UK. The required dictionary IS installed - or it 
wouldn't work

for the documents where it does work.
I believe that the problem is that for most of my documents the 'Text 
Language' is not set.
When I spellcheck and it doesn't do anything, I can see that behind the 
DB which says '"The spell check is complete. OK" is another DB titled 
"Spelling:[None]" which then says "Text language" and the drop-down
field next to that is blank. I can't use that DB to change this setting 
because when I click on "OK" both
DB's disappear. For the document where spellchecking works, the "Text 
Language" field is set to English UK.
So I need to know how to change the "Text Language" field for a document 
where it is blank, and to

ensure that new documents also have the correct setting.
Advice welcome !
AM


--
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

Re: [libreoffice-users] record macro greyed out

[Thomas Blasejewicz]

Thank you!Now macro recording is available.This is considered an "instable 
function"?(2011/02/28 23:06), Sigrid Carrera wrote:Hello Thomas, 


On Mon, 28 Feb 2011 22:53:46 +0900
Thomas blasejewicztho...@s7.dion.ne.jpwrote:Good eveningI just noticed, that 
the field "record macro" is always greyed out.That means, I currently cannot 
create any new macro.Does this function need to be "activated" somewhere?Thank 
you.Yes, you have to enable it. Go to "ToolsOptionsLibreOffice" Tab "General" 
and check the option "Activate experimental (instable) functions". 


You'll have to restart LibreOffice before you can use this function. 


Sigrid
-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

Re: [libreoffice-users] assign keyboard keys

[Regina Henschel]

Hi Thomas,

Thomas Blasejewicz schrieb:
> Good evening from JapanI have been loyal Wordperfect user for a long time, 
> but the software
>  gives me lately a lot of grief.Thus, I am considering to permanently 
> switch to Libreoffice (have
>  been using Openoffice on and off in the past).Question:Wordperfect has a 
> handy little function, that allows the user to
>  assign just about everything to individual keys, including which
>  letter they represent.Since I am a German, but live in Japan where I am 
> used to machines
>  which have basically the American keyboard layout,I cherished this 
> Wordperfect function, because it allowed me to
>  assign the letter "y" and "z" to their respective opposite position.That 
> means, if I switch under Windows to the German keyboard layout,
>  the "y" comes to lie where "z" is printed on the key and vice versa.
>  The WP function allows me to change that, so that I get a "y", where
>  it is printed on the key, even while using the German keyboard
>  layout.This is not essential, but I have been used to that layout for my
>  typing.Is there any way, I could accomplish this little feat in
>  Libreoffice?Thank you.

Depending on your Windows version "The Microsoft Keyboard Layout
Creator" might be the right tool for you.
http://msdn.microsoft.com/en-us/goglobal/bb964665

Kind regards
Regina

-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

Re: [libreoffice-users] record macro greyed out

[Sigrid Carrera]

Hello Thomas, 

On Mon, 28 Feb 2011 22:53:46 +0900
Thomas Blasejewicz  wrote:

> Good eveningI just noticed, that the field "record macro" is always greyed 
> out.That means, I currently cannot create any new macro.Does this function 
> need to be "activated" somewhere?Thank you.

Yes, you have to enable it. Go to "Tools > Options > LibreOffice" Tab "General" 
and check the option "Activate experimental (instable) functions". 

You'll have to restart LibreOffice before you can use this function. 

Sigrid

-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

[libreoffice-users] assign keyboard keys

[Thomas Blasejewicz]

Good evening from JapanI have been loyal Wordperfect user for a long time, but 
the software
gives me lately a lot of grief.Thus, I am considering to permanently switch 
to Libreoffice (have
been using Openoffice on and off in the past).Question:Wordperfect has a 
handy little function, that allows the user to
assign just about everything to individual keys, including which
letter they represent.Since I am a German, but live in Japan where I am 
used to machines
which have basically the American keyboard layout,I cherished this 
Wordperfect function, because it allowed me to
assign the letter "y" and "z" to their respective opposite position.That 
means, if I switch under Windows to the German keyboard layout,
the "y" comes to lie where "z" is printed on the key and vice versa.
The WP function allows me to change that, so that I get a "y", where
it is printed on the key, even while using the German keyboard
layout.This is not essential, but I have been used to that layout for my
typing.Is there any way, I could accomplish this little feat in
Libreoffice?Thank you.
-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

[libreoffice-users] record macro greyed out

[Thomas Blasejewicz]

Good eveningI just noticed, that the field "record macro" is always greyed 
out.That means, I currently cannot create any new macro.Does this function need 
to be "activated" somewhere?Thank you.
-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

[libreoffice-users] customize highlighting

[Thomas Blasejewicz]

Good eveningI used to have a "highlighting function" assigned to certain hot
keys using MS Word and Wordperfect.With OpenOffice I could not figure out 
how make that work (nobody on
that mailing list could tell either ...), so I created a macro.(here with 
LibreOffice the macro function currently does not work,
but I make that a different thread)In LO I found, that you CAN assign that 
function (see below), but it
does not do yet what I want to do:Tools -Customize -Keyboard -Format 
-a)Highlight fillb)HighlightingWhat I want to have:a keyboard shortcut, that 
will give me highlighting in a predefined
color whenever I push the relevant key combination - in all
documents;preferrably "toggling" between ON/OFF, like it is possible with
sub/superscriptHowever, when I assigned a shortcut to eithera)Highlight 
fill orb)Highlightingthis works just ONCE and only after I specifically 
indicate color
immediately before that - and that is not very helpful.I would like to have 
this functionality available like you get
"bold" whenever you press Ctrl+B.Is that possible? (I really hope so, 
because I think it is really
stupid to make this possible for sub/superscript but not highlight
...)If so, what is the trick to achieve this?Thank you.
-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

Re: [libreoffice-users] MS Office 97 Template files fail to open (re-posting previously wrong subject)

[Sigrid Carrera]

Hi Charles, 

On Mon, 28 Feb 2011 08:20:33 -0500
Charles Marcus  wrote:

> On 2011-02-28 6:33 AM, Sigrid Carrera wrote:
> > So my suggestion is that you try to download the 3.2.1 and use this for 
> > conversion, then you can use either LibO or OOo for your work. 
> 
> Wouldn't it make more sense to simply reinstall of LibO, and enable the
> legacy filters?
> 
> Do a 'Custom' install, then search for the 'Legacy Filters' (or
> something like that... and while you're at it you can disable all of the
> multitude of foreign language dictionaries you don't need...

I agree, it would make more sense - if the option is available. (And I don't 
know this - but I know that using 3.2.1 did work). 

Indeed, that's kind of stupid to have all those extra dictionaries. At least 
for disabling all those extra dictionaries, doing the "repair installation" is 
a good recommendation. 

Sigrid

-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

Re: [libreoffice-users] MS Office 97 Template files fail to open (re-posting previously wrong subject)

[Sigrid Carrera]

Hi, 

On Mon, 28 Feb 2011 12:13:28 +
Derry Birse  wrote:

> Thanks I will try 3.2.1. Do you know how you install these filters manually?

No, I haven't done it myself. And from what I can read you might have to 
compile LibO yourself with binfilter enabled. 

check this bugreport in the LibO bugtracker:
https://bugs.freedesktop.org/show_bug.cgi?id=33135
and also this bugreport in the OOo bugtracker: 
http://www.openoffice.org/issues/show_bug.cgi?id=116322

You might want to ask there where the standalone version of those binary 
filters is. 

If there's no real answer, then just getting OOo 3.2.1 should do the trick. 

You can find a 3.2.1 version e. g. on this server: 
http://ftp.sunet.se/pub/Office/OpenOffice.org/localized/


Sigrid

-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

Re: [libreoffice-users] MS Office 97 Template files fail to open (re-posting previously wrong subject)

[Charles Marcus]

On 2011-02-28 6:33 AM, Sigrid Carrera wrote:
> So my suggestion is that you try to download the 3.2.1 and use this for 
> conversion, then you can use either LibO or OOo for your work. 

Wouldn't it make more sense to simply reinstall of LibO, and enable the
legacy filters?

Do a 'Custom' install, then search for the 'Legacy Filters' (or
something like that... and while you're at it you can disable all of the
multitude of foreign language dictionaries you don't need...

No one has answered yet as to *why* in $deity's sake *all* of the
dictionaries are enabled by default, instead of your chosen language?

-- 

Best regards,

Charles

-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

[libreoffice-users] Calc links not all saving

[Ron Gregor]

I found this problem in 3.3.0 and tested 3.3.1.2 and it still exists.

We have sheets that have several relative links to another sheet but not all
are saving. When you update the links all the values are correct. Save the 
sheet and
close. Open the sheet and only the first link is valid the rest are zero's. For 
example "File A" has
3 links (c4, c5, c6) to "upgrade". Open "File A" and select update and then 
calculated value 
E13=13.825. Save the sheet and close. Open "File A" and C5 and C6 are 0 and
E13=1.250. This becomes a problem when "File B" tries to link to the value E13 
in "File A".
In our real set up we have several "File A's" that "File B" summarizes for us. 
The only way I could
fix this was to install Openoffice 3.3. Does anyone know how to get this 
working properly?

I have sample spreadsheets but I am not attaching them in case that is why 
several past post 
attempts have failed to show up.

LibreOffice 3.3.1 
OOO330m19 (Build:8)
tag libreoffice-3.3.1.2

WInXP

Thanks, Ron

-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

Re: [libreoffice-users] Re: Accessing the mailing list

[Charles Marcus]

On 2011-02-26 10:34 PM, MR ZenWiz wrote:
> "Evolution most likely ships with your Linux distribution of choice.
> To get your latest supported version, you will want to check with your
> distribution supplier."
> 
> For Windows, here's the first hit in Google:
> http://www.dipconsultants.com/evolution/

Evolution is far too unstable/buggy to be used as a serious email
program... even on linux, it is fairly unstable (google will show you
tons of evidence in support of this contention), but on windows it is
still totally unusable except for playing around. Yes, there are some
people here and there that seem to not have much problems with it, but
those are the exception, not the rule.

-- 

Best regards,

Charles

-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

Re: [libreoffice-users] Problem with spellcheck

[Sigrid Carrera]

Hi, 

On Mon, 28 Feb 2011 12:22:02 +
am577  wrote:

> I have installed Libreoffice 3.3.1 on Windows 7, and I still have a 
> problem which
> was there with OpenOffice:
> 
> 1. Spellchecking usually does nothing. It says 'spellcheck complete'
> but it hasn't actually checked anything.
> 2. On a few documents, it works OK i.e. it is to do with a document 
> setting, but I
> can't spot any difference between the option settings in the documents.

spellcheck for which language? If you want to have anything other than en-US, 
you'll have to install the appropriate languagepack and helpfile in addition to 
the software package. Once you've installed all those packages, start LibO and 
go to "Tools > Options > Language" there you can set the UI language as well as 
the default language used in your documents. Check that everything is set to 
your preferred language. 

I think this helps. 

Sigrid

-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

[libreoffice-users] Problem with spellcheck

[am577]

I have installed Libreoffice 3.3.1 on Windows 7, and I still have a 
problem which

was there with OpenOffice:

1. Spellchecking usually does nothing. It says 'spellcheck complete'
   but it hasn't actually checked anything.
2. On a few documents, it works OK i.e. it is to do with a document 
setting, but I

   can't spot any difference between the option settings in the documents.

AM


--
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

Re: [libreoffice-users] MS Office 97 Template files fail to open (re-posting previously wrong subject)

[Derry Birse]

Thanks I will try 3.2.1. Do you know how you install these filters manually?

Derry Birse
IT Support Manager
Converteam UK Ltd

Phone: +44(0)1788 563268




On 28 February 2011 11:33, Sigrid Carrera wrote:

> old binary formats

Converteam UK Ltd. Registration Number: 5571739 and Converteam Ltd. 
Registration Number: 2416188 Registered in England and Wales. Registered 
office: Boughton Road, Rugby, Warwickshire, CV21 1BU.

CONFIDENTIALITY : This e-mail and any attachments are confidential and may be 
privileged. 
If you are not a named recipient, please notify the sender immediately and do 
not disclose the contents to another person, use it for any purpose or store or 
copy the information in any medium.

http://www.converteam.com

Please consider the environment before printing this e-mail.

-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

Re: [libreoffice-users] MS Office 97 Template files fail to open (re-posting previously wrong subject)

[Sigrid Carrera]

Hi Derry, 

On Mon, 28 Feb 2011 11:07:11 +
Derry Birse  wrote:

> We are looking at LibreOffice as a potential corporate tool, however we have
> run into some issues relating to our company templates. We have several
> document templates that will not convert and these give the error "This is
> not a WinWord97 file". These files open in Word 97 without a problem.
> 
> These documents fail to convert using the Conversion Wizard, they also fail
> to open from both the File->Open menu and when double clicked in Windows
> Explorer. In all cases they give the above error.
> 
> The templates in question do have VB macros and although we do not expect
> these to work, the LibreOffice (and OpenOffice) documentation would suggest
> that these files should at least open and/or convert to odf format, even if
> they lose the macros.
> 
> I have included a link to a sample, can anyone help with this issue.
> 
> https://docs.google.com/viewer?a=v&pid=explorer&chrome=true&srcid=0B2rpQlb_yPptNDgxYmFmZDctNzBiYi00NTRlLThmODItOWYzYTI5ZTNhNTU5&hl=en&authkey=CPrJ0OUC
> 
> We are using LibreOffice 3.3.1 on Windows XP Pro SP3.

I've got the same error message with LibreOffice 3.3.1 on Mandriva Linux 2010.1

But I was able to open and convert your example file with the original 
OOo-Version 3.2.1. 

I think, OOo has removed support for the old binary formats (but I think those 
filters can be installed manually again) and LibO "inherited" this feature. 

So my suggestion is that you try to download the 3.2.1 and use this for 
conversion, then you can use either LibO or OOo for your work. 

HTH

Sigrid

-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

Re: [libreoffice-users] MS Office 97 Template files fail to open (re-posting previously wrong subject)

[Tom Davies]

From: Derry Birse 
To: users 
Sent: Mon, 28 February, 2011 11:07:11
Subject: [libreoffice-users] MS Office 97 Template files fail to open 
(re-posting previously wrong subject)

We are looking at LibreOffice as a potential corporate tool, however we have
run into some issues relating to our company templates. We have several
document templates that will not convert and these give the error "This is
not a WinWord97 file". These files open in Word 97 without a problem.

These documents fail to convert using the Conversion Wizard, they also fail
to open from both the File->Open menu and when double clicked in Windows
Explorer. In all cases they give the above error.

The templates in question do have VB macros and although we do not expect
these to work, the LibreOffice (and OpenOffice) documentation would suggest
that these files should at least open and/or convert to odf format, even if
they lose the macros.

I have included a link to a sample, can anyone help with this issue.

https://docs.google.com/viewer?a=v&pid=explorer&chrome=true&srcid=0B2rpQlb_yPptNDgxYmFmZDctNzBiYi00NTRlLThmODItOWYzYTI5ZTNhNTU5&hl=en&authkey=CPrJ0OUC


We are using LibreOffice 3.3.1 on Windows XP Pro SP3.

kind regards

Derry Birse
IT Support Manager
Converteam UK Ltd


Hi :)
I got the same error message in Ubuntu 10.04 using LibreOffice 3.3.0 
OOO330m19 (Build:6)
tag libreoffice-3.3.0.4, Ubuntu package 1:3.3.0-1lucid1
Regards from
Tom :)



  
-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

[libreoffice-users] Re: copy paste problem

[Alexander Thurgood]

Le 28/02/11 11:47, Benoît Majerus a écrit :

Hi,

> I'm using Libre Office 3.3.1., Mac OS X Version 10.6.6. and Firefox 4.0b11.
> When I copy text from LibreOffice to Firefox (for example Gmail), the
> following
> line precedes my copied text: "Version:1.0 StartHTML:000167
> EndHTML:000709 StartFragment:000454 EndFragment:000693".
> Thanks for your help.




I can confirm, but this is not a new problem, I seem to recall that I
had the same problem with OOo 3.2. BTW, Firefox 3.6.


Alex


-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

[libreoffice-users] copy paste problem

[Benoît Majerus]

I'm using Libre Office 3.3.1., Mac OS X Version 10.6.6. and Firefox 4.0b11.
When I copy text from LibreOffice to Firefox (for example Gmail), the
following
line precedes my copied text: "Version:1.0 StartHTML:000167
EndHTML:000709 StartFragment:000454 EndFragment:000693".
Thanks for your help.

Corto

-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

[libreoffice-users] MS Office 97 Template files fail to open (re-posting previously wrong subject)

[Derry Birse]

We are looking at LibreOffice as a potential corporate tool, however we have
run into some issues relating to our company templates. We have several
document templates that will not convert and these give the error "This is
not a WinWord97 file". These files open in Word 97 without a problem.

These documents fail to convert using the Conversion Wizard, they also fail
to open from both the File->Open menu and when double clicked in Windows
Explorer. In all cases they give the above error.

The templates in question do have VB macros and although we do not expect
these to work, the LibreOffice (and OpenOffice) documentation would suggest
that these files should at least open and/or convert to odf format, even if
they lose the macros.

I have included a link to a sample, can anyone help with this issue.

https://docs.google.com/viewer?a=v&pid=explorer&chrome=true&srcid=0B2rpQlb_yPptNDgxYmFmZDctNzBiYi00NTRlLThmODItOWYzYTI5ZTNhNTU5&hl=en&authkey=CPrJ0OUC

We are using LibreOffice 3.3.1 on Windows XP Pro SP3.

kind regards

Derry Birse
IT Support Manager
Converteam UK Ltd

Phone: +44(0)1788 563268

Converteam UK Ltd. Registration Number: 5571739 and Converteam Ltd. 
Registration Number: 2416188 Registered in England and Wales. Registered 
office: Boughton Road, Rugby, Warwickshire, CV21 1BU.

CONFIDENTIALITY : This e-mail and any attachments are confidential and may be 
privileged. 
If you are not a named recipient, please notify the sender immediately and do 
not disclose the contents to another person, use it for any purpose or store or 
copy the information in any medium.

http://www.converteam.com

Please consider the environment before printing this e-mail.

-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

Re: [libreoffice-users] Re: Welcome to users@libreoffice.org

[Sigrid Carrera]

Hello Derry, 

On Mon, 28 Feb 2011 10:33:50 +
Derry Birse  wrote:

> We are looking at OpenOffice as a potential corporate tool, however we have
> run into some issues relating to our company templates. We have several
> document templates that will not convert and give the error "This is not a
> WinWord97 file". These files open in Word 97 without a problem.
> 
> 
> The templates in question do have VB macros and we do not expect these to
> work, however documentation would suggest that these files should at least
> open and/or convert to odf format, even if they lose the macros.
> 
> I have attached a sample, can anyone help with this issue.

I'm sorry, but your attachment didn't reach the list. (Attachments aren't 
allowed). Can you upload the file somewhere and post the link here? So anyone 
who's willing to help can go to the place and download it directly. 

Also, it would be useful to know which operating system and which version of 
LibreOffice you're running. And what did you do when you tried to open the 
file? Just a double click in the file manager on the document name? Or did you 
go through the "menu process" in LibreOffice (file > open)? 

Please be as specific as you can, so that it is possible for us to help you 
solve your problem. 

Thanks. 

Sigrid

-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

[libreoffice-users] Re: Welcome to users@libreoffice.org

[Derry Birse]

We are looking at OpenOffice as a potential corporate tool, however we have
run into some issues relating to our company templates. We have several
document templates that will not convert and give the error "This is not a
WinWord97 file". These files open in Word 97 without a problem.


The templates in question do have VB macros and we do not expect these to
work, however documentation would suggest that these files should at least
open and/or convert to odf format, even if they lose the macros.

I have attached a sample, can anyone help with this issue.

kind regards

Derry Birse
IT Support Manager
Converteam UK Ltd

Phone: +44(0)1788 563268

Converteam UK Ltd. Registration Number: 5571739 and Converteam Ltd. 
Registration Number: 2416188 Registered in England and Wales. Registered 
office: Boughton Road, Rugby, Warwickshire, CV21 1BU.

CONFIDENTIALITY : This e-mail and any attachments are confidential and may be 
privileged. 
If you are not a named recipient, please notify the sender immediately and do 
not disclose the contents to another person, use it for any purpose or store or 
copy the information in any medium.

http://www.converteam.com

Please consider the environment before printing this e-mail.

-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

[libreoffice-users] Re: Writer Merge File

[Alexander Thurgood]

Le 26/02/11 20:50, Mark Stanton a écrit :
Hi Mark

> 
>> No, I think this is a bug. If you update the data source file, in this
>> case your CSV file, it should also update the data available for the
>> merge next time around. I seem to recall that this may already have been
>> filed as a bug report, but for an SQL statement as a datasource instead
>> of a CSV file.
> 
> Ah, ok, great.  I'll have another clear look at it (mebbe it's fixed in 
> 3.3.1?) And if it's still a problem I'll check the bug reports and report 
> it if it's not already there.
> 


https://bugs.freedesktop.org/show_bug.cgi?id=34325


Not sure that this really corresponds as the poster doesn't give any
more detail than can not use CSV file as datasource for mailmerge, but
it appears to be the nearest thing to it.

Alex


-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

Re: [libreoffice-users] Re: Day zero is 1904-01-01 for new spreadsheets

[Tom Davies]

From: Andreas Säger 
To: users@libreoffice.org
Sent: Sun, 27 February, 2011 23:48:01
Subject: [libreoffice-users] Re: Day zero is 1904-01-01 for new spreadsheets

Am 28.02.2011 00:25, NoOp wrote:


> You might try renaming ~/.libreoffice.org and let LO build a new profile
> to see if that makes any difference.
> 

Resetting the profile cures the problem. No, I don't want to reset my user 
profile. I'm going to reestablish my default template.
Thanks,
Andreas



Hi Andreas,
Now that you found resetting the profile cures the problem it should be 
possible 
to copy back some of the things from your renamed profile into the new one.  
That gets your old settings and stuff back while helping pinpoint exactly which 
part of your profile was causing the problem.  Copy&paste is great but if you 
are in linux then rsync might be better because it keeps permissions and stuff 
exactly the same.  I don't think Windows has something that sophisticated tho 
so 
copy&paste would have to do.
https://help.ubuntu.com/community/rsync
Good luck and regards from
Tom :)



  
-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

Re: [libreoffice-users] Re: Send document from LO 3.3.1 on OSX seems to produce no response

[Carlo Strata]

Il 28/02/2011 10:32, Alexander Thurgood ha scritto:

Le 28/02/11 05:39, Marc Grober a écrit :

Hi Marc,


On OSX having installed 3.3.1 choosing Send Document or other send
options produces no response and no log entries. Thunderbird was
selected from Internet options.



Yes, this doesn't quite work as intended...or at least, not as its
alleged to work on other platforms. From what I understand, you can not
simply point to the TB application bundle in your list of applications,
but have to drill down through the bundle's contents to point to the
thunderbird executable binary.

You also have to make sure when you want to send the document via e-mail
that TB is not already running, otherwise you will get an error message,
and nothing will happen.


Alex



I think the integration of the NeoOffice team, with its know how, native 
interface library use, ... in the MacOS X Libò team is as urgent as useful.


With big advantages on both sides: NeoOffice works and releases, "in 
nomine" LibreOffice, a functional updated (!) office suite, LibreOffice 
Community has a MacOS X team with a big quality experience, as well as 
just I said above.


Have a nice day,
  Carlo

--
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

[libreoffice-users] Re: Send document from LO 3.3.1 on OSX seems to produce no response

[Alexander Thurgood]

Le 28/02/11 05:39, Marc Grober a écrit :

Hi Marc,

> On OSX having installed 3.3.1 choosing Send Document or other send
> options produces no response and no log entries. Thunderbird was
> selected from Internet options.
> 

Yes, this doesn't quite work as intended...or at least, not as its
alleged to work on other platforms. From what I understand, you can not
simply point to the TB application bundle in your list of applications,
but have to drill down through the bundle's contents to point to the
thunderbird executable binary.

You also have to make sure when you want to send the document via e-mail
that TB is not already running, otherwise you will get an error message,
and nothing will happen.


Alex


-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

Re: [libreoffice-users] Re: test-drive linux easily

[Tom Davies]

From: Ken Springer 
To: users@libreoffice.org
Sent: Mon, 28 February, 2011 1:22:23
Subject: [libreoffice-users] Re: test-drive linux easily

On 2011-02-27 08:44:25 -0700, Larry Gusaas said:
>> 
> What is the name of that distro? I'd like to check it out.

This is embarrassing...  I'm sure I saved it to my hard drive somewhere!   
LOL
And now, I can't remember the name either.  It's also possible I stumbled on to 
a page for Mac4Lin, which is an OS X theme for Linux.  But I don't think I 
would 
have saved that.
I'll keep looking for it, and when I do find it, I'll let you know.
Ken


Hi :)
There are a lot of themes or DEs that have some elements of a "Mac" feel or 
look 
because Mac developed from Bsd which shares a lot of gnu&linux stuff.  When 
Ubuntu moved it window/console buttons to the left and switched from light to 
dark themes a lot of people said it switched from a "Windows" look to a "Mac" 
look.  Mac doesn't seem anxious to try to assert copyright probably because 
many 
of it's UI components were first seen in Gnu and then modified.  


The question is what elements do you want to change to make your distro look 
more like Mac?  Then you could try to configure those elements.  I like the 
Windows style taskbars but many people install Avant Windows Navigator and then 
set that to start-up at every boot.
Regards from
Tom :)



  
-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***