[libreoffice-users] Re: Calk - lookup cell in column

[IGraham]

Calc not Calk - dam that spell checker - - can we agree to blame the spell
checker 


vlookup thanks for pointing me at that does exactly what i wanted - though
it did kill a few grey cells getting it to work

now i can happily move on to the next problem 



-
IGraham

W764  LibreOffice 4.1.0.4
--
View this message in context: 
http://nabble.documentfoundation.org/Calk-lookup-cell-in-column-tp4074117p4074150.html
Sent from the Users mailing list archive at Nabble.com.

-- 
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: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Linux hyphenation

[Virgil Arrington]

On 09/13/2013 04:51 PM, Kracked_P_P---webmaster wrote:
The .config folder is a hidden folder as well, so that messes people 
up as well. I know where it is located with Debian-based Linux, Like 
Ubuntu and Mint, but not on the RPM based installs of LO. I do not 
know why you do not have those two parts. I recently did a clean 
install on a new drive. So it all has been mostly "default" installs. 
I did not add anything to LO except the dictionary .oxt file. 


Yes, I've become aware of the hidden nature of the .config folder.

I installed Linux Mint 15 a month or so ago, and used the LO 4.0.2 that 
came with it. I recently upgraded to 4.0.5, but I honestly don't recall 
if the hyphenation was working before the upgrade or not. So far, I've 
just played in Linux, slowly and patiently migrating as Tom recently 
mentioned.


I just renamed my user profile, reinstalled my American English 
dictionaries, and nothing changed. I still have no hyphenation or 
grammar modules.


Virgil

--
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: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: Formulas in text instead of result - LO Calc

[Paul]

Hi Brian,

Thanks again for your help.


On Fri, 13 Sep 2013 19:33:48 +0100
Brian Barker  wrote:

> At 20:09 13/09/2013 +0200, Paul Steyn wrote:
> >There still seems to be a bug in 4.1.1.2 in that entering a formula 
> >into a cell formatted as text gives you a blank cell until you make 
> >a change to the spreadsheet (add a column, change the cell format, 
> >something like that), and then like magic the formula value suddenly 
> >appears in the cell.
> 
> Is this just a display problem?  What happens, for example, if you 
> minimise and then restore the Calc window: does that do anything?
Yep, just a display problem. Minimising and restoring Calc makes it
show up.

> >I see that preceding formulae with "'" makes the "'" appear in the 
> >cell, irrespective of the cell format. Seems this is no longer a 
> >text mark character. I'm sure it used to be, or is in Excel, as I've 
> >used it before.
> 
> Surely it still works?  There are a couple of points that may be 
> confusing you here.
> 
> o If you have custom ("smart") quotes set in your AutoCorrect 
> options, the apostrophe you type will be converted into an open 
> single quote and will not fulfil its intended function.  To correct 
> this, either disable custom quotes or - more easily - just go to Edit 
> | Undo (or Ctrl+Z) immediately after typing the apostrophe: this will 
> undo the autocorrection to leave the intended apostrophe.
Hitting ctrl-z right after entering it doesn't change it, it removes
all the typing. The menu item has "Undo: Input", so it doesn't look
like an autocorrect is happening. I don't actually know where to set
this smart quotes you speak of. I had a look under AutoCorrect Options,
but nothing obvious leapt out at me. The Localized Options tab has
check boxes to replace single and double quotes, but the double quotes
one is ticked and the single quotes one is unticked for me.

Of course, when I try it with 0.00, it works. Entering 0.00 on its own
changes the value to just 0 (both in the cell and in the input line),
but entering '0.00 shows 0.00 in the cell ('0.00 is kept in the input
line). So it appears to be the way to enter numbers as text, but
doesn't perform the same function for formulae. Strange.

Regards

Paul

-- 
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: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Linux hyphenation

[Kracked_P_P---webmaster]

On 09/13/2013 04:36 PM, Virgil Arrington wrote:
> Kracked_P_P---webmaster wrote:
>
>> In the top box of the "Writing Aids", I see Hunspell Spellchecker,
>> Libhyphen Hyphenator, Lightproof grammar checker, and Openoffice.org New
>> Thesaurus.
>
> I'm missing the "Libhyphen Hyphenator" and "Lightproof Grammar Checker".
>
> I'll try renaming the profile. I've done this so many times in Windows
> that it's second nature to me. I've been a little skittish about doing
> in in Linux as I'm just not accustomed to the way Linux spreads things
> around its file system.
>
> Virgil
>

Yes, Linux can be "something" after using Windows for years and years.

The .config folder is a hidden folder as well, so that messes people up
as well.

I know where it is located with Debian-based Linux, Like Ubuntu and
Mint, but not on the RPM based installs of LO.

I do not know why you do not have those two parts.
I recently did a clean install on a new drive.  So it all has been
mostly "default" installs.

I did not add anything to LO except the dictionary .oxt file.

-- 
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: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Linux hyphenation

[Virgil Arrington]

Kracked_P_P---webmaster wrote:


In the top box of the "Writing Aids", I see Hunspell Spellchecker,
Libhyphen Hyphenator, Lightproof grammar checker, and Openoffice.org New
Thesaurus.


I'm missing the "Libhyphen Hyphenator" and "Lightproof Grammar Checker".

I'll try renaming the profile. I've done this so many times in Windows that 
it's second nature to me. I've been a little skittish about doing in in 
Linux as I'm just not accustomed to the way Linux spreads things around its 
file system.


Virgil 



--
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: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: Calc - Pasting links relative to a folder

[mariosv]

