Fwd: [libreoffice-users] Value and Date function in Macro

2013-02-10 Thread Johnny Rosenberg
7;t think my reply will spread some new light to this question, but I'll send it anyway. Maybe someone find it useful in some strange way that I can't figure out right now… Anyway, here it is, this time sent to the list and nowhere else: -- Forwarded message -- From: John

[libreoffice-users] How to select a background image?

2013-08-27 Thread Johnny Rosenberg
In Calc I inserted an image (svg). Then right clicked the image and placed it in the background. After that I did some further editing that I don't want to get rid of. Now I want to edit the image but I can no longer select it since it is located in the background! What now…? Johnny Rose

Re: [libreoffice-users] Can't print basic macro code

2013-09-09 Thread Johnny Rosenberg
page is blank with no code printed. >> >> I can of course cut and paste to another editor, but I wonder if anyone >> else sees this or maybe I am doing something wrong? >> >> Regards, Jim >> > As a workaround, you could save the macro as

Re: [libreoffice-users] macro to search and replace from a table?

2013-10-16 Thread Johnny Rosenberg
2013/10/16 T. R. Valentine > I want to do a Romanization of a text. What does that mean (sorry if that's a stupid question)? Johnny Rosenberg > I know I can write a (lengthy!) > macro to look for each possible character and substitute accordingly, > but was wonderi

Re: [libreoffice-users] Macro issue

2013-10-22 Thread Johnny Rosenberg
ort 1” has something to do with it? Johnny Rosenberg > > Since the statements are so simple this time i wonder if it just needs some > tweaking or needs to be copy&pasted into a fresh new macro or something? > Hopefully someone on this list will be able to give you a much bett

Fwd: [libreoffice-users] malfunzione

2014-01-26 Thread Johnny Rosenberg
Forgot the Reply To All thing again, sorry. -- Forwarded message -- From: Johnny Rosenberg Date: 2014-01-25 Subject: Re: [libreoffice-users] malfunzione To: italo.vign...@gmail.com 2014/1/24 Italo Vignoli > La lingua ufficiale della lista a cui ha scritto è l'inglese

Re: [libreoffice-users] Keyboard shortcuts

2014-02-18 Thread Johnny Rosenberg
the ”normal underline function” is defined exactly there, so you didn't override it, you changed it. Or do you mean that the LibreOffice Customise dialogue box changed the underline functions in other programs too, such as gnote or whatever? Johnny Rosenberg > > Before switching bac

Re: [libreoffice-users] HOW CAN I CONVERT A NUMBER IN LibreOffice CALC TO TEXT IN LibreOffice CALC?

2014-02-22 Thread Johnny Rosenberg
>> > Cristi > >> > > >> > > >> > On 21/02/2014 09:55, Dennis Regan wrote: > >> >> > >> >> MY EMAIL ADDRESS IS: dennispreg...@hotmail.com > >> >> > >> >> DEAR SIR OR MS., > >> >>

Re: [libreoffice-users] HOW CAN I CONVERT A NUMBER IN LibreOffice CALC TO TEXT IN LibreOffice CALC?

2014-02-22 Thread Johnny Rosenberg
2014-02-22 21:32 GMT+01:00 Paul : > > Off topic, but I'm just so surprised that nobody complained about > > shouting (using upper case letters)… and about top posting. > > > > > > Johnny Rosenberg > > Well, as to the shouting, I guess I kind of assumed the

Re: [libreoffice-users] HOW CAN I CONVERT A NUMBER IN LibreOffice CALC TO TEXT IN LibreOffice CALC?

2014-02-23 Thread Johnny Rosenberg
ch cleaner and easier to read >> than even top-posting, mainly because you can clearly see the full context). >> >> You can make everyone angry and happy by doing both. Place your entire > message at both the top and the bottom :-) > And in-line. The angrier the better

Re: [libreoffice-users] HOW CAN I CONVERT A NUMBER IN LibreOffice CALC TO TEXT IN LibreOffice CALC?

2014-02-23 Thread Johnny Rosenberg
2014-02-23 18:05 GMT+01:00 Tanstaafl : > On 2014-02-23 10:40 AM, Johnny Rosenberg wrote: > >> I don't use an email client, but the Gmail web interface also hides lines >> from previous posts. >> > > Lol! Thanks for the laugh Johnny... > Don't thank m

Re: [libreoffice-users] Libreoffice 4 corrupting Calc files

