[libreoffice-users] Re: unopkg error

2011-08-11 Thread Alexander Thurgood
Le 10/08/11 09:22, Lars Callenbach a écrit :

Hello Lars,


 
 I have compiled an addin which works find under openoffice 3.2. Using either 
 libreoffice 3.3 or 3.4 the following error message appears:
 
 ERROR: Fehler beim Hinzuf�gen von: 
 vnd.sun.star.expand:$UNO_USER_PACKAGES_CACHE/uno_packages/luecz64g.tmp_/CalcAddins.oxt
Cause: Media-Typ konnte nicht ermittelt werden: 
 file:///root/.libreoffice/3/user/uno_packages/cache/uno_packages/luecz64g.tmp_/CalcAddins.oxt
 
 unopkg failed.
 

Did you also try and install it on OOo 3.3 or OOo 3.4 beta ? The package
framework for extensions changed during OOo 3.3.x development and this
may be the reason why your extension is failing to install.


Alex


-- 
For unsubscribe instructions e-mail to: users+h...@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] How to use the command /msoreg=1 ?

2011-08-11 Thread Johnny Rosenberg
2011/8/11 sobriquet c.sobriq...@gmail.com:
 My computer does not have Microsoft office installed; rather the minute
 Starter office is in place.
 I followed the instructions in the System Requirements and
 downloaded--mmsvc90.dll. My computer is running Win7, so I went to
 Programs--Accessories-- Command Prompt, where the screen shows
 C:\users\name_
 I type the command /msoreg=1 at the prompt, and it refuses to acknowledge
 it.
 What went wrong?
 Tks,
 Sobriquet

And exactly where comes LibreOffice into the picture?


Regards

Johnny Rosenberg
ジョニー・ローゼンバーグ

-- 
For unsubscribe instructions e-mail to: users+h...@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] Macro not active when the document start

2011-08-11 Thread Johnny Rosenberg
2011/8/10 Cor Nouws oo...@nouenoff.nl:

 toto wrote (10-08-11 09:23)

 I'm using macro's function and it doesn't start when the document start.

 You can change that via Tools  Customize  Events.
 Find the OnOpen event and link it to the macro for the document.

I think the function is supposed to be used as a cell function. Then
the event thing is not needed.




Regards

Johnny Rosenberg
ジョニー・ローゼンバーグ


 Regards,


 --
  - Cor
  - http://nl.libreoffice.org


 --
 For unsubscribe instructions e-mail to: users+h...@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



-- 
For unsubscribe instructions e-mail to: users+h...@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] Macro not active when the document start

2011-08-11 Thread Johnny Rosenberg
2011/8/10 toto t...@nurulfikri.com:
 I'm using macro's function and it doesn't start when the document start. It
 would start if I change the value of the variabel at the function. The code
 is to change numeric value to string. If I execute the code: ubah(123) the
 result is seratus dua puluh tiga. Any idea how to make the function
 executed when I open the document?

The macro is used as a cell function right?
In that case, where did you put the macro? It should be placed in My
Macros, I think, so you need to move it there if it's not there
already.



Regards

Johnny Rosenberg
ジョニー・ローゼンバーグ


 The code is:

 Public Function ubah(x as currency) as String
    Dim triliun As Currency
    Dim milyar As Currency
    Dim juta As Currency
    Dim ribu As Currency
    Dim satu As Currency
    Dim sen As Currency
    Dim baca As String
    If x  1 Then
       gusti =  Modul belum tersedia saat ini 
       Exit Function
    End If
    'Jika x adalah 0, maka dibaca sebagai 0
    If x = 0 Then
       baca = angka(0, 1)
    Else
       'Pisah masing-masing bagian untuk triliun, milyar, juta, ribu, rupiah,
 dan sen
       triliun = Int(x / 1000 ^ 4)
       milyar = Int((x - triliun * 1000 ^ 4) / 1000 ^ 3)
       juta = Int((x - triliun * 1000 ^ 4 - milyar * 1000 ^ 3) / 1000 ^ 2)
       ribu = Int((x - triliun * 1000 ^ 4 - milyar * 1000 ^ 3 - juta * 1000 ^
 2) / 1000)
       satu = Int(x - triliun * 1000 ^ 4 - milyar * 1000 ^ 3 - juta * 1000 ^
 2 - ribu * 1000)
       sen = Int((x - Int(x)) * 100)
       'Baca bagian triliun dan ditambah akhiran triliun
       If triliun  0 Then
          baca = ratus(triliun, 5) + triliun 
       End If
       'Baca bagian milyar dan ditambah akhiran milyar
       If milyar  0 Then
          baca = ratus(milyar, 4) + milyar 
       End If
       'Baca bagian juta dan ditambah akhiran juta
       If juta  0 Then
          baca = baca + ratus(juta, 3) + juta 
       End If
       'Baca bagian ribu dan ditambah akhiran ribu
       If ribu  0 Then
          baca = baca + ratus(ribu, 2) + ribu 
       End If
       'Baca bagian rupiah dan ditambah akhiran rupiah
       If satu  0 Then
          baca = baca + ratus(satu, 1)
       End If
       'Baca bagian sen dan ditambah akhiran sen
       If sen  0 Then
          baca = baca + ratus(sen, 0)
       End If
    End If
    ubah = UCase(Left(baca, 1))  LCase(Mid(baca, 2))
 End Function

 Function ratus(x As Currency, Posisi As Integer) As String
    Dim a100 As Integer, a10 As Integer, a1 As Integer
    Dim baca As String
    a100 = Int(x * 0.01)
    a10 = Int((x - a100 * 100) * 0.1)
    a1 = Int(x - a100 * 100 - a10 * 10)
    'Baca Bagian Ratus
    If a100 = 1 Then
       baca = Seratus 
    Else
       If a100  0 Then
          baca = angka(a100, Posisi) + ratus 
       End If
    End If
    'Baca Bagian Puluh dan Satuan
    If a10 = 1 Then
       baca = baca + angka(a10 * 10 + a1, Posisi)
    Else
       If a10  0 Then
          baca = baca + angka(a10, Posisi) + puluh 
       End If
       If a1  0 Then
          baca = baca + angka(a1, Posisi)
       End If
    End If
    ratus = baca
 End Function

 Function angka(x As Integer, Posisi As Integer)
    Select Case x
        Case 0: angka = Nol
        Case 1:
            If Posisi = 1 Or Posisi  2 Then
               angka = Satu 
            Else
               angka = Satu 
            End If
        Case 2: angka = Dua 
        Case 3: angka = Tiga 
        Case 4: angka = Empat 
        Case 5: angka = Lima 
        Case 6: angka = Enam 
        Case 7: angka = Tujuh 
        Case 8: angka = Delapan 
        Case 9: angka = Sembilan 
        Case 10: angka = Sepuluh 
        Case 11: angka = Sebelas 
        Case 12: angka = Duabelas 
        Case 13: angka = Tigabelas 
        Case 14: angka = Empatbelas 
        Case 15: angka = Limabelas 
        Case 16: angka = Enambelas 
        Case 17: angka = Tujuhbelas 
        Case 18: angka = Delapanbelas 
        Case 19: angka = Sembilanbelas 
    End Select
 End Function




 --
 For unsubscribe instructions e-mail to: users+h...@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



-- 
For unsubscribe instructions e-mail to: users+h...@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] unopkg error

2011-08-11 Thread Lars Callenbach
Hi Jay,

I have modified the QuantLib addin code so that it runs under Linux and Windows 
XP (using Openoffice 3.2.1). Under Libreoffice the code compiles and the oxt 
file will be created but loading of the addin (using the oxt file) fails with 
an error message under Linux. 

Was there any change in the api of Libreoffice? What do I have to change/add to 
get a working addin? Is there any documentation or are there any C++ addin 
examples that can be used? The examples in the SDK (code examples under 
$SDK/examples/cpp) are not helpful. It seems that there have been no changes. 
So I expect that the code for the Quantlib addin need not be modified. Any 
ideas?

Regards,
   Lars

Lars,

On Wed, 2011-08-10 at 09:22 +0200, Lars Callenbach wrote:

 Hello,

 I have compiled an addin which works find under openoffice 3.2. Using either 
 libreoffice 3.3 or 3.4 the following error message appears:
 
 ERROR: Fehler beim Hinzuf�gen von: 
 vnd.sun.star.expand:$UNO_USER_PACKAGES_CACHE/uno_packages/luecz64g.tmp_/CalcAddins.oxt
 Cause: Media-Typ konnte nicht ermittelt werden: 
 file:///root/.libreoffice/3/user/uno_packages/cache/uno_packages/luecz64g.tmp_/CalcAddins.oxt

 unopkg failed.
 
 The directory CalcAddins.oxt has not been created and the oxt file has not 
 been unziped.

 What do I have to change to get a working addin using libreoffice?

 Regards,
 Lars
 --
 NEU: FreePhone - 0ct/min Handyspartarif mit Geld-zurück-Garantie!
 Jetzt informieren: http://www.gmx.net/de/go/freephone


I would check OOo to see if they have an updated version and check
http://libreplanet.org/wiki/Group:OpenOfficeExtensions/List and
http://wiki.documentfoundation.org/Downloads/Templates . Plugins, unless
they are official ones, may lag the release somewhat some if they need
significant changes they may not work with the latest version.

-- 
Jay Lozier
jsloz...@gmail.com


-- 
Empfehlen Sie GMX DSL Ihren Freunden und Bekannten und wir
belohnen Sie mit bis zu 50,- Euro! https://freundschaftswerbung.gmx.de

-- 
For unsubscribe instructions e-mail to: users+h...@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: Macro not active when the document start

2011-08-11 Thread Andreas Säger

Am 11.08.2011 10:30, Johnny Rosenberg wrote:

The macro is used as a cell function right?
In that case, where did you put the macro? It should be placed in My
Macros, I think, so you need to move it there if it's not there
already.




Wrong. It has to be stored in library Standard, either the document's 
one or the global one. Standard is loaded automatically and a cell 
function will be found immediately.
The functions do not contain any references to UNO objects so they 
*should* work right from the start and they *should* update 
automatically if menu:ToolsCellContentsAutomatic Calculation is 
enabled and if (and only if) a referenced value has been modified.

Otherwise recalculation should be triggered on key F9.
Ctrl+shift+F9 enforces a complete recalculation of the whole workbook.


--
For unsubscribe instructions e-mail to: users+h...@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] New Custom Style in Writer - odd behavior

2011-08-11 Thread Tom Davies






From: john d. herron paradox.her...@bluewin.ch
To: users@global.libreoffice.org
Sent: Thu, 11 August, 2011 4:12:48
Subject: [libreoffice-users] New Custom Style in Writer - odd behavior


Aug 07, 2011; 8:42pm - john herron wrote:

I created a style (Default_2, next style also Default_2) which I based on the 
standard Default style.
The only difference between the two is that Default has single line spacing 
whereas for Default_2 calls for double spacing.
When I assign Default_2 to a paragraph from Styles and Formatting, it properly 
displays double-spaced.
But when I then finish editing the paragraph with Return (or Enter, if you 
prefer that), the paragraph reverts to single space.
The same also occurs with an indenting style (Def_2_Ind_1) derived from 
Default_2.

Am I doing something wrong or could this be a bug?

TIA
john



Aug 08 Simon Cropper (The foss Workflow Guides) Aug 08, 2011; 12:49am replied:


Try not using the underscore. So rename Default_2 to Default2 or
DefaultDouble and see what happens.

-- Cheers Simon

Simon Cropper
Website Administrator
http://www.fossworkflowguides.com

-

Hello, Simon Cropper.
I tried following your suggestion to not use _ as a style name separator 
(i.e. 
renamed the style Default2) but to no avail.
Closing the double-spaced Default2 paragraph with Return/Enter still causes the 
paragraph to revert to single-spaced.

Why do I suspect that this behavior might be a bug?
Because in OOo's 3.2 Writer, which I also use, the problem does not occur.

What now?

john


Hi :)
The guide for posting a bug-report
http://wiki.documentfoundation.org/BugReport
can give soem useful advice but if you can't find out all the info it asks for 
don't worry, just post anyway.  You can always add info later.
Regards from
Tom :)

-- 
For unsubscribe instructions e-mail to: users+h...@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] Date Format in Writer

2011-08-11 Thread rjweir
To avoid confusion between the mm.dd. and the dd.mm. date formats can 
we have the less ambiguous International .mm.dd format included as an 
option (default?) in the fields for Writer?

-- 
For unsubscribe instructions e-mail to: users+h...@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] unopkg error

2011-08-11 Thread Tom Davies
Hi :)
Is the QuantLib addin/add-on/plug-in/extension released under a copy-left 
License such as GPL, LGPL, MPL or something like that?  Are you happy to 
release 
your updated one under a copy-left so that anyone can modify and redistribute 
the code in an OpenSource way?

If so then it might be a good idea to join the devs list and/or post a 
bug-report about the add-on to see if you get any helpful suggestions from 
other 
devs.
http://wiki.documentfoundation.org/BugReport

Good luck and many regards from
Tom :)





From: Lars Callenbach lars.callenb...@gmx.de
To: users@global.libreoffice.org
Sent: Thu, 11 August, 2011 9:23:53
Subject: Re: [libreoffice-users] unopkg error

Hi Jay,

I have modified the QuantLib addin code so that it runs under Linux and Windows 
XP (using OpenOffice 3.2.1). Under LibreOffice the code compiles and the oxt 
file will be created but loading of the addin (using the oxt file) fails with 
an 
error message under Linux. 


Was there any change in the api of LibreOffice? What do I have to change/add to 
get a working addin? Is there any documentation or are there any C++ addin 
examples that can be used? The examples in the SDK (code examples under 
$SDK/examples/cpp) are not helpful. It seems that there have been no changes. 
So 
I expect that the code for the Quantlib addin need not be modified. Any ideas?

