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

2011-08-22 Thread Johnny Rosenberg
2011/8/22 Tom Davies tomdavie...@yahoo.co.uk: Hi :) N, who would there be to argue with then?  Errr, i mean discuss. Fortunately saying something and doing it is sometimes not the same thing… :P Regards from Tom :) From: Johnny Rosenberg gurus.knu

Re: [libreoffice-users] Re: Constant values for Function arguments

2011-08-22 Thread Johnny Rosenberg
described will work just fine. Well, this thread is maybe a bit old by now, but if I didn't mention it before, that's the solution I finally adopted, just that I didn't put an ”s” there, but it's the same idea. Thanks, everyone! Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ -- View this message

Re: [libreoffice-users] Re: ReDim of a variable of a custom type

2011-08-23 Thread Johnny Rosenberg
2011/8/23 Johnny Rosenberg gurus.knu...@gmail.com: 2011/8/20 Johnny Rosenberg gurus.knu...@gmail.com: 2011/8/19 Niklas Johansson sleeping.pil...@gmail.com: To empty the array use x = Nothing. So before the ReDim-statement do... …       x = Nothing       ReDim x(1) As MyType … I think you

Re: [libreoffice-users] Re: ReDim of a variable of a custom type

2011-08-23 Thread Johnny Rosenberg
2011/8/23 Johnny Rosenberg gurus.knu...@gmail.com: 2011/8/23 Johnny Rosenberg gurus.knu...@gmail.com: 2011/8/20 Johnny Rosenberg gurus.knu...@gmail.com: 2011/8/19 Niklas Johansson sleeping.pil...@gmail.com: To empty the array use x = Nothing. So before the ReDim-statement do... …       x

Re: [libreoffice-users] Help, corrupted file after computer crash

2011-08-25 Thread Johnny Rosenberg
regards Johnny Rosenberg ジョニー・ローゼンバーグ Help and suggestions are greatly appreciated. Regards, Kong Susanto -- 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

Re: [libreoffice-users] Help, corrupted file after computer crash

2011-08-25 Thread Johnny Rosenberg
in Ubuntu, at least I don't remember that I installed mine separately. Anyway, it seems like Susanto lost the file permanently. Hopefully someone learned to always take backups of everything. Since using Ubuntu, why not try Ubuntu One for syncing files? Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ

Re: [libreoffice-users] Re: Basic question for new LibreOffice user...

2011-08-25 Thread Johnny Rosenberg
the 3.4.2 change log too… Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ Regards from Tom :) From: Johnny Rosenberg gurus.knu...@gmail.com To: users@global.libreoffice.org Sent: Thu, 25 August, 2011 17:55:42 Subject: Re: [libreoffice-users] Re: Basic

Re: [libreoffice-users] Re: Basic question for new LibreOffice user...

2011-08-25 Thread Johnny Rosenberg
2011/8/25 Johnny Rosenberg gurus.knu...@gmail.com: 2011/8/25 Tom Davies tomdavie...@yahoo.co.uk: Hi :) It was the 3.4.0 that was really bad.  That is probably the one you tried.   The 3.4.1 was ok but the 3.4.2 is much better judging from the comments about it. It's really stable now i think

Re: [libreoffice-users] Re: Basic question for new LibreOffice user...

2011-08-25 Thread Johnny Rosenberg
2011/8/25 Johnny Rosenberg gurus.knu...@gmail.com: 2011/8/25 Johnny Rosenberg gurus.knu...@gmail.com: 2011/8/25 Tom Davies tomdavie...@yahoo.co.uk: Hi :) It was the 3.4.0 that was really bad.  That is probably the one you tried.   The 3.4.1 was ok but the 3.4.2 is much better judging from

Re: [libreoffice-users] Re: Basic question for new LibreOffice user...

2011-08-25 Thread Johnny Rosenberg
, MyFile 20110823.ods and so on, but I would need a way bigger drive for that…). Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ  I think Murphy's Law or something?  At some point i might try the newer ones but i'm quite happy waiting for them to appear in the repos/ppa. Regards from Tom

Re: [libreoffice-users] Re: Basic question for new LibreOffice user...

2011-08-25 Thread Johnny Rosenberg
to upload all my data - about double the max. dial-up upload speed but 10MB+ download speed.  So any online backup service is out for my needs. But you can always backup to external drives, right? You just need to buy a couple of really big ones… Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ

