[libreoffice-users] Quick start without tray icon?

2014-01-13 Thread minhsien0330
Dear all:
When we checked the option Enable systray Quickstarter, we preload
libreoffice and have a Libreoffice logo icon on system tray.
But there are too many icons on my tray, can I preload Libreoffce without
tray icon?
Thank you.

Regards,
Minhsien0330

-- 
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] Quick start without tray icon?

2014-01-13 Thread Brian Barker

At 16:33 13/01/2014 +0800, Min Hsien wrote:
When we checked the option Enable systray Quickstarter, we preload 
libreoffice and have a Libreoffice logo icon on system tray. But 
there are too many icons on my tray, can I preload Libreoffice 
without tray icon?


Probably - depending on your operating system.

In Windows, for example, right-click in the Taskbar and select 
Properties.  On the Taskbar tab, under Notification area, tick 
Hide inactive icons and click Customize... .  Click the 
Quickstarter reference and select Always hide from the drop-down 
menu for Behavior.  (But these directions do vary between Windows versions.)


Of course, having the icon there provides a quick means of opening 
new or existing documents through the context menu.


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] Quick start without tray icon?

2014-01-13 Thread Tom Davies
Hi :)
I think Brian is mainly talking about Xp there.  Win8 doesn't seem to
have a system tray, but so far i've managed to mostly dodge Win8.
Win7 allows you to set parameters for each individual icon in the
system tray.

Why does it matter how much stuff is showing in the system tray?  My
guess is that you have so much stuff starting up at start-up that
machine's performance is a LOT slower and some IT person has suggested
that reducing the amount of stuff in the system tray will improve
performance.  However, just hiding the icons wont have any impact on
performance at all.  If you want you could list all the icons that do
appear and we might be able to suggest ones that would be good to
completely get rid of.

Regards from
Tom :)



On 13 January 2014 08:53, Brian Barker b.m.bar...@btinternet.com wrote:
 At 16:33 13/01/2014 +0800, Min Hsien wrote:

 When we checked the option Enable systray Quickstarter, we preload
 libreoffice and have a Libreoffice logo icon on system tray. But there are
 too many icons on my tray, can I preload Libreoffice without tray icon?


 Probably - depending on your operating system.

 In Windows, for example, right-click in the Taskbar and select Properties.
 On the Taskbar tab, under Notification area, tick Hide inactive icons
 and click Customize... .  Click the Quickstarter reference and select
 Always hide from the drop-down menu for Behavior.  (But these directions
 do vary between Windows versions.)

 Of course, having the icon there provides a quick means of opening new or
 existing documents through the context menu.

 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


-- 
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] a LibO/Calc problem (SOLVED)

2014-01-13 Thread Pertti Rönnberg

Thank you Paul and Brian
for your interesting answers and for your kindness to send them so soon. 
I have not checked them yet but I am sure that both of them give me what 
I was looking for.
I see thepros and cons in Paul's method: by splitting the calculation in 
details you can follow both the process and the reliability of the 
result, but at cost of space.
But, there is more fun in Brian's solution; I have always liked to 
create such complex formulas partly to be familiar with the spreadsheet 
program and it's functions but now a days mostly because it is very good 
exercise for an old man's brain --it is a challenge and then a good 
reason to award yourself with a drink when it finally works.
I think I was quite near Brian's solution, but something went wrong, so 
I had to shout for help.


Paul's answer is interesting from another point of view also -- he 
changes the decimal sign from a comma to a period and replaces the 
periods replaced by commas to get the correct thousand separator.
If you Google (e.g.) decimal dot vs. comma you will get a map that 
shows How the world separates its decimals. We in Finland, like all 
European countries -- with the U.K. as the only exception -- use a comma 
as decimal sign.


Another page Decimal and Thousand Separators says: Great Britain and 
the United States are two of the few places in the world that use a 
period to indicate the decimal place. Many other countries use a comma 
instead... Likewise, while the U.K. and U.S. use a comma to separate 
groups of thousands, many other countries use a period instead, and some 
countries separate thousands groups with a thin space.
Personally I have never understood the need or benefits of any thousand 
separator -- I have never used it neither private, in technical planning 
nor in (international)business.

Thanks again and
best regards
Pertti Rönnberg




On 12.1.2014 19:22, Paul wrote:

I haven't so much tried to answer your question directly, instead I
attempted to solve the same problem you did. For me, this gives a
simpler answer. Given:

Col A: The initial bank value as text
Col B: =IF(RIGHT(A1,1)=-,Debit,Credit)
Col C: =LEN(A1)
Col D: =LEFT(A1,C1-1)
Col E: =FIND(,,D1)
Col F: =SUBSTITUTE(D1,.,,)
Col G: =REPLACE(F1,E1,1,.)
Col H: =VALUE(G1)
Col I: =IF(B1=Debit, 0-H1, H1)

Col A holds the initial value as given by your bank, as text.

Col B then looks at the last character of that value, and displays
either Debit, if the character was a minus sign, or Credit for
anything else.

Col C gives the total length of the initial text value

Col D gives the initial value stripped of the last character, the plus
or minus sign.

Col E gives us the position of the comma, so that we can turn it into a
period later.

Col F gives us the stripped value (from col D) with the periods
replaced by commas, for correct thousand separators.

Col G gives us the value from col F with the final comma changed to a
period, for correct decimal separator. This text string should now be
correctly formatted for interpreting as a number.

Col H gives us the value from col G interpreted as a number.

Col I gives us the final value we want. This is derived from col
H, which has the initial value as a number, without the correct plus or
minus sign, and we use the value in col B to determine if we should use
the number as is, or subtract it from zero to get a negative number. I
formatted this column as currency.

I tested it with the following:

11.200,33+ == R 11,200.3
2.500.236,65- == R-2,500,236.65
11,25+ == R 11.25
0,96- == R-0.96

If I understand you correctly, this is exactly what you want. No need
to mess around with numbers under or over 9.999,99.

Of course, you can combine some of those formulas to use less extra
cells, but the more you combine stuff, the more complex it becomes, and
I don't know where you'd like to draw the line for complexity of
formulas vs complexity of page layout, so I leave that part up to you.

Hope this helps you out.

Paul



On Sun, 12 Jan 2014 17:55:17 +0200
Pertti Rönnberg p...@elisanet.fi wrote:


Happy New Year Dear LibO experts,

Since years back I have copied my bank's digital listing of my bank
account(s); first using MSOWord and later on MSOExcel.
My intension is to transform these listings so I can calculate with
the currency values in LibO-Calc.
The bank's table has four cols: colA=date, colBcolC= text and colD
is the currency as text.
Each listing consists of several hundreds of events (rows).

The problem is that the damn bank -- against all standards -- gives
the currency values with a dot (.) as thousand separator and + or
- chars (plus or minus) in the right end of each number (e.g.
987,65+, 1.234,56-, 23.456,78+) -- which is against Calc's will.

By now I have managed to get LibO/Calc to accept all values less than
9.999,99:
   first dragged (copied) the table from MSWord = MSExcel;
   MSExcel-file
saved in LibO/Calc as ods
   in Calc = function TRIM(D5) to get rid of non-printable chars

   

[libreoffice-users] Re: Import into a Template

2014-01-13 Thread Tinkerer
James

You have not read my request correctly.
I know how to use Templates and I know you can add to the text, I also know
that you cannot import another file into the Document, you can only Paste
something in.
This applies whether you are using a New Document, or one created from a
Template.
Brian Barker has it right, I must accept that the file will be on another
sheet and then Paste Special into my Formatted Sheet. 

I might add. The Bank Date Format uses Hyphens, Cor Nous Extension CT2N
corrects this.
With a small adjustment it will also recognize numbers prefixed by a
Currency sign.

Tink.



--
View this message in context: 
http://nabble.documentfoundation.org/Import-into-a-Template-tp4091874p4091971.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: Default Template

2014-01-13 Thread Tinkerer
Many thanks Brian.