Regards,
   Lars

Lars,

On Wed, 2011-08-10 at 09:22 +0200, Lars Callenbach wrote:

 Hello,

 I have compiled an addin which works find under OpenOffice 3.2. Using either 
LibreOffice 3.3 or 3.4 the following error message appears:
 
 ERROR: Fehler beim Hinzuf�gen von: 
vnd.sun.star.expand:$UNO_USER_PACKAGES_CACHE/uno_packages/luecz64g.tmp_/CalcAddins.oxt

 Cause: Media-Typ konnte nicht ermittelt werden: 
file:///root/.libreoffice/3/user/uno_packages/cache/uno_packages/luecz64g.tmp_/CalcAddins.oxt


 unopkg failed.
 
 The directory CalcAddins.oxt has not been created and the oxt file has not 
 been 
unziped.

 What do I have to change to get a working addin using LibreOffice?

 Regards,
 Lars
 --
 NEU: FreePhone - 0ct/min Handyspartarif mit Geld-zurück-Garantie!
 Jetzt informieren: http://www.gmx.net/de/go/freephone


I would check OOo to see if they have an updated version and check
http://libreplanet.org/wiki/Group:OpenOfficeExtensions/List and
http://wiki.documentfoundation.org/Downloads/Templates . Plugins, unless
they are official ones, may lag the release somewhat some if they need
significant changes they may not work with the latest version.

-- 
Jay Lozier
jsloz...@gmail.com


-- 
Empfehlen Sie GMX DSL Ihren Freunden und Bekannten und wir
belohnen Sie mit bis zu 50,- Euro! https://freundschaftswerbung.gmx.de

-- 
For unsubscribe instructions e-mail to: users+h...@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

-- 
For unsubscribe instructions e-mail to: users+h...@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] Date Format in Writer

2011-08-11 Thread Tom Davies
Hi :)
Good plan.  It sounds like an Easy Hack and posting bug-reports like that can 
help people learn how to write code for LibreOffice.  So, please post a 
bug-report
http://wiki.documentfoundation.org/BugReport
Good luck and regards from
Tom :)





From: rjw...@phonecoop.coop rjw...@phonecoop.coop
To: users@global.libreoffice.org
Sent: Thu, 11 August, 2011 10:11:57
Subject: [libreoffice-users] Date Format in Writer

To avoid confusion between the mm.dd. and the dd.mm. date formats can 
we 
have the less ambiguous International .mm.dd format included as an option 
(default?) in the fields for Writer?

-- 
For unsubscribe instructions e-mail to: users+h...@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
-- 
For unsubscribe instructions e-mail to: users+h...@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] How to use the command /msoreg=1 ?

2011-08-11 Thread Tom Davies
Hi :)
I think you don't need the / at the start of a command like that.  Try
msoreg=1

However, i have no idea what that command does or what it is supposed to do so 
please double check what the command is supposed to do and don't just blindly 
accept some random unofficial guide, blog or forum post, especially about 
Windows.  Even googling for the command might give some insight into what it 
really does.  


It would help if you could give us the link to the guide you are following.  We 
only really deal with LibreOffice here but some kind person might be willing to 
try to help.
Good luck and regards from
Tom :)





From: Johnny Rosenberg gurus.knu...@gmail.com
To: users@global.libreoffice.org
Sent: Thu, 11 August, 2011 9:23:44
Subject: Re: [libreoffice-users] How to use the command /msoreg=1 ?

2011/8/11 sobriquet c.sobriq...@gmail.com:
 My computer does not have Microsoft office installed; rather the minute
 Starter office is in place.
 I followed the instructions in the System Requirements and
 downloaded--mmsvc90.dll. My computer is running Win7, so I went to
 Programs--Accessories-- Command Prompt, where the screen shows
 C:\users\name_
 I type the command /msoreg=1 at the prompt, and it refuses to acknowledge
 it.
 What went wrong?
 Tks,
 Sobriquet

And exactly where comes LibreOffice into the picture?


Regards

Johnny Rosenberg
ジョニー・ローゼンバーグ

-- 
For unsubscribe instructions e-mail to: users+h...@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

-- 
For unsubscribe instructions e-mail to: users+h...@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: unopkg error

2011-08-11 Thread Alexander Thurgood
Le 11/08/11 10:23, Lars Callenbach a écrit :

Hi Lars,

 I have modified the QuantLib addin code so that it runs under Linux and 
 Windows XP (using Openoffice 3.2.1). Under Libreoffice the code compiles and 
 the oxt file will be created but loading of the addin (using the oxt file) 
 fails with an error message under Linux. 
 
 Was there any change in the api of Libreoffice? What do I have to change/add 
 to get a working addin? Is there any documentation or are there any C++ addin 
 examples that can be used? The examples in the SDK (code examples under 
 $SDK/examples/cpp) are not helpful. It seems that there have been no changes. 
 So I expect that the code for the Quantlib addin need not be modified. Any 
 ideas?
 

No, not in the LibreOffice API AFAIK, but the OOo extensions framework
was changed during 3.3.x development. You would need to look up the
archives of the OOo extensions/dev/api mailing lists to find out more
information.

Alex


-- 
For unsubscribe instructions e-mail to: users+h...@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: Macro not active when the document start

2011-08-11 Thread Johnny Rosenberg
2011/8/11 Andreas Säger ville...@t-online.de:
 Am 11.08.2011 10:30, Johnny Rosenberg wrote:

 The macro is used as a cell function right?
 In that case, where did you put the macro? It should be placed in My
 Macros, I think, so you need to move it there if it's not there
 already.



 Wrong. It has to be stored in library Standard, either the document's one
 or the global one. Standard is loaded automatically and a cell function
 will be found immediately.

Well, I have mine in My Macros/Standard but maybe that's not necessary.

At the moment I have one cell function there and it works perfectly,
but when I add another one, LibreOffice refuse to recognise it. What
ever I do, the cell only displays ”#NAME?” no matter if I have it in
the document's Standard library or in My Macros/Standard.

Can someone give a step-by-step instruction how to create a simple
cell function? Do I need to restart LibreOffice (did that too, but it
didn't help)?
I know I didn't create the thread, but still…


Kind regards

Johnny Rosenberg
ジョニー・ローゼンバーグ


 The functions do not contain any references to UNO objects so they *should*
 work right from the start and they *should* update automatically if
 menu:ToolsCellContentsAutomatic Calculation is enabled and if (and only
 if) a referenced value has been modified.
 Otherwise recalculation should be triggered on key F9.
 Ctrl+shift+F9 enforces a complete recalculation of the whole workbook.


 --
 For unsubscribe instructions e-mail to: users+h...@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


-- 
For unsubscribe instructions e-mail to: users+h...@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: Macro not active when the document start

2011-08-11 Thread Johnny Rosenberg
2011/8/11 Johnny Rosenberg gurus.knu...@gmail.com:
 2011/8/11 Andreas Säger ville...@t-online.de:
 Am 11.08.2011 10:30, Johnny Rosenberg wrote:

 The macro is used as a cell function right?
 In that case, where did you put the macro? It should be placed in My
 Macros, I think, so you need to move it there if it's not there
 already.



 Wrong. It has to be stored in library Standard, either the document's one
 or the global one. Standard is loaded automatically and a cell function
 will be found immediately.

 Well, I have mine in My Macros/Standard but maybe that's not necessary.

 At the moment I have one cell function there and it works perfectly,
 but when I add another one, LibreOffice refuse to recognise it. What
 ever I do, the cell only displays ”#NAME?” no matter if I have it in
 the document's Standard library or in My Macros/Standard.

 Can someone give a step-by-step instruction how to create a simple
 cell function? Do I need to restart LibreOffice (did that too, but it
 didn't help)?
 I know I didn't create the thread, but still…

Strange… I fiddled with it a bit and suddenly it works, I don't have a clue why…

It also seems like it looks in the document's Standard library first,
because if I had them at both places the local one was executed.

I made a very simple one, this is the one in the document's standard library:
Function DoStuff As Long
DoStuff=3
End Function

Here's the one in My Macros/Standard:
Function DoStuff As Long
DoStuff=4
End Function


In a cell:
=DOSTUFF

The result was 3. When I removed the local one, the result was 4 after
a Ctrl+Shift+F9.

But still I don't have a clue why it works now and not a few minutes ago…


Regards

Johnny Rosenberg
ジョニー・ローゼンバーグ

-- 
For unsubscribe instructions e-mail to: users+h...@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] How to use the command /msoreg=1 ?

2011-08-11 Thread Tom Davies
Hi :)
Ahah, i have just found these links
http://www.libreoffice.org/get-help/system-requirements/
I'm guessing that's the guide you used?  It's definitely official and 
definitely 
for LibreOffice but it doesn't give a lot of detail.

Jonny, it is to register all the various office formats that would 'normally' 
be 
opened by MS Office to be opened by LibreOffice instead.  


Normally when people install LibreOffice the final screen (the one with the 
Finish button rather than Next or Forwards) has a tick-box to make 
LibreOffice the default Office Suite.  Generally i avoid that at first to allow 
people to continue using MS Office by default and just get used to LibreOffice 
at their own pace.  


Sobriquet an easier way to achieve the same result might be to try reinstalling 
LibreOffice but choose the Repair option instead of the full re-install.  
Hopefully the last screen will show those tick-boxes again.  


These links might provide more help with the route you are taking

http://www.libreoffice.org/get-help/installation/windows/
and other official documentation is here
http://www.libreoffice.org/get-help/documentation/

http://user.services.openoffice.org/en/forum/viewtopic.php?f=74t=12918
It's an old guide and for OpenOffice.org but most things like that still work 
for LibreOffice because both Suites are very similar and we work together quite 
a bit sometimes.  The LibreOffice code is smaller, cleaner and faster and has 
quite a lot of extra functionality and it's developing faster but still most of 
the basics are the same for both.  Also although there is not a special section 
for Win7 the Vista and Xp guidance might help.  


This un-offical blog might help understand (i haven't read it yet so i don't 
know how good it is)
http://minimumsystemrequirements.net/libreoffice.html
If you do have to get java try to get their _20, _21 or _22 version, preferably 
the _21.  The newer _24  _26 re great for web-browsers but really slow 
LibreOffice down quite badly.  Hopefully you don't need java for Writer, Calc 
or 
anything except perhaps Base so you can leave Java until later.  


Somewhat insanely this guide might help!
http://wikis.sun.com/display/StarOffice/StarOffice+9+Readme+for+Windows
LibreOffice was developed from OpenOffice and we keep fairly close ties with 
them now that they are run by Apache.  OpenOffice developed from StarOffice but 
that was about a decade ago.  There are not many (a few but not many) that 
worked in StarOffice.  The crazy thing is that Oracle were fairly bad at 
supporting or doing anything for OpenOffice during their brief ownership of it. 
 
They just seemed to try to kill it (imo).  However, that link might be 
helpful??!!

This guide was written a year or so before Oracle took ownership of OpenOffice.
http://specs.openoffice.org/installation/filetyperegistration/foreign_file_type_registration.odt

Sun were good at building up the community and keeping the product stable.  
They 
owned it for about a decade and were the ones that gave it the name 
OpenOffice.org rather than keeping it as StarOffice.  The guide might try to 
download the Odt document onto your machine.  I don't normally like links that 
do that.  Many apols for that.  It's very dry stuff and difficult to read.  
It's 
not really aimed at normal users so it might not be helpful.  


Hmm, this guide also looks like it might try to download itself, it's also very 
dry and also unlikely to really give quick easy answers.  

http://www.scribd.com/doc/53230646/readme-en-US
Perhaps good for the detail tho, maybe.  

Hopefully someone else on this list might be able to give a quicker, easier 
answer.
Good luck and regards from
Tom :)





From: Johnny Rosenberg gurus.knu...@gmail.com
To: users@global.libreoffice.org
Sent: Thu, 11 August, 2011 9:23:44
Subject: Re: [libreoffice-users] How to use the command /msoreg=1 ?

2011/8/11 sobriquet c.sobriq...@gmail.com:
 My computer does not have Microsoft office installed; rather the minute
 Starter office is in place.
 I followed the instructions in the System Requirements and
 downloaded--mmsvc90.dll. My computer is running Win7, so I went to
 Programs--Accessories-- Command Prompt, where the screen shows
 C:\users\name_
 I type the command /msoreg=1 at the prompt, and it refuses to acknowledge
 it.
 What went wrong?
 Tks,
 Sobriquet

And exactly where comes LibreOffice into the picture?


Regards

Johnny Rosenberg
ジョニー・ローゼンバーグ

-- 
For unsubscribe instructions e-mail to: users+h...@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

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? 

Re: [libreoffice-users] How to use the command /msoreg=1 ?

2011-08-11 Thread Johnny Rosenberg
2011/8/11 Tom Davies tomdavie...@yahoo.co.uk:
 Hi :)
 I think you don't need the / at the start of a command like that.  Try
 msoreg=1

 However, i have no idea what that command does or what it is supposed to do so
 please double check what the command is supposed to do and don't just blindly
 accept some random unofficial guide, blog or forum post, especially about
 Windows.  Even googling for the command might give some insight into what it
 really does.


 It would help if you could give us the link to the guide you are following.  
 We
 only really deal with LibreOffice here but some kind person might be willing 
 to
 try to help.
 Good luck and regards from
 Tom :)

I did some searching and found that this actually IS about
OpenOffice.org/LibreOffice… :P
 It seems like if you install from the command line, you can add
/msoreg=1 or /msoreg=0 to the installation command or something like
that.


Kind regards

Johnny Rosenberg
ジョニー・ローゼンバーグ

-- 
For unsubscribe instructions e-mail to: users+h...@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] How to use the command /msoreg=1 ?

