[users] Charts customising

2009-02-26 Thread Johnny Rosenberg
Ubuntu 8.10 OpenOffice.org 3.0.0 (not the Ubuntu version) I made a chart, it's that lines kind of thing (sorry for bad English). To the right in the chart there is something that is called ”legent” when I hover the mouse over it. It explains what the different line colour s stands for. My proble

Re: [users] Charts customising

2009-02-26 Thread Johnny Rosenberg
>> calculated. The only way to manipulate its size is to change the size of the >> font. >> The issue for this missing feature is: >> http://qa.openoffice.org/issues/show_bug.cgi?id=28670 >> >> Kind regards, >> Ingrid >> >> Johnny Rosenberg w

Re: [users] Charts customising

2009-02-26 Thread Johnny Rosenberg
. I will add that suggestion to the bug report if some else did not, I think. J.R. > > > Johnny Rosenberg wrote: > >> Ubuntu 8.10 >> >> OpenOffice.org 3.0.0 (not the Ubuntu version) >> >> I made a chart, it's that lines kind of thing (sorry for ba

Re: [users] ver 3 is rubbish.

2009-02-27 Thread Johnny Rosenberg
2009/2/27 Adam Tauno Williams > On Fri, 2009-02-27 at 14:36 +0100, M Henri Day wrote: > > 2009/2/27 Richard > > > OOo3 is the worst version ever and like Netscape ver 4 a complete > disaster > > > that will loose countless users and loyal supporters > > > I am officially removing OOo 3 from my o

Re: [users] msoffice

2009-03-04 Thread Johnny Rosenberg
2009/3/3 sgb215 b > Dear Sirs, > > In tally9 while exporting any data .xls is mandatory. What is tally9? > > > Why cann't use open office? You probably can… > > > Can Open office be fully alternative for msoffice? Depends on who you are and what you need. For me, for example, MS Office can

Re: [users] Re: Solved

2009-03-04 Thread Johnny Rosenberg
2009/3/4 Richard > Graham Bowden wrote: > >> In the spirit of co operation that will make OOo the strongest software - >> please enlighten us on the registry changes you made and their effect so >> that all using this forum may benefit. >> >> Many thanks >> >> - Original Message - From: "

Re: [users] Can't open a 2nd spreadsheet?

2009-03-15 Thread Johnny Rosenberg
2009/3/15 Meenie1 > I have a small business. > I have an inventory made in OO spreadsheet. > I want to open a second OO spreadsheet to make some calculations for my > taxes so I want to be able to refer to the first spreadsheet, but OO won't > let me open a second spreadsheet. Why not? > When I t

[users] Strange bug when saving to doc format

2009-04-05 Thread Johnny Rosenberg
Normally I never save to anything but ODF or PDF, but I am doing one thing, just for once, for a guy I know who is an absolute computer idiot so I can hardly ask him to install something, no matter how easy it seems to be. So I need to save as Microsoft Word. The files I am going to do for him ar

Re: [users] ODT file: I forgot my password!

2009-04-25 Thread Johnny Rosenberg
2009/4/25 Dotan Cohen : >> Minimum time track = recreate the document from scratch. >> From a previous responder Jonathan: >> QUOTE >> >> Source code at >> http://www.oooforum.org/forum/viewtopic.phtml?t=23014&highlight=password+cracker >> >> 125 passwords checked per second. >> Number of possible

Re: [users] ODT file: I forgot my password!

2009-04-26 Thread Johnny Rosenberg
2009/4/26 James Knott : > Dotan Cohen wrote: >>> You might be waiting a very long time. >>> >>> >> >> That sounds reasonable. 72 characters (alphanum+symbols) ^ 10 >> characters comes out to about 100 million years. >> >> > Of course, on average, it'll take only half that time.  ;-) Maybe you miss

Re: [users] ODT file: I forgot my password!

2009-04-26 Thread Johnny Rosenberg
2009/4/26 Dotan Cohen : >> Maybe you missed that 100 million years wasn't correct, it's (a little >> less than) 1 billion years… But yes, half of that in average. 1 >> billion years is ”worst case”… >> > > Of course, that is assuming 125 tries per second. If we can get that > up to 150... Actuallt

Re: [users] Re: ODT file: I forgot my password!

2009-04-26 Thread Johnny Rosenberg
2009/4/26 Ed Jones : > On or about 4/26/2009 3:28 AM, Johnny Rosenberg typed the following: >> 2009/4/26 James Knott : >>> Dotan Cohen wrote: >>>>> You might be waiting a very long time. >>>>> >>>>> >>>> That sounds rea

