Re: [libreoffice-users] Macro to write a formula

2013-02-08 Thread Rolf Lochbühler
You're probably looking for something like this: Public Sub insertFormula ThisComponent.CurrentSelection.Formula = =TODAY() End Sub -rl Am 2013-02-07 um 21:06 schrieb T. R. Valentine trvalent...@gmail.com: Is it possible? If so, coiuld I get a simple example, something like =TODAY() to

Re: [libreoffice-users] OOSheet for Python: How to create a function that can be called from within a cell?

2013-01-20 Thread Rolf Lochbühler
If you search for python uno you'll find some documentation that may help. One of the first hits is http://www.openoffice.org/udk/python/python-bridge.html, where you will find an extension python-tokencounter-calc-addin.oxt that seems to define a Calc function named tokencount(). Since .oxt

Re: [libreoffice-users] Insert the filename in a cell

2012-10-20 Thread Rolf Lochbühler
The following two Basic macros FILENAME() and FILEPATH() may help. ~ Option Explicit Option VBASupport 1 ' Enables InStrRev() ' Returns file name including extension. Public Function FILENAME() As String Dim u As String Dim i As Long u = ConvertFromURL( ThisComponent.Url ) i =

Re: [libreoffice-users] Integer part of a number

2012-10-14 Thread Rolf Lochbühler
could anyone tell me which formula I should use for the integer part of a cell to be shown in another cell, The function you're probably looking for is INT(). Example: A1: 0.77 B1: =INT(A1) → 0 C1: =A1*2 → 1.54 D1: =B1*2 → 0 and for the value of this cell to be changed,

Re: [libreoffice-users] function concatenate

2012-10-11 Thread Rolf Lochbühler
Not sure if there's a way to do that with functions. How about this Basic macro? ~ Option Explicit Public Function CONCAT( ByRef rng As Variant ) As String Dim i, k As Long CONCAT = For i = 1 To UBound( rng(), 1 ) For k = 1 To UBound( rng(), 2 )

Re: [libreoffice-users] Help request on CALC charts' features

2012-10-07 Thread Rolf Lochbühler
1. The full worksheet as chart in excel are converted to embedded charts in those sheets (no full charts). I don't think that feature is available in Calc. However, you may move your chart (by cut and paste) onto a separate sheet, of course. 2. Legends are peculiar. They are named as

Re: [libreoffice-users] Serious memory issues in Calc

2011-04-04 Thread Rolf
Am 04.04.2011 um 01:31 schrieb Stefan Th. Gries: ... For a research project, I needed to handle a large tab-separated text file with 6 columns and approximately 60 rows (approx. 85MB as txt, about 35.7MB as ods). This raised the following problems: ... You could use gawk, sed, perl, or

[libreoffice-users] Re: more errors, libreoffice on amd64 debian, starts now but immediately aborts.

2011-01-14 Thread Rolf Gloor
no stable version available). The installation went fine and it works fine. Did just a few small test, since I am still dual booting. Main System presently still WinXP. So for me, official openSUSE x86_64 repository is working. Regards, Rolf -- Unsubscribe instructions: E-mail to users+h

[libreoffice-users] Re: Linux Distros using LO?

2011-01-10 Thread Rolf Gloor
/LibreOffice:/Unstable/ Greetings from Switzerland, Rolf -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***

[libreoffice-users] Re: Survey: Usage of LibreOffice components

2010-11-30 Thread Rolf Gloor
Am 30.11.2010 09:47, schrieb Arda Tunccekic: Maybe Quickstarter was usefull with the slow loading StarOffice suite, but OO and LO already load up pretty quick. And no one uses it here as I see. I don't use it too. I think it would be switched off by default or removed.. I actually am not