2011-08-11 Thread Johnny Rosenberg
2011/8/11 Tom Davies tomdavie...@yahoo.co.uk:
 Hi :)
 Ahah, i have just found these links
 http://www.libreoffice.org/get-help/system-requirements/
 I'm guessing that's the guide you used?  It's definitely official and 
 definitely
 for LibreOffice but it doesn't give a lot of detail.

 Jonny, it is to register all the various office formats that would 'normally' 
 be
 opened by MS Office to be opened by LibreOffice instead.

Yes, I just found out… But he operator could have been more detailed,
couldn't he…? :D
Well, it's all sorted out now anyway, isn't it?



Kind regards

Johnny Rosenberg
ジョニー・ローゼンバーグ



 Normally when people install LibreOffice the final screen (the one with the
 Finish button rather than Next or Forwards) has a tick-box to make
 LibreOffice the default Office Suite.  Generally i avoid that at first to 
 allow
 people to continue using MS Office by default and just get used to LibreOffice
 at their own pace.


 Sobriquet an easier way to achieve the same result might be to try 
 reinstalling
 LibreOffice but choose the Repair option instead of the full re-install.
 Hopefully the last screen will show those tick-boxes again.


 These links might provide more help with the route you are taking

 http://www.libreoffice.org/get-help/installation/windows/
 and other official documentation is here
 http://www.libreoffice.org/get-help/documentation/

 http://user.services.openoffice.org/en/forum/viewtopic.php?f=74t=12918
 It's an old guide and for OpenOffice.org but most things like that still work
 for LibreOffice because both Suites are very similar and we work together 
 quite
 a bit sometimes.  The LibreOffice code is smaller, cleaner and faster and has
 quite a lot of extra functionality and it's developing faster but still most 
 of
 the basics are the same for both.  Also although there is not a special 
 section
 for Win7 the Vista and Xp guidance might help.


 This un-offical blog might help understand (i haven't read it yet so i don't
 know how good it is)
 http://minimumsystemrequirements.net/libreoffice.html
 If you do have to get java try to get their _20, _21 or _22 version, 
 preferably
 the _21.  The newer _24  _26 re great for web-browsers but really slow
 LibreOffice down quite badly.  Hopefully you don't need java for Writer, Calc 
 or
 anything except perhaps Base so you can leave Java until later.


 Somewhat insanely this guide might help!
 http://wikis.sun.com/display/StarOffice/StarOffice+9+Readme+for+Windows
 LibreOffice was developed from OpenOffice and we keep fairly close ties with
 them now that they are run by Apache.  OpenOffice developed from StarOffice 
 but
 that was about a decade ago.  There are not many (a few but not many) that
 worked in StarOffice.  The crazy thing is that Oracle were fairly bad at
 supporting or doing anything for OpenOffice during their brief ownership of 
 it.
 They just seemed to try to kill it (imo).  However, that link might be
 helpful??!!

 This guide was written a year or so before Oracle took ownership of 
 OpenOffice.
 http://specs.openoffice.org/installation/filetyperegistration/foreign_file_type_registration.odt

 Sun were good at building up the community and keeping the product stable.  
 They
 owned it for about a decade and were the ones that gave it the name
 OpenOffice.org rather than keeping it as StarOffice.  The guide might try to
 download the Odt document onto your machine.  I don't normally like links that
 do that.  Many apols for that.  It's very dry stuff and difficult to read.  
 It's
 not really aimed at normal users so it might not be helpful.


 Hmm, this guide also looks like it might try to download itself, it's also 
 very
 dry and also unlikely to really give quick easy answers.

 http://www.scribd.com/doc/53230646/readme-en-US
 Perhaps good for the detail tho, maybe.

 Hopefully someone else on this list might be able to give a quicker, easier
 answer.
 Good luck and regards from
 Tom :)




 
 From: Johnny Rosenberg gurus.knu...@gmail.com
 To: users@global.libreoffice.org
 Sent: Thu, 11 August, 2011 9:23:44
 Subject: Re: [libreoffice-users] How to use the command /msoreg=1 ?

 2011/8/11 sobriquet c.sobriq...@gmail.com:
 My computer does not have Microsoft office installed; rather the minute
 Starter office is in place.
 I followed the instructions in the System Requirements and
 downloaded--mmsvc90.dll. My computer is running Win7, so I went to
 Programs--Accessories-- Command Prompt, where the screen shows
 C:\users\name_
 I type the command /msoreg=1 at the prompt, and it refuses to acknowledge
 it.
 What went wrong?
 Tks,
 Sobriquet

 And exactly where comes LibreOffice into the picture?


 Regards

 Johnny Rosenberg
 ジョニー・ローゼンバーグ

 --
 For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
 Problems? 
 http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
 Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette

Re: [libreoffice-users] How to use the command /msoreg=1 ?

2011-08-11 Thread Tom Davies
Hi :)
Lol, yup.  I think we both found the same thing at the same time!  I am not 
sure 
about missing the / now.  All the guides i have seen do include it.  So maybe 
the issue is about which folder you are in when you run the command.  I might 
test it out from work later.  If i can get onto a suitable Windows machine.  
Lol, this is going to be fun.
Regards from
Tom :)





From: Johnny Rosenberg gurus.knu...@gmail.com
To: users@global.libreoffice.org
Sent: Thu, 11 August, 2011 11:13:24
Subject: Re: [libreoffice-users] How to use the command /msoreg=1 ?

2011/8/11 Tom Davies tomdavie...@yahoo.co.uk:
 Hi :)
 I think you don't need the / at the start of a command like that.  Try
 msoreg=1

 However, i have no idea what that command does or what it is supposed to do so
 please double check what the command is supposed to do and don't just blindly
 accept some random unofficial guide, blog or forum post, especially about
 Windows.  Even googling for the command might give some insight into what it
 really does.


 It would help if you could give us the link to the guide you are following. 
 We
 only really deal with LibreOffice here but some kind person might be willing 
to
 try to help.
 Good luck and regards from
 Tom :)

I did some searching and found that this actually IS about
OpenOffice.org/LibreOffice… :P
It seems like if you install from the command line, you can add
/msoreg=1 or /msoreg=0 to the installation command or something like
that.


Kind regards

Johnny Rosenberg
ジョニー・ローゼンバーグ

-- 
For unsubscribe instructions e-mail to: users+h...@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

-- 
For unsubscribe instructions e-mail to: users+h...@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] Date Format in Writer

2011-08-11 Thread Johnny Rosenberg
2011/8/11  rjw...@phonecoop.coop:
 To avoid confusion between the mm.dd. and the dd.mm. date formats can 
 we have the less ambiguous
 International

It IS international, it's ISO 8601 (and also Swedish standard, lucky
me… ;P)! Except that there should be dashes, not dots: -mm-dd.


Kind regards

Johnny Rosenberg
ジョニー・ローゼンバーグ

 .mm.dd format included as an option (default?) in the fields for Writer?

 --
 For unsubscribe instructions e-mail to: users+h...@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



-- 
For unsubscribe instructions e-mail to: users+h...@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] Date Format in Writer

2011-08-11 Thread Tom Davies
Hi :)
Ahhah, great.  I prefer dashes - because after reading too much for too long my 
eyes get a bit muddled when people use / and dots still seem to confuse obscure 
Windows systems sometimes.  I was told that the / was the European Standard but 
if - are used in one other country then that helps me argue the case with my 
boss.  

Regards from
Tom :)





From: Johnny Rosenberg gurus.knu...@gmail.com
To: users@global.libreoffice.org
Sent: Thu, 11 August, 2011 11:18:39
Subject: Re: [libreoffice-users] Date Format in Writer

2011/8/11  rjw...@phonecoop.coop:
 To avoid confusion between the mm.dd. and the dd.mm. date formats can 
we have the less ambiguous
 International

It IS international, it's ISO 8601 (and also Swedish standard, lucky
me… ;P)! Except that there should be dashes, not dots: -mm-dd.


Kind regards

Johnny Rosenberg
ジョニー・ローゼンバーグ

 .mm.dd format included as an option (default?) in the fields for Writer?

 --
 For unsubscribe instructions e-mail to: users+h...@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



-- 
For unsubscribe instructions e-mail to: users+h...@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

-- 
For unsubscribe instructions e-mail to: users+h...@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] How to use the command /msoreg=1 ?

2011-08-11 Thread Johnny Rosenberg
2011/8/11 Tom Davies tomdavie...@yahoo.co.uk:
 Hi :)
 Lol, yup.  I think we both found the same thing at the same time!  I am not 
 sure
 about missing the / now.  All the guides i have seen do include it.  So maybe
 the issue is about which folder you are in when you run the command.  I might
 test it out from work later.  If i can get onto a suitable Windows machine.
 Lol, this is going to be fun.
 Regards from
 Tom :)

I used Windows about 200 years ago, and as far as I remember, in the
Windows command line, you use a ”/” instead of a ”-” for options, like
”dir /p /o /w” rather than ”dir -pow” which would be the Unix-style
syntax.


Kind regards

Johnny Rosenberg
ジョニー・ローゼンバーグ

-- 
For unsubscribe instructions e-mail to: users+h...@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] How to use the command /msoreg=1 ?

2011-08-11 Thread Johnny Rosenberg
2011/8/11 Johnny Rosenberg gurus.knu...@gmail.com:
 2011/8/11 Tom Davies tomdavie...@yahoo.co.uk:
 Hi :)
 Lol, yup.  I think we both found the same thing at the same time!  I am not 
 sure
 about missing the / now.  All the guides i have seen do include it.  So maybe
 the issue is about which folder you are in when you run the command.  I might
 test it out from work later.  If i can get onto a suitable Windows machine.
 Lol, this is going to be fun.
 Regards from
 Tom :)

 I used Windows about 200 years ago, and as far as I remember, in the
 Windows command line, you use a ”/” instead of a ”-” for options, like
 ”dir /p /o /w” rather than ”dir -pow” which would be the Unix-style
 syntax.

Actually, what I', trying to say here, is that in this case, the
command should look something like this:

some_command /msoreg=1
Maybe
install /msoreg=1

Well, something like that anyway.
Just a guess, though.


Kind regards

Johnny Rosenberg
ジョニー・ローゼンバーグ

-- 
For unsubscribe instructions e-mail to: users+h...@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] Date Format in Writer

2011-08-11 Thread Johnny Rosenberg
2011/8/11 Tom Davies tomdavie...@yahoo.co.uk:
 Hi :)
 Ahhah, great.  I prefer dashes - because after reading too much for too long 
 my
 eyes get a bit muddled when people use / and dots still seem to confuse 
 obscure
 Windows systems sometimes.  I was told that the / was the European Standard 
 but
 if - are used in one other country then that helps me argue the case with my
 boss.

I though that ”/” was the US standard… Here (Sweden) we follow the
ISO8601, except for time. Seems like we use dots instead of colons.
Wish we and the rest of the world could just adapt the ISO 8601. There
is a reason for why it was created… And personally I use it all the
time. And of course every ”dygn” (sorry, there is no English
translation for that word – yet…) is 24 hours, so why that silly 12
hour thing? If all analogue watches were made 24 hours, you could very
easily also use it as a compass, at least when you can see the sun (if
the hour hand point to the sun, then 24, or rather 0, will point to
north, 6 to east, 12 to south and 18 to west). How can it be easier
than that?


Regards

Johnny Rosenberg
ジョニー・ローゼンバーグ
2011-08-11 12:36:51



 Regards from
 Tom :)




 
 From: Johnny Rosenberg gurus.knu...@gmail.com
 To: users@global.libreoffice.org
 Sent: Thu, 11 August, 2011 11:18:39
 Subject: Re: [libreoffice-users] Date Format in Writer

 2011/8/11  rjw...@phonecoop.coop:
 To avoid confusion between the mm.dd. and the dd.mm. date formats can
we have the less ambiguous
 International

 It IS international, it's ISO 8601 (and also Swedish standard, lucky
 me… ;P)! Except that there should be dashes, not dots: -mm-dd.


 Kind regards

 Johnny Rosenberg
 ジョニー・ローゼンバーグ

 .mm.dd format included as an option (default?) in the fields for Writer?

 --
 For unsubscribe instructions e-mail to: users+h...@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



 --
 For unsubscribe instructions e-mail to: users+h...@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

 --
 For unsubscribe instructions e-mail to: users+h...@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


-- 
For unsubscribe instructions e-mail to: users+h...@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] MS Works import

2011-08-11 Thread Dave Sergeant
LibreOffice 3.4 is advertised as supporting import of MS Works files, 
but a search of the archives of this list shows very little about it. I 
have a colleague who has a rather large (66Mb) .wps file with loads of 
pictures that he wants to open on his Mac, and I suggested LO as an 
easy way.

A quick play with my own LO (3.4.1) on Windows XP was inconclusive. I 
found a few sample .wps text documents on the web. Two of them opened 
OK, but had no formatting. The third opened as a blank document. A .wdb 
spreadsheet that I had been sent in the past also opened as a blank 
text document.

How much experience of people had of Works import and does it actually 
work, or is it as I seem to be finding rather buggy?

Dave

http://www.davesergeant.com


-- 
For unsubscribe instructions e-mail to: users+h...@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] MS Works import

2011-08-11 Thread Charlie

On 11/08/11 12:16, Dave Sergeant wrote:




How much experience of people had of Works import and does it actually
work, or is it as I seem to be finding rather buggy?

Dave

http://www.davesergeant.com




No problem here using V 3.3.3 running on Ubuntu (that's the latest 
version for Ubuntu). See samples at 
www.writersedgeservice.com/filebrowser/proposalsfiction.asp . Formatting 
was fine.



Charlie.

--
M0WYM
www.radiowymsey.org

Sales @ radiowymsey
http://shop.ebay.co.uk/gnome7763/m.html?




--
For unsubscribe instructions e-mail to: users+h...@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: How can I build only libreoffice-writer instead of whole officesuite ?

2011-08-11 Thread Tom Davies
Hi :)
Yes, i have heard that of AbiWord before.  Writer does have a lot more 
features.  