There is an option in:
Menu/Tools/Options/Load Save/Save - Save URLs relative to file system.

In the help.
"
Save URLs relative to file system
This option allows you to select the default for relative addressing of URLs
in the file system and on the Internet. Relative addressing is only possible
if the source document and the referenced document are both on the same
drive.
A relative address always starts from the directory in which the current
document is located. In contrast, absolute addressing always starts from a
root directory. The following table demonstrates the difference in syntax
between relative and absolute referencing:
Examples
File system
Internet
relative
../images/img.jpg
../images/img.jpg
absolute
file:///c|/work/images/img.jpg
http://myserver.com/work/images/img.jpg


The Help tip always displays an absolute path. However, if a document is
saved in HTML format, LibreOffice will enter a relative path if the
appropriate check box is selected.
"
Miguel Ángel.



--
View this message in context: 
http://nabble.documentfoundation.org/Calc-Pasting-links-relative-to-a-folder-tp4074106p4074137.html
Sent from the Users mailing list archive at Nabble.com.

-- 
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: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: Formulas in text instead of result - LO Calc

[Paul]

Hi Brian,

By golly, you got it in one! I've tested this with both a csv file and
an odt file, and they both work the same way. When you enter a formula
into a cell formatted as a number, you get the formula result, but when
you enter a formula into a cell formatted as text you get the formula
value. Any changes to the cell format *after* you have entered the
formula do not affect that. You need to change the cell format *before*
you enter the formula. If you change it afterwards, you need to
re-enter the formula to get the new representation.

It just so happens that the csv file had a date column as the first
column, which was defaulting to text format, so any new columns added
between it and the next column inherited the text format, but any other
column in the file had number format, which is why only that column
exhibited the strange behaviour.

There still seems to be a bug in 4.1.1.2 in that entering a formula
into a cell formatted as text gives you a blank cell until you make a
change to the spreadsheet (add a column, change the cell format,
something like that), and then like magic the formula value suddenly
appears in the cell. You can still see that the formula value is in
the cell from the text bar at the top, it just doesn't initially
appear in the cell itself. If the cell is formatted as a number you get
the formula result immediately. I'm pretty sure the previous versions
of LO didn't do this. I think I'll file a bug about just this.

This really isn't the way I thought it worked. I thought any cell
contents that started with an "=" made the cell a formula, and the cell
would always display the result of the formula, which could be
formatted in different ways. In order to have a cell that started with
an "=", you had to preceed it by "'" in order to make it display as
pure text. I thought the cell format only affected the format of the
displayed value, not the interpretation of the contents. I guess this
way makes sense too, but it's not necessarily intuitive, especially
when newly created columns inherit formatting. At least now that I know
I shouldn't have any further problems.

I see that preceeding formulae with "'" makes the "'" appear in the
cell, irrespective of the cell format. Seems this is no longer a text
mark character. I'm sure it used to be, or is in Excel, as I've used it
before. Can someone with Excel test if it works like that? Can someone
recall if LO used to work like that, and changed at some point? Am I
maybe remembering Quattro Pro or some such, and imagining that I've
used it since the DOS days?

See below for some further inline comments.

Thanks again Brian, and everybody who helped figure this out.

Paul



On Fri, 13 Sep 2013 13:27:28 +0100
Brian Barker  wrote:

> At 13:41 13/09/2013 +0200, Paul Steyn wrote:
> >Thanks, but as I stated in my original email, changing the cell 
> >formatting doesn't do anything. I've tried a number of different 
> >formats, including percent, currency, number and text, as well as 
> >clearing direct formatting.
> 
> I won't guarantee this, but I think the damage is done when you enter 
> a formula into a cell already formatted as Text when you have opened 
> the spreadsheet from a .csv file.  What you type is then interpreted 
> and stored as text.  *Changing* the format afterwards will not help: 
> you need not to have had the format as Text when you typed the entry.
Yup, as I've stated above, this is exactly correct.

> >That said, I did redo my experiment (for about the 10th time), but 
> >this time I put the formula in a new column to the right of the 
> >existing data, and it worked fine.
> 
> That would be because your new column is not formatted as 
> Text.  Alternatively, what do you mean by "put" the formula?  If you 
> copy the existing formula - already fossilised as text - you will get 
> text again, of course.  But if you retype the formula into a 
> non-text-formatted cell, won't you then obtain the formula you
> require?
By "put" I do mean retype. I also tried with "paste only > formula",
but this also didn't work, either because, as you point out, it was
pasting from a cell that contained text instead of a formula, and
therefore copied the text instead as it had no formula to copy, or
because it was pasting into a cell formatted as text, and therefore
copied the formula in but interpreted it as text.

> >However, when I do as previously, and make a new column B, and put 
> >the formula in there, it still doesn't work.
> 
> Hmm: perhaps that depends on how you create any new column: does it 
> inherit the (troublesome) formatting of the existing column?  Or 
> perhaps by "put" you again mean "paste" rather than "type"?  (These 
> have different effects.)
Again, bingo! The column was inheriting the text formatting of the
column to the left, which was a date, and therefore interpreted as text
when importing the csv file.

> >Actually, now that I experiment, it seems to work in any column I 
> >put the formula, existing or

Re: [libreoffice-users] Re: Formulas in text instead of result - LO Calc

[Brian Barker]

At 20:09 13/09/2013 +0200, Paul Steyn wrote:

By golly, you got it in one!


Good-oh!

There still seems to be a bug in 4.1.1.2 in that entering a formula 
into a cell formatted as text gives you a blank cell until you make 
a change to the spreadsheet (add a column, change the cell format, 
something like that), and then like magic the formula value suddenly 
appears in the cell.