2014-03-02 Thread Johnny Rosenberg
probably not the solution you are looking for, I just wanted to say that you are probably not the only one who had this problem, but I'm not 100% sure it's the same bug. Johnny Rosenberg > > > > -- > Jerry Van Brimmer > > -- > To unsubscribe e-mail to: use

Re: [libreoffice-users] MSO for iPad, big deal or big yawn

2014-04-03 Thread Johnny Rosenberg
About running Apache OpenOffice or LibreOffice on Android devices: Wouldn't it, in theory at least, be possible to run both of them if you first install Ubuntu on your Android device? I know, then it's not Android any more, but still… Johnny Rosenberg -- To unsubscribe e-mail

Re: [libreoffice-users] Which components do you use most?

2014-05-15 Thread Johnny Rosenberg
I don't have a clue, but I guess something like this: Calc 998 ‰ Draw 1 ‰ Math ⅔ ‰ Writer ⅓ ‰ Base 0 ‰ Impress 0 ‰ But, as I said, I have no clue. Maybe it's even more Calc and less of the others. Johnny Rosenberg -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.or

[libreoffice-users] Fatal error when exporting a dialogue.

2014-10-19 Thread Johnny Rosenberg
could just start all over again and create a new one, but I want to know (if possible) what's wrong with the one I already have. Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-he

[libreoffice-users] Is there a way for a Basic macro to detect what application is running it?

2014-10-19 Thread Johnny Rosenberg
the web, but so far nothing. Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundatio

[libreoffice-users] Another spreadsheet destroyed.

2014-10-22 Thread Johnny Rosenberg
2.6.3. Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive:

Re: [libreoffice-users] Another spreadsheet destroyed.

2014-10-24 Thread Johnny Rosenberg
2014-10-24 11:57 GMT+02:00 James E Lang : > Pardon my ignorance. What do you mean when you speak of dialogues in LO > Calc? > Tools → Macros → Organise macros → LibreOffice Basic → (Select something) → Edit → Insert Basic Dialog Johnny Rosenberg > > -- > Jim > &g

[libreoffice-users] Styles mess

2014-10-26 Thread Johnny Rosenberg
e I did something wrong but I lack more ideas what to look for, so any kind of idea is welcome. Thanks in advance! If someone wants the file for testing, let me know. I guess I can't attach it to this message anyway, so I won't even try that. Kind regards Johnny Rosenber

Re: [libreoffice-users] [BASIC]: Timer() function only has resolution of 1 second

2011-04-14 Thread Johnny Rosenberg
Sub ExampleWait Dim lTick As Double lTick = GetSystemTicks() wait 2000 lTick = (GetSystemTicks() - lTick) MsgBox "" & lTick & " Ticks" ,0,"Pausen varade i" End Sub Seems like one tick is one millisecond, at least o

Re: [libreoffice-users] Re: [BASIC]: Timer() function only has resolution of 1 second

2011-04-17 Thread Johnny Rosenberg
fre 2011-04-15 klockan 05:11 -0700 skrev Jack: > Johnny Rosenberg wrote: > > > > > > GetSystemTicks() > > > > > > Ah, ok. Thanks for the suggestion. > > > Johnny Rosenberg wrote: > > > > > > Seems like one tick is o

Re: [libreoffice-users] Swedish Grammar Check

2011-04-21 Thread Johnny Rosenberg
enOffice.org nor LibreOffice, but I think there is some kind of work going on. -- Vänliga hälsningar Johnny Rosenberg -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.

Re: [libreoffice-users] [Feature Request] Calc cell format for bytes

2011-05-05 Thread Johnny Rosenberg
ase 'b' as bit and upper case 'B' as Byte > 3. Recognize KB as KiloByte (x1000) and KiB as KibiByte (x1024) > K≠kilo, but k=kilo. I think most of those who type KB means K as in 1024, not 1000, but since there is Kibi for that, K should be obsolete, shouldn't it? At

Re: [libreoffice-users] [Feature Request] Calc cell format for bytes

2011-05-06 Thread Johnny Rosenberg
a sum function, add the option to choose the display >> meter >> (so when the sum is 2,040 KiloBytes, I can choose to display 1.9 MiB or >> 2,040 KiB) >> >> Thanks for the good job >> Yehuda >> >> It might sound strange, but I didn't realise that Ko

Re: [libreoffice-users] how to export macros

