Re: [libreoffice-users] spreadsheets / timelines ... + queries

2012-07-15 Thread Tom Davies
Hi :) (2)  The 'buttons' are not really proper buttons.  http://www.libreoffice.org/download/ You have to click on the appropriate text inside the button/block.  Sometimes a 'button' has a couple of different links that do slightly different things.  It would be awkward to have a 3way button

[libreoffice-users] Mac Fonts

2012-07-15 Thread Joe Artichoke
New fonts that I have downloaded that are in my Fontbook on the Mac aren't showing up in the LibreOffice list of fonts. -- 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

[libreoffice-users] lo 3.5.5

2012-07-15 Thread Sharon Kimble
i've just installed almost successfully libreoffice 3.5.5 except i installed the helppack before the language pack. consequently my desktop integration is mixed up with missing shortcuts in the menu. how do i get them back please? At the moment i have to open calc before opening writer, so how do

Re: [libreoffice-users] lo 3.5.5

2012-07-15 Thread webmaster-Kracked_P_P
On 07/15/2012 07:10 AM, Sharon Kimble wrote: i've just installed almost successfully libreoffice 3.5.5 except i installed the helppack before the language pack. consequently my desktop integration is mixed up with missing shortcuts in the menu. how do i get them back please? At the moment i

Re: [libreoffice-users] lo 3.5.5

2012-07-15 Thread Sharon Kimble
If you read the whole message you would have seen in the signature that i'm using debian 6.0.5. sudo dpkg -i *.deb i've tried using apt-get and am unable to uninstall. Atm, its working though. English GB, and helppack english GB Thanks Sharon. On 15/07/2012, webmaster-Kracked_P_P

Re: [libreoffice-users] lo 3.5.5

2012-07-15 Thread Jay Lozier
On 07/15/2012 10:00 AM, Sharon Kimble wrote: If you read the whole message you would have seen in the signature that i'm using debian 6.0.5. sudo dpkg -i *.deb i've tried using apt-get and am unable to uninstall. Atm, its working though. English GB, and helppack english GB Thanks Sharon. You

Re: [libreoffice-users] lo 3.5.5

2012-07-15 Thread Sharon Kimble
Thanks Jay, I was able to completely remove it with synaptic, which I've never used before. However, on re installation, properly this time, I've only got menu shortcuts for calc, impress, and printer administration, so there appears to be some bug still in the debian-menus-desktop-integration

Re: [libreoffice-users] lo 3.5.5

2012-07-15 Thread webmaster-Kracked_P_P
I would remove all traces of LO with Synaptic and any OpenOffice stuff as well. I know Ubuntu's Synaptic shows some. Also it tends to show the older version of LO when I thought I removed them with other ways. Then do the dpkg again. Do the desktop-integration first, then add the language

[libreoffice-users] Re: lo 3.5.5

2012-07-15 Thread Andreas Säger
Am 15.07.2012 13:10, Sharon Kimble wrote: i've just installed almost successfully libreoffice 3.5.5 except i installed the helppack before the language pack. consequently my desktop integration is mixed up with missing shortcuts in the menu. how do i get them back please? At the moment i have

Re: [libreoffice-users] lo 3.5.5

2012-07-15 Thread Jay Lozier
On 07/15/2012 12:52 PM, Sharon Kimble wrote: Thanks Jay, I was able to completely remove it with synaptic, which I've never used before. However, on re installation, properly this time, I've only got menu shortcuts for calc, impress, and printer administration, so there appears to be some bug

[libreoffice-users] Unexpected behavior while writing Calc Functions

2012-07-15 Thread Andrew Douglas Pitonyak
I wrote a simple function Function mydate As Date mydate = CDate(100) End Function I then called this function from a Calc document =myDate() Finally, I directly accessed the cells with the dates from a macro similar to the following code: Print

[libreoffice-users] CALC-Need an easier way to do the following -