Re: [libreoffice-users] Re: Re: Basic question for new LibreOffice user...

2011-08-26 Thread Johnny Rosenberg
2011/8/25 Twayne twa...@twaynesdomain.com: In news:CADo7T4ehM-8YwizE5SDCP=C=53C22FBksN=f3rags6z3n6j...@mail.gmail.com, Johnny Rosenberg gurus.knu...@gmail.com typed: 2011/8/25 webmaster for Kracked Press Productions webmas...@krackedpress.com: Found 3.3.3 solved most of my issues that 3.3.2

Re: [libreoffice-users] 2 Questions about Calc in LibreOffice

2011-08-26 Thread Johnny Rosenberg
haven't seen that ever, and I run LibreOffice 3.3 since quite a while by now, and I also had OpenOffice.org 3.3 for quite some time. Can you include those cells (or similar ones) in the example document? Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ        Each time this anomalie occurs, I have

Re: [libreoffice-users] Re: strikethrough feature

2011-08-27 Thread Johnny Rosenberg
2011/8/27 NoOp gl...@sbcglobal.net: On 08/26/2011 04:03 PM, Johnny Rosenberg wrote: ... You can do that yourself. Here is how: Tools → Customize… → Toolbars. LibreOffice Writer Toolbars – Toolbar: Select ”Formatting” In the ”Commands” list, scroll down to ”Underline” and highlight

Re: [libreoffice-users] Re: strikethrough feature

2011-08-27 Thread Johnny Rosenberg
2011/8/27 Twayne twa...@twaynesdomain.com: In news:cado7t4fptxqvhz5bnkswhgdgapffcznrro43phwsb1bs52h...@mail.gmail.com, Johnny Rosenberg gurus.knu...@gmail.com typed: 2011/8/25 Maria Rechnitzer rrrah...@gmail.com: Dear Support, This is the LibreOffice users' list. It's not a real support. We

Re: [libreoffice-users] Re: Spreadsheet 3.4.2 Bug

2011-08-27 Thread Johnny Rosenberg
2011/8/27 Andreas Säger ville...@t-online.de: The only thing that seems broken is the page preview (FilePage Preview). In LibO 3.3 and 3.4. it shows the print pages of the current sheet only. ViewPageBreak Preview shows all the pages on each sheet. The new FilePrint... dialog shows all

Re: [libreoffice-users] Linked Cell says True instead of Showing the value

2011-08-28 Thread Johnny Rosenberg
here? That would make it a lot easier to answer your question. 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] Linked Cell says True instead of Showing the value

2011-08-28 Thread Johnny Rosenberg
2011/8/28 Tom Davies tomdavie...@yahoo.co.uk: Hi :) Even just copypasting the equation into a reply to this thread might help ;) Regards from Tom :) Might help but not necessarily, I think. Depends on where the problem is. It's not always where it seems to be… Kind regards Johnny Rosenberg

Re: [libreoffice-users] Search and replace

2011-09-01 Thread Johnny Rosenberg
2011/9/1 Tom Davies tomdavie...@yahoo.co.uk: Hi :) The Return looks different in different apps, for example in GEdit it shows as a /n Really? Isn't it \n? Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ I tend to select an area that includes a carriage-return and then try findreplace

Re: [libreoffice-users] CALC - copy formula via macro

2011-09-03 Thread Johnny Rosenberg
/OOME_3_0.pdf Even if you can't use it in this situation, it might be good reading anyway… 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

Re: [libreoffice-users] Re: CALC - copy formula via macro

2011-09-03 Thread Johnny Rosenberg
somehow (how many ways are there to double click a handle anyway?). 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

Re: [libreoffice-users] Re: CALC - copy formula via macro

2011-09-03 Thread Johnny Rosenberg
2011/9/3 Andreas Säger ville...@t-online.de: Johnny Rosenberg wrote: 2011/9/3 Andreas Säger lt;ville...@t-online.degt;: A double-click on the cell handle will drag down until the end of the adjacent column which is what most people want to do in most cases. Doesn't happen to me

Re: [libreoffice-users] Re: Should LibreOffice even support Microsoft secret formats?

2011-09-11 Thread Johnny Rosenberg
? 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

Re: [libreoffice-users] A small annoying problem with the formula editor