I wasn't until widened the Template Manager Window that I realised all these
other options Existed.

Tink.




--
View this message in context: 
http://nabble.documentfoundation.org/SOLVED-Default-Template-tp4091871p4091972.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] Quick start without tray icon?

2014-01-13 Thread minhsien0330
I am sorry that I did not tell you I am using Linux (Debian).
Thanks.

Regards,
Minhsien0330


2014/1/13 Tom Davies tomc...@gmail.com

 Hi :)
 I think Brian is mainly talking about Xp there.  Win8 doesn't seem to
 have a system tray, but so far i've managed to mostly dodge Win8.
 Win7 allows you to set parameters for each individual icon in the
 system tray.

 Why does it matter how much stuff is showing in the system tray?  My
 guess is that you have so much stuff starting up at start-up that
 machine's performance is a LOT slower and some IT person has suggested
 that reducing the amount of stuff in the system tray will improve
 performance.  However, just hiding the icons wont have any impact on
 performance at all.  If you want you could list all the icons that do
 appear and we might be able to suggest ones that would be good to
 completely get rid of.

 Regards from
 Tom :)



 On 13 January 2014 08:53, Brian Barker b.m.bar...@btinternet.com wrote:
  At 16:33 13/01/2014 +0800, Min Hsien wrote:
 
  When we checked the option Enable systray Quickstarter, we preload
  libreoffice and have a Libreoffice logo icon on system tray. But
 there are
  too many icons on my tray, can I preload Libreoffice without tray icon?
 
 
  Probably - depending on your operating system.
 
  In Windows, for example, right-click in the Taskbar and select
 Properties.
  On the Taskbar tab, under Notification area, tick Hide inactive icons
  and click Customize... .  Click the Quickstarter reference and select
  Always hide from the drop-down menu for Behavior.  (But these
 directions
  do vary between Windows versions.)
 
  Of course, having the icon there provides a quick means of opening new or
  existing documents through the context menu.
 
  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
 

 --
 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] Quick start without tray icon?

2014-01-13 Thread Tom Davies
Hi :)
On GnuLinux just switch the Quick Starter off.  It doesn't do much in
GnuLinux apparently and might just make things awkward when you
upgrade or try to run multiple versions.

GnuLinux is completely different from Windows and designed to be much
more responsive and efficient with resources such as Ram, so you don't
really need to section off a protected space in Ram for LibreOffice or
anything and you don't need to have it quietly running in the
background to make it appear to start faster.  So i don't think you
really get many benefit from having the Quickstarter enabled in
GnuLinux.

I take it you are using KDE rather than Gnome or Xfce or anything as
your Desktop Environment?  I think Debian is one of those that gives a
lot of choices so it's not always clear what people have chosen.  The
Debian machines i use have carefully avoided havign any DE at all so
it's all command-line based which is great for servers but not so good
for desktops. On desktops i'm more familiar with Unity (Ubuntu only)
or Gnome (runs on most different flavours of GnuLinux).  I've not
really seen KDE in action.  Gnome doesn't really seem to have a
system-tray as such.

Regards from
Tom :)





On 13 January 2014 13:15, minhsien0330 minhsien0...@gmail.com wrote:
 I am sorry that I did not tell you I am using Linux (Debian).
 Thanks.

 Regards,
 Minhsien0330


 2014/1/13 Tom Davies tomc...@gmail.com

 Hi :)
 I think Brian is mainly talking about Xp there.  Win8 doesn't seem to
 have a system tray, but so far i've managed to mostly dodge Win8.
 Win7 allows you to set parameters for each individual icon in the
 system tray.

 Why does it matter how much stuff is showing in the system tray?  My
 guess is that you have so much stuff starting up at start-up that
 machine's performance is a LOT slower and some IT person has suggested
 that reducing the amount of stuff in the system tray will improve
 performance.  However, just hiding the icons wont have any impact on
 performance at all.  If you want you could list all the icons that do
 appear and we might be able to suggest ones that would be good to
 completely get rid of.

 Regards from
 Tom :)



 On 13 January 2014 08:53, Brian Barker b.m.bar...@btinternet.com wrote:
  At 16:33 13/01/2014 +0800, Min Hsien wrote:
 
  When we checked the option Enable systray Quickstarter, we preload
  libreoffice and have a Libreoffice logo icon on system tray. But
 there are
  too many icons on my tray, can I preload Libreoffice without tray icon?
 
 
  Probably - depending on your operating system.
 
  In Windows, for example, right-click in the Taskbar and select
 Properties.
  On the Taskbar tab, under Notification area, tick Hide inactive icons
  and click Customize... .  Click the Quickstarter reference and select
  Always hide from the drop-down menu for Behavior.  (But these
 directions
  do vary between Windows versions.)
 
  Of course, having the icon there provides a quick means of opening new or
  existing documents through the context menu.
 
  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
 

 --
 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


-- 
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] (Serious) issues with Impress rendering documents

2014-01-13 Thread Community
When creating a document in Impress (using the fonts Papyrus and Comic Sans) 
everything is rendered fine, that is, sometimes the font size is getting 
decreased automatically/arbitrarily, filling the whole text box, but apparently 
using a font size bigger than indicated in the corresponding drop down box, and 
upon re-entering the very same text box, the text is displayed at the actual, 
smaller one.

Anyways, the issue at hand is, in Impress the document is looking perfectly 
fine, but when exporting as PDF the text is exceeding the right hand border by 
far, and the text is getting cut off! :(

Please see enclosed screenshots for some details.


-- 
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] I think you could significantly improve the compression on the odt docs.

2014-01-13 Thread Tom Davies
Hi :)
It might be good to contact the developers about that.  Perhaps post a
bug-report and then use the drop-downs to turn into a feature
request for someone keen to jump on.  76% is huge!!
Regards from
Tom :)



On 11 January 2014 21:52, frank ernest do...@mail.com wrote:
 I think you could significantly improve the compression on the odt docs.

 tar -c dir | xz -4 -e  file.tar.xz

 16,760 tar.xz
 21,919 odt

 76.46334230576213%

 If you were really crazy you could use a custom filter chain to knock off
 an additional 0.4927232081755619%.

 xz -k -C sha256 --lzma2=dict=64MiB,lc=4,lp=0,pb=0,mf=bt4,mode=normal,\
 nice=273,depth=500 file.tar

 75.97061909758656%

 16,652 tar.xz

 And it only takes my system (64bit 3.2 GHz,)

 real 0m0.399s
 user 0m0.248s
 sys 0m0.148s

 to complete the above custom filter chain task so it can't be that hard
 for an older system to do.

 The file I tested this on was a very old file from before I knew much
 about computers. I created it because intranet explioter can't manage to save
 wiki pages and I was most interested in saving the file on how to create a 
 level.
 So it should be freely reditributable and I include it for the interseted.

 It's decompressed size is

 213,906 bytes

 Yielding

 10.247024393892644% odt

 and

 7.7847278711209595% tar.xz

 for the custom filter chain.

 I think a savings of about 25% is worth looking into.

 --
 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



[libreoffice-users] Re: a LibO/Calc problem (SOLVED)

2014-01-13 Thread Larry Evans

On 01/13/14 05:10, Pertti Rönnberg wrote:

Thank you Paul and Brian
for your interesting answers and for your kindness to send them so soon.
I have not checked them yet but I am sure that both of them give me what
I was looking for.
I see thepros and cons in Paul's method: by splitting the calculation in
details you can follow both the process and the reliability of the
result, but at cost of space.
But, there is more fun in Brian's solution; I have always liked to
create such complex formulas partly to be familiar with the spreadsheet
program and it's functions but now a days mostly because it is very good
exercise for an old man's brain --it is a challenge and then a good
reason to award yourself with a drink when it finally works.
I think I was quite near Brian's solution, but something went wrong, so
I had to shout for help.


[snip]
Hi Pertti,

I don't see Brian's reply to you(maybe he emailed you privately).
Could you please post it so other's could see it?