Re: [users] ODT file: I forgot my password!

2009-04-26 Thread Johnny Rosenberg
2009/4/26 Dave Post : > On Apr 26, 2009, at 10:36 AM, Johnny Rosenberg wrote: > >> the macro was modified so it could generate 8300 passwords/s on a 3.19 GHz >> Penthium. > > > > >> You could perharps attack the file directly using a C program. > > I'

[users] OpenOffice.org 3.1.0 speed improvements.

2009-05-09 Thread Johnny Rosenberg
I just installed OpenOffice.org 3.1.0 on my Ubuntu 8.10 system. Before I did that I read about what's new and things like that. It was interesting to see that they finally did something about at least some speed issues, so I was looking forward to install it and see if it feels faster. However, fi

Re: [users] OpenOffice.org 3.1.0 speed improvements.

2009-05-11 Thread Johnny Rosenberg
2009/5/11 Charles T. Bell : > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > > David B Teague wrote: >> Johnny Rosenberg wrote: >>> I just installed OpenOffice.org 3.1.0 on my Ubuntu 8.10 system. Before >>> I did that I read about what's new and thi

Re: [users] Re: OpenOffice.org 3.1.0 speed improvements.

2009-05-11 Thread Johnny Rosenberg
2009/5/11 NoOp : > On 05/11/2009 09:02 AM, Johnny Rosenberg wrote: > >> >> So, if someone will compare with Excel, what do we think about this? >> Should a bit more than 2000 rows take this long to filter? >> Last time I last Excel was Excel '97 on Windows 98

Re: [users] Re: OpenOffice.org 3.1.0 speed improvements.

2009-05-14 Thread Johnny Rosenberg
2009/5/14 Gordon : > Johnny Rosenberg wrote: > >> >> There are a bit more than 2000 rows and what I want you to do is to >> use the autofilter function. >> For example I did this: >> Click the autofilter button in the ”Till” column, which is column I. >> S

Re: [users] Re: OpenOffice.org 3.1.0 speed improvements.

2009-05-16 Thread Johnny Rosenberg
maybe happen in like 50-100 years or so, but maybe there could be other spreadsheets out there, growing faster… Well, I know, maybe I should use Base for this, but that doesn't mean that OpenOffice.org doesn't need to be faster. J.R. 2009/5/14 Gordon : > Johnny Rosenberg wrote: >

Re: [users] Calc: no overflow

2009-05-18 Thread Johnny Rosenberg
other solution than all those already mentioned. Except filing a bug report, perhaps? Johnny Rosenberg > > http://what-is-what.com > http://gibberish.co.il > > - > To unsubscribe, e-mail: users-unsubscr...@openoff

Re: [users] OpenOffice 3.1 and Xandros

2009-05-18 Thread Johnny Rosenberg
I am also somewhat sure that you first need to uninstall the currently installed very old (2.0.4, right?) version. Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org

Re: [users] IsDate

2009-05-21 Thread Johnny Rosenberg
is is close to what you are looking for, and if you want to use this in other spreadsheets, you can make that function global. I think there are a lot of information out there how to do that, so I won't mention it here unless you (or anyone) ask. Kind regards Johnny Rosenberg --

Re: [users] IsDate

2009-05-21 Thread Johnny Rosenberg
ns.  Unless you > format the cell as a Date, it will act as a number, even though it displays > in a Date format. I also noticed that with my cell function. This simply didn't work. Maybe it's a OpenOffice.org Calc bug, I don't know. Johnny Rosenberg > (A little behind

Re: [users] "Update Problem"

2009-05-23 Thread Johnny Rosenberg
http://wiki.services.openoffice.org/wiki/Features#Features_planned_for_OOo_3.2_.28November_2009.29 2009/5/23 Koray ERŞEN : > > > Hi Everyone; > > > > I am using OpenOffice.Org 3.1 version, and when I want to check the updates > of this version from the menus, help/check for updates, it opens a lo

[users] Macro certificate

2009-05-24 Thread Johnny Rosenberg
… Kind regards Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org

[users] Signera makron med e-legitimation?

2009-05-24 Thread Johnny Rosenberg
insnöat att man bara kan använda amerikanska certifikat eller liknande? Vänliga hälsningar Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org

[users] Re: Signera makron med e-legitimation?