2011-10-16 Thread Johnny Rosenberg
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

Re: [libreoffice-users] Different opening times between Ubuntu and Windows7?

2011-10-17 Thread Johnny Rosenberg
2011/10/17 Gordon Burgess-Parker gbpli...@gmail.com: Has anyone noticed this? I have two machines - both Toshiba, one a Satellite L40 with duo core twin processors @ 1.6 GHz running Windows 7 SP1, the other a Netbook NB100 with one processor @ 1.6 GHz running Ubuntu 10.04 LTS. Both machines

Re: [libreoffice-users] question LIBREOFFICE

2011-10-20 Thread Johnny Rosenberg
+ + LIBREOFICCE? Thank you. Best Regards Why not just download the source code and have a look at it? 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

Re: [libreoffice-users] problem with formulas

2011-10-24 Thread Johnny Rosenberg
There is a setting for this, maybe it's not set properly? Tools → Options… → LibreOffice Calc → Formula → ☒ Use English function names Should be: Tools → Options… → LibreOffice Calc → Formula → ☐ Use English function names Or maybe it's the bug that's already mentioned. Kind regards Johnny

Re: [libreoffice-users] How may I read the value of a cell into a macro variable?

2011-10-30 Thread Johnny Rosenberg
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

Re: [libreoffice-users] function aliases in calc

2011-11-05 Thread Johnny Rosenberg
it out from the documentation. 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

Re: [libreoffice-users] How do I enter a numeric into a Calc cell from LO Basic macro?

2011-11-21 Thread Johnny Rosenberg
you want to use that UNO dispatcher thing or whatever it is called. Why not just doing something like the following? Dim x As Integer x=3 ThisComponent.getSheets().getByIndex(0).getCellByPosition(0,0).setValue(x) Well, something like that, I didn't test it. Kind regards Johnny Rosenberg ジョニー

Re: [libreoffice-users] Loading and Saving in Calc is too slow

2011-11-24 Thread Johnny Rosenberg
be extracted, then all the different files is explored and so on. I guess those things take quite a lot more time than just reading or writing a binary file. So the only thing you can do about it is probably to get a faster computer and things like that… Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ Im

[libreoffice-users] Stuck with 3.3 forever?

2011-12-03 Thread Johnny Rosenberg
the best way to go? Why is handling an empty cell as 0 in calculations such a bad idea? Am I stuck with 3.3 like forever ow or is this going to change any time soon? Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org

Re: [libreoffice-users] Re: Stuck with 3.3 forever?

2011-12-03 Thread Johnny Rosenberg
2011/12/3 Pedro pedl...@gmail.com: Johnny Rosenberg wrote Depending on the value in other cells, the result can be a time or an empty string (). In this case, E9 is an empty string, so E10 becomes ”#VALUE!”, and in fact every cell below E10 is also ”#VALUE!” because of this. Can you

Re: [libreoffice-users] Stuck with 3.3 forever?

2011-12-03 Thread Johnny Rosenberg
Rosenberg ジョニー・ローゼンバーグ Regards from Tom :) --- On Sat, 3/12/11, Johnny Rosenberg gurus.knu...@gmail.com wrote: From: Johnny Rosenberg gurus.knu...@gmail.com Subject: [libreoffice-users] Stuck with 3.3 forever? To: LibreOffice Användare users@global.libreoffice.org Date: Saturday, 3

Re: [libreoffice-users] Re: Stuck with 3.3 forever?

2011-12-03 Thread Johnny Rosenberg
=6;;B1) Now, in some cases, A2 will be an empty string, so =A2+1 will fail in another cell, right? Is there another way to make A2 look empty in this case, making it useable for calculations? Something like the following: =IF(A1=6;SomethingNiceToPutHere;B1) Kind regards Johnny Rosenberg ジョニー

Re: [libreoffice-users] Stuck with 3.3 forever?

2011-12-03 Thread Johnny Rosenberg
2011/12/3 MiguelAngel mari...@miguelangel.mobi: In 3.4 only text which can be explicitly interpreted as number, is treated as number, and an space or an empty string is not a number. But what's wrong with having any kind of no-number-strings treated like 0? You can use the N(e9) to avoid

Re: [libreoffice-users] Re: Stuck with 3.3 forever?