-regards,
Larry



--
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] Corrupt File! Help!!!

2014-01-13 Thread melodyfire
My husband has been working on a spreadsheet for over a month when last night
our laptop was unplugged. The battery is busted and the only way to keep the
laptop on is to have it plugged in. When he booted the laptop back up he was
prompted to recover the file and the recovery failed.He is them prompted to
choose an ACSII Filter option. When he chooses the option he gets a window
that says Document file 'name%20name.ods' is locked for editing by Unknown
User Open document read-only or open a copy of document for editing.

Each option opens a word document with this for 3 pages:

ice.Office.UI.WindowState:WindowStateType['private:resource/toolbar/drawbar']prop
oor:name=SoftClose oor:op=fusevaluefalse/value/prop/itemitem
oor:path=/org.openoffice.Office.UI.ChartWindowState/UIElements/States/org.openoffice.Office.UI.WindowState:WindowStateType['private:resource/toolbar/drawbar']prop
oor:name=Style oor:op=fusevalue0/value/prop/itemitem

The file had been saved many times before, is there a way I can either save
this file or open a past save? This is an ancient laptop (MacOS 10.4.11) so
alot of downloads wont work for it. If I can email the file to an up to date
laptop then I could save it. Can anyone help me? My husband is really upset
about losing this file and is already battling depression and this does not
need to be another thing on his list to be upset about.

Thanks for everyone help!



--
View this message in context: 
http://nabble.documentfoundation.org/Corrupt-File-Help-tp4092029.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: a LibO/Calc problem (SOLVED)

2014-01-13 Thread Pertti Rönnberg

Larry,
Here is a copy/paste copy of Brian's comments to my message.
I hope Brian does not mind.
Regards
Pertti Rönnberg


Since years back I have copied my bank's digital listing of my bank 
account(s); first using MSOWord and later on MSOExcel. My intention is 
to transform these listings so I can calculate with the currency 
values in LibO-Calc. The bank's table has four cols: colA=date, 
colBcolC= text and colD is the currency as text. Each listing 
consists of several hundreds of events (rows). The problem is that the 
damn bank -- against all standards -- gives the currency values with a 
dot (.) as thousand separator and + or - chars (plus or minus) 
in the right end of each number (e.g. 987,65+, 1.234,56-, 
23.456,78+) -- which is against Calc's will.


By now I have managed to get LibO/Calc to accept all values less than 
9.999,99:
 first dragged (copied) the table from MSWord = MSExcel; 
MSExcel-file saved in LibO/Calc as ods


I'm not sure why you want to use Microsoft Word or Excel.  You can open 
a .doc file in LibreOffice (as a text file) and copy and paste the table 
into a spreadsheet there.  You can open an .xls file directly in 
LibreOffice.  If your bank's original data is plain text or web 
material, you can import this directly into a LibreOffice spreadsheet.



_Question:_
What formula/function gives the same result for the bank's currency 
values bigger than 9.999,99?

e.g. 11.222,33+, 11.222.333,44-


It's a bit messy, but this should work:
=VALUE(RIGHT(Xn;1)SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(Xn;.;);+;);-;)) 



Cannot get the Fixed() -- when trying to eliminate the separator/dot 
that way -- working in this 'project' either.


This is no help.  If you already had correctly interpreted numbers 
(which you don't: that's the problem), FIXED() would convert these to 
text (with which you then couldn't calculate) - exactly the opposite of 
what you are trying to do.  Once you have your real numbers, you can 
control their appearance by choosing appropriate cell formats, of course.


I trust this helps.

Brian Barker







On 13.1.2014 19:15, Larry Evans wrote:

On 01/13/14 05:10, Pertti Rönnberg wrote:

Thank you Paul and Brian
for your interesting answers and for your kindness to send them so soon.
I have not checked them yet but I am sure that both of them give me what
I was looking for.
I see thepros and cons in Paul's method: by splitting the calculation in
details you can follow both the process and the reliability of the
result, but at cost of space.
But, there is more fun in Brian's solution; I have always liked to
create such complex formulas partly to be familiar with the spreadsheet
program and it's functions but now a days mostly because it is very good
exercise for an old man's brain --it is a challenge and then a good
reason to award yourself with a drink when it finally works.
I think I was quite near Brian's solution, but something went wrong, so
I had to shout for help.


[snip]
Hi Pertti,

I don't see Brian's reply to you(maybe he emailed you privately).
Could you please post it so other's could see it?

-regards,
Larry






--
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]mmult with transpose arg drops last row

2014-01-13 Thread Larry Evans

I've a spreadsheet with 2 3x2 matridces side by side (A1:D3).
I want to mmult(A1:B3;transpose(C1:D3)); however,
the result has the last row truncated.  IOW, the
resulting matrix is 2x3 instead of 3x3.

The spreadsheet also has the transpose stored separately
in cells A5:C12, and then the mmult done with this separately
stored transpose, and the result is a 3x3 matrix, as expected.

Here's the printout of formulas in csv notation:

1,4,7,10
2,5,8,11
3,6,9,12
,,,
{=TRANSPOSE(C1:D3)},{=TRANSPOSE(C1:D3)},{=TRANSPOSE(C1:D3)},
{=TRANSPOSE(C1:D3)},{=TRANSPOSE(C1:D3)},{=TRANSPOSE(C1:D3)},
,,,
{=MMULT(A1:B3,A5:C6)},{=MMULT(A1:B3,A5:C6)},{=MMULT(A1:B3,A5:C6)},
{=MMULT(A1:B3,A5:C6)},{=MMULT(A1:B3,A5:C6)},{=MMULT(A1:B3,A5:C6)},
{=MMULT(A1:B3,A5:C6)},{=MMULT(A1:B3,A5:C6)},{=MMULT(A1:B3,A5:C6)},
,,,
{=MMULT(A1:B3,TRANSPOSE(C1:D3))},{=MMULT(A1:B3,TRANSPOSE(C1:D3))},{=MMULT(A1:B3,TRANSPOSE(C1:D3))},
{=MMULT(A1:B3,TRANSPOSE(C1:D3))},{=MMULT(A1:B3,TRANSPOSE(C1:D3))},{=MMULT(A1:B3,TRANSPOSE(C1:D3))},

Why are there only 2 rows instead of 3 in the last result
[the one done with mmult(a1:b3,transpose(c1:d3))]?

TIA.

-regards,
Larry


--
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] I think you could significantly improve the compression on the odt docs.

2014-01-13 Thread Regina Henschel

Hi Frank,

frank ernest schrieb:

I think you could significantly improve the compression on the odt docs.

tar -c dir | xz -4 -e  file.tar.xz

16,760 tar.xz
21,919 odt

76.46334230576213%


there is no choice, how to compress the package, because it is defined 
in the standard, see 
http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part3.html#__RefHeading__752789_826425813


Kind regards
Regina

--
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] a LibO/Calc problem (SOLVED)

2014-01-13 Thread Pertti Rönnberg

Brian,
Your formula workes perfect! Fantastic!
And I learned a little more about creating formulas.
Thanks again!
Cheers ; skål (swedish) ; kippis (finnish)
Pertti Rönnberg


On 13.1.2014 3:13, Brian Barker wrote:

At 17:55 12/01/2014 +0200, Pertti Rönnberg wrote:
Since years back I have copied my bank's digital listing of my bank 
account(s); first using MSOWord and later on MSOExcel. My intention 
is to transform these listings so I can calculate with the currency 
values in LibO-Calc. The bank's table has four cols: colA=date, 
colBcolC= text and colD is the currency as text. Each listing 
consists of several hundreds of events (rows). The problem is that 
the damn bank -- against all standards -- gives the currency values 
with a dot (.) as thousand separator and + or - chars (plus or 
minus) in the right end of each number (e.g. 987,65+, 1.234,56-, 
23.456,78+) -- which is against Calc's will.


By now I have managed to get LibO/Calc to accept all values less than 
9.999,99:
 first dragged (copied) the table from MSWord = MSExcel; 