2011-05-08 Thread Johnny Rosenberg
y the other way around on the other machine. You can also copy macros to one file per macro. The file will be a pure text file and you can load it back on the other machine. You can also export dialogues to text files (xml), but so far I didn't find a way to import them. Hopefully someone

Re: [libreoffice-users] tabs in LibreOffice - like you can do for MS-Word?

2011-05-27 Thread Johnny Rosenberg
+Alt+←. But if you really want this, you could file a ”bug report” about it. Yes, it's not a bug, but you can also wish for enhancements there. Best regards Johnny Rosenberg ジョニー・ローゼンバーグ > I just wish she would get her ""story" straight since she promotes open > source o

Re: [libreoffice-users] Re: tabs in LibreOffice - like you can do for MS-Word?

2011-05-28 Thread Johnny Rosenberg
stall compizconfig-settings-manager The settings manager will end up at System → Preferences, so go there and have some fun…! Regards Johnny Rosenberg ジョニー・ローゼンバーグ -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiqu

Re: [libreoffice-users] I have to ask (four qustions)

2011-05-28 Thread Johnny Rosenberg
mat for a range of cells that > currently have different formats. Automatic in Excel > (I remember that one for sure). Things like this > should be the easiest things in the world to do, > instead of such a massive struggle. Well, I had no struggle, or maybe I totally misunderst

Re: [libreoffice-users] Re: tabs in LibreOffice - like you can do for MS-Word?

2011-05-28 Thread Johnny Rosenberg
2011/5/28 webmaster for Kracked Press Productions : > On 05/27/2011 09:33 PM, Cliff Scott wrote: >> >> ** Reply to message from plino  on Fri, 27 May 2011 >> 15:27:13 -0700 (PDT) >> Are you aware that, at least in Win. that you can move between documents using Alt+tab? I find that mu

Re: [libreoffice-users] Re: tabs in LibreOffice - like you can do for MS-Word?

2011-05-28 Thread Johnny Rosenberg
2011/5/28 Johnny Rosenberg : > 2011/5/28 webmaster for Kracked Press Productions > : >> On 05/27/2011 09:33 PM, Cliff Scott wrote: >>> >>> ** Reply to message from plino  on Fri, 27 May 2011 >>> 15:27:13 -0700 (PDT) >>> >>>>> Are y

Re: [libreoffice-users] Re: tabs in LibreOffice - like you can do for MS-Word?

2011-05-28 Thread Johnny Rosenberg
t hunk of doo doo. Which four people are you referring to? Regards Johnny Rosenberg ジョニー・ローゼンバーグ > > On Sat, 2011-05-28 at 19:38 +0100, Tom Davies wrote: > >> Hi :) >> I thought it's just for fancy desktops like spinning cubes with movies >> playing >&g

Re: [libreoffice-users] Re: tabs in LibreOffice - like you can do for MS-Word?

2011-05-29 Thread Johnny Rosenberg
about GNU/Linux and what I think, I usually recommend them to continue with Windows. That way, I don't have to help them when things go wrong; I just tell them that I don't know anything about it. Regards Johnny Rosenberg ジョニー・ローゼンバーグ > > In OpenSuSE 11.4, just try changing y

Re: [libreoffice-users] I have to ask (four qustions)

2011-06-01 Thread Johnny Rosenberg
;. INstead of doubling ½" to 2·1.27 cm, only the integer part was double and the decimals were kept as they were, therefore 2.27 cm. That COULD happen if you think way too fast… Regards Johnny Rosenberg ジョニー・ローゼンバーグ > >>How do I change it > > It is hard wired into LibO.  :(

[libreoffice-users] SUMPRODUCT() (just some thoughts, no question)

2011-06-02 Thread Johnny Rosenberg
the SUMPRODUCT() function forced me to learn quite a few other functions, workarounds and tricks… Maybe this would rather be sent to the Discuss list, but I thought that this could be a hint for other people who didn't know about the SUMPRODUCT() function for some strange reason… Kind regar

Re: [libreoffice-users] Re: SUMPRODUCT() (just some thoughts, no question)

2011-06-02 Thread Johnny Rosenberg
2011/6/2 Jack : > > Johnny Rosenberg wrote: >> >> I guess the lack of knowledge of the SUMPRODUCT() function forced me >> to learn quite a few other functions, workarounds and tricks… >> > > For reference, here's one of these "tricks" that could

Re: [libreoffice-users] Re: Calc: Has anyone tested the backward-compatibility of LibreOffice 3.4?