Is this just a display problem?  What happens, for example, if you 
minimise and then restore the Calc window: does that do anything?


I see that preceding formulae with "'" makes the "'" appear in the 
cell, irrespective of the cell format. Seems this is no longer a 
text mark character. I'm sure it used to be, or is in Excel, as I've 
used it before.


Surely it still works?  There are a couple of points that may be 
confusing you here.


o If you have custom ("smart") quotes set in your AutoCorrect 
options, the apostrophe you type will be converted into an open 
single quote and will not fulfil its intended function.  To correct 
this, either disable custom quotes or - more easily - just go to Edit 
| Undo (or Ctrl+Z) immediately after typing the apostrophe: this will 
undo the autocorrection to leave the intended apostrophe.


o If you have already managed to enter something starting with an 
apostrophe or open quote in a cell in the same column, Calc may offer 
you suggested input, and you may need additional presses of Ctrl+Z to 
return to the plain apostrophe you need before typing the real cell 
contents you require.


I trust this helps.

Brian Barker


--
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: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: Oracle Report Builder - Text field overflow and a N.aN problem

[SergeiK]

Have you tried  Oracle report builder
  
in dbForge Studio for Oracle? This perfect IDE solves almost all the task of
database development and management! Generating reports is only one of its
multiple features! You can read more about this software here:
http://www.devart.com/dbforge/oracle/studio/



--
View this message in context: 
http://nabble.documentfoundation.org/Oracle-Report-Builder-Text-field-overflow-and-a-N-aN-problem-tp4047794p4074095.html
Sent from the Users mailing list archive at Nabble.com.

-- 
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: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Calk - lookup cell in column

[Brian Barker]

At 08:36 13/09/2013 -0700, Graham Lovatt wrote:

Calk - lookup cell in column


I imagine it's your spelling checker that thinks Calc is called Calk?

I have a spreadsheet that records data for each day of the year. 
Vertically row by row I have the days of the year. I like my week to 
start on a Monday. So I have my year/days set to start on the first 
Monday of the year. So the actual first day of the year position/row 
is dynamic either on the Monday or above.


Er, can you run that last sentence past me again, please?!


This all works ok


Nice to hear it!

However I then (for manipulating data by month) need to know the 
row/cell in which the first day of the year (or month) appears. How 
do I look up/find within a column the cell in which the first day of 
the month is - I assume that if I know how to do it for say January 
then I can do it for any month. I'm totally clueless as to how to do this.


I fear so shall any one else be!  One likely possibility is to use 
VLOOKUP(), which enables you to look for a match in the date 
column(s) and then retrieve data from the corresponding cells in 
neighbouring columns.  But exactly how you do this depends on the 
form of your date data.  Do you have a single column of proper dates 
(however formatted)?  Or by "days of the year" do you mean that you 
have an integer from 1 to 365 or 366?  Or do you have this data 
spread between more than one column - perhaps with the month in one 
column and the day in another?  Or what?


It might help if you list the date data for the first few days of the 
current year.  This might explain both conundrums.



/Hopping that my explanation isn't to bamboozling/


Gymnastics quite unnecessary, in fact.

I trust this helps.

Brian Barker


--
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: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Error in Calc custom formats between closing and opening a file

[Tom Davies]

Hi :)
The 2nd one
https://www.libreoffice.org/get-help/bug/
(without the dot at the end) leads to the first one but just helps you collect 
useful information for it.  

So, either is fine.  
[Edit]  oops, that 2nd one seem to be down right now but might well be fixed by 
the time you look at it
Regards from 
Tom :)





 From: Paul 
To: users@global.libreoffice.org 
Sent: Friday, 13 September 2013, 1:54
Subject: Re: [libreoffice-users] Error in Calc custom formats between closing 
and opening a file
 

Hi Regina, All,

I've finally (finally!) updated LO, and checked this problem again, and
it still manifests. I can confirm that it manifests with the following
LO versions:

4.0.3.3
4.0.5.2
4.1.1.2

This is with a locale of South Africa, but I think that just makes the
problem worse by confusing some of the characters in the string "hour"
with locale specific currency symbols; the underlying problem has to do
with not preserving the space before the quoted string literal in the
format string over saves, which is not a locale specific problem, as far
as I can see.

Can anybody confirm this and give their LO version and locale?

Should I file a bug report, and if so how do I go about doing that?
When I first looked at filing a bug, I found both
https://bugs.freedesktop.org/ and
https://www.libreoffice.org/get-help/bug/. Which is the currently
preferred bugtracker?

Thanks for the assistance so far

Paul


On Fri, 19 Jul 2013 15:07:20 +0200
Paul  wrote:

> Hi All,
> 
> Haven't had a chance to test in LO 4.1 beta, but I was hoping someone
> could at least confirm that they are getting the same results in 4.0
> or prior, and maybe even someone with 4.1 could comment on if it is
> still happening.
> 
> Anybody?
> 
> Regina, you said you weren't getting the weird formatting in your
> version, but can you confirm the behaviour as regards the moving of
> the space in your version?
> 
> Many thanks
> 
> Paul
> 
> 
> 
> On Wed, 10 Jul 2013 02:11:26 +0200
> Paul  wrote:
> 
> > Hi Regina,
> > 
> > Terribly sorry about the delay in following up on your suggestions.
> > I didn't mean to just disappear like that. It's been a bit hectic
> > here, and I haven't had time to try with LibreOffice 4.1 beta yet,
> > but I've tried a couple of other things.
> > 
> > Firstly, I tried formatting the cell as a plain number, with
> > ' " / hour"' after the default format, so the complete format is
> > #,###.00 " / hour"
> > 
> > This got changed over the save to
> > #,###.00"  / hour"
> > 
> > Again, the space was removed in front of the quotes, and added
> > behind. Other than that, the "hour" wasn't mangled, I'm assuming
> > that the mangling is only because of interpreting it as currency
> > symbols.
> > 
> > When I removed the extra space behind the quotes, but left it
> > without a space in front, it preserved that over saves, i.e. the
> > following worked fine over saves
> > #,###.00" / hour"
> > 
> > This is still rejected when I change to currency format.
> > 
> > Next, I looked at my locale settings. Under Tools|Options|Language
> > Settings|Languages I have the following:
> > Language of
> >     User interface: Default - English (USA)
> >     Locale setting: Default - English (South Africa)
> >     Decimal separator key: checked : Same as locale setting (.)
> >     Default currency: Default - ZAR
> >     Date acceptance patterns: Y/M/D;M/D
> > Default languages for documents
> >     Western: English (South Africa)
> >     Asian: greyed out : Default - Chinese (simplified)
> >     CTL: greyed out : Default - Hindi
> >     For the current document only: not checked
> > Enhanced language support
> >     Show UI elements for East Asian writings: not checked
> >     Show UI elements for Bi-Directional writing: not checked
> >     Ignore system input language: not checked
> > 
> > I tried changing the default locale setting to "English (USA)",
> > which also changed the currency and date settings. When I added '
> > " / hour"' it again moved the space from in front of the quotes to
> > inside the quotes over saves. But now this doesn't mangle anything,
> > I'm guessing because it's using a dollar sign instead of an "R" as
> > the currency symbol. Changing the symbol to "R" by changing the
> > format code from "[$$-409]" to "[$R-409]" works if the locale is
> > "English (USA)". When the locale is "Default - English (South
> > Africa)", changing the currency symbol by changing "[$R-1C09]" to
> > "[$$-1C09]" doesn't help matters.
> > 
> > I also noticed that with a space either in front of the quotes or
> > moved inside the quotes to give a double space before the slash, two
> > spaces are shown before the slash in the actual cell. So the only
> > way to get only one space between the number and the slash in the
> > cell is to have only one space, either in front of the qoutes or
> > inside the quotes, but not both.
> > 
> > It feels like there are two bugs, the first is that over saves LO
> > doesn't 

[libreoffice-users] Calk - lookup cell in column

[IGraham]

Hi

Now this might take a bit of explaining

I have a spreadsheet that records data for each day of the year
Vertically row by row I have the days of the year
I like my week to start on a Monday
So I have my year/days set to start on the first Monday of the year
So the actual first day of the year position/row is dynamic either on the
Monday or above
This all works ok

However I then (for manipulating data by month) need to know the row/cell in
which the first day of the year (or month) appears
How do I look up/find within a column the cell in which the first day of the
month is - I assume that if I know how to do it for say January then I can
do it for any month.
I'm totally clueless as to how to do this 

/Hopping that my explanation isn't to bamboozling/
 
Any ideas - please 



-
IGraham

W764  LibreOffice 4.1.0.4
--
View this message in context: 
http://nabble.documentfoundation.org/Calk-lookup-cell-in-column-tp4074117.html
Sent from the Users mailing list archive at Nabble.com.

-- 
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: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Linux hyphenation

[Kracked_P_P---webmaster]

It works on my Ubuntu 12.04 install[s] and my Windows install[s].

Since it uses the same en_US.dic for the language reference for the
797K+ word list, it may not show up as a different dictionary outside of
the Extension manager.  My last testing for the thesaurus showed the
lookup results of that dictionary first , then showed the original en_US
thesaurus results at the end of those results.

In the top box of the "Writing Aids", I see Hunspell Spellchecker,
Libhyphen Hyphenator, Lightproof grammar checker, and Openoffice.org New
Thesaurus.

The bottom box - at the bottom of the option list - is the check boxes
for the Hyphenate option, plus there is the grammar check boxes.

The only added extension was the American English extension.

I have seen this same issue[s] with dictionary/thesaurus/hyphen system
on and off since 3.4 or 3.5 days.  I believe there has been bug reports
before.  Some people fixed the problem by closing LO and then renaming
the user profile.  When you reopen LO, you will need to reinstall the
American English, since it may have been removed from the extension list.

For Ubuntu, it is ".config/libreoffice/"  I would rename it
".config/libreoffice-old/" or "-backup".  That way you do not loose your
profile if you want to go back to it.