MSExcel-file saved in LibO/Calc as ods


I'm not sure why you want to use Microsoft Word or Excel.  You can 
open a .doc file in LibreOffice (as a text file) and copy and paste 
the table into a spreadsheet there.  You can open an .xls file 
directly in LibreOffice.  If your bank's original data is plain text 
or web material, you can import this directly into a LibreOffice 
spreadsheet.



_Question:_
What formula/function gives the same result for the bank's currency 
values bigger than 9.999,99?

e.g. 11.222,33+, 11.222.333,44-


It's a bit messy, but this should work:
=VALUE(RIGHT(Xn;1)SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(Xn;.;);+;);-;)) 



Cannot get the Fixed() -- when trying to eliminate the separator/dot 
that way -- working in this 'project' either.


This is no help.  If you already had correctly interpreted numbers 
(which you don't: that's the problem), FIXED() would convert these to 
text (with which you then couldn't calculate) - exactly the opposite 
of what you are trying to do.  Once you have your real numbers, you 
can control their appearance by choosing appropriate cell formats, of 
course.


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] Corrupt File! Help!!!

2014-01-13 Thread Tom Davies
Hi :)

1st thing is to copy the file that appears to be corrupted.
2nd is to find the User Profile and inside it the back-up folder
and copy the relevant file that is hopefully in there too.

Preferably put those copies on Usb-stick or email them to yourselves
so that you have a copy that hasn't been worked on yet.  So any advice
from anyone can be safely tried without further harming the one
version of the files.

Regards from
Tom :)



On 13 January 2014 17:00, melodyfire cowens33...@gmail.com wrote:
 My husband has been working on a spreadsheet for over a month when last night
 our laptop was unplugged. The battery is busted and the only way to keep the
 laptop on is to have it plugged in. When he booted the laptop back up he was
 prompted to recover the file and the recovery failed.He is them prompted to
 choose an ACSII Filter option. When he chooses the option he gets a window
 that says Document file 'name%20name.ods' is locked for editing by Unknown
 User Open document read-only or open a copy of document for editing.

 Each option opens a word document with this for 3 pages:

 ice.Office.UI.WindowState:WindowStateType['private:resource/toolbar/drawbar']prop
 oor:name=SoftClose oor:op=fusevaluefalse/value/prop/itemitem
 oor:path=/org.openoffice.Office.UI.ChartWindowState/UIElements/States/org.openoffice.Office.UI.WindowState:WindowStateType['private:resource/toolbar/drawbar']prop
 oor:name=Style oor:op=fusevalue0/value/prop/itemitem

 The file had been saved many times before, is there a way I can either save
 this file or open a past save? This is an ancient laptop (MacOS 10.4.11) so
 alot of downloads wont work for it. If I can email the file to an up to date
 laptop then I could save it. Can anyone help me? My husband is really upset
 about losing this file and is already battling depression and this does not
 need to be another thing on his list to be upset about.

 Thanks for everyone help!



 --
 View this message in context: 
 http://nabble.documentfoundation.org/Corrupt-File-Help-tp4092029.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


-- 
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] I think you could significantly improve the compression on the odt docs.

2014-01-13 Thread Cley Faye
2014/1/13 Regina Henschel rb.hensc...@t-online.de

 Hi Frank,

 frank ernest schrieb:

  I think you could significantly improve the compression on the odt docs.

 tar -c dir | xz -4 -e  file.tar.xz

 16,760 tar.xz
 21,919 odt

 76.46334230576213%


 there is no choice, how to compress the package, because it is defined in
 the standard, see http://docs.oasis-open.org/office/v1.2/os/OpenDocument-
 v1.2-os-part3.html#__RefHeading__752789_826425813


​Agreed.
It *is* possible to achieve better compression than ZIP (we knew how to do
that ​for quite some time ;) ), but to do so we would need a new iteration
of the OpenDocument standard. While it's not totally out of question, I
have the feeling that increasing fragmentation just to save space on office
files is not a good trade-off. Remember that ODT files are used by many
pieces of software, not only LibreOffice.
OpenOffice of course, but some part of google export, some less-known
office suite, various custom software that output their reports as odt
files... even mso got to implement it. I doubt a new version of the
standard would be a good thing while it is still functionnal.


-- 
Cley Faye
http://cleyfaye.net

-- 
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] Quick start without tray icon?

2014-01-13 Thread Mirosław Zalewski
Dnia 2014-01-13, o godz. 16:33:32
minhsien0330 minhsien0...@gmail.com napisał(a):

 Dear all:
 When we checked the option Enable systray Quickstarter, we preload
 libreoffice and have a Libreoffice logo icon on system tray.
 But there are too many icons on my tray, can I preload Libreoffce
 without tray icon?

Since you have revealed in other message that you are using Linux:
grab script below, save it, add executable flag (chmod +x scrip.sh) and
make it run at start of your desktop environment of choice.

Script:
--START--
#!/bin/bash

if ps -C soffice.bin /dev/null 21; then
exit
fi

sleep 90
soffice --nodefault --nologo 
PID=$!
echo $PID  /tmp/lo-quickstarter
sleep 10
kill $PID
END--

How it works:
It takes advantage of Linux smart memory management. When you run
application, Linux loads it into memory (RAM). It stays there then,
just in case you decide to run it later on. But it is marked as
cache, so if you want to open another application, and running low on
memory, Linux will delete marked data from RAM to make up space for
this new application.
In high level steps: this script fires up LibreOffice in non-graphical
mode (so all libraries etc. are loaded into RAM), wait few seconds and
then kills process. LibreOffice will be in memory from now on. When you
start it again, you will perceive that process as much faster.


What it does, step by step:
1. Check whether libreoffice is running. If it is, just finish. We
don't want to break anything.
2. Wait 90 seconds. Starting graphical interface usually means starting
a bunch of services and many disk reads. Since LibreOffice is low
priority (we want our desktop responsive as fast as possible), we
somehow queue it on the end of boot process.
3. Run LibreOffice in non-graphical mode - hide splash screen and UI.
4. Save LibreOffice PID (Process ID - a number that uniquely identifies
each application running on system) for later use.
5. Wait 10 seconds for LibreOffice to finish starting. We don't want to
interrupt it on start, as something bad might happen (although
shouldn't).
6. Stop LibreOffice, identified by PID earlier. This way we make sure
that we don't stop another application by mistake.

One drawback that I have noticed - if you force stop LibreOffice with
documents opened, it will ask you what to do with these documents on
next start. And this next start sometimes happen to be that script
running. This might lead to unwanted windows popping up shortly after
machine boot.

I am using that script since some time and I am enjoying LibreOffice
perceived boot in 4-5 seconds on my dated machine.
-- 
Best regards
Mirosław Zalewski

-- 
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] I think you could significantly improve the compression on the odt docs.

2014-01-13 Thread Tom Davies
Hi :)
Ahh, ok :)  That makes sense now.

It is, of course, possible to put several Odt documents inside another
zipped file and that should benefit from the higher compression rate.

I guess the feature request would be passed on to the OASIS
committee but it sounds like they have probably already weighed-up the
pros-and-cons
Regards from
Tom :)


On 13 January 2014 18:26, Cley Faye cleyf...@gmail.com wrote:
 2014/1/13 Regina Henschel rb.hensc...@t-online.de

 Hi Frank,

 frank ernest schrieb:

  I think you could significantly improve the compression on the odt docs.

 tar -c dir | xz -4 -e  file.tar.xz

 16,760 tar.xz
 21,919 odt

 76.46334230576213%


 there is no choice, how to compress the package, because it is defined in
 the standard, see http://docs.oasis-open.org/office/v1.2/os/OpenDocument-
 v1.2-os-part3.html#__RefHeading__752789_826425813


 Agreed.
 It *is* possible to achieve better compression than ZIP (we knew how to do
 that for quite some time ;) ), but to do so we would need a new iteration
 of the OpenDocument standard. While it's not totally out of question, I
 have the feeling that increasing fragmentation just to save space on office
 files is not a good trade-off. Remember that ODT files are used by many
 pieces of software, not only LibreOffice.
 OpenOffice of course, but some part of google export, some less-known
 office suite, various custom software that output their reports as odt
 files... even mso got to implement it. I doubt a new version of the
 standard would be a good thing while it is still functionnal.


 --
 Cley Faye
 http://cleyfaye.net

 --
 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] Corrupt File! Help!!!