2011-06-04 Thread Johnny Rosenberg
; would return 0. So this behavior seems a bug to me in the N function. > Otherwise I would have recommend to use N(C1)-N(B1) instead of C1-B1. > > I notice, that Tom has already found the solution, to enter 0 and format it > to show - . > > Kind regards > Regina Someone

Re: [libreoffice-users] Re: Calc: Has anyone tested the backward-compatibility of LibreOffice 3.4?

2011-06-04 Thread Johnny Rosenberg
2011/6/4 Regina Henschel : > Hi Johnny, > > Johnny Rosenberg schrieb: >> >> 2011/6/4 Regina Henschel: > > [..] >>> >>> In OOo this can be done by the function N. Unfortunately the spec makes >>> it >>> "implemention defined"

Re: [libreoffice-users] Re: LO Writer 3.4.0 --- basic .doc/.odt files not understood properly by MS Office 2010

2011-06-05 Thread Johnny Rosenberg
sting. How can you top- or bottom post when you write a new thread? Top of what? Regards Johnny Rosenberg ジョニー・ローゼンバーグ > On Sat, 2011-06-04 at 18:11 -0700, At0mic wrote: > >> OK thanks to all. Looks like the version change works without complaint in >> Office 2010. I should also

Re: [libreoffice-users] I have to ask (four qustions)

2011-06-05 Thread Johnny Rosenberg
2011/6/5 Nuzhna Pomoshch : > --- On Sat, 5/28/11, Johnny Rosenberg wrote: > >> > 2. I sometimes need to work in cm, and >> > sometimes in inches. How do I change from >> > one to the other? Again, I recall that >> > this was easy to set in Excel.

[libreoffice-users] LibreOffice/OpenOffice.org BASIC – CDbl doesn't work properly with string argument

2011-06-06 Thread Johnny Rosenberg
nvert from text to a numerical value? Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org Posting guidelines + more: http://wiki.documentfoundation.org

Re: [libreoffice-users] Re: [libreoffice-users] LibreOffice/OpenOffice.org BASIC – CDbl doesn't work properly with string argument

2011-06-06 Thread Johnny Rosenberg
2011/6/6 Regina Henschel : > Hi Johnny, > > Johnny Rosenberg schrieb: >> >> CDbl returns an integer when the argument is a text string. >> >> LibreOffice 3.4.0 >> OOO340m1 (Build:12) >> >> OpenOffice.org 3.2.1 >> OOO320m19 (Build:9505

Re: [libreoffice-users] Re: [libreoffice-users] Re: [libreoffice-users] LibreOffice/OpenOffice.org BASIC – CDbl doesn't work properly with string argument

2011-06-06 Thread Johnny Rosenberg
zilla/show_bug.cgi?id=70236 Okay, I see. Thanks, Clio! Best regards Johnny Rosenberg ジョニー・ローゼンバーグ > > -- > Unsubscribe instructions: E-mail to users+h...@libreoffice.org > In case of problems unsubscribing, write to > postmas...@documentfoundation.org > Posting guidelines +

[libreoffice-users] Delete key doesn't work in the Basic Macro editor!

2011-06-06 Thread Johnny Rosenberg
rsion) though. Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive:

Re: [libreoffice-users] Delete key doesn't work in the Basic Macro editor!

2011-06-06 Thread Johnny Rosenberg
2011/6/6 Nuno J. Silva : > Johnny Rosenberg writes: > >> LibreOffice 3.4 (the one at the Libre Office site, the most recent one >> released 2011-06-03) >> Ubuntu 10.10 >> >> When writing BASIC macros I can't delete with the Delete key, so I >&g

[libreoffice-users] LibreOffice 3.4 changes my cell formatting…

2011-06-07 Thread Johnny Rosenberg
$kr-41D];[<0]-# ##0,00" "[$kr-41D];"±"0,00" "[$kr-41D] Why did they add this exciting feature? Workaround suggestions? Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org In case of problems uns

Re: [libreoffice-users] Re: LibreOffice 3.4 changes my cell formatting…

2011-06-07 Thread Johnny Rosenberg
2011/6/7 Gérard Fargeot : > Hello, > > > Johnny Rosenberg wrote: >> >> Right click a cell range → Format cells… → Numbers → Now type in the >> format description field: # ##0,00" "[$kr-41D];[GREEN]-# ##0,00" >> "[$kr-41D];"±"0,

Re: [libreoffice-users] Windows "Open with" - the answer - Call for a cleaner