On 09/12/2013 11:39 AM, Tom Davies wrote:
> Hi :)
> I think that is 2 separate questions.  (Not completely convinced but i think 
> it is)  
>
> For hyphenation try 
> Tools - Options - "Language Settings" - "Writing Aids" 
> and then near the bottom of the bottom box as well as near the top of the top 
> one.  
>
> I think the middle box might deal with the dictionaries problem?  
> Regards from 
> Tom :)  
>
>
>
>
> 
>  From: Virgil Arrington 
> To: users@global.libreoffice.org 
> Sent: Thursday, 12 September 2013, 13:40
> Subject: [libreoffice-users] Linux hyphenation
>  
>
> I need some help with my Linux LO installation.
>
> I'm running Linux Mint 15, and LO 4.0.5. I recently noticed that 
> hyphenation doesn't work. I don't know if it ever did, so I can't say 
> that it just recently stopped working.
>
> My language settings tell me that I have spell check and thesaurus 
> modules, but neither hyphenation nor grammar modules. My language 
> setting is "English (USA)."
>
> My "usr/share/hunspell" folder simply shows two files "en_US.dic" and 
> "en_US.aff."
>
> So, I then downloaded the more complete American English dictionary from 
> the LO dictionary extension pages. 
> (http://extensions.libreoffice.org/extension-center/american-british-canadian-spelling-hyphen-thesaurus-dictionaries).
>
> My extension manager says it is installed, and the files, including a 
> hyphenation dictionary, appear in the 
> "users/extensions/tmp/extensions/lu3jpv1t.tmp_/kpp-american(etc)" 
> folder, but...
>
> LO doesn't seem to recognize the new dictionaries. Hyphenation still 
> doesn't work, and my language settings under "Tools/Options/Language 
> Settings/" haven't changed. I still have no hyphenation or grammar 
> modules, and no options are available to recognize them.
>
> Any ideas on how to get LO to recognize my new dictionaries?
>
> Virgil
>
>


-- 
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: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Calc - Pasting links relative to a folder

[IGraham]

Hi

Calc - Pasting links relative to a folder

I have spreadsheets named '2012' '2013' in a folder and within each
spreadsheet end result info for each year. In the same folder I want to have
a spreadsheet named 'combine' that combines the data from the two year
spreadsheets. Can I/is there away to paste the data from the two year
spreadsheets into the combine spreadsheet but have the links relative to the
folder all three sheets are within - not relative to the actual storage
system (in this case a NAS)



-
IGraham

W764  LibreOffice 4.1.0.4
--
View this message in context: 
http://nabble.documentfoundation.org/Calc-Pasting-links-relative-to-a-folder-tp4074106.html
Sent from the Users mailing list archive at Nabble.com.

-- 
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: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: Translating odf files using omegat

[Alexander Thurgood]

Le 13/09/13 13:52, Milos Sramek a écrit :

Hi,

> Since there are several such tags for nearly each sentence, translating
> using OmegaT is not possible. I've checked if removing them manually
> from the content.xml filed changes anything - no, the document remains
> the same.
> So, there is a way how to use OmegaT: one has to clean up the xml code
> by removing all these useless tags. Does anybody have an idea, how to do
> that? Do you happen to know such tool?

Having tried to use OmegaT for the very same purpose and not having
found a way around that problem, and similar ones for other ODT
documents I was translating, I have given up on using it at the moment.
There may be others more knowledgable who do know how to solve this problem.

Alex



-- 
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: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Translating odf files using omegat

[Tom Davies]

Hi :)  
It might be worth asking on the L10n (international translators) mailing list 
and the Documentation Team mailing list.  

The international translators focus on the in-built help but still do quite a 
bit to translate the official guides too.  The Documentation Team work on the 
official guides and might appreciate a bit of help tidying things up or else be 
able to help show why the tags are there (if there is a reason)
Regards from 
Tom :)  





 From: Milos Sramek 
To: users@global.libreoffice.org 
Sent: Friday, 13 September 2013, 12:52
Subject: [libreoffice-users] Translating odf files using omegat
 

Hi,

I would like to translate the book Getting Started with LO 4.0 to 
Slovak. Translating directly the odt file is perhaps not a good idea, so 
I would like to use a tool with translation memory - I tried OmegaT. 
There is, however, a problem with tags:

For example, the sentence

*Quickstarter is installed in the Windows system tray and is 
automatically loaded during system startup.*

is displayed in the document without any formatting, using just the the 
Default character style

In OmegaT, however, it is displayed like this:

*Quickstarter is installed in the Windows system tray 
and is automatically loaded during system startup.**
***/
/( are tag replacements and should not be touched/.)
/
This suggests that there are some tags inside this sentence, in spite 
the fact that I do not see any. Really, in the content.xml file inside 
the document we can see them:

*Quickstarter is installed in 
the Windows system tray 
and is automatically loaded 
during system startup. 
*/
/
These tags in fact do not mean anything meaningfull:

**

Since there are several such tags for nearly each sentence, translating 
using OmegaT is not possible. I've checked if removing them manually 
from the content.xml filed changes anything - no, the document remains 
the same.
So, there is a way how to use OmegaT: one has to clean up the xml code 
by removing all these useless tags. Does anybody have an idea, how to do 
that? Do you happen to know such tool?

Thanks
Milos

-- 
email & jabber: sramek.mi...@gmail.com


-- 
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: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
-- 
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: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: Formulas in text instead of result - LO Calc

[Brian Barker]

At 13:41 13/09/2013 +0200, Paul Steyn wrote:
Thanks, but as I stated in my original email, changing the cell 
formatting doesn't do anything. I've tried a number of different 
formats, including percent, currency, number and text, as well as 
clearing direct formatting.


I won't guarantee this, but I think the damage is done when you enter 
a formula into a cell already formatted as Text when you have opened 
the spreadsheet from a .csv file.  What you type is then interpreted 
and stored as text.  *Changing* the format afterwards will not help: 
you need not to have had the format as Text when you typed the entry.


That said, I did redo my experiment (for about the 10th time), but 
this time I put the formula in a new column to the right of the 
existing data, and it worked fine.


That would be because your new column is not formatted as 
Text.  Alternatively, what do you mean by "put" the formula?  If you 
copy the existing formula - already fossilised as text - you will get 
text again, of course.  But if you retype the formula into a 
non-text-formatted cell, won't you then obtain the formula you require?


However, when I do as previously, and make a new column B, and put 
the formula in there, it still doesn't work.