2014-01-13 Thread Tom Davies
Hi :)
Ok, so you have made a copy of the corrupted file.  The User Profile is here
https://wiki.documentfoundation.org/UserProfile
well, that's the guide that describes where it is on the various
different systems.

I tend to try a few different approaches all at about the same time
when faced with this sort of thing.  We have all been there and lost
data at some point or other.  It's easy to be wiser with hindsight,
such as saving back-ups on different machines but before hindsight we
mnight not have thought about it!!

It might be worth trying to remember if the file is saved anywhere
else.  Has the file been worked on anywhere else?  Are there any other
machines that might have a fairly recent version, perhaps the newer
laptop got used sometime?  Did the file get emailed, or saved onto
usb-stick?  Cd/Dvd back-ups?  Do you have a network, might it be on
there?  Is there an older version of the same file in the same folder
or archived somewhere?

If your husband can manage to start again he will find that it is FAR
quicker to re-do.  He might even find that the entire month's work can
be done fairly easily in just a couple of days.  In the process of
writing it originally he might have done research or thought carefully
about different options and tried different things out, perhaps
read-up on how to do certain things and then maybe not even gone that
way in the end.  All of that is swept aside on the 2nd time making it
much easier and faster to re-do something.

Regards from
Tom :)


On 13 January 2014 17:00, melodyfire cowens33...@gmail.com wrote:
 My husband has been working on a spreadsheet for over a month when last night
 our laptop was unplugged. The battery is busted and the only way to keep the
 laptop on is to have it plugged in. When he booted the laptop back up he was
 prompted to recover the file and the recovery failed.He is them prompted to
 choose an ACSII Filter option. When he chooses the option he gets a window
 that says Document file 'name%20name.ods' is locked for editing by Unknown
 User Open document read-only or open a copy of document for editing.

 Each option opens a word document with this for 3 pages:

 ice.Office.UI.WindowState:WindowStateType['private:resource/toolbar/drawbar']prop
 oor:name=SoftClose oor:op=fusevaluefalse/value/prop/itemitem
 oor:path=/org.openoffice.Office.UI.ChartWindowState/UIElements/States/org.openoffice.Office.UI.WindowState:WindowStateType['private:resource/toolbar/drawbar']prop
 oor:name=Style oor:op=fusevalue0/value/prop/itemitem

 The file had been saved many times before, is there a way I can either save
 this file or open a past save? This is an ancient laptop (MacOS 10.4.11) so
 alot of downloads wont work for it. If I can email the file to an up to date
 laptop then I could save it. Can anyone help me? My husband is really upset
 about losing this file and is already battling depression and this does not
 need to be another thing on his list to be upset about.

 Thanks for everyone help!



 --
 View this message in context: 
 http://nabble.documentfoundation.org/Corrupt-File-Help-tp4092029.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


-- 
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] Corrupt File! Help!!!

2014-01-13 Thread mcmurchy1917-libreoffice
If you can't find a backup. Try this.

You seem to indicate that the corrupted spreadsheet is called *name 
name.ods*.  

If that is what it is called copy the corrupted file to an empty 
folder/directory.

In that folder/directory there should now only contain the file *name 
name.ods* unzip this file.

The contents of the folder should now contain these files and directories.
 *  Configurations2/  *content.xml*  manifest.rdf  META-INF/  meta.xml  
mimetype  name\ name.ods  settings.xml  styles.xml  Thumbnails/
Open the file *content.xml* with firefox or equivalent and inspect the file. 
Hopefully you should recognise your data albeit in xml format.

If you recognise the data, paste the first 10 or so lines and the last 10 or so 
lines into an emial and mail it here. Anonymise any data as appropriate.

Then we cen see what we can do next.


Alex




On Monday 13 Jan 2014 18:30:50 Tom Davies wrote:
 Hi :)
 Ok, so you have made a copy of the corrupted file.  The User Profile is here
 https://wiki.documentfoundation.org/UserProfile
 well, that's the guide that describes where it is on the various
 different systems.
 
 I tend to try a few different approaches all at about the same time
 when faced with this sort of thing.  We have all been there and lost
 data at some point or other.  It's easy to be wiser with hindsight,
 such as saving back-ups on different machines but before hindsight we
 mnight not have thought about it!!
 
 It might be worth trying to remember if the file is saved anywhere
 else.  Has the file been worked on anywhere else?  Are there any other
 machines that might have a fairly recent version, perhaps the newer
 laptop got used sometime?  Did the file get emailed, or saved onto
 usb-stick?  Cd/Dvd back-ups?  Do you have a network, might it be on
 there?  Is there an older version of the same file in the same folder
 or archived somewhere?
 
 If your husband can manage to start again he will find that it is FAR
 quicker to re-do.  He might even find that the entire month's work can
 be done fairly easily in just a couple of days.  In the process of
 writing it originally he might have done research or thought carefully
 about different options and tried different things out, perhaps
 read-up on how to do certain things and then maybe not even gone that
 way in the end.  All of that is swept aside on the 2nd time making it
 much easier and faster to re-do something.
 
 Regards from
 Tom :)
 
 
 On 13 January 2014 17:00, melodyfire cowens33...@gmail.com wrote:
  My husband has been working on a spreadsheet for over a month when last 
  night
  our laptop was unplugged. The battery is busted and the only way to keep the
  laptop on is to have it plugged in. When he booted the laptop back up he was
  prompted to recover the file and the recovery failed.He is them prompted to
  choose an ACSII Filter option. When he chooses the option he gets a window
  that says Document file 'name%20name.ods' is locked for editing by Unknown
  User Open document read-only or open a copy of document for editing.
 
  Each option opens a word document with this for 3 pages:
 
  ice.Office.UI.WindowState:WindowStateType['private:resource/toolbar/drawbar']prop
  oor:name=SoftClose oor:op=fusevaluefalse/value/prop/itemitem
  oor:path=/org.openoffice.Office.UI.ChartWindowState/UIElements/States/org.openoffice.Office.UI.WindowState:WindowStateType['private:resource/toolbar/drawbar']prop
  oor:name=Style oor:op=fusevalue0/value/prop/itemitem
 
  The file had been saved many times before, is there a way I can either save
  this file or open a past save? This is an ancient laptop (MacOS 10.4.11) so
  alot of downloads wont work for it. If I can email the file to an up to date
  laptop then I could save it. Can anyone help me? My husband is really upset
  about losing this file and is already battling depression and this does not
  need to be another thing on his list to be upset about.
 
  Thanks for everyone help!
 
 
 
  --
  View this message in context: 
  http://nabble.documentfoundation.org/Corrupt-File-Help-tp4092029.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
 
 
 

-- 
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: libreoffice untitled docs constantly autosaving

2014-01-13 Thread John King

On 12/01/14 20:30, Luuk wrote:

On 12-01-2014 20:38, Cley Faye wrote:
Additionnaly, how did you install LibreOffice on your system? Did you 
use

some distribution-specific repositories, or got it from the Libreoffice
website ? Maybe there is something opensuse-specific that cause this. 
If it
doesn't happen with the version downloaded from the website, you'll 
have to

report this issue to the Opensuse folks.



I have an OpenSUSE 12.3 system too, here's some version info.
(last patches/updates are installed)

I could not reproduce the bug.

luuk@opensuse:~/temp cat /etc/os-release
NAME=openSUSE
VERSION=12.3 (Dartmouth)
VERSION_ID=12.3
PRETTY_NAME=openSUSE 12.3 (Dartmouth) (x86_64)
ID=opensuse
ANSI_COLOR=0;32
CPE_NAME=cpe:/o:opensuse:opensuse:12.3