2011-06-11 Thread Johnny Rosenberg
r to make a Live USB stick instead. Much faster, but still not as fast as a native install. But enough about that now, aren't we supposed to discuss LibreOffice here…? :P Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ > > > Actually the 10.04 and the 10.10 are a bit quirky so i tend to choo

Re: [libreoffice-users] LibreOffice 3.3.3 is ready for download

2011-06-21 Thread Johnny Rosenberg
Why is there a 3.3.3 when 3.4.0 was released a while ago? Apart from the incredible amount of bugs in 3.4.0… Regards Johnny Rosenberg ジョニー・ローゼンバーグ -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org In case of problems unsubscribing, write to postmas

Re: [libreoffice-users] LibreOffice 3.3.3 is ready for download

2011-06-22 Thread Johnny Rosenberg
t; every 2 years with 3 years support.  Debian has a stable and separate testing > and development branches.  SliTaz call their's a "cooking" release.  RedHat > use > a separate distro, Fedora, for testing interesting ideas. > Regards from > Tom :) > > > &g

Re: [libreoffice-users] Re: RTF support

2011-06-28 Thread Johnny Rosenberg
ppears there is more current work on LO. > BTW, I save all files in RTF. I did that too maybe 10 or 15 years ago, which I later regretted very much. Fortunately I need very few (none, I think) of those old documents today. Since then I always make sure no RTF files comes near me ever. Kind regards

Re: [libreoffice-users] Save odt/ods files take too much time

2011-07-12 Thread Johnny Rosenberg
2011/7/12 MichaelB : > Hi, > > When i save (Ctrl+S) a file after some modification, it take 5 seconds or > more with a .odt file (~2.5 Mo) What is Mo? > If i save the same presention with .ppt format, it take only 1.5 seconds to > save. > > Is only a little presentation file with 25 slides..  I t

Re: [libreoffice-users] Save odt/ods files take too much time

2011-07-12 Thread Johnny Rosenberg
2011/7/12 Johnny Rosenberg : > 2011/7/12 MichaelB : >> Hi, >> >> When i save (Ctrl+S) a file after some modification, it take 5 seconds or >> more with a .odt file (~2.5 Mo) > > What is Mo? > >> If i save the same presention with .ppt format, it take on

Re: [libreoffice-users] Re: Save odt/ods files take too much time

2011-07-12 Thread Johnny Rosenberg
g if you ask me. By the way, how long does it take to uncompress the file with, for example, FileRoller? You might need to change the file suffix to .zip before trying that, or maybe not… Regards Johnny Rosenberg ジョニー・ローゼンバーグ > -- > View this message in context: > http://nabble.docume

Re: [libreoffice-users] Re: Save odt/ods files take too much time

2011-07-12 Thread Johnny Rosenberg
> the time it takes you to click on this extra box, it has to be longer than > 4s. What happens if you save as .ppt instead? Regards Johnny Rosenberg ジョニー・ローゼンバーグ > > > regards > > John B > xp sp3 > LO 3.4.1 > > > --

Re: [libreoffice-users] How to abbreviate the first name of the author?

2011-07-13 Thread Johnny Rosenberg
ey, release it, press o, release it, press c, release it ⇨ a © appears at the cursor's position). Once again, sorry for being off topic here, I just couldn't stop myself… ☺ Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ -- Unsubscribe instructions: E-mail to users+h...@global.l

Re: [libreoffice-users] How to abbreviate the first name of the author?

2011-07-13 Thread Johnny Rosenberg
what's going on. Well, that's my opinion anyway. Well, enough about this, I guess. Sorry for continuing being off topic… ☺ Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ > > > > > > From: Johnny Rosenberg > To: users@global.libreoff

Re: [libreoffice-users] How to abbreviate the first name of the author?

2011-07-13 Thread Johnny Rosenberg
2011/7/13 Johnny Rosenberg : > 2011/7/13 Tom Davies : >> Hi :) >> +1 >> Lol, i totally agree.  I just never thought about it.  I did notice someone >> taking extravagant care in a very precise guide ages ago.  Hmm Ctrl+c would >> be >> Ctrl and the + key a

Re: [libreoffice-users] Re: Conditional formatting cell copying?

2011-07-13 Thread Johnny Rosenberg
conditional formatting would point to the same cell as those > referenced in cell C3. Remember that the $ works the same way in conditional formatting like it does in cell formulas, for example $A$1. This reference won't change when copying the cell, A1 would. Kind regards Johnny Rosenber