2011-12-04 Thread Johnny Rosenberg
2011/12/3 Jay Lozier jsloz...@gmail.com: On 12/03/2011 12:50 PM, Johnny Rosenberg wrote: 2011/12/3 Pedropedl...@gmail.com: Johnny Rosenberg wrote Depending on the value in other cells, the result can be a time or an empty string (). In this case, E9 is an empty string, so E10 becomes

Re: [libreoffice-users] Re: Stuck with 3.3 forever?

2011-12-04 Thread Johnny Rosenberg
2011/12/3 Pedro pedl...@gmail.com: Johnny Rosenberg wrote I could agree with that, but it would have been nice if they thought of that since 1.0 and not changing it on the way, breaking a whole lot of spreadsheets… I see your point. But this was wrong. It's not a change of plans it's

Re: [libreoffice-users] Re: Re: Stuck with 3.3 forever?

2011-12-05 Thread Johnny Rosenberg
2011/12/5 Harold Fuchs hwfa.gmanen...@gmail.com: Johnny Rosenberg gurus.knu...@gmail.com wrote in message news:cado7t4d47+3comv6+rbhbloeb6wpilhf3isrfm0o5qmpkcx...@mail.gmail.com... 2011/12/3 Pedro pedl...@gmail.com: Johnny Rosenberg wrote I could agree with that, but it would have been

Re: [libreoffice-users] Re: Re: Stuck with 3.3 forever?

2011-12-05 Thread Johnny Rosenberg
have now and visible/invisible contents, and I'm not sure three different conditions will be enough. It seems more complicated than using N() in any case, I think. Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems

Re: [libreoffice-users] Identifying the correct row in Spreadsheet formulas

2011-12-09 Thread Johnny Rosenberg
Hope you follow me. Thanks for any help. Ian Whitfield. I would take a look at MATCH(). You can use Ctrl+F2 to experiment with different functions in a more graphical way. After selecting a function, you can click Help for more information about that function. Kind regards Johnny Rosenberg

Re: [libreoffice-users] Re: [SOLVED] Identifying the correct row in Spreadsheet formulas

2011-12-11 Thread Johnny Rosenberg
there actual position of the values I wanted to check in then the ROW COUNT returned by MATCH would in fact be the actual ROW NUMBER!! Or you could just use the original array and add what's missing, like ”=MATCH(Paramters)+Something” Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ Problem

Re: [libreoffice-users] Re: AVERAGE calculation differs when alone or in a complex formula?

2011-12-29 Thread Johnny Rosenberg
AVERAGE formula, that is in a complex formula calculate the value '4,07' but the cell 'AD46' calculate with the same AVERAGE formula when is alone the value '4,13'. How could that be? Take a look again. They are still not the same (AD20 ≠ AD21). Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ

Re: [libreoffice-users] Re: AVERAGE calculation differs when alone or in a complex formula?

2011-12-29 Thread Johnny Rosenberg
2011/12/29 Johnny Rosenberg gurus.knu...@gmail.com: 2011/12/29 csanyipal csanyi...@gmail.com: Jay, Jay Lozier wrote On 12/29/2011 09:09 AM, csanyipal wrote: I'm trying to figure out why differs AVERAGE calculations when using it alone in a cell or when using it in a complex formula

Re: [libreoffice-users] Ignoring text in calc formula

2012-01-01 Thread Johnny Rosenberg
does the same thing and both of them works no matter if cells contain text or numerical data. However, the last example is a bit necessary, since ”=SUM(E4;D5)” works perfectly without the N() function. Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ -- For unsubscribe instructions e-mail to: users

Re: [libreoffice-users] Ignoring text in calc formula

2012-01-01 Thread Johnny Rosenberg
2012/1/1 Johnny Rosenberg gurus.knu...@gmail.com: 2012/1/1 Jay Lozier jsloz...@gmail.com: Toni Please advise which LO version you are using and your OS. This will help us determine if the problem is a know issue with a specific version of LO or with a particular OS. For your problem, I

[libreoffice-users] Can't edit my macros

2012-01-03 Thread Johnny Rosenberg
into it. I can highlight text, but that's about all I can do in that window. Anyone else seen this? Where to start debugging…? Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help

Re: [libreoffice-users] Re: Can't edit my macros