With LinuxFromScratch you might find Slackware forums helpful as i think they 
are the most similar to what you are doing.  There will be slight differences 
of 
course but they are probably very used to the approach and the ideal of keeping 
the system streamlined.  Othe distros forums might have soem tips but take care 
as they probably don't worry about adding 'bloat'.  Also the forum 

http://www.linuxquestions.org
is good for every distro but again take care as people might not worry about 
adding bloat which you may not want.  Good to get ideas from tho! :)

I have 1 machine that has Ubuntu and doesn't yet have LibreOffice installed but 
it's difficult for me to get to.  If i do manage it i will try to remember to 
get a list of dependencies for Writer alone.  I have a feeling that it is going 
to be the entirety of LibreOffice excluding only Base and possibly Java.  


Regards from
Tom :)





From: Partha Chowdhury parthachowdhur...@gmail.com
To: users@global.libreoffice.org
Sent: Thu, 11 August, 2011 6:04:26
Subject: Re: [libreoffice-users] Re: How can I build only libreoffice-writer 
instead of whole officesuite ?

I have tried abiword, but when I try to open a doc document in abiword which 
was 
created by microsoft office 2003, the file looks gibberish.In addition , all 
indentation, margins,tables,frames etc look out-of-place.It cannot render the 
file properly.Atleast openoffice or Libreoffice renders it properly.And abiword 
being a lightweight lacks many features than LO-writer.

I am using Linux from Scratch, http://www.linuxfromscratch.org, which teaches 
you to build a minimalist bootable GNU/Linux system entirely from source 
code.from there, One can easily install any software of his choice or need and 
have a minimal yet very fast,efficient and functional system.

-- For unsubscribe instructions e-mail to: users+h...@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
-- 
For unsubscribe instructions e-mail to: users+h...@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] MS Works import

2011-08-11 Thread Tanstaafl
On 11/08/11 12:16, Dave Sergeant wrote:
 How much experience of people had of Works import and does it actually
 work, or is it as I seem to be finding rather buggy?

Be sure you installed the 'Legacy File Format Filters' when you
installed it.

You have to choose the 'Custom' install option to get to these...

-- 
For unsubscribe instructions e-mail to: users+h...@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: add ttf fonts to LibreOffice

2011-08-11 Thread SillyOne
Thanks for all who answered, creating the .fonts directory under
/home/username/ and rerunning fc-cache was the solution that worked.

Thanks for all of you!

--
View this message in context: 
http://nabble.documentfoundation.org/add-ttf-fonts-to-LibreOffice-tp3241306p3245749.html
Sent from the Users mailing list archive at Nabble.com.

-- 
For unsubscribe instructions e-mail to: users+h...@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] MS Works import

2011-08-11 Thread Dave Sergeant
On 11 Aug 2011 at 12:35, Charlie wrote:

  How much experience of people had of Works import and does it actually
  work, or is it as I seem to be finding rather buggy?
 
 No problem here using V 3.3.3 running on Ubuntu (that's the latest
 version for Ubuntu). See samples at
 www.writersedgeservice.com/filebrowser/proposalsfiction.asp . Formatting
 was fine.
 

Thanks Charlie for that. I have just updated to 3.4.2 to see if that 
would change things, but it did not. And yes, I DO have the legacy 
filters installed, which you need for the old .sxw etc formats but I 
don't think they are needed for Works.

The documents on writersedge were in fact the ones I had found myself. 
There are three .wps files on there, and these all open fine, complete 
with formatting, bolding etc in MS Word Viewer.

In LO 3.4.2:
cad7593009.wps - opens blank, if I look at the properties pane it 
claims it has 1 page with 0 characters.
fot4813409.wps and mot6312910.wps open correctly as plain text but all 
the bolding, italics, paragraph indents, and other formatting is 
missing. They look totally different from how they do in Wordview.

I wonder if it has changed between v3.3 and v3.4 or maybe it is a 
Windows issue?

Dave


http://www.davesergeant.com


-- 
For unsubscribe instructions e-mail to: users+h...@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: New user to BASE

2011-08-11 Thread Wayne

On 08/10/2011 04:50 AM, Alexander Thurgood wrote:

Le 07/08/11 03:55, Wayne a écrit :

Hi Wayne,


A couple of three days ago someone, on this list, mention not to use
BASE, as there wasn't much development going on. Their suggestion
was to look for a different front end to use. Can someone make a suggestion
as to what would be a good alternative to use?
No wars please. Just good advice. Thanks

LibreOffice Base can do quite a lot, but it requires a fairly steep
initial investment once you realise that the wizards are a bit limited,
and thus you become reliant on macro programming for the unmet features
that would be found in other front end solutions like FMPro or Approach
or Access, and dare I say it, the fairly numerous bugs that are now in
the source code (and aren't yet being fixed).

Having used Approach in the past, I would have to agree with Roland if
all you want is to have a db front end that you can use on Linux (via
Wine) and Windows. If you want it to provide a front end for Mac as
well, then you will be stuck with either LibreOffice Base and a fairly
sustantial choice of server backends, or using some other interface
design tool for your db such as Ruby, XML forms, PHP, etc.


Alex

Would you include Python in that list?
Wayne








--
For unsubscribe instructions e-mail to: users+h...@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: Base 3.4.2 doesn't run on Windows 7

2011-08-11 Thread Don C. Myers

Hi,

I saved the instructions for adding the Java for my future reference if 
needed. These are slightly modified over what had been in the post:


*Older Java Version for LibreOffice and Open Office for Linux Install:*

Overview:

1. Download the JRE archive (approx. 20 mb)
2. Extract in /tmp
3. as root, copy the extracted directory to /usr/lib/jvm
4. set this JRE as the JRE of choice in LO (ToolsOptionsJava)
5. Exit LO  restart

Instructions:

1.Download jre-6u21-linux-i586.bin (for i386) or jre-6u21-linux-x64.bin for
x86_64 from


http://www.oracle.com/technetwork/java/javasebusiness/downloads/java-archive-  
http://www.oracle.com/technetwork/java/javasebusiness/downloads/java-archive-downloads-javase6-419409.html#jdk-6u21-b07-oth-JPRdownloads-javase6-419409.html#jre-6u21-b07-oth-JPR
  
http://www.oracle.com/technetwork/java/javasebusiness/downloads/java-archive-downloads-javase6-419409.html#jdk-6u21-b07-oth-JPR
Save to /tmp . Open Terminal and enter cd /tmp. Then do the following commands:
2.run it using: sh jre-6u21-linux-i586.bin . The JRE is now extracted to
/tmp/jre1.6.0_21/
3. copy to /usr/lib/jvm sudo cp -a jre1.6.0_21/ /usr/lib/jvm
4. Exit  restart office.  In ToolsOptionsJava, choose 1.6.0_21. Exit
restart office
5. Load you Base file  compare the speed.

If you want to remove it simply set the JRE back to the old one in
ToolsOptionsJava  sudo rm -rf /usr/lib/jvm/jre1.6.0_21/




On 08/10/2011 09:31 AM, Tom Davies wrote:

Hi :)
Thanks for confirming that the _21 is the best version for LibreOffice.  Is
there any chance of joining the Documentation Team to write-up the instructions
for installing a separate version of Java specifically for LibreOffice?  I think
a chapter about Java is likely to start off as being very small and it's not
clear exactly where it could go but i think once written it could be moved
fairly easily.


Alternatively perhaps an Ubuntu Community Documentation page?  Either a radical
re-write of
https://help.ubuntu.com/community/Java
or something more specific to LibreOffice such as creating a new page
https://help.ubuntu.com/community/Base/Java
With a longer-term view of having a single main page about Base that then has
sub-pages (such as the Java one) and/or links to proper LibreOffice
documentation.


Regards from
Tom :)




From: Don Myersdonmy...@myersfarm.com
To: users@global.libreoffice.org
Sent: Wed, 10 August, 2011 4:09:06
Subject: Re: [libreoffice-users] Re: Base 3.4.2 doesn't run on Windows 7

Hi,

When we had the long thread about Base working really slowly and the problem
being Java, I thought someone said the issue only affected those running Base in
Linux. I only run it (but on 4 machines) in Ubuntu. I have no Windows installs.
When Ubuntu had 1.6.0_22 as the default, my base worked fine. When the Java
1.6.0_24 update was installed, base became horribly slow. When the 1.6.0_26
update was installed, it was still very slow. Someone in the thread said that in
Linux you can have two Java versions installed on a system side by side, and he
gave instructions on how to do it. Following those instructions, I've tried both
1.6.0_21 and 1.6.0_22. Base works well with both of them, but is just a tiny bit
faster on my systems with the _21 version. When you install the second version
as per the instructions this person gave, the older version is only used for
LibreOffice. The browsers are still using the latest version, so you have all of
the security protection of the latest version. I'm sorry I can't give you advise
relative to Windows systems. I don't know if Windows has the same situation as
Linux. The problem wasn't that Base didn't run in Linux. It was just very
sluggish.

On 08/09/2011 06:50 PM, Tom Davies wrote:

Hi :)
Except that quite a few people have reported problems with ultra-new java such
as the  _26 version.  The _22 and _20 were ok but the _21 seems to be the best
for LibreOffice Base.  I think the _22 is the standard one in the Ubuntu repos
but i'm not sure about other distros or Windows (or Mac or Bsd).  It might

mean

you need to have 2 versions of Java installed as your web-browser might be
using
something other than the _20 - _22

Regards from
Tom :)





From: webmaster for Kracked Press Productionswebmas...@krackedpress.com
To: users@global.libreoffice.org
Sent: Sun, 7 August, 2011 14:00:59
Subject: Re: [libreoffice-users] Re: Base 3.4.2 doesn't run on Windows 7


I remember something about Sun/Oracle older version of Java having problem

with

LibreOffice, but there is an open-source version that would instead.

The one on my Ubuntu system states it is Sun's Java, but the file's name
[folder's name] of the runtime engine seems to be Java-6-openjdk.

I know someone on this list would know what the best link for it is.  Ubuntu
seems to have it on its repository, but Windows would need a link to
find/download it for their use.

As for the latest version of Java, it is always a good 

Re: [libreoffice-users] mailinglist

2011-08-11 Thread soumalya ray
yeah,thought so

On 10 August 2011 19:09, Tom Davies tomdavie...@yahoo.co.uk wrote:

 Hi :)
 Not really.  It is nice to see different languages in here but native
 English-speakers are often unable to understand more than 1 language and
 many
 have trouble even with that one.  There are many other lists for many other
 languages.

 Regards from
 Tom the monoglot :)



 
 From: soumalya ray drsouma...@gmail.com
 To: users@global.libreoffice.org
 Sent: Wed, 10 August, 2011 14:12:31
 Subject: Re: [libreoffice-users] mailinglist

 could any language be used to ask question in this mailing list?

 On 10 August 2011 14:41, Stan Goodman stan.good...@hashkedim.com wrote:

  On 08/10/2011 10:48 AM, RK wrote:
 
  Werte Damen und Herren,
 
  bitte meine E-Mail Adresse aus der mailinglist streichen.
  Danke
  Rainer Kretzschmar
  Kärrnerweg 25
  09350 Lichtenstein
 
  e-Mail: srkretzsch...@vodafone.de
  --
  For unsubscribe instructions e-mail to: users+help@global.libreoffice.
 **
  org users%2bh...@global.libreoffice.org
  Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-**
 unsubscribe/
 http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
 
  Posting guidelines + more: http://wiki.**documentfoundation.org/**
  Netiquette http://wiki.documentfoundation.org/Netiquette
  List archive:
 http://listarchives.**libreoffice.org/global/users/
 http://listarchives.libreoffice.org/global/users/
 
  All messages sent to this list will be publicly archived and cannot be
  deleted
 
 
 
  Nobody here can do what you ask. The only one that can unsubscribe you is
  you yourself. To do so, READ the instructions just above (which appear at
  the bottom of each and every message you receive from the list.
  --
  Stan Goodman
  Qiryat Tiv'on
  Israel
 
 
  --
  For unsubscribe instructions e-mail to: users+help@global.libreoffice.**
  org users%2bh...@global.libreoffice.org
  Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-**
 unsubscribe/
 http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
 
  Posting guidelines + more: http://wiki.**documentfoundation.org/**
  Netiquette http://wiki.documentfoundation.org/Netiquette
  List archive:
 http://listarchives.**libreoffice.org/global/users/
 http://listarchives.libreoffice.org/global/users/
 
  All messages sent to this list will be publicly archived and cannot be
  deleted
 
 


 --
 Dr soumalya ray http://drsoumalya.blogspot.com  drsouma...@gmail.com
 MBBS,MD(PGT)C.Medicine,Ex-HousePhysician(Medicine)
 Skype: som3776 | Twitter: @docbkp http://twitter.com/docbkp

 --
 For unsubscribe instructions e-mail to: users+h...@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

 --
 For unsubscribe instructions e-mail to: users+h...@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




-- 
Dr soumalya ray http://drsoumalya.blogspot.com  drsouma...@gmail.com
MBBS,MD(PGT)C.Medicine,Ex-HousePhysician(Medicine)
Skype: som3776 | Twitter: @docbkp http://twitter.com/docbkp

-- 
For unsubscribe instructions e-mail to: users+h...@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: Macro not active when the document start

2011-08-11 Thread Andreas Säger

Am 10.08.2011 09:23, toto wrote:

I'm using macro's function and it doesn't start when the document start.
It would start if I change the value of the variabel at the function.
The code is to change numeric value to string. If I execute the code:
ubah(123) the result is seratus dua puluh tiga. Any idea how to make
the function executed when I open the document?

The code is:

Public Function ubah(x as currency) as String


Currency is not a valid type to be used in a spreadsheet.
From the Basic perspective all spreadsheet values are doubles or 
string, errors are Null, empty cells are empty strings. There are no 
date values in particular.


This function works as expected:
Function DOUBLE(n as Double)
 DOUBLE = n *2
End Function

This function returns a text value.
Function DOUBLE_CURR(n as Currency)
 DOUBLE_CURR = n *2
End Function

I can not reproduce the recalculation problem, though.
Both versions of the above functions recalculate when I load the 
document or when I modify A1 with auto-cacluation enabled.

A1 =PI()
=DOUBLE(A1) = 6.2832 (number)
=DOUBLE_CURR(A1) = 6.2832 (text)


--
For unsubscribe instructions e-mail to: users+h...@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: LibreOffice Calc: Format column titles in DataPilot

2011-08-11 Thread Andreas Säger

Am 11.08.2011 01:28, jorge wrote:

Hi

I'm sorry but I made an example with Style and the first column header
(Title) wasn't changed. Besides, I refreshed the pilot table and lost
the headers format.

What did I wrong ?



The pilot uses one distinct set of automatically generated styles. For 
column headers in the English GUI the style is named DataPilot_Category.
When the pilot is rebuilt on refresh, all formatting falls back to that 
style.

- Application of some other style will be reset to DataPilot_Category.
- Hard attributes will be reset to the bare DataPilot_Category settings.
- Modifying DataPilot_Category itself will format both, row headers 
and column headers.



--
For unsubscribe instructions e-mail to: users+h...@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: Date Format in Writer

2011-08-11 Thread Andreas Säger

Am 11.08.2011 11:11, rjw...@phonecoop.coop wrote:

To avoid confusion between the mm.dd. and the dd.mm. date formats can we have the 
less ambiguous International .mm.dd format included as an option 
(default?) in the fields for Writer?



menu:ToolsOptionsLanguageSettingsLangugesLocale=Swedish
applies Swedish formatting to all numbers in all components unless the 
locale has been set explicitly.
When I send you a document where I explicitly applied the German locale, 
all numeric values look like 1.234,99 and 31.12.2011 regardless of your 
default setting.


In Writer you can define an auto text with an ISO formatted date field 
as content.



--
For unsubscribe instructions e-mail to: users+h...@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] Opening xls file with xhtml embedded