Re: [libreoffice-users] automatic updates?

2011-07-16 Thread Johnny Rosenberg
ce. That will never happen. It's like banging your head into a brick-wall when making suggestions. You will probably be told that you are stupid, coming up with a suggestion like that… I'll be happy if I am wrong, though. Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ > > -- &g

Re: [libreoffice-users] automatic updates?

2011-07-16 Thread Johnny Rosenberg
2011/7/16 Andrew Douglas Pitonyak : > > > On 07/16/2011 04:18 PM, Johnny Rosenberg wrote: >> >> 2011/7/16 Paul W: >>> >>> Does LibreOffice automatically update itself? If not that's a suggestion. >>> Again, like firefox. It's about time

Re: [libreoffice-users] Displaying Negative Numbers as red in Calc

2011-07-17 Thread Johnny Rosenberg
2011/7/15 bikerbrent : > I don't seem to be able to display negative numbers red using a comma > thousands separator and 2 decimal places . If I go to cell formatting, I > have been able to get the negative number red with 2 decimal places, but no > separator. However as soon as I save the document

Re: [libreoffice-users] New User: Three Questions

2011-07-19 Thread Johnny Rosenberg
ter document instead of this icon box? > > Are you using Windows? No, he isn't. He wrote: ”I have many typefaces/fonts installed in /usr/share/fonts/ and the 18 subdirectries below that”, which clearly indicates that his operating system is one of the many Unix-like operating systems

Re: [libreoffice-users] New User: Three Questions

2011-07-19 Thread Johnny Rosenberg
bar. Well, that would work in just about the same way in most GNU/Linux-distributions too. The icons are located in Programs → Office in most Gnome based GNU/Linux-distributions, and probably something like that in most KDE-/Xfce-/Lxde (etc)- based GNU/Linux-distributions as well. Kind regards Johnny

Re: [libreoffice-users] How to convert a number(in format YYYYMMDD) to date

2011-07-29 Thread Johnny Rosenberg
3. The cell displayed 11-07-29 (since the default date format on my system seems to be YY-MM-DD) and in the formula field I could read 2011-07-29, as expected. Regards Johnny Rosenberg ジョニー・ローゼンバーグ -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org Problems? http://w

Re: [libreoffice-users] How to convert a number(in format YYYYMMDD) to date

2011-07-29 Thread Johnny Rosenberg
bout that! Sorry for giving a far too complicated answer, when it could be solved that easily. On the other hand, learning regular expressions may come handy in many other situations… Best regards Johnny Rosenberg ジョニー・ローゼンバーグ -- Unsubscribe instructions: E-mail to users+h...@glob

Re: [libreoffice-users] Code snippet

2011-07-31 Thread Johnny Rosenberg
f odd, isn't it? But on the other hand, odd doesn't necessarily mean wrong… So this is correct? 500 ⇨ ½ cm=5 mm (cm≠CM, by the way) 1000 ⇨ 1 cm 10 000 ⇨ 1 dm 100 000 ⇨ 1 m Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ > > On 07/30/2011 07:05 PM, Bill Gradwohl wrote: >> >&

Re: [libreoffice-users] Calc: colour of negative numbers