2012-01-03 Thread Johnny Rosenberg
script.xlb I suspect it could have something to do with Compiz-Fusion though, since I fiddled a bit with it a few days ago. Just turned it off and the problem was solved. Going to find out which of its plugins that caused the problem. Thanks for replying. Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ

Re: [libreoffice-users] libre draw source code needed

2012-01-06 Thread Johnny Rosenberg
2012/1/6 Johnny Rosenberg gurus.knu...@gmail.com: 2012/1/6 Ankush bansal anku...@gmail.com: Dear Sir,Mam, This mail is regarding libre draw,i have to implement some new features to libre office draw, so kindly provide me source code for libre office. http://www.libreoffice.org/download

Re: [libreoffice-users] Re: Latest version?

2012-01-06 Thread Johnny Rosenberg
provided? When an answer is not clear people ask for more details. They don't simply open a NEW TOPIC to ask EXACTLY the same question. I think the OP didn't bother to read any of the answers given yesterday... Fabian is not the OP. Caesar is. Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ

Re: [libreoffice-users] Re: Latest version?

2012-01-06 Thread Johnny Rosenberg
2012/1/6 Pedro pedl...@gmail.com: Johnny Rosenberg wrote I think the OP didn't bother to read any of the answers given yesterday... Fabian is not the OP. Caesar is. That is exactly what I said. The OP of this thread (Cesar) didn't read any of the answers given yesterday on the thread

Re: [libreoffice-users] calc sort

2012-01-07 Thread Johnny Rosenberg
this. Those two cells, how did you enter their content? Just typing ”Tue” and ”Wed” into them or typing actual dates and then format them to only view weekdays? Exactly how did you sort them? Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ -- For unsubscribe instructions e-mail to: users+h

Re: [libreoffice-users] calc sort

2012-01-08 Thread Johnny Rosenberg
2012/1/7 Jay Lozier jsloz...@gmail.com: On 01/07/2012 12:32 PM, James wrote: On 01/07/12 03:48, Johnny Rosenberg wrote: 2012/1/7 Jamesbjloc...@lockie.ca: I made a simple sheet in calc that just contained 'Tue' and 'Wed'. Both cells are a date format but I tried to sort them and they won't

Re: [libreoffice-users] Set Print Range quickly?

2012-01-11 Thread Johnny Rosenberg
2012/1/11 . pe...@aleksandrsolzhenitsyn.net: Besides Format -Print Ranges---Define..is there a quick way to set a print range? Well, you could probably set up a keyboard short-cut for it, I'd guess. What's quicker than that? Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ

Re: [libreoffice-users] Need simple find replace macro

2012-01-19 Thread Johnny Rosenberg
the ”}” and delete it, but I couldn't find a way to place the cursor there! That's funny, because that should be one of the more basic things to do. Well, I don't say it's imposible, just that I was stupid enough to not find the answer. Sorry… Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ

Re: [libreoffice-users] Re: Need simple find replace macro

2012-01-19 Thread Johnny Rosenberg
the } character.  I want a macro to find that character, delete it, and leave the cursor at that position.  It needs to be one I can assign to a key. You can assign any macro to a key. Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ Paul -- View this message in context: http

Re: [libreoffice-users] Need simple find replace macro

2012-01-19 Thread Johnny Rosenberg
2012/1/19 Calvin Kim cal...@4to14window.com: On 01/19/2012 12:59 PM, Johnny Rosenberg wrote: 2012/1/19 paulwhitehurstwhan...@aol.com: I want to migrate my law office from WordPerfect to Libreoffice.  My forms have the } character that I use where I want to input text.  I created a macro

Re: [libreoffice-users] question about search replace

2012-01-21 Thread Johnny Rosenberg
for certain format attributes, like italic, but not how to replace one attribute with another, Well, unless you want to write a macro, of course. Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http

Re: [libreoffice-users] question about search replace

2012-01-21 Thread Johnny Rosenberg
the Replace with window?) o Click Replace All. I trust this helps. Thanks, Jean-Christophe Sekinger for asking the question and Brian Barker for answering it! I didn't know this was possible! Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ Brian Barker -- For unsubscribe instructions e-mail

Re: [libreoffice-users] Excel macros and functions

2012-01-23 Thread Johnny Rosenberg
2012/1/23 Nathan Gutman nzgut...@sbcglobal.net: I have a rather complex Excel 2003 spreadsheet which extensively uses some built function and macros. Can Calc translate and run them? Nathan Probably not. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems?