2011-08-11 Thread msaum@smi
We have main frame reports that are generated using xhtml and saved as
extension xls. When the user gets the report they would typically just
open them with excel, no problem...  Calc does not open them properly. When
I ope CALC and manually open the spreadsheet, it eventually opens in
Writer/Web and does not look like the same result as Excel does This is
a major stumbling block for us to move over to Libre Office.. We are engaged
with application vendor to change the report, but we all know how that can
beSLOWWW..

--
View this message in context: 
http://nabble.documentfoundation.org/Opening-xls-file-with-xhtml-embedded-tp3245877p3245877.html
Sent from the Users mailing list archive at Nabble.com.

-- 
For unsubscribe instructions e-mail to: users+h...@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: MS Works import

2011-08-11 Thread NoOp
On 08/11/2011 06:44 AM, Dave Sergeant wrote:
 On 11 Aug 2011 at 12:35, Charlie wrote:
 
  How much experience of people had of Works import and does it actually
  work, or is it as I seem to be finding rather buggy?
 
 No problem here using V 3.3.3 running on Ubuntu (that's the latest
 version for Ubuntu). See samples at
 www.writersedgeservice.com/filebrowser/proposalsfiction.asp . Formatting
 was fine.
 
 
 Thanks Charlie for that. I have just updated to 3.4.2 to see if that 
 would change things, but it did not. And yes, I DO have the legacy 
 filters installed, which you need for the old .sxw etc formats but I 
 don't think they are needed for Works.
 
 The documents on writersedge were in fact the ones I had found myself. 
 There are three .wps files on there, and these all open fine, complete 
 with formatting, bolding etc in MS Word Viewer.
 
 In LO 3.4.2:
 cad7593009.wps - opens blank, if I look at the properties pane it 
 claims it has 1 page with 0 characters.
 fot4813409.wps and mot6312910.wps open correctly as plain text but all 
 the bolding, italics, paragraph indents, and other formatting is 
 missing. They look totally different from how they do in Wordview.
 
 I wonder if it has changed between v3.3 and v3.4 or maybe it is a 
 Windows issue?
...
It's not a Windows issue... I've tested using OOo 3.2.1 (go-oo based),
LO 3.3.3, and LO 3.4.2 - all linux, and get the same results in 3.4.2.
OOo 3.2.1 and LO 3.3.3 opens cad7593009.wps (albeit without detailed
formating). So I reckon that you've found a bug - please file a bug
report using those files as examples.




-- 
For unsubscribe instructions e-mail to: users+h...@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: MS Works import

2011-08-11 Thread Alexander Thurgood
Le 11/08/11 15:44, Dave Sergeant a écrit :

Hi Dave,

 In LO 3.4.2:
 cad7593009.wps - opens blank, if I look at the properties pane it 
 claims it has 1 page with 0 characters.
 fot4813409.wps and mot6312910.wps open correctly as plain text but all 
 the bolding, italics, paragraph indents, and other formatting is 
 missing. They look totally different from how they do in Wordview.

I can confirm your described display of these files on Mac OSX with
LibreOffice 3.4.2, but as far as I knew, WPS import was never perfect
anyway.

FWIW, in LO 3.3.2, the files display differently, with cad7593009
opening and showing bold and italic formatting. However, the other two
files do not appear to show paragraph indents, bold or italic either in
LO 3.3.2, so I would say that the import feature is less than perfect,
and that something between 3.3.x and 3.4.x now prevents opening of
certain content stored within WPS files. You'd best open a bug report.


Alex


-- 
For unsubscribe instructions e-mail to: users+h...@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: New user to BASE

2011-08-11 Thread Alexander Thurgood
Le 11/08/11 15:46, Wayne a écrit :

 Would you include Python in that list?
 Wayne

Sure, any programming language that allows you to build a graphically
driven frontend. AFAIK, Python can do that with tcl, wx, gtk, and no
doubt other graphical toolkits so why not ? ;-)


I actually went scouring for stuff like that the other day on
sourceforge because I need to have a frontend I can design, implement
and distribute over a network and multiple-OSes. I haven't had time to
try the various bits out yet though, most of which looks PHP-based (but
only because I have a vague understanding of PHP - my python skills are
way too low to attempt something like that at the moment, but I did give
it some thought :-))

Alex


-- 
For unsubscribe instructions e-mail to: users+h...@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] size of LibreOffice RAM when converting towards pdf

2011-08-11 Thread DE VITO Dominique
Hi,

I have just a 10 Mo .ppt including around 30 jpeg images.
I want to convert it towards PDF using LibreOffice, while using a Java program.

To do so, I use the LibreOffice SDK from Java, with socket connection (due to 
streaming) between Java/LibreOffice.
While the original document size sounds not that high, LibreOffice raises up to 
3 Go (!) of RAM.

What do you think about that numbers ?

While looking for a way to decrease the RAM used by LibreOffice, I wondered 
about the folllowing:

- what is the version of PDF for the created PDF doc ?

- are you using JPXDecode (a lossy or lossless filter based on the JPEG 2000 
standard, introduced in PDF 1.5) for not converting jpeg images ?

- are you doing streaming during the transformation process ?

Thanks for your responses.

Regards,
Dominique


-- 
For unsubscribe instructions e-mail to: users+h...@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] Calc will not save file after sheet deleted.

2011-08-11 Thread Bill Gradwohl
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

On 08/10/2011 05:23 PM, Simon Cropper wrote:
 It is obvious that you do not like OO or LO Calc, and that you don't
 like the fact that your data is continually corrupted.
LO is a tool. I neither like or dislike it. As a tool, it has a major
defect in that it periodically destroys the product which was built
using it. You're right in that I don't like the tool I'm using to
destroy my work.

 You also say you continuously have to rebuild your spreadsheet and that
 the process can take several days.
Just spent 2 long days recreating the spreadsheet using 2 machines. Not fun.

 If you are so unhappy with the format, corruption and dirty code, my
 question is why do you persist?
I've got a lot of investment in my macro code (9000 lines of it) that
can only function within LO. I can't migrate it to something else as is.

Had I known about the corruption when I started the project 6 years ago,
I would have chosen a different platform. I would have never imagined
that over the course of several years that corruption issues would be
ignored. That's just inconceivable to me as a professional software
developer, but that's apparently the reality.

 Change packages.
Can't, as was mentioned above, unless I rewrite everything. Sad to say,
LO is the only real competitor to MS Office and given its corruption
history it will turn a lot of people off that might have moved away from
MS Windows to Linux had the product been reliable.

My real interest is in moving people away from a lousy operating system
like Windows to something near bullet proof like Linux. We all need
applications tools like word processing, spreadsheet, etc, so a tool
like LO is vitally important to Linux adoption.

If I could get MS Office compiled to run on Linux as a native
application, I'd forget about LO in a heartbeat. MS Office is the best
thing Microsoft has. It works well in its native environment. I wish I
could say the same for LO, and that's why I'm critical of it.

With the time and effort you have already put into recreating corrupted
spreadsheets you
 could of written your own application or mastered alternative packages.
I guess you don't write code for a living. I estimate a rewrite of my
POS system would take well over a year of my time. While that's going
on, I need something reliable to help run a business. I have sketched
out a web based replacement much much more sophisticated than what I'm
using now, and plan on developing it when I have the time.

Wasting time reporting OO / LO bugs that never get taken seriously and
recreating a spreadsheet periodically helps keeps me from such a new
development effort. My wife (also a professional software developer)
keeps telling me to stop wasting time reporting issues - that I'm
tilting at windmills. She may be right.

 I am not trying to be rude here it just if I had a package that caused
 me so much wasted time I would just move on.
I will move on in time, but in the interim, I'd like LO to thrive in the
market, and that won't happen unless it becomes reliable. My problem is
really with LO management. There isn't any.

Despite what you may think, I'm more interested in LO's success than
most people are, and I know it won't be successful long term unless its
reliable. It hasn't been reliable for years and that's a problem.

- -- 
Bill Gradwohl
Roatan, Honduras
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.11 (GNU/Linux)
Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org/

iEYEARECAAYFAk5EEGMACgkQ7Orvev+eC8rvIACgly5u6U6eM9DeiCbJJ5++k8rf
BpUAoIy9kOViLVFCssIwmN3BfCGnR+Dy
=ct68
-END PGP SIGNATURE-

-- 
For unsubscribe instructions e-mail to: users+h...@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] size of LibreOffice RAM when converting towards pdf

2011-08-11 Thread Tom Davies
Hi :)
Which version of Java are you using?  The more recent _26 and _24 versions 
create problems in LibreOffice.  The ideal version is their _21 but the _22 and 
_20 are also quite good.  


Also which version of LibreOffice are you using?  The 3.3.3 is the latest 
stable 
but the more adventurous 3.4.2 has some extra functionality.  You can install 
both side-by-side but only by following the technique shown in this guide
http://wiki.documentfoundation.org/Installing_in_parallel

It might also make a difference which Operating System you are using; a 
Windows, 
Ubuntu, another GnuLinux, Bsd or Mac?
Regards from
Tom :)





From: DE VITO Dominique dominique.dev...@thalesgroup.com
To: users@global.libreoffice.org users@global.libreoffice.org
Sent: Thu, 11 August, 2011 18:24:28
Subject: [libreoffice-users] size of LibreOffice RAM when converting towards pdf

Hi,

I have just a 10 Mo .ppt including around 30 jpeg images.
I want to convert it towards PDF using LibreOffice, while using a Java program.

To do so, I use the LibreOffice SDK from Java, with socket connection (due to 
streaming) between Java/LibreOffice.
While the original document size sounds not that high, LibreOffice raises up to 
3 Go (!) of RAM.

What do you think about that numbers ?

While looking for a way to decrease the RAM used by LibreOffice, I wondered 
about the folllowing:

- what is the version of PDF for the created PDF doc ?

- are you using JPXDecode (a lossy or lossless filter based on the JPEG 2000 
standard, introduced in PDF 1.5) for not converting jpeg images ?

- are you doing streaming during the transformation process ?

Thanks for your responses.

Regards,
Dominique


-- 
For unsubscribe instructions e-mail to: users+h...@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
-- 
For unsubscribe instructions e-mail to: users+h...@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: New user to BASE

2011-08-11 Thread planas
Hi

On Thu, 2011-08-11 at 18:01 +0200, Alexander Thurgood wrote: 

 Le 11/08/11 15:46, Wayne a écrit :
 
  Would you include Python in that list?
  Wayne
 
 Sure, any programming language that allows you to build a graphically
 driven frontend. AFAIK, Python can do that with tcl, wx, gtk, and no
 doubt other graphical toolkits so why not ? ;-)
 
 
 I actually went scouring for stuff like that the other day on
 sourceforge because I need to have a frontend I can design, implement
 and distribute over a network and multiple-OSes. I haven't had time to
 try the various bits out yet though, most of which looks PHP-based (but
 only because I have a vague understanding of PHP - my python skills are
 way too low to attempt something like that at the moment, but I did give
 it some thought :-))
 
 Alex
 
 

You have several options with databases: use Base only, use Base as the
front end with another database as the back end, or use another database
and hope there are decent graphical tools available. Base only may limit
what you can do particularly with network access For Base with another
back end you will need to set up the connection in Base and many common
options are supported. Using another database completely can be tricky,
some do not have nice front end tools. Two that do are MySQL/MariaDB
(Linux uses MySQL Workbench) and PostgreSQL (pgadmin). SQLite is another
possibility but it does not easily support all the data types that may
be in a database.

None of these will require any programming but will require varying
knowledge of SQL to use effectively.

-- 
Jay Lozier
jsloz...@gmail.com

-- 
For unsubscribe instructions e-mail to: users+h...@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] Libre Office being recommended on Microsoft Answers Forums!

2011-08-11 Thread Gordon Burgess-Parker