luuk@opensuse:~/temp ooffice --version
LibreOffice 3.6

luuk@opensuse:~/temp zypper info libreoffice | grep -i version
Version: 3.6.3.2.4-2.4.1




Thanks for trying.
I notice you are using LO 3.6.3.2.
I didn't have a problem with the 3.6 series either, nor with the 4.0 
series. The problem started after the updates to the 4.1. series from

http://download.opensuse.org/repositories/LibreOffice:/Stable/openSUSE_12.3/

John

--
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] Quick start without tray icon?

2014-01-13 Thread Tom Davies
Hi :)
I know probably everyone else knows this already but i just learned
that i can kill a process by using it's name without needing to find
it's PID!  Since it's often Firefox that misbehaves after i push it
t far i find this useful

pkill firefox

Then when i click on Firefox icon to open it again it remembers most
of the tabs i had open and lets me untick a few if i want.
Regards from
Tom :)






On 13 January 2014 18:32, Mirosław Zalewski mini...@poczta.onet.pl wrote:
 Dnia 2014-01-13, o godz. 16:33:32
 minhsien0330 minhsien0...@gmail.com napisał(a):

 Dear all:
 When we checked the option Enable systray Quickstarter, we preload
 libreoffice and have a Libreoffice logo icon on system tray.
 But there are too many icons on my tray, can I preload Libreoffce
 without tray icon?

 Since you have revealed in other message that you are using Linux:
 grab script below, save it, add executable flag (chmod +x scrip.sh) and
 make it run at start of your desktop environment of choice.

 Script:
 --START--
 #!/bin/bash

 if ps -C soffice.bin /dev/null 21; then
 exit
 fi

 sleep 90
 soffice --nodefault --nologo 
 PID=$!
 echo $PID  /tmp/lo-quickstarter
 sleep 10
 kill $PID
 END--

 How it works:
 It takes advantage of Linux smart memory management. When you run
 application, Linux loads it into memory (RAM). It stays there then,
 just in case you decide to run it later on. But it is marked as
 cache, so if you want to open another application, and running low on
 memory, Linux will delete marked data from RAM to make up space for
 this new application.
 In high level steps: this script fires up LibreOffice in non-graphical
 mode (so all libraries etc. are loaded into RAM), wait few seconds and
 then kills process. LibreOffice will be in memory from now on. When you
 start it again, you will perceive that process as much faster.


 What it does, step by step:
 1. Check whether libreoffice is running. If it is, just finish. We
 don't want to break anything.
 2. Wait 90 seconds. Starting graphical interface usually means starting
 a bunch of services and many disk reads. Since LibreOffice is low
 priority (we want our desktop responsive as fast as possible), we
 somehow queue it on the end of boot process.
 3. Run LibreOffice in non-graphical mode - hide splash screen and UI.
 4. Save LibreOffice PID (Process ID - a number that uniquely identifies
 each application running on system) for later use.
 5. Wait 10 seconds for LibreOffice to finish starting. We don't want to
 interrupt it on start, as something bad might happen (although
 shouldn't).
 6. Stop LibreOffice, identified by PID earlier. This way we make sure
 that we don't stop another application by mistake.

 One drawback that I have noticed - if you force stop LibreOffice with
 documents opened, it will ask you what to do with these documents on
 next start. And this next start sometimes happen to be that script
 running. This might lead to unwanted windows popping up shortly after
 machine boot.

 I am using that script since some time and I am enjoying LibreOffice
 perceived boot in 4-5 seconds on my dated machine.
 --
 Best regards
 Mirosław Zalewski

 --
 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] libreoffice untitled docs constantly autosaving

2014-01-13 Thread John King

On 12/01/14 19:38, Cley Faye wrote:

Additionnaly, how did you install LibreOffice on your system? Did you use
some distribution-specific repositories, or got it from the Libreoffice
website ? Maybe there is something opensuse-specific that cause this. If it
doesn't happen with the version downloaded from the website, you'll have to
report this issue to the Opensuse folks.


I've now done further tests with the distributions I have easy access to.
First of all, a correction.  When I originally reported this, I thought 
it was restricted to opensuse. I have since found the same problem 
arises on Kubuntu and Xubuntu with the 4.1 series of Libreoffice, as I 
have documented in the bug report on:

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

In the case of both the ubuntu-based distributions and opensuse KDE and 
Gnome, Libreoffice was installed from the distribution repositories (as 
recommended on the Libreoffice web site). In all these cases, ticking

Tools-Option-Load/Save-General-Automatically save the document too

results in the constant saving.

However, in Kubuntu and Opensuse 12.3 - Gnome, I deinstalled the 
repository provided version and installed the versions from the 
Libreoffice website to see if there was any difference. Libreoffice was 
run with completely new profiles, and on first run worked fine, not 
showing any constant saving. However, after logging out and logging in 
and rerunning the test, the same constant saving occurred on every 
subsequent occasion, so it doesn't seem to be repository version specific.


John

--
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: a LibO/Calc problem (SOLVED)

2014-01-13 Thread Brian Barker

At 11:15 13/01/2014 -0600, Larry Evans wrote:

I don't see Brian's reply to you (maybe he emailed you privately).


No, it was sent to the list.  See 
http://listarchives.libreoffice.org/global/users/msg36082.html .


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] Quick start without tray icon?

2014-01-13 Thread Mirosław Zalewski
Dnia 2014-01-13, o godz. 19:16:14
Tom Davies tomc...@gmail.com napisał(a):

 I know probably everyone else knows this already but i just learned
 that i can kill a process by using it's name without needing to find
 it's PID!  

Yeah, I know that.

But this is not an option here. pkill will, by default, search for
processes of every user. Imagine that there are two users on the
system, and one of them has LibreOffice already running. If you do
pkill soffice.bin, it might hit another user and interrupt his work
(unlikely, as you probably won't have sufficient permissions).

Or imagine that you have libreoffice running in background in headless
mode, used to convert documents in large batches. If you issue pkill,
you will interrupt it's work.

In both these cases you won't need quickstarter/preloader script, as LO
will already be in memory (so there is no benefit in preloading it).
But still, killing process by name is not an option here. We need to
stop one particular instance of LO that we have started only to put it
in memory. 
-- 
Best regards
Mirosław Zalewski

-- 
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] a LibO/Calc problem (SOLVED)

2014-01-13 Thread Paul
On Mon, 13 Jan 2014 13:10:03 +0200
Pertti Rönnberg p...@elisanet.fi wrote:

 Paul's answer is interesting from another point of view also -- he 
 changes the decimal sign from a comma to a period and replaces the 
 periods replaced by commas to get the correct thousand separator.
Well, you might be able to just change your locale settings to allow
the different format, but I assumed you didn't want to do that. As I
understand it, that can only be changed system-wide, not per document.

 Another page Decimal and Thousand Separators says: Great Britain
 and the United States are two of the few places in the world that use
 a period to indicate the decimal place.
It's also pretty common in computer circles (programming, data
interchange formats, etc) to use a period for a decimal separator.

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] I think you could significantly improve the compression on the odt docs

2014-01-13 Thread frank ernest
Acctually I thought that it was kinda obvious and I was thinking that you'd 
want to fix it before your ODT standard was widly adopted.
It would be easier to change the code of 10 programs then 1000 once you finally 
retire the standard.
You could also develop a split in the standard and call the files *.ODT2.
Personally I was shocked how bad the compression was. I expected maybe I'd get 
5% or (if I was really lucky) 15% better compression, but 25%! That's (as 
someone already pointed out) HUGE!
I am advising to fix the spec before the cat gets out of the bag.

-- 
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] I think you could significantly improve the compression on the odt docs

2014-01-13 Thread V Stuart Foote
Frank,

Wrong venue... take the suggestion to the standards group for ODF