2012-07-15 Thread dave_
Col A-O; ROWS 15 Input value in a1 only. The rest should look like the following (or see attached file) http://nabble.documentfoundation.org/file/n3995670/Double_Number_Series.ods Double_Number_Series.ods starting at a1 1,1,2,2,3,3,4,4,5,5,6,6,7,7,8 8,9,9,10,10,11,11,12,12,13,13,14,14,15,15

[libreoffice-users] Compose key is being ignored

2012-07-15 Thread J.A. de Vries
Hi all, Recently I moved from using the version of LibreOffice supplied by my package manager (aptitude) to the one provided on the LibreOffice website (currently I am running 3.5.4). So far all is well, but I noticed one difference that I'd really like to change. I've set up Capslock to be used

[libreoffice-users] Re: CALC-Need an easier way to do the following -

2012-07-15 Thread Andreas Säger
Vertically: =A1+MOD(ROW(A1);2) Horizontally: =A1+MOD(COLUMN(A1);2) -- View this message in context: http://nabble.documentfoundation.org/CALC-Need-an-easier-way-to-do-the-following-tp3995670p3995675.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions

Re: [libreoffice-users] CALC-Need an easier way to do the following -

2012-07-15 Thread Brian Barker
At 15:25 15/07/2012 -0700, Dave Wagner wrote: Col A-O; ROWS 15 Input value in a1 only. The rest should look like the following [...] starting at a1 1,1,2,2,3,3,4,4,5,5,6,6,7,7,8 8,9,9,10,10,11,11,12,12,13,13,14,14,15,15 16,16,... and so on. Is there an easier way to do this, than the way I

Re: [libreoffice-users] Re: CALC-Need an easier way to do the following -

2012-07-15 Thread Brian Barker
At 15:59 15/07/2012 -0700, Andreas Säger wrote: Vertically: =A1+MOD(ROW(A1);2) Horizontally: =A1+MOD(COLUMN(A1);2) Do you perhaps mean: Vertically: =A1+MOD(ROW(A1)-1;2) Horizontally: =A1+MOD(COLUMN(A1)-1;2) Brian Barker -- For unsubscribe instructions e-mail to:

Re: [libreoffice-users] Compose key is being ignored

2012-07-15 Thread Mirosław Zalewski
On 16/07/2012 at 00:26, J.A. de Vries hdv.ja...@gmail.com wrote: Can anyone advise me on how to fix this behavior? I could not reproduce your issue. I am using Debian testing, amd64, KDE 4.8.4. I have installed LO 3.5.5 downloaded from LO page, run it and compose key (which is right-Ctrl

[libreoffice-users] BASIC Runtime Errors

2012-07-15 Thread Stephen Leibowitz
I am trying to convert an Excel 2003 VBA macro to LibO. I have fixed the few syntax problems. The heart of the conversion effort will be in dealing with the two very different APIs. My preference is to Open the Excel xla file in Calc and have it run until the first runtime error, which I would

[libreoffice-users] Re: CALC-Need an easier way to do the following -

2012-07-15 Thread dave_
To Andreas and Brian, Thanks for both of your quick responses. It was just what I needed. -- View this message in context: http://nabble.documentfoundation.org/CALC-Need-an-easier-way-to-do-the-following-tp3995670p3995698.html Sent from the Users mailing list archive at Nabble.com. -- For

Re: [libreoffice-users] Re: Unexpected behavior while writing Calc Functions

2012-07-15 Thread Andrew Douglas Pitonyak
On 07/15/2012 06:52 PM, Andreas Säger wrote: Calc does not know any dates nor times. It's all about doubles and text. -- View this message in context: http://nabble.documentfoundation.org/Unexpected-behavior-while-writing-Calc-Functions-tp3995669p3995674.html Sent from the Users mailing list

Re: [libreoffice-users] BASIC Runtime Errors

2012-07-15 Thread Andrew Douglas Pitonyak
On 07/15/2012 11:07 PM, Stephen Leibowitz wrote: I am trying to convert an Excel 2003 VBA macro to LibO. I have fixed the few syntax problems. The heart of the conversion effort will be in dealing with the two very different APIs. My preference is to Open the Excel xla file in Calc and have it