Yes it's true!
I see this more and more - LO being recommended to people who've bought 
a computer with a Trial version of Office 2010 that's expired...


--
For unsubscribe instructions e-mail to: users+h...@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] Opening xls file with xhtml embedded

2011-08-11 Thread planas
Hi

On Thu, 2011-08-11 at 06:11 -0700, msaum@smi wrote: 

 We have main frame reports that are generated using xhtml and saved as
 extension xls. When the user gets the report they would typically just
 open them with excel, no problem...  Calc does not open them properly. When
 I ope CALC and manually open the spreadsheet, it eventually opens in
 Writer/Web and does not look like the same result as Excel does This is
 a major stumbling block for us to move over to Libre Office.. We are engaged
 with application vendor to change the report, but we all know how that can
 beSLOWWW..
 
 --
 View this message in context: 
 http://nabble.documentfoundation.org/Opening-xls-file-with-xhtml-embedded-tp3245877p3245877.html
 Sent from the Users mailing list archive at Nabble.com.
 

Instead of opening the file try importing the file into Calc using
INSERT  SHEET FROM FILE. You will be presented with an import wizard.
If that does not work you link to data, also under INSERT. 

I think the problem is when the encoding is read by LO it sees as an
XHTML page for Writer. Excel is a stand alone product, as all the MSO
suite members while LO is an integrated suite (you get everything at
once). So LO opens a file it tries to open it with what is normally the
best option based on the actual encoding. Changing the file extension
does not change the file encoding. This can cause problems because the
opening program may incorrectly interpret the file format present
gibberish. The best way for the main frame to output is with the correct
extension or as a CSV file which any spreadsheet can handle.

-- 
Jay Lozier
jsloz...@gmail.com

-- 
For unsubscribe instructions e-mail to: users+h...@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] Date Format in Writer

2011-08-11 Thread planas
Johnny

On Thu, 2011-08-11 at 12:36 +0200, Johnny Rosenberg wrote: 

 2011/8/11 Tom Davies tomdavie...@yahoo.co.uk:
  Hi :)
  Ahhah, great.  I prefer dashes - because after reading too much for too 
  long my
  eyes get a bit muddled when people use / and dots still seem to confuse 
  obscure
  Windows systems sometimes.  I was told that the / was the European Standard 
  but
  if - are used in one other country then that helps me argue the case with my
  boss.
 
 I though that ”/” was the US standard… Here (Sweden) we follow the
 ISO8601, except for time. Seems like we use dots instead of colons.

/ with mm/dd/ is the normal US standard (sometimes mm.dd.
because / is mis interpreted in file names). Most Americans who have
dealt with international trade are comfortable with either US or ISO
styles and for dates. 

 Wish we and the rest of the world could just adapt the ISO 8601. There
 is a reason for why it was created… And personally I use it all the
 time. And of course every ”dygn” (sorry, there is no English
 translation for that word – yet…) is 24 hours, so why that silly 12
 hour thing? If all analogue watches were made 24 hours, you could very
 easily also use it as a compass, at least when you can see the sun (if
 the hour hand point to the sun, then 24, or rather 0, will point to
 north, 6 to east, 12 to south and 18 to west). How can it be easier
 than that?

When I was in elementary school we were taught a 12 hour cycle with AM
and PM to determine if it was morning or afternoon/evening. The US
military, I believe, uses the 24 hour clock because 0900 is always in
the morning while evening equivalent 2100 is always in the
evening/night, much less likely to be misunderstood. 

 
 Regards
 
 Johnny Rosenberg
 ジョニー・ローゼンバーグ
 2011-08-11 12:36:51
 
 
 
  Regards from
  Tom :)
 
 
 
 
  
  From: Johnny Rosenberg gurus.knu...@gmail.com
  To: users@global.libreoffice.org
  Sent: Thu, 11 August, 2011 11:18:39
  Subject: Re: [libreoffice-users] Date Format in Writer
 
  2011/8/11  rjw...@phonecoop.coop:
  To avoid confusion between the mm.dd. and the dd.mm. date formats 
  can
 we have the less ambiguous
  International
 
  It IS international, it's ISO 8601 (and also Swedish standard, lucky
  me… ;P)! Except that there should be dashes, not dots: -mm-dd.
 
 
  Kind regards
 
  Johnny Rosenberg
  ジョニー・ローゼンバーグ
 
  .mm.dd format included as an option (default?) in the fields for 
  Writer?
 
  --
  For unsubscribe instructions e-mail to: users+h...@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
 
 
 
  --
  For unsubscribe instructions e-mail to: users+h...@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
 
  --
  For unsubscribe instructions e-mail to: users+h...@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
 
 



-- 
Jay Lozier
jsloz...@gmail.com

-- 
For unsubscribe instructions e-mail to: users+h...@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] Libre Office being recommended on Microsoft Answers Forums!

2011-08-11 Thread planas
Gordon

On Thu, 2011-08-11 at 20:24 +0100, Gordon Burgess-Parker wrote: 

 Yes it's true!
 I see this more and more - LO being recommended to people who've bought 
 a computer with a Trial version of Office 2010 that's expired...
 

+1

Where is this happening? 

-- 
Jay Lozier
jsloz...@gmail.com

-- 
For unsubscribe instructions e-mail to: users+h...@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] unopkg error

2011-08-11 Thread planas
Lars

On Thu, 2011-08-11 at 10:23 +0200, Lars Callenbach wrote: 

 Hi Jay,
 
 I have modified the QuantLib addin code so that it runs under Linux and 
 Windows XP (using Openoffice 3.2.1). Under Libreoffice the code compiles and 
 the oxt file will be created but loading of the addin (using the oxt file) 
 fails with an error message under Linux. 
 
 Was there any change in the api of Libreoffice? What do I have to change/add 
 to get a working addin? Is there any documentation or are there any C++ addin 
 examples that can be used? The examples in the SDK (code examples under 
 $SDK/examples/cpp) are not helpful. It seems that there have been no changes. 
 So I expect that the code for the Quantlib addin need not be modified. Any 
 ideas?
 
 Regards,
Lars

Truthfully, I do not know what changes, if any were made to the APIs. You might 
want to check some the developer documentation.

 Lars,
 
 On Wed, 2011-08-10 at 09:22 +0200, Lars Callenbach wrote:
 
  Hello,
 
  I have compiled an addin which works find under openoffice 3.2. Using 
  either libreoffice 3.3 or 3.4 the following error message appears:
  
  ERROR: Fehler beim Hinzuf�gen von: 
  vnd.sun.star.expand:$UNO_USER_PACKAGES_CACHE/uno_packages/luecz64g.tmp_/CalcAddins.oxt
  Cause: Media-Typ konnte nicht ermittelt werden: 
  file:///root/.libreoffice/3/user/uno_packages/cache/uno_packages/luecz64g.tmp_/CalcAddins.oxt
 
  unopkg failed.
  
  The directory CalcAddins.oxt has not been created and the oxt file has not 
  been unziped.
 
  What do I have to change to get a working addin using libreoffice?
 
  Regards,
  Lars
  --
  NEU: FreePhone - 0ct/min Handyspartarif mit Geld-zurück-Garantie!
  Jetzt informieren: http://www.gmx.net/de/go/freephone
 
 
 I would check OOo to see if they have an updated version and check
 http://libreplanet.org/wiki/Group:OpenOfficeExtensions/List and
 http://wiki.documentfoundation.org/Downloads/Templates . Plugins, unless
 they are official ones, may lag the release somewhat some if they need
 significant changes they may not work with the latest version.
 
 -- 
 Jay Lozier
 jsloz...@gmail.com
 
 
 -- 
 Empfehlen Sie GMX DSL Ihren Freunden und Bekannten und wir
 belohnen Sie mit bis zu 50,- Euro! https://freundschaftswerbung.gmx.de
 



-- 
Jay Lozier
jsloz...@gmail.com

-- 
For unsubscribe instructions e-mail to: users+h...@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] How can I build only libreoffice-writer instead of whole office suite ?

2011-08-11 Thread planas
Partha,

On Wed, 2011-08-10 at 18:07 +0530, Partha Chowdhury wrote: 

 Hallo all.This is my first post to the list.
 
 I have successfully build libreoffice-3.3.3.1 form source.However, I 
 need office only to open and edit word documents and nothing else. So I 
 want only to build the writer part and not the whole office.I have 
 googled but have not found anything to this effect.The documentation 
 covers only building from git and not the individual parts. So is it 
 possible only to build a part of libreoffice instead of whole suite ?
 
 


I might check out the source code,
http://cgit.freedesktop.org/libreoffices. I am not sure what you need
from the list.
-- 
Jay Lozier
jsloz...@gmail.com

-- 
For unsubscribe instructions e-mail to: users+h...@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] Libre Office being recommended on Microsoft Answers Forums!

2011-08-11 Thread Gordon Burgess-Parker

On 11/08/2011 20:43, planas wrote:

Gordon

On Thu, 2011-08-11 at 20:24 +0100, Gordon Burgess-Parker wrote:


Yes it's true!
I see this more and more - LO being recommended to people who've bought
a computer with a Trial version of Office 2010 that's expired...


+1

Where is this happening?


here's one thread:
http://answers.microsoft.com/en-us/windows/forum/windows_7-windows_install/have-windows-7-on-computer-try-and-open-a-doc-and/166d698d-b3a0-4a56-9dee-1fb0aba2a3a9

By an MVP no less!

--
For unsubscribe instructions e-mail to: users+h...@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: Macro not active when the document start

2011-08-11 Thread planas
On Thu, 2011-08-11 at 11:17 +0200, Andreas Säger wrote: 

 Am 10.08.2011 09:23, toto wrote:
  I'm using macro's function and it doesn't start when the document start.
  It would start if I change the value of the variabel at the function.
  The code is to change numeric value to string. If I execute the code:
  ubah(123) the result is seratus dua puluh tiga. Any idea how to make
  the function executed when I open the document?
 
  The code is:
 
  Public Function ubah(x as currency) as String
 
 Currency is not a valid type to be used in a spreadsheet.
  From the Basic perspective all spreadsheet values are doubles or 
 string, errors are Null, empty cells are empty strings. There are no 
 date values in particular.

Subtle little gotcha, use dates/time and currencies in the spreadsheet but the 
value must be converted to a valid Basic data type.

 This function works as expected:
 Function DOUBLE(n as Double)
   DOUBLE = n *2
 End Function
 
 This function returns a text value.
 Function DOUBLE_CURR(n as Currency)
   DOUBLE_CURR = n *2
 End Function
 
 I can not reproduce the recalculation problem, though.
 Both versions of the above functions recalculate when I load the 
 document or when I modify A1 with auto-cacluation enabled.
 A1 =PI()
 =DOUBLE(A1) = 6.2832 (number)
 =DOUBLE_CURR(A1) = 6.2832 (text)
 
 



-- 
Jay Lozier
jsloz...@gmail.com

-- 
For unsubscribe instructions e-mail to: users+h...@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] How can I build only libreoffice-writer instead of whole office suite ?

2011-08-11 Thread Nuno J. Silva
On 2011-08-11, planas wrote:

 Partha,

 On Wed, 2011-08-10 at 18:07 +0530, Partha Chowdhury wrote: 

 I have successfully build libreoffice-3.3.3.1 form source.However, I 
 need office only to open and edit word documents and nothing else. So I 
 want only to build the writer part and not the whole office.I have 
 googled but have not found anything to this effect.The documentation 
 covers only building from git and not the individual parts. So is it 
 possible only to build a part of libreoffice instead of whole suite ?

 I might check out the source code,
 http://cgit.freedesktop.org/libreoffices. I am not sure what you need
 from the list.

The OP asked the list if anyone knows if it is possible to compile just
a single component, instead of the entire suite.

As so far it seems noone knows here, I'd suggest the OP to post his
question to the developers list, at least there I guess more people are
used to play with the build system.

The devs list mailman page:
http://lists.freedesktop.org/mailman/listinfo/libreoffice

There's also #libreoffice-dev at freenode (IRC).

-- 
Nuno J. Silva (aka njsg)
gopher://sdf-eu.org/1/users/njsg

-- 
For unsubscribe instructions e-mail to: users+h...@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 will not save file after sheet deleted.

2011-08-11 Thread Alexander Thurgood
Le 10/08/11 01:46, Simon Cropper a écrit :

Hi Simon,

 If I work back through the historical copies of the file, I can only
 reproduce the error in this years version. It is as if the file has
 become partially corrupted. The question is how and can it be easily fixed.
 

Use xmlpp and xmldiff (perl scripts) to compare the content.xml of each
ODS between a good (older) file and one of the recent ones where the
problem started occurring. You may find that you have some odd
difference in the two files that causes the behaviour you mention.

Alex







-- 
For unsubscribe instructions e-mail to: users+h...@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] Date Format in Writer