Re: [libreoffice-users] Suggestions for LibreOffice

2012-01-29 Thread Johnny Rosenberg
2012/1/19 Help_Please mykelt...@gmail.com: Suggestion One:    Include Check for updates  to perform online checking for updates to LibreOffice. Your distro should take care of that for you automatically. Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ -- For unsubscribe instructions e-mail

Re: [libreoffice-users] Problems with format in Calc

2012-02-01 Thread Johnny Rosenberg
in your version? 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

Re: [libreoffice-users] Problems with format in Calc

2012-02-02 Thread Johnny Rosenberg
”wednesday,” but NNN displays only ”wednesday”, so that's probably how to get rid of the comma, if there is one… Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ Perhaps post a bug-report/'feature request'? Regards from Tom :) --- On Thu, 2/2/12, Thomas Damratowski tomraymond...@gmail.com wrote: From

Re: [libreoffice-users] emacs mode?

2012-02-02 Thread Johnny Rosenberg
. It´s not at all limited to the programming of mainframes. Yes, I remember the early 1990's when I played MUD in Emacs and later I also used Emacs for IRC. Good old days… :) Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ -- For unsubscribe instructions e-mail to: users+h

Re: [libreoffice-users] LO 3.5 - Can't see page margins in Writer

2012-02-14 Thread Johnny Rosenberg
in 3.5 is getting rid of the visible ”border” for the margins, if that's what you mean. 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

Re: [libreoffice-users] LO 3.5 - Can't see page margins in Writer

2012-02-15 Thread Johnny Rosenberg
2012/2/14 yahoo-pier_andreit pier_andr...@yahoo.it: On 14/02/12 17:49, Ron Johnson wrote: On 02/14/2012 10:34 AM, Johnny Rosenberg wrote: 2012/2/14 noibsnoibs...@me.com: I just upgraded to 3.5 from 3.4.4. There are no page margins visible for my Writer documents last saved in 3.4.4. Am I

Re: [libreoffice-users] Macros - Basic Documentation

2012-02-19 Thread Johnny Rosenberg
be a good start. Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ Dim ... Dim ... x(0)=... [etc] dispatcher.executeDispatch(document, .uno:Move, , 0, args1()) End Sub --- Very Good! Now I know the instruction is a dispatcher with URL/Command .uno:Move If I place

Re: [libreoffice-users] LO Calc (3.4.5 and 3.5.0): Displaying sum() Results

2012-02-22 Thread Johnny Rosenberg
might I be doing incorrectly? Rich Tools → Options → LibreOffice Calc → View → Untick ”Show formulas”. 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

Re: [libreoffice-users] LO Calc (3.4.5 and 3.5.0): Displaying sum() Results

2012-02-22 Thread Johnny Rosenberg
2012/2/22 Johnny Rosenberg gurus.knu...@gmail.com: 2012/2/22 Rich Shepard rshep...@appl-ecosys.com:  I thought that I used to be able to enter =sum(d1:f1) in a cell and see the numeric results of the summation. Now, however, all I see is the function in that cell. Happens, too, with clicking

Re: [libreoffice-users] Re: calc problem

2012-02-27 Thread Johnny Rosenberg
: Ubuntu 10.10 Web browser: Opera 11.61 Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ Dan I think that discussion what is faster or slower is off topic. I just need to solve problem with dialogue. Not find how to do it better or another way. Dne 27.2.2012 14:48, Dan Lewis napsal

Re: [libreoffice-users] Re: calc : very slow

2012-02-27 Thread Johnny Rosenberg
2012/2/27 Andreas Säger ville...@t-online.de: Am 27.02.2012 10:43, pcpconsulting wrote: I have removed libreoffice 3.5 from my computer linux ubuntu and I have reinstalled version 3.3.4 because operating with calc appear very slow. I use one file in calc linked to another one as dabase with

Re: [libreoffice-users] How do add percentage in Calc?

2012-03-03 Thread Johnny Rosenberg
), or as a constant in A1, that is A1=100*(1+A2). If you want A1 to change its value by Itself·(1+A2) every time you enter a new value in A2, then you could use a macro for that, but how ever you do it, you are very likely to shoot yourself in the foot. Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ

Re: [libreoffice-users] How do add percentage in Calc?