https://www.oasis-open.org/committees/tc_home.php?wg_abbrev=office

The LibreOffice project is simply an implementer and has greater issues with 
ODF standards.

Kind regards,

Stuart

 -Original Message-
 From: frank ernest [mailto:do...@mail.com]
 Sent: Monday, January 13, 2014 4:39 PM
 To: users@global.libreoffice.org
 Subject: Re: [libreoffice-users] I think you could significantly improve the
 compression on the odt docs
 
 Acctually I thought that it was kinda obvious and I was thinking that you'd
 want to fix it before your ODT standard was widly adopted.
 It would be easier to change the code of 10 programs then 1000 once you
 finally retire the standard.
 You could also develop a split in the standard and call the files *.ODT2.
 Personally I was shocked how bad the compression was. I expected maybe
 I'd get 5% or (if I was really lucky) 15% better compression, but 25%! That's
 (as someone already pointed out) HUGE!
 I am advising to fix the spec before the cat gets out of the bag.
 
 --
 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] I think you could significantly improve the compression on the odt docs

2014-01-13 Thread Cley Faye
2014/1/13 frank ernest do...@mail.com

 Acctually I thought that it was kinda obvious and I was thinking that
 you'd want to fix it before your ODT standard was widly adopted.
 It would be easier to change the code of 10 programs then 1000 once you
 finally retire the standard.
 You could also develop a split in the standard and call the files *.ODT2.
 Personally I was shocked how bad the compression was. I expected maybe I'd
 get 5% or (if I was really lucky) 15% better compression, but 25%! That's
 (as someone already pointed out) HUGE!
 I am advising to fix the spec before the cat gets out of the bag.


Huu, you might have missed the last five years where odt is already widely
used.

Also, you should warn microsoft before their docx stuff get in the wild
too, as they also use the zip file format.

-- 
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] Quick start without tray icon?

2014-01-13 Thread minhsien0330
Dear Mirosław Zalewski:
Your solution is really a  very good idea!!!
Thank you!!!

Best Regards,
Minhsien0330


2014/1/14 Mirosław Zalewski mini...@poczta.onet.pl

 Dnia 2014-01-13, o godz. 16:33:32
 minhsien0330 minhsien0...@gmail.com napisał(a):

  Dear all:
  When we checked the option Enable systray Quickstarter, we preload
  libreoffice and have a Libreoffice logo icon on system tray.
  But there are too many icons on my tray, can I preload Libreoffce
  without tray icon?

 Since you have revealed in other message that you are using Linux:
 grab script below, save it, add executable flag (chmod +x scrip.sh) and
 make it run at start of your desktop environment of choice.

 Script:
 --START--
 #!/bin/bash

 if ps -C soffice.bin /dev/null 21; then
 exit
 fi

 sleep 90
 soffice --nodefault --nologo 
 PID=$!
 echo $PID  /tmp/lo-quickstarter
 sleep 10
 kill $PID
 END--

 How it works:
 It takes advantage of Linux smart memory management. When you run
 application, Linux loads it into memory (RAM). It stays there then,
 just in case you decide to run it later on. But it is marked as
 cache, so if you want to open another application, and running low on
 memory, Linux will delete marked data from RAM to make up space for
 this new application.
 In high level steps: this script fires up LibreOffice in non-graphical
 mode (so all libraries etc. are loaded into RAM), wait few seconds and
 then kills process. LibreOffice will be in memory from now on. When you
 start it again, you will perceive that process as much faster.


 What it does, step by step:
 1. Check whether libreoffice is running. If it is, just finish. We
 don't want to break anything.
 2. Wait 90 seconds. Starting graphical interface usually means starting
 a bunch of services and many disk reads. Since LibreOffice is low
 priority (we want our desktop responsive as fast as possible), we
 somehow queue it on the end of boot process.
 3. Run LibreOffice in non-graphical mode - hide splash screen and UI.
 4. Save LibreOffice PID (Process ID - a number that uniquely identifies
 each application running on system) for later use.
 5. Wait 10 seconds for LibreOffice to finish starting. We don't want to
 interrupt it on start, as something bad might happen (although
 shouldn't).
 6. Stop LibreOffice, identified by PID earlier. This way we make sure
 that we don't stop another application by mistake.

 One drawback that I have noticed - if you force stop LibreOffice with
 documents opened, it will ask you what to do with these documents on
 next start. And this next start sometimes happen to be that script
 running. This might lead to unwanted windows popping up shortly after
 machine boot.

 I am using that script since some time and I am enjoying LibreOffice
 perceived boot in 4-5 seconds on my dated machine.
 --
 Best regards
 Mirosław Zalewski


-- 
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] Similar Problem?

2014-01-13 Thread Vince Radice
I am seeing something and I don't know if it is a problem or something I 
have to live with.


In the ~/.config/libreoffice/4/user/backup  directory, I have 3,000+ 
files with 0 bytes.  I assume that this means the files are empty. There 
are other files there which are not empty.  The non-empty ones appear to 
be backups of files I have worked on.  The empty files all appear to be 
attempts to backup a Base database that I have created using the built 
in hsql engine.  The file is stored on my computer. The time stamps on 
the files are unusual.  There are 6 files with a time stamp of 15:58, 6 
with 15:59, 6 with 16:00 and the pattern continues for the other 3,500 
empty files.


Does any one else have the same situation?  I have the save/backup time 
in the general options set to 15 minutes.


I have a listing of all of the files if anyone wants to see it.

Thank you,
Vince Radice

--
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] getting larger set of colors that the standard that comes with LO -corrected URL

2014-01-13 Thread Kracked_P_P---webmaster


I am working on increasing the official installed color 
list/chart/table with a lot of new ones.


In this folder, there are two standard.soc files, but I am working on an 
even larger one.


https://owncloud.documentfoundation.org/Common/QA/New-Colors#

My current working standard.soc file is about 2224 colors in size.
I am adding color tables I have found, plus other named colors.

Right now I have added 2 tables with 77 colors each.  I have a few more 
of these tables to go.

As for the named colors, I found :
brass, bronze, copper, gold, wood, and others with those colors in their 
names [plus others as well].


It takes some time to create the lines of code for each color, times 
70+, times 2 or more, then adding them to the file and correcting mistakes.


But I will upload what I have soon.


On 01/12/2014 10:55 AM, Kracked_P_P---webmaster wrote:

Thanks som

I redid the arrangement of some of the colors in the original large 
color file and put that in the ownCloud folder.  Plus I added a few 
more colors I found.


I found Hex codes for colors like
Silver, Copper, Wood, etc..

So I added it to the second one.

I found a set of Hex codes that do not have any named to them, but 
they explore the range of colors, from light to dark, starting with 
one color/code.


This is a sample of those color tables.

http://libreoffice-na.us/color-coder-tables.png

I may work on creating a file with those color in it.  Although there 
are not names for them, I would end up using their Hex codes for the 
names, unless there is no need for naming the colors in the list.



If you look at the color table in Writer, via. its table properties 
for the background of a cell, you can see it another way.


http://libreoffice-na.us/writer-color-table.png

This is a screen clip of Writer and one of my calendars that I made 
from a .doc template I found.


The bottom two rows, and part of the row above that, are the Branding 
Colors, so if you want to create something with the LO Branded Colors 
you do not have to look any farther.  Yes, above those colors there 
are colors like Blue 8 or Turquoise 2, but there is no indication if 
any of those colors are the Branded Colors or not.  I made sure that 
the colors had names like LO green 4 or LO yellow 1 so you know that 
they are the colors listed in the Branding information page.


With over 2,000 colors in the list, the users should be able to find 
something they would like to use.  When I have the time to make a new 
one, with the colors in the first image's file, then there will be a 
lot more choices.





On 01/11/2014 11:33 PM, som wrote:




On Saturday, 11 January 2014 10:07 PM, Kracked_P_P---webmaster 
webmas...@krackedpress.com wrote:

https://owncloud.documentfoundation.org/Common/QA/New-Colors#