Hmm: perhaps that depends on how you create any new column: does it 
inherit the (troublesome) formatting of the existing column?  Or 
perhaps by "put" you again mean "paste" rather than "type"?  (These 
have different effects.)


Actually, now that I experiment, it seems to work in any column I 
put the formula, existing or new, provided it isn't between the 
original first two columns.


Look at the formatting of any relevant cells before you enter any 
formula: is it Text?  Change it *first*.


When I save it and then open it in a plain text editor, I see that 
in the column that worked, the result is saved, but in column B the 
formula value is saved. However, when I then open the file in LO 
again, now both columns show the result, although the originally 
working one is of course just a number.


When you reopen the .csv file, your text string is evidently 
reinterpreted - as if it had been typed, not pasted - so it is 
converted to the formula you want.


Note that the formatting of cells has (at least?!) two effects: how 
any stored value is displayed and how any entered (i.e. typed) input 
is interpreted.  Reopening a proper (.ods) spreadsheet file preserved 
the save cell contents, of course.  Opening a .csv file seems to 
reinterpret it as if the contents were retyped.  You could override 
this - the opposite of what you want - by selecting Text as the 
column type in the Text Import dialogue.


I trust the helps.

Brian Barker


--
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: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Translating odf files using omegat

[Milos Sramek]

Hi,

I would like to translate the book Getting Started with LO 4.0 to 
Slovak. Translating directly the odt file is perhaps not a good idea, so 
I would like to use a tool with translation memory - I tried OmegaT. 
There is, however, a problem with tags:


For example, the sentence

*Quickstarter is installed in the Windows system tray and is 
automatically loaded during system startup.*


is displayed in the document without any formatting, using just the the 
Default character style


In OmegaT, however, it is displayed like this:

*Quickstarter is installed in the Windows system tray 
and is automatically loaded during system startup.**

***/
/( are tag replacements and should not be touched/.)
/
This suggests that there are some tags inside this sentence, in spite 
the fact that I do not see any. Really, in the content.xml file inside 
the document we can see them:


*Quickstarter is installed in 
the Windows system tray 
and is automatically loaded 
during system startup. 
*/

/
These tags in fact do not mean anything meaningfull:

*style:family="text">fo:country="GB"/>*


Since there are several such tags for nearly each sentence, translating 
using OmegaT is not possible. I've checked if removing them manually 
from the content.xml filed changes anything - no, the document remains 
the same.
So, there is a way how to use OmegaT: one has to clean up the xml code 
by removing all these useless tags. Does anybody have an idea, how to do 
that? Do you happen to know such tool?


Thanks
Milos

--
email & jabber: sramek.mi...@gmail.com


--
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: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Error in Calc custom formats between closing and opening a file

[Paul]

Hi Tom,

Thanks, I think I'll try add a bug report about this. Was hoping to
have some verification of this error, but it doesn't seem to be
something many people have run into.

Paul


On Fri, 13 Sep 2013 12:23:36 +0100 (BST)
Tom Davies  wrote:

> Hi :)
> The 2nd one
> https://www.libreoffice.org/get-help/bug/
> (without the dot at the end) leads to the first one but just helps
> you collect useful information for it.  
> 
> So, either is fine.  
> [Edit]  oops, that 2nd one seem to be down right now but might well
> be fixed by the time you look at it Regards from 
> Tom :)
> 
> 
> 
> 
> 
>  From: Paul 
> To: users@global.libreoffice.org 
> Sent: Friday, 13 September 2013, 1:54
> Subject: Re: [libreoffice-users] Error in Calc custom formats between
> closing and opening a file 
> 
> Hi Regina, All,
> 
> I've finally (finally!) updated LO, and checked this problem again,
> and it still manifests. I can confirm that it manifests with the
> following LO versions:
> 
> 4.0.3.3
> 4.0.5.2
> 4.1.1.2
> 
> This is with a locale of South Africa, but I think that just makes the
> problem worse by confusing some of the characters in the string "hour"
> with locale specific currency symbols; the underlying problem has to
> do with not preserving the space before the quoted string literal in
> the format string over saves, which is not a locale specific problem,
> as far as I can see.
> 
> Can anybody confirm this and give their LO version and locale?
> 
> Should I file a bug report, and if so how do I go about doing that?
> When I first looked at filing a bug, I found both
> https://bugs.freedesktop.org/ and
> https://www.libreoffice.org/get-help/bug/. Which is the currently
> preferred bugtracker?
> 
> Thanks for the assistance so far
> 
> Paul
> 
> 
> On Fri, 19 Jul 2013 15:07:20 +0200
> Paul  wrote:
> 
> > Hi All,
> > 
> > Haven't had a chance to test in LO 4.1 beta, but I was hoping
> > someone could at least confirm that they are getting the same
> > results in 4.0 or prior, and maybe even someone with 4.1 could
> > comment on if it is still happening.
> > 
> > Anybody?
> > 
> > Regina, you said you weren't getting the weird formatting in your
> > version, but can you confirm the behaviour as regards the moving of
> > the space in your version?
> > 
> > Many thanks
> > 
> > Paul
> > 
> > 
> > 
> > On Wed, 10 Jul 2013 02:11:26 +0200
> > Paul  wrote:
> > 
> > > Hi Regina,
> > > 
> > > Terribly sorry about the delay in following up on your
> > > suggestions. I didn't mean to just disappear like that. It's been
> > > a bit hectic here, and I haven't had time to try with LibreOffice
> > > 4.1 beta yet, but I've tried a couple of other things.
> > > 
> > > Firstly, I tried formatting the cell as a plain number, with
> > > ' " / hour"' after the default format, so the complete format is
> > > #,###.00 " / hour"
> > > 
> > > This got changed over the save to
> > > #,###.00"  / hour"
> > > 
> > > Again, the space was removed in front of the quotes, and added
> > > behind. Other than that, the "hour" wasn't mangled, I'm assuming
> > > that the mangling is only because of interpreting it as currency
> > > symbols.
> > > 
> > > When I removed the extra space behind the quotes, but left it
> > > without a space in front, it preserved that over saves, i.e. the
> > > following worked fine over saves
> > > #,###.00" / hour"
> > > 
> > > This is still rejected when I change to currency format.
> > > 
> > > Next, I looked at my locale settings. Under Tools|Options|Language
> > > Settings|Languages I have the following:
> > > Language of
> > >     User interface: Default - English (USA)
> > >     Locale setting: Default - English (South Africa)
> > >     Decimal separator key: checked : Same as locale setting (.)
> > >     Default currency: Default - ZAR
> > >     Date acceptance patterns: Y/M/D;M/D
> > > Default languages for documents
> > >     Western: English (South Africa)
> > >     Asian: greyed out : Default - Chinese (simplified)
> > >     CTL: greyed out : Default - Hindi
> > >     For the current document only: not checked
> > > Enhanced language support
> > >     Show UI elements for East Asian writings: not checked
> > >     Show UI elements for Bi-Directional writing: not checked
> > >     Ignore system input language: not checked
> > > 
> > > I tried changing the default locale setting to "English (USA)",
> > > which also changed the currency and date settings. When I added '
> > > " / hour"' it again moved the space from in front of the quotes to
> > > inside the quotes over saves. But now this doesn't mangle
> > > anything, I'm guessing because it's using a dollar sign instead
> > > of an "R" as the currency symbol. Changing the symbol to "R" by
> > > changing the format code from "[$$-409]" to "[$R-409]" works if
> > > the locale is "English (USA)". When the locale is "Default -
> > > English (South Africa)", changing the currency symbol by changing
> > > "[$R-1C09]" to "[$$-1C09]" 