2009-05-24 Thread Johnny Rosenberg
Sorry, sent this to the wrong list. My apologises. Kind regards Johnny Rosenberg Den den 24 maj 2009 10:01 skrev Johnny Rosenberg : > Upptäckte i makromenyn att man tydligen kan signera sina makron > digitalt själv (Tools → Makros → Digital signatures… och nej, jag har > inte orkat i

Re: [users] Signera makron med e-legitimation?

2009-05-25 Thread Johnny Rosenberg
OpenOffice.org (fast jag kör fortfarande engelsk version) men inte samma operativsystem. Johnny Rosenberg Den den 24 maj 2009 21:54 skrev Per : > Hejsan > > Jag har oxå Nordea och testade jag med. > > samma sak som för dig. > > Vet inte om det är Nordeas certifikat

Re: [users] Calc: insert a date string into a cell - not a function, not a format.

2009-05-28 Thread Johnny Rosenberg
2009/5/21 Clifton Liles : > OK, I'm wrong.  I thought I saw the problem, but did not.  What we need is a > function that puts the results of on 'NOW()' in the cell. I do not know how > to do that in Calc.  It just died when I ask for the help for 'current > function'.  I 'll leave  this to someone

Re: [users] Calc: insert a date string into a cell - not a function, not a format.

2009-05-28 Thread Johnny Rosenberg
2009/5/28 Johnny Rosenberg : > 2009/5/21 Clifton Liles : > >> OK, I'm wrong.  I thought I saw the problem, but did not.  What we need is a >> function that puts the results of on 'NOW()' in the cell. I do not know how >> to do that in Calc.  It just di

Re: [users] How to get current cell in Basic Macro

2009-05-28 Thread Johnny Rosenberg
getFormula() and setFormula() available, but I am not sure. Use Xray to find out what methods are available for a specific object. It's the most helpful tool I used so far with OpenOffice.org BASIC. I think it is installed by default these days, if not you can find it somewhere, use google… Well,

Re: [users] Is this even possible? (Compacted table from long list...)

2009-05-29 Thread Johnny Rosenberg
s found, which it should be, then it still returns the > last value? Where am I going wrong in my reading of the help file, or > is it just not really there? > >   Assume for a moment I wanted to find the first occurrence? Can > VLOOKUP do that? (Again, assu

Re: [users] Is this even possible? (Compacted table from long list...)

2009-05-30 Thread Johnny Rosenberg
this? > > Yes: that's an obvious technique.  Alternatively (as has already been > suggested) you could concatenate the values as text strings.  Note that, if > you want to keep the separate year and week columns for appearance purposes, > you could always create a new column with

Re: [users] word compatability?

2009-05-31 Thread Johnny Rosenberg
r will. No, your professor can't open it in Word (I think), but everyone has Adobe Reader installed these days, right? Kind regards Johnny Rosenberg > > -- > hannah knapp > big lake, alaska > (907)355-6180 > hannah.vkn...@gmail.com > --

Re: [users] Re: bypass regative numbers

2009-05-31 Thread Johnny Rosenberg
e bit more straight forward: =IF(OR(A1<0;B1<0);"";(A1-B1)/B1) This means (and this is only for a quick explanation, you can't enter it this way, of course): IF A1<0 OR B1<0 THEN "" ELSE (A1-B1)/B1 Johnny Rosenberg 2009/5/31 Walter Hildebrandt : > Thank y

Re: [users] word compatability?

2009-05-31 Thread Johnny Rosenberg
seems that many schools have not yet recognised that ODF formats are >> an international ISO standard. Lagards! >> >> > Another way to verify the file is to use the free Word viewer, available > from Microsoft. Yes, that works for most people. If they h

Re: [users] word compatability?

2009-05-31 Thread Johnny Rosenberg
2009/5/31 James Knott : > Johnny Rosenberg wrote: >> 2009/5/31 James Knott : >> >>> Another way to verify the file is to use the free Word viewer, available >>> from Microsoft. >>> >> >> Yes, that works for most people. If they have Windows t

Re: [users] Re: bypass regative numbers

2009-06-01 Thread Johnny Rosenberg
2009/5/31 JOE Conner : > Johnny Rosenberg wrote: >> >> Maybe I misunderstood the question, but what if both A1 and B1 are >> negative? If that also should give a blank C1, the formula you got was >> correct (I guess, I didn't study it closer, but it looks correct)

Re: [users] Re: bypass regative numbers

2009-06-02 Thread Johnny Rosenberg
Yes, all of that seems very logical. Was this what you were originally asking for? Johnny Rosenberg 2009/6/2 Walter Hildebrandt : > Thanks to everyone who helped with this question. > The following is a summary I made for myself.  This might be of interest to > some. >  =IF(OR(A1<

Re: [users] Re: bypass regative numbers

2009-06-03 Thread Johnny Rosenberg
2009/6/3 Walter Hildebrandt : > Yes, Johnny, that is what I originally ask for.  There are some other > question I expect to be asking in the future but for now I am learning by > using various formulas. > > Walter Well, good luck then and welcome back with more questions. J

Re: [users] Open Office on Netbook

2009-06-03 Thread Johnny Rosenberg
ou could live without Math and some other stuff, even if it won't mean any bigger difference in total amount of installed bytes. Kind regards Johnny Rosenberg > > > -- > > > > Pierre > Worrigee, NSW, >   ,-._|\ >  /  Oz  \ >  \_,--._/ >        v > &g

Re: [users] empty cells and negative numbers in Calc

2009-06-05 Thread Johnny Rosenberg
What about if A1 or B1 is 0? That's not covered in any of the five conditions below. Kind regards Johnny Rosenberg 2009/6/6 Walter Hildebrandt : > What formula would be used to meet the following conditions? > > 1) If both A1 and B1 are positive numbers, and A1 is greater

Re: [users] empty cells and negative numbers in Calc

2009-06-05 Thread Johnny Rosenberg
B1… Is it OK if the formula outputs ”∞” or maybe ”∞ %” in that particular case? (In case UTF-8 characters does not make it through all the email servers on the way, ∞=the "infinity" character). Johnny Rosenberg > > On Fri, Jun 5, 2009 at 5:12 PM, Johnny Rosenberg > wrot

Re: [users] empty cells and negative numbers in Calc

2009-06-05 Thread Johnny Rosenberg
And I forgot, if both A1 and B1 are 0, should then the output be ”100 %”, since A1 and B1 then are equal? Johnny Rosenberg 2009/6/6 Johnny Rosenberg : > 2009/6/6 Walter Hildebrandt : >> Johnny; >> >> If there is a 0 (zero) it is considered to be a positive number.  I missed

Re: [users] empty cells and negative numbers in Calc

2009-06-06 Thread Johnny Rosenberg
ns as separators, so I'm a bit confused there… Johnny Rosenberg 2009/6/6 Walter Hildebrandt : > Thank you Joe for the list of places that have information.  Quite a few > years ago I started the website tutorialsforopenoffice.org.  You included a > lot of links to my website.  I

Re: [users] empty cells and negative numbers in Calc

2009-06-06 Thread Johnny Rosenberg
methods but this one worked for me today and I got almost no errors at all on my way from a simple uncomplete formula until the final formula was done. Since i tested every step as the formula grew, I didn't have to test everything when the formula was finished and the need for debugging was min

Re: [users] empty cells and negative numbers in Calc

2009-06-08 Thread Johnny Rosenberg
g BASIC and make them available in all your spreadsheets or just a specific one, you decide. Johnny Rosenberg > > 2009/6/7 Walter Hildebrandt > >> Johnny, I tested all the different possibilities and found, assuming I did >> not make a mistake, there was one condition that

Re: [users] empty cells and negative numbers in Calc

2009-06-09 Thread Johnny Rosenberg
t; what and how to communicate with someone who is learning a part of > OpenOffice. Thanks…! Well, I can't really say that I know OpenOffice.org; I know some parts of it, that is those parts that I use regularly. I've asked many questions here throughout the years… :) Johnny Rosenberg &g

[users] Conditional number formatting bug?

2009-06-12 Thread Johnny Rosenberg
d the following: [BLUE][<-5]Standard;[GREEN][<=30]Standard;[RED]Standard It turns out exactly the same as [BLUE][<-5]Standard;[RED][>30]Standard;[GREEN]Standard I also tried this: [RED][>30]Standard;[BLUE][<-5]Standard;[GREEN]Standard This gives an even worse result since the m

Re: [users] Conditional number formatting bug?

2009-06-13 Thread Johnny Rosenberg
currently, but my operating system is set to Swedish, that's why I use commas as decimal separator, just in case anyone wonder. Johnny Rosenberg OpenOffice.org Calc 3.1.0 Ubuntu 8.10 (Yes, I got rid of the Ubuntu version of OpenOffice.org and replaced it with the version mentioned above) 2009

Re: [users] Re: Conditional number formatting bug?

2009-06-14 Thread Johnny Rosenberg
1 on Mandriva Linux Free 2009.1) -10 is displayed as -10 and -3 is displayed as 3, and I can't really see why. I will try to attach an example spreadsheet to this post, but I don't know it it will come through. If it does, please open it and take a look. If it does

Re: [users] Re: Conditional number formatting bug?

2009-06-14 Thread Johnny Rosenberg
2009/6/14 Brian Barker : > At 15:55 14/06/2009 +0200, Johnny Rosenberg wrote: >> >> Just to eliminate more language confusion, let's from now on change the >> example to this instead: >> [BLUE][<-5]0;[RED][>30]0;[GREEN]0 >> >> It gives the sam

Re: [users] How to set text entry font and underline?

2009-06-16 Thread Johnny Rosenberg
the settings as you wish, then copy the field and paste it to where ever you want them. It will look different, but that doesn't mean it will look bad… One advantage is also that you can jump between the text boxes using the TAB key. Johnny Rosenberg 2009/6/16 Dotan Cohen : >> OK, how

Re: [users] How to set text entry font and underline?

2009-06-17 Thread Johnny Rosenberg
the bottom border of all the cells in the second column… But of course there will be some complications in that case too: The position of the cursor will be fixed. Johnny Rosenberg > > -- > Dotan Cohen > > http://what-is-what.com > http://gibberish.co.il > > -

Re: [users] Re: instaling version 2

2009-06-19 Thread Johnny Rosenberg
the main reasons that I switched from OpenOffice.org 2.4.1 (Ubuntu 8.10 version) to OpenOffice.org 3.1.0 (OpenOffice.org version). Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org

Re: [users] Calc keyboard shortcut for adding background color?

2009-06-25 Thread Johnny Rosenberg
ff. The choice is yours… :) Johnny Rosenberg > > Thanks and have a nice day/evening, > > -- > Zhengquan > > > - > To unsubscribe, e-mail: users-unsubscr...@openoffice.org > For a

Re: [users] Calc keyboard shortcut for adding background color?

2009-06-25 Thread Johnny Rosenberg
2009/6/25 Zhengquan Zhang : > On Thu, Jun 25, 2009 at 06:35:14PM +0200, Johnny Rosenberg wrote: >> 2009/6/25 Zhengquan Zhang : >> > Hello, openoffice list, >> > >> > I need to frequently add background color for cells and I was wondering >> > if who

Re: [users] Calc: Writing My Own Spreadsheet Function

2009-06-26 Thread Johnny Rosenberg
" & LBound(x, 1) & " To " & UBound(x, 1) > &_ > '          ", " & LBound(x, 2) & " To " & UUBound(x, 2) & ")." > 'EndIf > > WahooFunc = s > End Function > > Ideas anyone? I don't know what

Re: [users] Calc: Writing My Own Spreadsheet Function

2009-06-30 Thread Johnny Rosenberg
2009/6/26 Don Daugherty : > Johnny Rosenberg wrote: >> >> I don't know what to say… I pasted the text to the Macro edit thing >> and it worked, even when I removed all the comments. >> >> OpenOffice.org 3.1.0 >> Ubuntu 8.10 >> >> Did you c

Re: [users] Recording a macro to format a table

2009-06-30 Thread Johnny Rosenberg
Just don't record macros. The only proper way to crate macros is to write them by hand, since the built in macro recorder really sucks. There is an alternate macro recorder to download somewhere, but I don't think it's much better in this case. Johnny Rosenberg 2009/6/30 Jo

Re: [users] Re: Major data loss: Calc formatting numbers

2009-07-02 Thread Johnny Rosenberg
If you go to an empty cell and make sure it is formatted properly, and then enter =A1 (if A1 is one of the cells that is corrupted) in it, will the corrupted value or the correct value be displayed? Johnny Rosenberg 2009/7/2 Dotan Cohen : >> Have you checked the "Precision as shown&

Re: [users] Calc: Writing My Own Spreadsheet Function

2009-07-10 Thread Johnny Rosenberg
2009/7/7 Don Daugherty : > >> Can you attach an example file so I can have a look? Something is >> obviously wrong somewhere… If the file works for me, the fault is >> somewhere else, I would guess. >> >> Johnny Rosenberg >> > > Johnny: > Did you get

Re: [users] Question

2009-07-15 Thread Johnny Rosenberg
ant, from the line. I don't think that's possible. What about using a background colour instead? You can have borders around a paragraph, but obviously not around a single word. Johnny Rosenberg > > there somenting that help me > > thank > Daiana > > _  Daian

Re: [users] Question

2009-07-16 Thread Johnny Rosenberg
2009/7/16 Harold Fuchs : > On 15/07/09 18:15, Johnny Rosenberg wrote: >> >> 2009/7/14 Daiana Leporatti - NETCOM : >> >>> >>> Dear Support >>> >> >> First of all, this is not a support place. We all are just regular >> users just l

Re: [users] problem writing a simple macro

2009-08-09 Thread Johnny Rosenberg
Just never ever use the macro recording feature in OpenOffice.org and you'll be fine. Learn how to write macros from scratch instead. The macro recorder always sucked and will probably always suck (or be removed). Johnny Rosenberg 2009/8/6 Jean-Michel Courat : > In a spreadsheet,

Re: [users] ubuntu linux version - any guidance?

2009-08-09 Thread Johnny Rosenberg
tu version? Johnny Rosenberg 2009/8/7 Web Kracked : > I just installed Ubuntu 9.04 on one of my machines. > > Is there any thing I should know about dealing with > the Ubuntu version of OOo? > > I want to start setting it up with all the extensions > I have on my Vista laptop,

Re: [users] Re: Unicode hex values not working

2009-08-12 Thread Johnny Rosenberg
ters with my compose key on Ubuntu 9.04 than on my Ubuntu 8.10 machine, for example Compose c o gives © and so does Compose o c on Ubuntu 9.04. On Ubuntu 8.10 I get © and ǒ respecively, but I guess that's another issue… Johnny Rosenberg ---

Re: [users] Re: Unicode hex values not working

2009-08-13 Thread Johnny Rosenberg
2009/8/12 John Jason Jordan : > On Wed, 12 Aug 2009 20:34:30 +0200 > Johnny Rosenberg dijo: > >> On my laptop with Ubuntu 8.10 and OpenOffice.org 3.1.0 it works >> perfectly, and so does the compose key. >> On my Eee PC 900 I have Ubuntu 9.04 and OpenOffice.org 3.0.1,

Re: [users] open office

2009-08-13 Thread Johnny Rosenberg
Keyboard shortcuts can be saved to a file, and that file can be loaded into the new version (this didn't work for some versions, though). But why do you use keyboard shortcuts for just typing single characters? There are a lot of better ways to do that. You don't mention what operating system you

Re: [users] Web Publishing

2009-08-13 Thread Johnny Rosenberg
for the odd page or two, but it really isn't suited for > website development (again, IMO, so fanboys, keep away). I used OpenOffice.org för web pages quite a while ago, but it didn't seem to follow W3C in every aspect so I dropped it. I love OpenOffice.org, but it's not good

Re: [users] Columns on/off

2009-08-13 Thread Johnny Rosenberg
And what is left on the first page? Did you use Insert → Section for the column stuff? Johnny Rosenberg 2009/8/12 Mark Howe : > I am having problems with columns in Writr.  I have everything perfect in > columns, I save it, the thumbnail even looks right; but when I open it, the >

Re: [users] stdout of a shell command into OpenOffice variable?

2009-08-19 Thread Johnny Rosenberg
I think the OpenOffice.org developers list is a better place to ask this kind of question. Maybe d...@api.openoffice.org or something like that. J.R. 2009/8/18 Christian Rößler : > Christian Rößler schrieb: > > Hallo everyone - answering my own posts, as usual:). > > For the record, as other have

Re: [users] stdout of a shell command into OpenOffice variable?

2009-08-19 Thread Johnny Rosenberg
ch for them when I need them. Johnny Rosenberg > > Best regards, Christian > > --- > To unsubscribe, e-mail: users-unsubscr...@openoffice.org > For additional commands, e-mail: u

Re: [users] Deleting 2+ spaces throughout a document

2009-08-20 Thread Johnny Rosenberg
s > replaced "a single space followed by zero or more spaces" with "a single > space". Read up about Regular Expressions for details. Your time doing that > will be well spent :-) > > And then it's pretty easy to write a macro that runs the same thi

Re: [users] Re: Deleting 2+ spaces throughout a document

2009-08-20 Thread Johnny Rosenberg
ce key as usual… This doesn't bring much new to the whole thing, I know, I just wanted to point the [:space:] thing out and also mention that there are other useful things too, like [:digit:], [:upper:], [:lower:], [:al

Re: [users] can OO replace MSO?

2009-08-20 Thread Johnny Rosenberg
ion as you can: What version of OpenOffice.org are you using? What is your operating system (Windows 7, Ubuntu 9.04, Mac OS 10.5, Mandriva Linux One 2009.1 etc)? What are you trying to do? What do you expect to happen? What actually happens? Things like tha

Re: [users] Re: Deleting 2+ spaces throughout a document

2009-08-21 Thread Johnny Rosenberg
go through the help file for > RE is worth the while! I actually read the help thing, but I obviously missed that part. Seems to be very usable! Thanks! Johnny Rosenberg > > Cheers, > Pradeep > -- > on 21 Aug 2009, Friday, IST (which is GMT +05:30) >

[users] OpenOffice.org crash when I try to open a file

2009-08-21 Thread Johnny Rosenberg
y difference is that this computer's OS is Ubuntu 8.10 and the Eee PC 900 has Ubuntu 9.04. Suggestions for further debugging? Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org

Re: [users] can OO replace MSO?

2009-08-22 Thread Johnny Rosenberg
and fix it there”, but no matter how hard I tried, I didn't find a way to make the TOC look the same way as it did in OpenOffice.org Writer. But that's very off topic… Johnny Rosenberg > The situation is bad enough to sway my decision to stick with MSO, unless I > resolve this di

Re: [users] can OO replace MSO?

2009-08-22 Thread Johnny Rosenberg
. When you insert the Index by clicking [Insert → Indexs and Tables → Indexes and Tables…], click on the Styles tab. That's the place to associate styles with levels. Johnny Rosenberg 2009/8/22 Drew Jensen : > Hi, > > Sorry for intruding - but if I don't do something othe

Re: [users] Compatibility question Openoffice

2009-08-23 Thread Johnny Rosenberg
export to PDF. Looks almost exactly like the original document, at least what I've seen so far. Johnny Rosenberg > > -- > Cameron Miller > Email: cmiller...@gmail.com > Cell:  858.205.3857 > - To unsubscribe, e

Re: [users] Re: OpenOffice.org crash when I try to open a file

2009-08-25 Thread Johnny Rosenberg
ve an external backup if things would go wrong. Johnny Rosenberg 2009/8/23 NoOp : > On 08/22/2009 01:26 PM, NoOp wrote: >> On 08/21/2009 11:54 AM, Johnny Rosenberg wrote: >>> ”terminate called after throwing an instance of >>> 'com::sun::star::uno::RuntimeException&

Re: [users] Calc: Array Problem

2009-08-28 Thread Johnny Rosenberg
I am not sure, but I don't think things like ROW(1:12) is supported in Calc. I remember many years ago when I, used to Excel, typed something like ”=SUM(A:A)” (mening ”sum the entire A column”) in a cell. That works with Excel, but didn't with Calc. Still today, I don't think this

Re: [users] Embedding fonts in ODF documents.

2009-08-28 Thread Johnny Rosenberg
I don't think that's possible (maybe I'm wrong though). If you want to be sure about fonts, export to PDF. J.R. 2009/8/28 Dotan Cohen : > How does one embed a font in an ODF document if he is unsure that the > receiver will have that font? Thanks. > > -- > Dotan Cohen > > http://what-is-what.com

[users] Error 522 in full screen mode

2009-08-30 Thread Johnny Rosenberg
h;freekin;blaha;aha). Thanks for listening… Johnny Rosenberg - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org

[users] Re: Error 522 in full screen mode

2009-08-31 Thread Johnny Rosenberg
I just filed a bug report about this one, and it can be found at: http://www.openoffice.org/issues/show_bug.cgi?id=104659 I also attached (to the bug report, not here) an example spreadsheet where this problem occurs. J.R. Den 30 augusti 2009 09.39 skrev Johnny Rosenberg: > I have a s

Re: [users] Open Office

2009-09-02 Thread Johnny Rosenberg
? Or your locale setting. > > *I think this is some problems in Open office.* Yes, there are, just like with all the other software in the world. Johnny Rosenberg *Guitarist*… > > >  *Thank you very much, and happy day.* > > >  *Mr Merouane Louma

Re: [users] Open Office

2009-09-02 Thread Johnny Rosenberg
Please stop being an idiot. There's no need to write the same ”question” or message over and over again. Just wait for people to reply. If nobody do, well, then I guess nobody has anything to say. Johnny Rosenberg 2009/9/2 Merouane Louma : > > > Dear > Sir > > > >

Re: [users] Open Office

2009-09-03 Thread Johnny Rosenberg
2009/9/3 Harold Fuchs : > Johnny Rosenberg wrote: >> >> Please stop being an idiot. There's no need to write the same >> ”question” or message over and over again. Just wait for people to >> reply. If nobody do, well, then I guess nobody has anything to say. >&

Re: [users] Open Office

2009-09-04 Thread Johnny Rosenberg
2009/9/4 Michael Adams : > On Thu, 03 Sep 2009 21:49:54 +0200 > Came this utterance formulated by Johnny Rosenberg to my mailbox: > >> > Johnny Rosenberg wrote: >> >> >> >> Please stop being an idiot. There's no need to write the same >> >&g

Re: [users] Open Office

2009-09-05 Thread Johnny Rosenberg
his by purpose and I apologize if someone was hurt. Johnny Rosenberg 2009/9/5 Gene Heskett : > On Saturday 05 September 2009, M Henri Day wrote: >>2009/9/5 Lars Nooden >> >>> Johnny Rosenberg wrote: >>> > Since English is not my first language (and I don't ha

Re: [users] I have no Times New Roman?

2009-09-06 Thread Johnny Rosenberg
Serif should be pretty compatible to Times New Roman and Free mono could perharps replace Courier New. Anyway, if a font is missing and the original document was created with it, the font listbox will still display that fonts name, but another font is selected, hopefully a similar font. J

Re: [users] Your system is incredible a bunch of trash.

2009-09-06 Thread Johnny Rosenberg
2009/9/5 Humberto Vargas Suárez : > First  of  all,  I  need  that  all  your  bull  shetters  pages,  must  BE > IN  SPANISH. Then write to the spanish list. This one is English only (however, non-perfect English is OK). Best regards Johnny Rosenberg   second  in  too many  times  I  d

Re: [users] formula in Calc

2009-09-07 Thread Johnny Rosenberg
2009/9/7 Walter Hildebrandt : > The following formula works to give a Yes or a No in C1 > > IF(AND(A1>=0;B1>=0);"Yes";"No") > > How can that formula be increased so that not only A1 and B1 is used but > that C1, D1 and E1 be included > > In other words, what formula can be used when A1>=0 and B1>=0

Re: [users] I have no Times New Roman?

2009-09-07 Thread Johnny Rosenberg
earch for it with Synaptic and see if it's still marked as installed. OpenOffice.org use the system fonts, so everything that's installed in the system SHOULD work in OpenOffice.org, as far as I know. J.R. > > Linda > > - Original Message - > From: "Johnny Rosenb

Re: [users] Spreadsheet update automation

2009-09-08 Thread Johnny Rosenberg
Maybe you could try the developer's mail list? I think it is d...@openoffice.org or something like that. J.R. 2009/9/8 James E. Lang : > I take it that no one here knows how to automate spreadsheet updates and no > one knows a better forum to ask. > > If you need me to, I'll send you a personal c

Re: [users] 'Save as' annoyance

2009-09-09 Thread Johnny Rosenberg
oesn't seem to remember where I save files or any other locations I use for my files, so I always have to start all over again from my home folder (~/ or $HOME). By the way, you don't need to say ”od*" format. You can say ODF (Open Document Format) since it includes ods, odt and all

Re: [users] Macro to SaveAs .csv format

2009-09-17 Thread Johnny Rosenberg
The macro recorder sucks, sorry to say that. Just don't use it. Just type the commands manually instead. It's a bit of a learning curve, but it's worth it. If you know Basic, installing Xray will help you a lot to figure out most of the objects you need. For example: Option Explicit Sub MyTestS

Re: [users] Sue

2009-09-17 Thread Johnny Rosenberg
2009/9/17 sue gill > > > Dear? > I have got 6e-mails that keep coming to me, what's going on. > Don't worry about my inquire I have  Purchased Microsoft Office now, I > certainly won't be purchasing any more of your products. You don't purchase OpenOffice.org. You download it for free at www.ope

Re: [users] OpenOffice Basic - Converting Spreadsheet formulas into string

2009-09-18 Thread Johnny Rosenberg
Cell=Sheet.getCellByPosition(0,0) Cell.setString(Cell.getString()) End Sub In the example above, A1 will now contain '90. The ' is not displayed, but 90 will be aligned to the left. Johnny Rosenberg > > Also the same for converting from Formula to Value it wou

Re: [users] Newline between paragraphs?

2009-09-18 Thread Johnny Rosenberg
2009/9/19 John Kaufmann : > Does OO Writer deprecate the traditional practice of inserting a  return > (newline = "carriage return" = "hard return" = "line break") between > paragraphs?  If not, how can Writer handle the case where the end of a > paragraph coincides with the end of a page, such tha

  1   2   3   4   5   6   7   8   >