2011-08-11 Thread Stan Goodman
On Thursday 11 August 2011 22:40:04 planas wrote:
 Johnny
 
 On Thu, 2011-08-11 at 12:36 +0200, Johnny Rosenberg wrote:
  2011/8/11 Tom Davies tomdavie...@yahoo.co.uk:
   Hi :)
   Ahhah, great.  I prefer dashes - because after reading too much
   for too long my eyes get a bit muddled when people use / and
   dots still seem to confuse obscure Windows systems sometimes.  I
   was told that the / was the European Standard but if - are used
   in one other country then that helps me argue the case with my
   boss.
  
  I though that ”/” was the US standard… Here (Sweden) we follow the
  ISO8601, except for time. Seems like we use dots instead of colons.
 
 / with mm/dd/ is the normal US standard (sometimes mm.dd.
 because / is mis interpreted in file names). Most Americans who
 have dealt with international trade are comfortable with either US
 or ISO styles and for dates.
 
  Wish we and the rest of the world could just adapt the ISO 8601.
  There is a reason for why it was created… And personally I use it
  all the time. And of course every ”dygn” (sorry, there is no
  English translation for that word – yet…) is 24 hours, so why that
  silly 12 hour thing? If all analogue watches were made 24 hours,
  you could very easily also use it as a compass, at least when you
  can see the sun (if the hour hand point to the sun, then 24, or
  rather 0, will point to north, 6 to east, 12 to south and 18 to
  west). How can it be easier than that?
 
 When I was in elementary school we were taught a 12 hour cycle with
 AM and PM to determine if it was morning or afternoon/evening. The
 US military, I believe, uses the 24 hour clock because 0900 is
 always in the morning while evening equivalent 2100 is always in the
 evening/night, much less likely to be misunderstood.
 
  Regards
  
  Johnny Rosenberg
  ジョニー・ローゼンバーグ
  2011-08-11 12:36:51
  
   Regards from
   Tom :)
   
   
   
   
   
   From: Johnny Rosenberg gurus.knu...@gmail.com
   To: users@global.libreoffice.org
   Sent: Thu, 11 August, 2011 11:18:39
   Subject: Re: [libreoffice-users] Date Format in Writer
   
   2011/8/11  rjw...@phonecoop.coop:
   To avoid confusion between the mm.dd. and the dd.mm.
   date formats can
  
  we have the less ambiguous
  
   International
   
   It IS international, it's ISO 8601 (and also Swedish standard,
   lucky me… ;P)! Except that there should be dashes, not dots:
   -mm-dd.
   
   
   Kind regards
   
   Johnny Rosenberg
   ジョニー・ローゼンバーグ
   
   .mm.dd format included as an option (default?) in the fields
   for Writer?
   
   --
   For unsubscribe instructions e-mail to:
   users+h...@global.libreoffice.org Problems?
   
   http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscr
   ibe/
   
   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
   
   --
   For unsubscribe instructions e-mail to:
   users+h...@global.libreoffice.org Problems?
   http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubsc
   ribe/ 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
   
   --
   For unsubscribe instructions e-mail to:
   users+h...@global.libreoffice.org Problems?
   http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubsc
   ribe/ 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

There is a limit to how comfortable such people can be, living in a 
mixed envirenment and trying to juggle mm/dd/ and dd/mm/. I 
wonder how many schedules or appointments have been missed, how much 
money lost, because of misinterpreting 8/11/2011 as a date in November 
rather than one in August, or vice versa.  Not to mention applications 
that know only mm/dd/ although the OS is set for dd/mm/ (as 
here), so that one must analyse every date that is displayed.

-- 
Stan Goodman
Qiryat Tiv'on
Israel

-- 
For unsubscribe instructions e-mail to: users+h...@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] Libre Office being recommended on Microsoft Answers Forums!

2011-08-11 Thread Stan Goodman
On Friday 12 August 2011 00:22:12 planas wrote:
 On Thu, 2011-08-11 at 20:59 +0100, Gordon Burgess-Parker wrote:
  On 11/08/2011 20:43, planas wrote:
   Gordon
   
   On Thu, 2011-08-11 at 20:24 +0100, Gordon Burgess-Parker wrote:
   Yes it's true!
   I see this more and more - LO being recommended to people who've
   bought a computer with a Trial version of Office 2010 that's
   expired...
   
   +1
   
   Where is this happening?
  
  here's one thread:
  http://answers.microsoft.com/en-us/windows/forum/windows_7-windows_
  install/have-windows-7-on-computer-try-and-open-a-doc-and/166d698d-
  b3a0-4a56-9dee-1fb0aba2a3a9
  
  By an MVP no less!
 
 Priceless - getting a plug from the enemy's camp.

The logical next step is for somebody to reply to that helpful hint, and 
suggest that the fellow go the whole hog and dump his Win7 altogether.

-- 
Stan Goodman
Qiryat Tiv'on
Israel

-- 
For unsubscribe instructions e-mail to: users+h...@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] Libre Office being recommended on Microsoft Answers Forums!

2011-08-11 Thread planas
On Fri, 2011-08-12 at 01:07 +0300, Stan Goodman wrote: 

 On Friday 12 August 2011 00:22:12 planas wrote:
  On Thu, 2011-08-11 at 20:59 +0100, Gordon Burgess-Parker wrote:
   On 11/08/2011 20:43, planas wrote:
Gordon

On Thu, 2011-08-11 at 20:24 +0100, Gordon Burgess-Parker wrote:
Yes it's true!
I see this more and more - LO being recommended to people who've
bought a computer with a Trial version of Office 2010 that's
expired...

+1

Where is this happening?
   
   here's one thread:
   http://answers.microsoft.com/en-us/windows/forum/windows_7-windows_
   install/have-windows-7-on-computer-try-and-open-a-doc-and/166d698d-
   b3a0-4a56-9dee-1fb0aba2a3a9
   
   By an MVP no less!
  
  Priceless - getting a plug from the enemy's camp.
 
 The logical next step is for somebody to reply to that helpful hint, and 
 suggest that the fellow go the whole hog and dump his Win7 altogether.
 
 -- 
 Stan Goodman
 Qiryat Tiv'on
 Israel
 


+1
-- 
Jay Lozier
jsloz...@gmail.com

-- 
For unsubscribe instructions e-mail to: users+h...@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] Libre Office being recommended on Microsoft Answers Forums!

2011-08-11 Thread upscope
On Thursday, August 11, 2011 03:07:54 PM Stan Goodman wrote:
 On Friday 12 August 2011 00:22:12 planas wrote:
  On Thu, 2011-08-11 at 20:59 +0100, Gordon Burgess-Parker wrote:
   On 11/08/2011 20:43, planas wrote:
Gordon

On Thu, 2011-08-11 at 20:24 +0100, Gordon Burgess-Parker wrote:
Yes it's true!
I see this more and more - LO being recommended to people
who've bought a computer with a Trial version of Office 2010
that's expired...

+1

Where is this happening?
   
   here's one thread:
   http://answers.microsoft.com/en-us/windows/forum/windows_7-window
   s_
   install/have-windows-7-on-computer-try-and-open-a-doc-and/166d69
   8d- b3a0-4a56-9dee-1fb0aba2a3a9
   
   By an MVP no less!
  
  Priceless - getting a plug from the enemy's camp.
 
 The logical next step is for somebody to reply to that helpful hint,
 and suggest that the fellow go the whole hog and dump his Win7
 altogether.
+5 that's what I did 12 years ago when my Win ME died.
-- 
Russ

-- 
For unsubscribe instructions e-mail to: users+h...@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] minor install/config issues

2011-08-11 Thread David Ross
Installing LO 3.4.2 and a long list of add-ons (+90) had few problems than
several prior OO installs. The Extension Manager GUI stability is greatly
improved. No crashes! Yea!

Problems encountered were largely due to the EM installing (or attempting to
install) defective packages, primarily .zips. Some only vaguely resembled
an OXT package. IMO at a minimum a package that cannot be uninstalled with
standard tools, i.e.: unopkg. should be rejected.

It seems that the presence of bogus packages in the cache prevented
persistent completion of component  registration. Repeatedly, start-up
(QuickStart) and first document opening were painfully slow. Each process
consuming IO in the high tens of megabytes. 

Changing the JRE used to 6.21 produce a geometric run-time reduction.
Apparently, removing offending extensions  has allowed registration
processing to be completed and saved.

There has been a significant and stable reduction in start-up time and IO.
Opening documents after the first is fast. Subjectively much better than OO.

The platform is XP SP3 running on legacy hardware: P4 - 2 MHz, 1 GB 266MHz
DDR, PCI 133. 

No errors were reported from several invocations of unopkg validate (at
different points in the above process).

The command unopkg reinstall --shared -v produced the following message:

ERROR: cannot get file url from system path:
-env:INIFILENAME=vnd.sun.star.pathname:c:\Software\Office\Libre\v3\program\redirect.ini
Exception details:
(com.sun.star.uno.RuntimeException) { { Message = cannot get file url from
system path:
-env:INIFILENAME=vnd.sun.star.pathname:c:\\Software\\Office\\Libre\\v3\\program\\redirect.ini,
Context = (com.sun.star.uno.XInterface) @0 } }

redirect.ini has on entry: URE_BOOTSTRAP=${ORIGIN}/fundamental.ini

fundamental.ini does not have a URE_BOOTSTRAP entry. None was found in any
.ini file examined.

LanguageTool-1.4 was uninstalled. It was generating a runtime exception
about not finding a start class, locales directory not found, it couldn't
write a record because it could find saxon9-dom.jar and was reporting the
use of JRE version 17 (not installed on the system). The exception continued
after saxon9-dom.jar was added to the system class path and to LO Java
options for jre-6.21.

Do any of the issues above require corrective action? If so what needs to
done and/or where should I look for answers?

david



--
View this message in context: 
http://nabble.documentfoundation.org/minor-install-config-issues-tp3247894p3247894.html
Sent from the Users mailing list archive at Nabble.com.

-- 
For unsubscribe instructions e-mail to: users+h...@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] Calc will not save file after sheet deleted [FOLLOW-UP]

2011-08-11 Thread Simon Cropper

Hi Everyone,

I have been doing some follow-up investigations that I thought you might 
like to be made aware.


First, why? Well after testing the file that I recreated by copying the 
text, formula and styles I could not cause the error to occur again. 
This is what I reported yesterday. I then proceeded with importing the 
few images and 'artwork' objects from the old file to the new. After 
several saves and sheet manipulations I noticed the file became unstable 
again.


The outcome of my investigation was that one of the image files used on 
one of the sheets had become corrupted* and adding this file in caused 
the file to become unstable - eventually exhibiting the problem I 
mentioned about not being able to save after a sheet was deleted. These 
'corrupted' files are relatively benign with the error only becoming 
apparent *once* you attempt to delete the sheet. So somehow the error 
caused problems with the broader 'workbook' structure not the sheet 
structure. Although I compared files between different versions of the 
file the XML were too varied (usually style names and definitions; 
content was identical).


   * note I say corrupted but it rendered OK and only resulted
   in the observed behaviour one a sheet is deleted. I 'deem' it
   corrupted as once replaced with a clean version render and
   saved as a new file by GIMP, the problem disappeared.

The error was with the particular corrupt objects. On recreating new 
images and inserting them into a file I have not been able to trigger 
any problems. If I cut-and-paste from the original 'corrupt' file the 
file becomes unstable after a few saves and sheet manipulations.


So the steps for salvage is...
1. recreate a new file with the exact number of sheets as the original. 
Ensure each sheet names are the same.
2. Cut and Paste each sheet. Make sure you 'Paste special' limiting the 
content being placed in the new file to text, numbers, date  time, 
formulas and formats.
3. If you have images in the file. Recreate / Save using another 
package. As mentioned I used GIMP.
4. Insert new copies of the images into file. *Don't* cut-and-paste 
objects from the old file.

5. If you have any lines, text boxes and artwork; recreate them from new.

During this process...
- Save as a new version (+tabs, +data, +images, +other objects) 
following each step.

- Test each version thoroughly before proceeding.
- Only add one object at a time, so if something goes wrong you can 
isolate the problem component.

- To check it is not a bug try and recreate with a fresh file.

A couple of quick notes that may be valuable to others...
- ODS files are archives. Use an archive facility to extract the data 
inside. Inspect the contents in the folders to see what is different.
- On every 'Save as' the file size changes. This is not due to changes 
in the file contents, but rather in changes in how the components of the 
file is compressed/archived. If you open a file, add objects then save, 
the file size with be so big. Open that file and Save as a new name 
and the file will be a different size. If you extract the files the 
contents of all the files and directories are identical. It is just the 
internal archive facility in LO will decide the best compaction routine 
based on what it encounters.
- The content.xml file can be quite large and has no internal 
end-of-line characters. This make it difficult to open and be parse by 
various text editors, xml viewers and comparison facilities. To insert a 
EOL character after the end of each tag (i.e. ), I used the following 
command in the terminal (requires Linux).


   cat content.xml | sed -e 's//\n/g'  content_with_linebreaks.xml

   cat just spews the content of the text file to the standard output.
   I then pipe it to sed, where I used regular expressions to find ''
   and replace every instance of it with '\n'. I then compared the
   contents with Diffuse.


On 11/08/11 14:44, jorge wrote:

Congratulations,... it was an interesting investigation.

Regards,

Jorge Rodríguez
__

El jue, 11-08-2011 a las 11:50 +1000, Simon Cropper escribió:

On 10/08/11 16:41, Simon Cropper wrote:

*The upshot*

Unless someone recognised these symptoms and can put forward some ideas,
I am treating this as a corrupt file. I have drawn this conclusion
because (a) I can only reproduce the error on the effected file, (b) the
comment insert/delete trick is suggestive but not consistent (or at
least from what I can tell) - random sheets cause the file save error if
comments are inserted; inserting comments into new sheets also trigger
the error.

I just hope that recreating this file does not corrupt the new file as I
will need to copy blocks of text, numbers and formulas.



  *My attempts at recreating a clean file*

ATTEMPT 1

Created a new file with one less tab. All tabs were named the same as
the original. I then cut-and-paste all the data from the original to
this newly created file. This took about 10 

Re: [libreoffice-users] Date Format in Writer

2011-08-11 Thread Brian Barker

At 10:11 11/08/2011 +0100, R J Weir wrote:
To avoid confusion between the mm.dd. and the dd.mm. date 
formats can we have the less ambiguous International .mm.dd 
format included as an option (default?) in the fields for Writer?


Isn't it already there?

When entering a new field:
o  Go to Insert | Fields  | Other... | Document.
o  Under Type select Date and make the appropriate choice under Select.
o  Under Format, you can select 1999-12-31.  (As has already been 
suggested, the international format uses hyphens, in fact, not dots.)
o  Alternatively, if you prefer the dots, under Format select 
Additional formats...; in the Number Format dialogue, under Format 
code, enter .MM.DD.