2012-03-03 Thread Johnny Rosenberg
as that. If you want it to be even more obvious what's going on, enter =A1*(100%+A2) in A3. 100% will automatically be changed to 1, though, so you'll get the same =A1*(1+A2) anyway. Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ A percentage is really just a number over or divided by 100 of course

Re: [libreoffice-users] Re: Calc macro to open tab delimited data file?

2012-03-07 Thread Johnny Rosenberg
with text, ↹ and ↵ and so on. The macros could automatically detect how many rows and columns there are, shouldn't be too difficult. I'd give it a try if I had some time left. Sorry that I don't at the moment. Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ -- For unsubscribe instructions e-mail

Re: [libreoffice-users] Re: Calc macro to open tab delimited data file?

2012-03-08 Thread Johnny Rosenberg
always filter your posts out with his email client… :P 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

[libreoffice-users] A Writer question about cross references

2012-03-15 Thread Johnny Rosenberg
: ”2.” Expected result: ”2” If I wanted a dot, I could always enter it after the ”2”… 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

Re: [libreoffice-users] formatting emails

2012-03-24 Thread Johnny Rosenberg
(only ↵, that is Shift+¶, can be found), and that's why Search And Replace won't work in this case. I think there is a workaround, but I don't remember how… Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http

Re: [libreoffice-users] formatting emails

2012-03-24 Thread Johnny Rosenberg
Den 24 mars 2012 13:11 skrev Dan Lewis elderdanle...@gmail.com: On Sat, 2012-03-24 at 11:01 +, Brian Barker wrote: At 09:24 24/03/2012 +, E. Letter wrote: On a separate issue, what is the syntax in LO to select paragraph breaks (pilcrow (¶) sign) in the 'find and replace' dialogue

Re: [libreoffice-users] question

2012-03-25 Thread Johnny Rosenberg
Den 25 mars 2012 10:02 skrev Łukasz Janik ljani...@wp.pl: and, finally, will improve the Java 3.5.x libreoffice 7 to be compatible I'm sorry, I don't quite follow you. Seems that most of your text is missing, doesn't it? Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ czy wreszcie poprawicie

Re: [libreoffice-users] How to edit words and phrases in a pdf

2012-04-12 Thread Johnny Rosenberg
this was about PDF, so if you find something that does the OCR thing on PDF files and save the result as PDF, it ”works” with everything that can open PDF, including LibreOffice. Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ --- On Thu, 12/4/12, Marc Groberm...@interak.com  wrote: From: Marc

Re: [libreoffice-users] select en-dash and em-dash characters

2012-04-16 Thread Johnny Rosenberg
”this - that” is automatically converted to ”this – that”. I'm not sure about the em-dash though. You can easily create new abbreviations for auto correct, for example making ” —” out of ” --- ” and so on. Best regards Johnny Rosenberg ジョニー・ローゼンバーグ -- For unsubscribe instructions e-mail to: users

Re: [libreoffice-users] Re: Calc function

2012-04-18 Thread Johnny Rosenberg
and hard to read… 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

Re: [libreoffice-users] select en-dash and em-dash characters

2012-04-18 Thread Johnny Rosenberg
Den 17 april 2012 22:32 skrev Thomas Taylor li...@comcast.net: On Tue, 17 Apr 2012 18:09:31 +0200 Johnny Rosenberg gurus.knu...@gmail.com wrote: Den 16 april 2012 22:36 skrev Séamas Ó Brógáin s...@iol.ie: Regina wrote: They are usually written via AutoCorrect. The simple hyphen

Re: [libreoffice-users] select en-dash and em-dash characters

2012-04-18 Thread Johnny Rosenberg
I thought this was true for all of them. Maybe it's a Gnome thing and you have the KDE version of OpenSUSE? Well, I don't think so, but I use Gnome only, so I don't know. Best regards Johnny Rosenberg ジョニー・ローゼンバーグ -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org

Re: [libreoffice-users] select en-dash and em-dash characters