this worked. thanks for the file. here (https://db.tt/pLDjVXJW) is a 
screenshot of libreoffice after replacing the original with this 
standard.soc on a Xubuntu 13.10.


regards,


som








--
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] getting larger set of colors that the standard that comes with LO -corrected URL

2014-01-13 Thread tk
Did I send you a copyof the colour soc I use?
(The one that is 2.5 MB in size, not the one that is 2.x GB in size.

jonathon
-- 
Sent from the eating establishment at the Far side of the Universe, at the 
begining of Time, and at  the end of Space.
-- 
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] Corrupt File! Help!!!

2014-01-13 Thread Tom Davies
Hi :)
After you have created copies of the files can you rename the file
ending of one from .ods to .zip and then double-click on that?  It
should open as though it is a compressed file so an archive manager
should open it.

If it works it wont look anything like the file!  You should see
various .xml documents and about 3 folders.  One of the xml files
should be called something like contents.xml.  I think this is the
file that should contain most of the data.  However when you open it
then it should look a LOT like the file you described so maybe there
is something weird going on.

Any chance of reinstalling LibreOffice?  If LibreOffice itself got
knocked out then that might explain the weird result.  Of course if it
was that then the newer laptop should just open the file with no
problem (hence why i tend to try several different approaches all at
the same time)

Regards from
Tom :)


On 13 January 2014 18:30, Tom Davies tomc...@gmail.com wrote:
 Hi :)
 Ok, so you have made a copy of the corrupted file.  The User Profile is here
 https://wiki.documentfoundation.org/UserProfile
 well, that's the guide that describes where it is on the various
 different systems.

 I tend to try a few different approaches all at about the same time
 when faced with this sort of thing.  We have all been there and lost
 data at some point or other.  It's easy to be wiser with hindsight,
 such as saving back-ups on different machines but before hindsight we
 mnight not have thought about it!!

 It might be worth trying to remember if the file is saved anywhere
 else.  Has the file been worked on anywhere else?  Are there any other
 machines that might have a fairly recent version, perhaps the newer
 laptop got used sometime?  Did the file get emailed, or saved onto
 usb-stick?  Cd/Dvd back-ups?  Do you have a network, might it be on
 there?  Is there an older version of the same file in the same folder
 or archived somewhere?

 If your husband can manage to start again he will find that it is FAR
 quicker to re-do.  He might even find that the entire month's work can
 be done fairly easily in just a couple of days.  In the process of
 writing it originally he might have done research or thought carefully
 about different options and tried different things out, perhaps
 read-up on how to do certain things and then maybe not even gone that
 way in the end.  All of that is swept aside on the 2nd time making it
 much easier and faster to re-do something.

 Regards from
 Tom :)


 On 13 January 2014 17:00, melodyfire cowens33...@gmail.com wrote:
 My husband has been working on a spreadsheet for over a month when last night
 our laptop was unplugged. The battery is busted and the only way to keep the
 laptop on is to have it plugged in. When he booted the laptop back up he was
 prompted to recover the file and the recovery failed.He is them prompted to
 choose an ACSII Filter option. When he chooses the option he gets a window
 that says Document file 'name%20name.ods' is locked for editing by Unknown
 User Open document read-only or open a copy of document for editing.

 Each option opens a word document with this for 3 pages:

 ice.Office.UI.WindowState:WindowStateType['private:resource/toolbar/drawbar']prop
 oor:name=SoftClose oor:op=fusevaluefalse/value/prop/itemitem
 oor:path=/org.openoffice.Office.UI.ChartWindowState/UIElements/States/org.openoffice.Office.UI.WindowState:WindowStateType['private:resource/toolbar/drawbar']prop
 oor:name=Style oor:op=fusevalue0/value/prop/itemitem

 The file had been saved many times before, is there a way I can either save
 this file or open a past save? This is an ancient laptop (MacOS 10.4.11) so
 alot of downloads wont work for it. If I can email the file to an up to date
 laptop then I could save it. Can anyone help me? My husband is really upset
 about losing this file and is already battling depression and this does not
 need to be another thing on his list to be upset about.

 Thanks for everyone help!



 --
 View this message in context: 
 http://nabble.documentfoundation.org/Corrupt-File-Help-tp4092029.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


-- 
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] Quick start without tray icon?

2014-01-13 Thread minhsien0330
Dear Mirosław Zalewski:
I found an other convenient way to preload Libreoffice without tray icon,
just put the following command line in ~/.xinitrc:
soffice  --nodefault --nologo 

Then, Libreoffice will be preloaded without tray icon in the background
after I get into X.

Thanks for your idea~

Best Regards,
Minhsien0330



2014/1/14 minhsien0330 minhsien0...@gmail.com

 Dear Mirosław Zalewski:
 Your solution is really a  very good idea!!!
 Thank you!!!

 Best Regards,
 Minhsien0330


 2014/1/14 Mirosław Zalewski mini...@poczta.onet.pl

 Dnia 2014-01-13, o godz. 16:33:32
 minhsien0330 minhsien0...@gmail.com napisał(a):

  Dear all:
  When we checked the option Enable systray Quickstarter, we preload
  libreoffice and have a Libreoffice logo icon on system tray.
  But there are too many icons on my tray, can I preload Libreoffce
  without tray icon?

 Since you have revealed in other message that you are using Linux:
 grab script below, save it, add executable flag (chmod +x scrip.sh) and
 make it run at start of your desktop environment of choice.

 Script:
 --START--
 #!/bin/bash

 if ps -C soffice.bin /dev/null 21; then
 exit
 fi

 sleep 90
 soffice --nodefault --nologo 
 PID=$!
 echo $PID  /tmp/lo-quickstarter
 sleep 10
 kill $PID
 END--

 How it works:
 It takes advantage of Linux smart memory management. When you run
 application, Linux loads it into memory (RAM). It stays there then,
 just in case you decide to run it later on. But it is marked as
 cache, so if you want to open another application, and running low on
 memory, Linux will delete marked data from RAM to make up space for
 this new application.
 In high level steps: this script fires up LibreOffice in non-graphical
 mode (so all libraries etc. are loaded into RAM), wait few seconds and
 then kills process. LibreOffice will be in memory from now on. When you
 start it again, you will perceive that process as much faster.


 What it does, step by step:
 1. Check whether libreoffice is running. If it is, just finish. We
 don't want to break anything.
 2. Wait 90 seconds. Starting graphical interface usually means starting
 a bunch of services and many disk reads. Since LibreOffice is low
 priority (we want our desktop responsive as fast as possible), we
 somehow queue it on the end of boot process.
 3. Run LibreOffice in non-graphical mode - hide splash screen and UI.
 4. Save LibreOffice PID (Process ID - a number that uniquely identifies
 each application running on system) for later use.
 5. Wait 10 seconds for LibreOffice to finish starting. We don't want to
 interrupt it on start, as something bad might happen (although
 shouldn't).
 6. Stop LibreOffice, identified by PID earlier. This way we make sure
 that we don't stop another application by mistake.

 One drawback that I have noticed - if you force stop LibreOffice with
 documents opened, it will ask you what to do with these documents on
 next start. And this next start sometimes happen to be that script
 running. This might lead to unwanted windows popping up shortly after
 machine boot.

 I am using that script since some time and I am enjoying LibreOffice
 perceived boot in 4-5 seconds on my dated machine.
 --
 Best regards
 Mirosław Zalewski




-- 
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] Corrupt File! Help!!!

2014-01-13 Thread Zeki Bildirici
13 Oca 2014 19:17 tarihinde melodyfire cowens33...@gmail.com yazdı:
Hi,
File corruption may occur in all platforms due to similar reasons.

Dont be upset. Thanks to odf format the file can be examined. Probably some
xml errors in styles.xml.

If you have Ubuntu, install Emacs. It comes with great xml tools to mark
the errors.

I can help you too but i will be available only after Wednesday.  Other
friends will help soon i hope.

Best regards,
Zeki

-- 
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