If you have an existing date field you need to modify, either go to 
right-click | Fields... or put the cursor in front of the date field 
and go to Edit | Fields... in order to reach the same dialogues and options.


Note that the default date format depends on the language of your 
text at that point - and the default language is that set at Tools | 
Options... | Language Settings | Languages | Default languages for 
documents | Western.


I trust this helps.

Brian Barker


--
For unsubscribe instructions e-mail to: users+h...@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] Calc will not save file after sheet deleted [FOLLOW-UP]

2011-08-11 Thread jorge
Hi

I'm some confused. Was the comment or the image the problem ? or Both ?

Regards,

Jorge Rodríguez
_


El vie, 12-08-2011 a las 13:52 +1000, Simon Cropper escribió:
 Hi Everyone,
 
 I have been doing some follow-up investigations that I thought you might 
 like to be made aware.
 
 First, why? Well after testing the file that I recreated by copying the 
 text, formula and styles I could not cause the error to occur again. 
 This is what I reported yesterday. I then proceeded with importing the 
 few images and 'artwork' objects from the old file to the new. After 
 several saves and sheet manipulations I noticed the file became unstable 
 again.
 
 The outcome of my investigation was that one of the image files used on 
 one of the sheets had become corrupted* and adding this file in caused 
 the file to become unstable - eventually exhibiting the problem I 
 mentioned about not being able to save after a sheet was deleted. These 
 'corrupted' files are relatively benign with the error only becoming 
 apparent *once* you attempt to delete the sheet. So somehow the error 
 caused problems with the broader 'workbook' structure not the sheet 
 structure. Although I compared files between different versions of the 
 file the XML were too varied (usually style names and definitions; 
 content was identical).
 
 * note I say corrupted but it rendered OK and only resulted
 in the observed behaviour one a sheet is deleted. I 'deem' it
 corrupted as once replaced with a clean version render and
 saved as a new file by GIMP, the problem disappeared.
 
 The error was with the particular corrupt objects. On recreating new 
 images and inserting them into a file I have not been able to trigger 
 any problems. If I cut-and-paste from the original 'corrupt' file the 
 file becomes unstable after a few saves and sheet manipulations.
 
 So the steps for salvage is...
 1. recreate a new file with the exact number of sheets as the original. 
 Ensure each sheet names are the same.
 2. Cut and Paste each sheet. Make sure you 'Paste special' limiting the 
 content being placed in the new file to text, numbers, date  time, 
 formulas and formats.
 3. If you have images in the file. Recreate / Save using another 
 package. As mentioned I used GIMP.
 4. Insert new copies of the images into file. *Don't* cut-and-paste 
 objects from the old file.
 5. If you have any lines, text boxes and artwork; recreate them from new.
 
 During this process...
 - Save as a new version (+tabs, +data, +images, +other objects) 
 following each step.
 - Test each version thoroughly before proceeding.
 - Only add one object at a time, so if something goes wrong you can 
 isolate the problem component.
 - To check it is not a bug try and recreate with a fresh file.
 
 A couple of quick notes that may be valuable to others...
 - ODS files are archives. Use an archive facility to extract the data 
 inside. Inspect the contents in the folders to see what is different.
 - On every 'Save as' the file size changes. This is not due to changes 
 in the file contents, but rather in changes in how the components of the 
 file is compressed/archived. If you open a file, add objects then save, 
 the file size with be so big. Open that file and Save as a new name 
 and the file will be a different size. If you extract the files the 
 contents of all the files and directories are identical. It is just the 
 internal archive facility in LO will decide the best compaction routine 
 based on what it encounters.
 - The content.xml file can be quite large and has no internal 
 end-of-line characters. This make it difficult to open and be parse by 
 various text editors, xml viewers and comparison facilities. To insert a 
 EOL character after the end of each tag (i.e. ), I used the following 
 command in the terminal (requires Linux).
 
 cat content.xml | sed -e 's//\n/g'  content_with_linebreaks.xml
 
 cat just spews the content of the text file to the standard output.
 I then pipe it to sed, where I used regular expressions to find ''
 and replace every instance of it with '\n'. I then compared the
 contents with Diffuse.
 
 
 On 11/08/11 14:44, jorge wrote:
  Congratulations,... it was an interesting investigation.
 
  Regards,
 
  Jorge Rodríguez
  __
 
  El jue, 11-08-2011 a las 11:50 +1000, Simon Cropper escribió:
  On 10/08/11 16:41, Simon Cropper wrote:
  *The upshot*
 
  Unless someone recognised these symptoms and can put forward some ideas,
  I am treating this as a corrupt file. I have drawn this conclusion
  because (a) I can only reproduce the error on the effected file, (b) the
  comment insert/delete trick is suggestive but not consistent (or at
  least from what I can tell) - random sheets cause the file save error if
  comments are inserted; inserting comments into new sheets also trigger
  the error.
 
  I just hope that recreating this file does not corrupt the new file as I
  will need 

Re: [libreoffice-users] Calc will not save file after sheet deleted [FOLLOW-UP]

2011-08-11 Thread planas
On Fri, 2011-08-12 at 13:52 +1000, Simon Cropper wrote: 

 Hi Everyone,
 
 I have been doing some follow-up investigations that I thought you might 
 like to be made aware.
 
 First, why? Well after testing the file that I recreated by copying the 
 text, formula and styles I could not cause the error to occur again. 
 This is what I reported yesterday. I then proceeded with importing the 
 few images and 'artwork' objects from the old file to the new. After 
 several saves and sheet manipulations I noticed the file became unstable 
 again.
 
 The outcome of my investigation was that one of the image files used on 
 one of the sheets had become corrupted* and adding this file in caused 
 the file to become unstable - eventually exhibiting the problem I 
 mentioned about not being able to save after a sheet was deleted. These 
 'corrupted' files are relatively benign with the error only becoming 
 apparent *once* you attempt to delete the sheet. So somehow the error 
 caused problems with the broader 'workbook' structure not the sheet 
 structure. Although I compared files between different versions of the 
 file the XML were too varied (usually style names and definitions; 
 content was identical).
 
 * note I say corrupted but it rendered OK and only resulted
 in the observed behaviour one a sheet is deleted. I 'deem' it
 corrupted as once replaced with a clean version render and
 saved as a new file by GIMP, the problem disappeared.
 
 The error was with the particular corrupt objects. On recreating new 
 images and inserting them into a file I have not been able to trigger 
 any problems. If I cut-and-paste from the original 'corrupt' file the 
 file becomes unstable after a few saves and sheet manipulations.
 
 So the steps for salvage is...
 1. recreate a new file with the exact number of sheets as the original. 
 Ensure each sheet names are the same.
 2. Cut and Paste each sheet. Make sure you 'Paste special' limiting the 
 content being placed in the new file to text, numbers, date  time, 
 formulas and formats.
 3. If you have images in the file. Recreate / Save using another 
 package. As mentioned I used GIMP.
 4. Insert new copies of the images into file. *Don't* cut-and-paste 
 objects from the old file.
 5. If you have any lines, text boxes and artwork; recreate them from new.
 
 During this process...
 - Save as a new version (+tabs, +data, +images, +other objects) 
 following each step.
 - Test each version thoroughly before proceeding.
 - Only add one object at a time, so if something goes wrong you can 
 isolate the problem component.
 - To check it is not a bug try and recreate with a fresh file.
 
 A couple of quick notes that may be valuable to others...
 - ODS files are archives. Use an archive facility to extract the data 
 inside. Inspect the contents in the folders to see what is different.
 - On every 'Save as' the file size changes. This is not due to changes 
 in the file contents, but rather in changes in how the components of the 
 file is compressed/archived. If you open a file, add objects then save, 
 the file size with be so big. Open that file and Save as a new name 
 and the file will be a different size. If you extract the files the 
 contents of all the files and directories are identical. It is just the 
 internal archive facility in LO will decide the best compaction routine 
 based on what it encounters.
 - The content.xml file can be quite large and has no internal 
 end-of-line characters. This make it difficult to open and be parse by 
 various text editors, xml viewers and comparison facilities. To insert a 
 EOL character after the end of each tag (i.e. ), I used the following 
 command in the terminal (requires Linux).
 
 cat content.xml | sed -e 's//\n/g'  content_with_linebreaks.xml
 
 cat just spews the content of the text file to the standard output.
 I then pipe it to sed, where I used regular expressions to find ''
 and replace every instance of it with '\n'. I then compared the
 contents with Diffuse.
 

Snip

+1

I wonder how the images got corrupted, interesting. 



 Cheers Simon
 
 Simon Cropper
 Principal Consultant
 Botanicus Australia Pty Ltd
 PO Box 160, Sunshine, VIC
 W: www.botanicusaustralia.com.au
 



-- 
Jay Lozier
jsloz...@gmail.com

-- 
For unsubscribe instructions e-mail to: users+h...@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 Calc: Format column titles in DataPilot

2011-08-11 Thread jorge
Hi

Thank you, I understand now. I used it as you say and I could modify
all the headers (The first Column included), but the data headers (Where
the sum, average or other calcs are), change to its original formats
when the pilot data is refreshed (The first column header and Data Title
keep its format changed.

Regards,

Jorge Rodríguez

_


El jue, 11-08-2011 a las 11:24 +0200, Andreas Säger escribió:
 Am 11.08.2011 01:28, jorge wrote:
  Hi
 
  I'm sorry but I made an example with Style and the first column header
  (Title) wasn't changed. Besides, I refreshed the pilot table and lost
  the headers format. 
 
  What did I wrong ?
 
 
 The pilot uses one distinct set of automatically generated styles. For 
 column headers in the English GUI the style is named DataPilot_Category.
 When the pilot is rebuilt on refresh, all formatting falls back to that 
 style.
 - Application of some other style will be reset to DataPilot_Category.
 - Hard attributes will be reset to the bare DataPilot_Category settings.
 - Modifying DataPilot_Category itself will format both, row headers 
 and column headers.
 
 

-- 
Atentamente,

Jorge Rodríguez


-- 
For unsubscribe instructions e-mail to: users+h...@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] Date Format in Writer

2011-08-11 Thread nvrk
FWIW -  I prefer mmmdd or ddmmm where the 'm' is alphabetic; -
unambiguous!
nvsoar

On Thu, Aug 11, 2011 at 1:46 PM, Stan Goodman stan.good...@hashkedim.comwrote:

 On Thursday 11 August 2011 22:40:04 planas wrote:
  Johnny
 
  On Thu, 2011-08-11 at 12:36 +0200, Johnny Rosenberg wrote:
   2011/8/11 Tom Davies tomdavie...@yahoo.co.uk:
Hi :)
Ahhah, great.  I prefer dashes - because after reading too much
for too long my eyes get a bit muddled when people use / and
dots still seem to confuse obscure Windows systems sometimes.  I
was told that the / was the European Standard but if - are used
in one other country then that helps me argue the case with my
boss.
  
   I though that ”/” was the US standard… Here (Sweden) we follow the
   ISO8601, except for time. Seems like we use dots instead of colons.
 
  / with mm/dd/ is the normal US standard (sometimes mm.dd.
  because / is mis interpreted in file names). Most Americans who
  have dealt with international trade are comfortable with either US
  or ISO styles and for dates.
 
   Wish we and the rest of the world could just adapt the ISO 8601.
   There is a reason for why it was created… And personally I use it
   all the time. And of course every ”dygn” (sorry, there is no
   English translation for that word - yet…) is 24 hours, so why that
   silly 12 hour thing? If all analogue watches were made 24 hours,
   you could very easily also use it as a compass, at least when you
   can see the sun (if the hour hand point to the sun, then 24, or
   rather 0, will point to north, 6 to east, 12 to south and 18 to
   west). How can it be easier than that?
 
  When I was in elementary school we were taught a 12 hour cycle with
  AM and PM to determine if it was morning or afternoon/evening. The
  US military, I believe, uses the 24 hour clock because 0900 is
  always in the morning while evening equivalent 2100 is always in the
  evening/night, much less likely to be misunderstood.
 
   Regards
  
   Johnny Rosenberg
   ジョニー・ローゼンバーグ
   2011-08-11 12:36:51
  
Regards from
Tom :)
   
   
   
   

From: Johnny Rosenberg gurus.knu...@gmail.com
To: users@global.libreoffice.org
Sent: Thu, 11 August, 2011 11:18:39
Subject: Re: [libreoffice-users] Date Format in Writer
   
2011/8/11  rjw...@phonecoop.coop:
To avoid confusion between the mm.dd. and the dd.mm.
date formats can
   
   we have the less ambiguous
   
International
   
It IS international, it's ISO 8601 (and also Swedish standard,
lucky me… ;P)! Except that there should be dashes, not dots:
-mm-dd.
   
   
Kind regards
   
Johnny Rosenberg
ジョニー・ローゼンバーグ
   
.mm.dd format included as an option (default?) in the fields
for Writer?
   
--
For unsubscribe instructions e-mail to:
users+h...@global.libreoffice.org Problems?
   
http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscr
ibe/
   
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
   
--
For unsubscribe instructions e-mail to:
users+h...@global.libreoffice.org Problems?
http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubsc
ribe/ 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
   
--
For unsubscribe instructions e-mail to:
users+h...@global.libreoffice.org Problems?
http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubsc
ribe/ 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

 There is a limit to how comfortable such people can be, living in a
 mixed envirenment and trying to juggle mm/dd/ and dd/mm/. I
 wonder how many schedules or appointments have been missed, how much
 money lost, because of misinterpreting 8/11/2011 as a date in November
 rather than one in August, or vice versa.  Not to mention applications
 that know only mm/dd/ although the OS is set for dd/mm/ (as
 here), so that one must analyse every date that is displayed.

 --
 Stan Goodman
 Qiryat Tiv'on
 Israel

 --
 For unsubscribe instructions e-mail to: users+h...@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