2012-04-18 Thread Johnny Rosenberg
Den 18 april 2012 18:19 skrev Johnny Rosenberg gurus.knu...@gmail.com: Den 18 april 2012 02:12 skrev Thomas Taylor li...@comcast.net: On Tue, 17 Apr 2012 10:48:22 +0100 Séamas Ó Brógáin s...@iol.ie wrote: Doug: Using the compose key, the default settings are:    dash (em rule

Re: [libreoffice-users] calc compliance with openformula

2012-04-21 Thread Johnny Rosenberg
Den 20 april 2012 15:57 skrev e-letter inp...@gmail.com: Readers, According to the specification for openformula (see: http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html), the syntax for the function 'sum' is: SUM( { NumberSequenceList N }+ ) e.g. SUM(a1+b2)

Re: [libreoffice-users] calc compliance with openformula

2012-04-21 Thread Johnny Rosenberg
Den 20 april 2012 15:57 skrev e-letter inp...@gmail.com: Readers, According to the specification for openformula (see: http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html), the syntax for the function 'sum' is: SUM( { NumberSequenceList N }+ ) e.g. SUM(a1+b2)

Re: [libreoffice-users] Formulas...

2012-05-09 Thread Johnny Rosenberg
2012/5/10 Mirosław Zalewski mini...@poczta.onet.pl: Hi Zed I believe you are looking for =E10/$D$10 Or rather =E10/$D$4… -- Best regards Mirosław Zalewski -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems?

Re: [libreoffice-users] No QuickStarter? (Linux)

2012-05-20 Thread Johnny Rosenberg
2012/5/20 Tom Davies tomdavie...@yahoo.co.uk: Hi :) Is this in Windows? Read the subject line again… Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ The quick-starter is one of the options during install.  I think you can try reinstalling but choose the Repair option instead of the full re

Re: [libreoffice-users] Re: No QuickStarter? (Linux)

2012-05-22 Thread Johnny Rosenberg
of it.  Mine is over 2GHz but has low cache. GnuLinux with 8Gb ram!!?!? 8 Gb=1 GB. :P Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ   Lol, why!?!!  Was it made for Windows perchance?  I guess that much would be good for playing around with virtual machines.  You could have a whole swarm

Re: [libreoffice-users] Re: No QuickStarter? (Linux)

2012-05-22 Thread Johnny Rosenberg
things, and now I really mean SIMPLE things, then perhaps Gnumeric and AbiWord could work for you? 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

Re: [libreoffice-users] Libre Office localization for multinational work environment

2011-03-28 Thread Johnny Rosenberg
? Thanks in advance. Cevad OZTUG Select the appropriate language (the language that makes use of that number format you are talking about) in your character settings in your styles and/or in your document. -- Best regards Johnny Rosenberg -- Unsubscribe instructions: E

Re: [libreoffice-users] Libre Office localization for multinational work environment

2011-03-28 Thread Johnny Rosenberg
the ”1'234.12” format: French (Schweiz) German (Liechtenstein) German (Schweiz) Italian (Schweiz) Seems to be a Schweiz/Liechtenstein thing… -- Best regards Johnny Rosenberg -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users

Re: [libreoffice-users] Bug in calc?

2011-03-28 Thread Johnny Rosenberg
OpenOffice.org windows on any of my desktop areas… I have Ubuntu 10.10, OpenOffice.org 3.3.0 and LibreOffice 3.3.2. Both the office suites are installed by running those ”debs” from a terminal, so I don't use the extremely buggy Ubuntu version of OpenOffice.org. -- Best regards Johnny Rosenberg

Re: [libreoffice-users] Calc Question

2011-04-08 Thread Johnny Rosenberg
to do this using Calc in LibreOffice? Chris I guess that could be done in several ways. What does that formula look like in Excel? -- Best regards Johnny Rosenberg -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org

Re: [libreoffice-users] poor conversion of .docx files

2011-04-09 Thread Johnny Rosenberg
, if Evince won't open the documents. -- Best regards Johnny Rosenberg -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent

Re: [libreoffice-users] Calc Question

2011-04-11 Thread Johnny Rosenberg
the ”=1” mean at the end of the formula? -- Best regards Johnny Rosenberg -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent

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

2011-04-14 Thread Johnny Rosenberg
,Pausen varade i End Sub Seems like one tick is one millisecond, at least on my system. The rest is simple math. -- Best regards Johnny Rosenberg -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List

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 one millisecond, at least on my system. The rest is simple math. I suspect it's

Re: [libreoffice-users] Swedish Grammar Check

2011-04-21 Thread Johnny Rosenberg
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.libreoffice.org/www/users/ All messages sent to this list

<    1   2   3   4   5   6   >