Re: [libreoffice-users] Error in Calc custom formats between closing and opening a file

[Paul]

Hi Don,

Thanks for the input.

Is this also using a string literal after the format string, like " /
hour" ? And if so, even if the formatting isn't messed up, is there a
space between the number specifier and the string literal, like
#,###.00 " / hour"

or has the space been put inside the string literal, like
#,###.00"  /hour"

I suspect the space issue is not region specific, but just isn't
immediately apparent on US versions, so would be interested to hear if
it is happening or not with your documents.

Thanks

Paul



On Thu, 12 Sep 2013 22:41:50 -0400
Don Myers  wrote:

> Hi,
> 
> I'm running LO 4.1.1.2 (Document Foundation Version) in Ubuntu 13.04. 
> After reading about this issue, I tried some spreadsheets going back
> a number of years, mostly .ods, and one .sxc, and all of the formulas 
> saved in them are working perfectly. This is in the US. I also tried 
> some new formulas using existing data in the spreadsheet, and they
> work fine also.
> 
> Don
> 
> 
> 
> On 09/12/2013 08:54 PM, Paul wrote:
> > Hi Regina, All,
> >
> > I've finally (finally!) updated LO, and checked this problem again,
> > and it still manifests. I can confirm that it manifests with the
> > following LO versions:
> >
> > 4.0.3.3
> > 4.0.5.2
> > 4.1.1.2
> >
> > This is with a locale of South Africa, but I think that just makes
> > the problem worse by confusing some of the characters in the string
> > "hour" with locale specific currency symbols; the underlying
> > problem has to do with not preserving the space before the quoted
> > string literal in the format string over saves, which is not a
> > locale specific problem, as far as I can see.
> >
> > Can anybody confirm this and give their LO version and locale?
> >
> > Should I file a bug report, and if so how do I go about doing that?
> > When I first looked at filing a bug, I found both
> > https://bugs.freedesktop.org/ and
> > https://www.libreoffice.org/get-help/bug/. Which is the currently
> > preferred bugtracker?
> >
> > Thanks for the assistance so far
> >
> > Paul
> >
> >
> > On Fri, 19 Jul 2013 15:07:20 +0200
> > Paul  wrote:
> >
> >> Hi All,
> >>
> >> Haven't had a chance to test in LO 4.1 beta, but I was hoping
> >> someone could at least confirm that they are getting the same
> >> results in 4.0 or prior, and maybe even someone with 4.1 could
> >> comment on if it is still happening.
> >>
> >> Anybody?
> >>
> >> Regina, you said you weren't getting the weird formatting in your
> >> version, but can you confirm the behaviour as regards the moving of
> >> the space in your version?
> >>
> >> Many thanks
> >>
> >> Paul
> >>
> >>
> >>
> >> On Wed, 10 Jul 2013 02:11:26 +0200
> >> Paul  wrote:
> >>
> >>> Hi Regina,
> >>>
> >>> Terribly sorry about the delay in following up on your
> >>> suggestions. I didn't mean to just disappear like that. It's been
> >>> a bit hectic here, and I haven't had time to try with LibreOffice
> >>> 4.1 beta yet, but I've tried a couple of other things.
> >>>
> >>> Firstly, I tried formatting the cell as a plain number, with
> >>> ' " / hour"' after the default format, so the complete format is
> >>> #,###.00 " / hour"
> >>>
> >>> This got changed over the save to
> >>> #,###.00"  / hour"
> >>>
> >>> Again, the space was removed in front of the quotes, and added
> >>> behind. Other than that, the "hour" wasn't mangled, I'm assuming
> >>> that the mangling is only because of interpreting it as currency
> >>> symbols.
> >>>
> >>> When I removed the extra space behind the quotes, but left it
> >>> without a space in front, it preserved that over saves, i.e. the
> >>> following worked fine over saves
> >>> #,###.00" / hour"
> >>>
> >>> This is still rejected when I change to currency format.
> >>>
> >>> Next, I looked at my locale settings. Under Tools|Options|Language
> >>> Settings|Languages I have the following:
> >>> Language of
> >>>  User interface: Default - English (USA)
> >>>  Locale setting: Default - English (South Africa)
> >>>  Decimal separator key: checked : Same as locale setting (.)
> >>>  Default currency: Default - ZAR
> >>>  Date acceptance patterns: Y/M/D;M/D
> >>> Default languages for documents
> >>>  Western: English (South Africa)
> >>>  Asian: greyed out : Default - Chinese (simplified)
> >>>  CTL: greyed out : Default - Hindi
> >>>  For the current document only: not checked
> >>> Enhanced language support
> >>>  Show UI elements for East Asian writings: not checked
> >>>  Show UI elements for Bi-Directional writing: not checked
> >>>  Ignore system input language: not checked
> >>>
> >>> I tried changing the default locale setting to "English (USA)",
> >>> which also changed the currency and date settings. When I added '
> >>> " / hour"' it again moved the space from in front of the quotes to
> >>> inside the quotes over saves. But now this doesn't mangle
> >>> anything, I'm guessing because it's using a dollar sign instead
> >>> of an "R" as the currency symbol. 