2011-08-01 Thread Johnny Rosenberg
numbers red option is greyed out) > > This [WHITE] format code still functions in OOo 3.3.0 (m19 Build:9561 > > Anyone knows how to fix this? > -- > Guy Known bug. Solution 1: Use the latest version 3.3.x (3.3.3 at the moment, I think). Solution 2: Wait for the bug to be fixe

Re: [libreoffice-users] Calc: colour of negative numbers

2011-08-01 Thread Johnny Rosenberg
2011/8/1 Guy Voets : > Thanks Johnny! > By the way: https://bugs.freedesktop.org/show_bug.cgi?id=37658 Regards Johnny Rosenberg ジョニー・ローゼンバーグ > 2011/8/1 Johnny Rosenberg : >> 2011/8/1 Guy Voets : >>> Hello, >>> >>> In LibO 3.3, I could make negativ

Re: [libreoffice-users] Re: Calc: colour of negative numbers

2011-08-02 Thread Johnny Rosenberg
but the Help section was wrong and I think it's corrected since a couple of years back). Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ > > The English number format > #.##0.00;[WHITE]-#.##0.00 > works as expected. > > With comma decimals > #.##0,00;[WEISS]-#

Re: [libreoffice-users] Calc - Would like to see "Insert Cut Cells" & "Insert Copied Cells" Added to Right-Click Menus

2011-08-07 Thread Johnny Rosenberg
Office Calc. So what does this ”Insert Copied Cells” actually do? > Is this the right forum for posting requests for features? Not really. There is a place for reporting bugs and asking for enhancements, read more here: http://wiki.documentfoundation.org/BugReport Kind regards Johnny Rose

Re: [libreoffice-users] Calc - Would like to see "Insert Cut Cells" & "Insert Copied Cells" Added to Right-Click Menus

2011-08-07 Thread Johnny Rosenberg
at this isn't as efficient as just hitting a > couple keys or picking one item in the context menu, and that is a > problem if you use this frequently. Probably not a big problem. If you selected ”Down” or ”Right” once, it will be selected next time you use it, so it only means one extra cl

Re: [libreoffice-users] Re: Calc - Would like to see "Insert Cut Cells" & "Insert Copied Cells" Added to Right-Click Menus

2011-08-08 Thread Johnny Rosenberg
e did not copy MS Office’s behaviour in every aspect. That's why there, for example, is no MS Excel leap-year bug in LibreOffice, nor in OpenOffice.org (1900-02-29 doesn't exist in the real world, in LibreOffice or in OpenOffice.org, but it does in MS Excel, as far as I have heard). Regar

Re: [libreoffice-users] HELP WITH CODE excel

2011-08-08 Thread Johnny Rosenberg
y appreicated > -- Exactly why did you write two different threads about exactly the same thing? 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-unsubscrib

Re: [libreoffice-users] new book

2011-08-09 Thread Johnny Rosenberg
but that has probably nothing to do with the document itself. Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ > On 08/05/2011 08:49 AM, rogerio dandrea wrote: >> >> new book >> >> http://www.pitonyak.org/OOME_3_0.odt >> >> :0)   thanks Pitonyak  for the exce

Re: [libreoffice-users] add ttf fonts to LibreOffice

2011-08-10 Thread Johnny Rosenberg
tool called AutoKey (there are other ones for other operating systems) to expand all my shortenings as I type, like ”” for ”OpenOffice.org”, ”lboo” for ”LibreOffice”, ”lboc” for ”LibreOffice Calc” and ”kregj” for: ”Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ” > > -- > Nuno J. Silva (

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

2011-08-11 Thread Johnny Rosenberg
--> 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 ジョニー・ローゼンバー

Re: [libreoffice-users] Macro not active when the document start

2011-08-11 Thread Johnny Rosenberg
ocument. 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: us

Re: [libreoffice-users] Macro not active when the document start

2011-08-11 Thread Johnny Rosenberg
eratus 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. Re

Re: [libreoffice-users] Re: Macro not active when the document start

2011-08-11 Thread Johnny Rosenberg
2011/8/11 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 >

Re: [libreoffice-users] Re: Macro not active when the document start

2011-08-11 Thread Johnny Rosenberg
2011/8/11 Johnny Rosenberg : > 2011/8/11 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, s

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

2011-08-11 Thread Johnny Rosenberg
/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 +

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

2011-08-11 Thread Johnny Rosenberg
f 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 ou

Re: [libreoffice-users] Date Format in Writer

2011-08-11 Thread Johnny Rosenberg
yy-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-list

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

2011-08-11 Thread Johnny Rosenberg
ather 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://

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

2011-08-11 Thread Johnny Rosenberg
2011/8/11 Johnny Rosenberg : > 2011/8/11 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 f

Re: [libreoffice-users] Date Format in Writer

2011-08-11 Thread Johnny Rosenberg
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:

Re: [libreoffice-users] Libre Office being recommended on Microsoft Answers Forums!

2011-08-12 Thread Johnny Rosenberg
y that Win 7 is actually not > bad. Does that mean that it has multiple desktops and that the drive letters are gone? Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ > (All we need to do now is to get Windows 7 users to STOP running as Admin on > a daily basis - it really ain't

Re: [libreoffice-users] MS Word .docx formatting in Libre Office

2011-08-12 Thread Johnny Rosenberg
ses, though. If people can not read them, they can install LibreOffice or OpenOffice.org and it won't cost them anything else than disk space and time. They don't have to buy anything. Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ -- For unsubscribe instructions e-mail to

Re: OT: Multiple desktops in Windows (was: Re: [libreoffice-users] Libre Office being recommended on Microsoft Answers Forums!)

2011-08-13 Thread Johnny Rosenberg
2011/8/13 Nuno J. Silva : > On 2011-08-12, Johnny Rosenberg wrote: > >> 2011/8/12 Gordon Burgess-Parker : >>> On 12/08/2011 00:24, upscope wrote: >>>> >>>> +5 that's what I did 12 years ago when my Win ME died. >>> >>> I

Re: [libreoffice-users] Opening PDF files in Draw

2011-08-13 Thread Johnny Rosenberg
ware out there, you know… Tried PDF edit? If you have Ubuntu it's in the repositories (or ”sudo apt-get install pdfedit” in a terminal). Regards Johnny Rosenberg ジョニー・ローゼンバーグ -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.o

Re: [libreoffice-users] Opening PDF files in Draw

2011-08-15 Thread Johnny Rosenberg
ng to say was only something like ”maybe there are other Open Source software out there that is better suited for the task than OpenOffice.org Draw”. I guess there were better ways to say it, though. Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ -- For unsubscribe instructions e-mail to: users+h..

Re: [libreoffice-users] Re: Problem with combo box

2011-08-15 Thread Johnny Rosenberg
t; ... does the trick accepting any formula expression, even calculated > references to dynamic ranges. > When you turn off the error message, you get the same behaviour as a combo, > which is just a text box with auto-complete suggestions. > Unlike form controls, this spreadsheet variant

Re: [libreoffice-users] Re: Problem with combo box

2011-08-16 Thread Johnny Rosenberg
org/en/forum/download/file.php?id=333 I have never seen that validation thing before, but I can see it is useful, and it will probably solve a few of my problems I've had that I previously gave up on… :D Still there are cases when form controls are the right way to go, for example when ne

Re: [libreoffice-users] Re: Problem with combo box

2011-08-16 Thread Johnny Rosenberg
one neat post too :)  Ok, maybe just 1 or 2 ways this time but still a classic > OpenSource thread. And a small amount of healthy debate… :D Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ > > Regards from > Tom :) > > > > > ____ > From: John

[libreoffice-users] Search/Replace in Basic IDE

2011-08-16 Thread Johnny Rosenberg
this a bug or is it only me? Can someone confirm this? If it's supposed to work like this, why is that? LibreOffice 3.3.3, Ubuntu 10.10. Regards Johnny Rosenberg ジョニー・ローゼンバーグ -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.or

Re: [libreoffice-users] Re: Search/Replace in Basic IDE

2011-08-16 Thread Johnny Rosenberg
2011/8/16 NoOp : > On 08/16/2011 07:52 AM, Johnny Rosenberg wrote: >> When I search for something and leave the Replace With field empty >> (meaning that I will replace something with nothing), replace will not >> take place. The only way I could find to do it, was to copy the

Re: [libreoffice-users] Re: Search/Replace in Basic IDE

2011-08-16 Thread Johnny Rosenberg
2011/8/16 NoOp : > On 08/16/2011 12:17 PM, NoOp wrote: >> On 08/16/2011 12:04 PM, NoOp wrote: >>> On 08/16/2011 11:44 AM, Johnny Rosenberg wrote: >>>> 2011/8/16 NoOp : >>>>> On 08/16/2011 07:52 AM, Johnny Rosenberg wrote: >>>>>> Whe

Re: [libreoffice-users] Re: Search/Replace in Basic IDE

2011-08-16 Thread Johnny Rosenberg
meone else want to do it, feel free. You can copy my report if you like, or link to it. If copying, just remember that ”LibreOffice” sometimes should be replaced by ”OpenOffice.org” in the text, not everywhere though… Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ -- For unsubscribe instructions

Re: [libreoffice-users] Decimal Point Move

2011-08-17 Thread Johnny Rosenberg
2011/8/17 John D : > Can anyone help with Calc. Move Decimal Point from the following: > > The result in a the cell is 1.23 of which I would like to format the cell to > 0.0123 Just of curiosity: Why would you like to do that? Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ >

Re: [libreoffice-users] Re: Search/Replace in Basic IDE

2011-08-17 Thread Johnny Rosenberg
2011/8/17 Cor Nouws : > Bill Gradwohl wrote (16-08-11 21:13) >> >> -BEGIN PGP SIGNED MESSAGE- >> Hash: SHA1 >> >> On 08/16/2011 12:44 PM, Johnny Rosenberg wrote: >>>>> >>>>> When I search for something and leave the Replace Wit

<    1   2   3   4   5   6   >