Re: [libreoffice-users] Re: Formulas in text instead of result - LO Calc

[Paul]

Hi T. R.,

Thanks, but as I stated in my original email, changing the cell
formatting doesn't do anything. I've tried a number of different
formats, including percent, currency, number and text, as well as
clearing direct formatting.

That said, I did redo my experiment (for about the 10th time), but this
time I put the formula in a new column to the right of the existing
data, and it worked fine. However, when I do as previously, and make a
new column B, and put the formula in there, it still doesn't work.
Actually, now that I experiment, it seems to work in any column I put
the formula, existing or new, provided it isn't between the
original first two columns.

I created a minimal sample file (I would attach, but I think it will be
stripped out of the email?), and tried again. When I put the formula in
a column to the right of the existing data, it works, but when I create
a new column B and put the formula there, I get the formula value
instead of the result. When I save it and then open it in a plain text
editor, I see that in the column that worked, the result is saved, but
in column B the formula value is saved. However, when I then open the
file in LO again, now both columns show the result, although the
originally working one is of course just a number. And I can still not
get the result when putting a formula into a newly created second
column. I note that it works fine if I put it in column B *without*
creating a new column, but any newly created column between the
original columns A and B will not show a formula result.

This is very strange. It's as if creating a new column B somehow marks
it as not for formulas.

And I tested it in a normal ods file, and it doesn't exhibit this
behavior, only in csv files.

Any ideas anybody?

Paul



On Thu, 12 Sep 2013 19:53:30 -0500
"T. R. Valentine"  wrote:

> On 12 September 2013 19:44, Paul  wrote:
> 
> > I've just had the same thing. I was working on a file, and found
> > that the formulas I put in would only show up as formula values,
> > instead of results. I made sure that the option for Display >
> > Formulas was unchecked, as suggested below, but this did not change
> > anything. I even tried checking it, then unchecking it, but neither
> > one did anything.
> 
> Make sure the cell is not formatted as text.
> Format -> Cells, Numbers tab, under 'Category'
> 
> 


-- 
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: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Libra office OLE object

[afreen]

Hello, 

I have an query,  when i have created OLE object from file in the Libra
Office Writer, the whole file come in the document, i just want the object
of file as an "Icon" ( like MSoffice)

Please suggest me how can i do this ??




--
View this message in context: 
http://nabble.documentfoundation.org/Libra-office-OLE-object-tp4074080.html
Sent from the Users mailing list archive at Nabble.com.

-- 
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: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] the password of Libreoffice

[Tom Davies]

Hi :
It's ok.  It's nice to hear ideas to try.  Even a wrong answer might help 
someone else or "by bouncing ideas off each other" we might arrive at the best 
answers.  

I was fairly sure your method would work but hadn't got around to trying it out 
so thanks for doing that and getting back to the list with the results.  I 
think Alex had already said that method wouldn't work but i "never believe 
anything until it's been denied by a government minister" (i am not sure where 
that quote is from)
Regards from 
Tom :)  





 From: ZP 
To: users@global.libreoffice.org 
Sent: Thursday, 12 September 2013, 21:27
Subject: Re: [libreoffice-users] the password of Libreoffice
 


> Well, here's a shot in the dark.  The .odt fileis simply a container 
> (like a .zipfile).  Use a program like 7-zip (confirmed to work) and 
> extract the content.xml file.  It won't be clean, but you may be able to:
>
> 1) copy the content.xml into a new.odt file without password 
> protection, or...
> 2) just open the content.xml file directly in LO.  You'll have a lot 
> of xml data in there...so its quite messy.
>
> |ZP|
>

Disregard my last message.  You can open the .odt file in 7-zip, or 
Gnome Archive Manager, or whatever...unfortunately, the content.xml is 
scrambled after password protection.  My apologies for the misdirection.

|ZP|

-- 
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: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
-- 
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: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted