2013/2/8 Brian Barker b.m.bar...@btinternet.com:
At 14:05 07/02/2013 -0800, Joel Madero wrote:
I have enabled regular expressions in LibreOffice settings but still am
unable to get this one to work. Here is my line:
IF(N200=*regression*,1,0)
Not sure what I'm missing.
What you are
any more, since a
better answer already arrived on this list:
-- Forwarded message --
From: Johnny Rosenberg gurus.knu...@gmail.com
Date: 2013/2/8
Subject: Re: [libreoffice-users] IF w/ Regular Expression
To: Joel Madero jmadero@gmail.com
2013/2/7 Joel Madero jmadero
Yet again, I seem to have sent my reply directly to the original
poster, sorry again (and again and again…).
Here's my reply that I wrote yesterday (2013-02-07), except that I'll
do some minor corrections before sending it this time:
-- Forwarded message --
From: Johnny Rosenberg
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: Johnny Rosenberg gurus.knu...@gmail.com
Date
Okay, I'm there again… sending replies privately (not intionally
though) instead of to the list.
Here's the last one:
-- Forwarded message --
From: Johnny Rosenberg gurus.knu...@gmail.com
Date: 2013/2/23
Subject: Re: [libreoffice-users] Autofilter sorting bug
To: Joel Madero
, 0)
ThisComponent.CurrentController.Select(oCell)
Dim oRanges As Object
oRanges=ThisComponent.createInstance(com.sun.star.sheet.SheetCellRanges)
ThisComponent.CurrentController.Select(oRanges)
End Sub
Johnny Rosenberg
--
For unsubscribe instructions e-mail to: users+h
2013/2/28 pierre masci piema...@gmail.com:
Thanks a lot Johnny, it works perfectly, as requested, the cursor goes
to the first cell of the current column.
I assigned it to Alt+Home, it will probably get used quite often.
You’re welcome!
:)
On 27 February 2013 16:53, Johnny Rosenberg
Did it again… sent it privately. Sorry again, then. Here's to the list:
-- Forwarded message --
From: Johnny Rosenberg gurus.knu...@gmail.com
Date: 2013/3/9
Subject: Re: [libreoffice-users] Currency conversion/display in calc
To: Tom Davies tomdavie...@yahoo.co.uk
2013/3/9 Tom
Same mistake as usual, sending my replies privately. I will never
learn, I'm quite sure of that now…
Anyway, here it is again, to the list this time:
-- Forwarded message --
From: Johnny Rosenberg gurus.knu...@gmail.com
Date: 2013/3/9
Subject: Re: [libreoffice-users] Currency
a macro that does all the
necessary Search/Replace steps in one single step, though.
Johnny Rosenberg
Regards from
Tom :)
From: Johnny Rosenberg gurus.knu...@gmail.com
To: LibreOffice Användare users@global.libreoffice.org
Sent: Saturday, 9 March 2013, 12
the error message say?
For security reasons I think it's better to keep the highest level,
just add paths in the ”Trusted sources” (or whatever it's called in
English version) tab whenever LibreOffice complains about macro
security.
Johnny Rosenberg
Any help?
Thank you in advance
2013/3/9 Andrew apb5...@bak.rr.com:
On 3/9/2013 11:56 AM, Johnny Rosenberg wrote:
2013/3/9 Andrew apb5...@bak.rr.com:
Version 3.6.5.2 (Build ID: 5b93205)
I wrote a program? macro? many years ago in Excel 2000 that I haven't
used
in almost as long, but now I have need of it again.
When I
I want my macro to find out my current decimal separator and thousands
delimiter. Did some searching without any kinds of results. With xray
I found my language, but not much more than that.
I appreciate any link (or other information) that brings me closer to
the answer.
Johnny Rosenberg
2013/3/9 Andrew apb5...@bak.rr.com:
On 3/9/2013 12:42 PM, Johnny Rosenberg wrote:
I now have the problem Miroslaw has already commented on - star office
vs.
VBA. Ouch. I've received Basic runtime error 1. Is there a
translation
guide?
I'm not sure, I don't think so. I have never tried
2013/3/10 Alex Thurgood alex.thurg...@gmail.com:
Le 09/03/2013 21:52, Johnny Rosenberg a écrit :
Hi Johnny,
http://api.libreoffice.org/docs/common/ref/com/sun/star/i18n/LocaleDataItem.html#decimalSeparator
Thanks! That looks like what I was looking for!
Now I only need to figure out how
Sorry, did it again… Here's for the list.
-- Forwarded message --
From: Johnny Rosenberg gurus.knu...@gmail.com
Date: 2013/3/10
Subject: Re: [libreoffice-users] Hello
To: Tom Davies tomdavie...@yahoo.co.uk
2013/3/10 Tom Davies tomdavie...@yahoo.co.uk:
Hi :)
Try documentation
. Much more life on the global list. :)
Don't forget, when you reply to someone, you need to ”Reply to all” or
”Reply to list”, otherwise the message only reach the person who wrote
the message you reply to, in this case me.
I do that mistake all the time…
Johnny Rosenberg
2013/3/10 Johnny
2013/3/10 Johnny Rosenberg gurus.knu...@gmail.com:
2013/3/10 Alex Thurgood alex.thurg...@gmail.com:
Le 09/03/2013 21:52, Johnny Rosenberg a écrit :
Hi Johnny,
http://api.libreoffice.org/docs/common/ref/com/sun/star/i18n/LocaleDataItem.html#decimalSeparator
Thanks! That looks like
2013/3/10 Johnny Rosenberg gurus.knu...@gmail.com:
2013/3/10 Johnny Rosenberg gurus.knu...@gmail.com:
2013/3/10 Alex Thurgood alex.thurg...@gmail.com:
Le 09/03/2013 21:52, Johnny Rosenberg a écrit :
Hi Johnny,
http://api.libreoffice.org/docs/common/ref/com/sun/star/i18n
easier to understand/analyse if arranged in a
programmatic layout.
And, of course, if the cells a formula references can all be seen
simultaneously, there is always the F2 key to help get some idea of
what the formula is doing.
You mean Ctrl+F2, right?
Johnny Rosenberg
--
T. R. Valentine
2013/3/22 T. R. Valentine trvalent...@gmail.com:
On 22 March 2013 11:34, Johnny Rosenberg gurus.knu...@gmail.com wrote:
You mean Ctrl+F2, right?
No, I meant F2, which highlights dependent cells. That was why I wrote
'if the cells a formula references can all be seen simultaneously'.
Ooops
+c, then Ctrl+v at
the same cell.
Did anyone else see those false Err 522 messages?
I have seen them for quite a while now, for years, I think. I use
LibreOffice 3.6.5.2 at the moment.
Johnny Rosenberg
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http
nothing more
than before creating this thread.
Unfortunately I am still with 3.6, so I can't help either. Sorry for that.
Johnny Rosenberg
I use LO 4.0.2.2 on Win XP SP 3 and I can only search for tabs using \t
expression but I can't replace any symbols with a tab.
Regards,
gordom
--
Jay
Forgot to include the list again, sorry…
-- Forwarded message --
From: Johnny Rosenberg gurus.knu...@gmail.com
Date: 2013/4/10
Subject: Re: [libreoffice-users] Re: Fractions in Maths
To: Tom tomdavie...@yahoo.co.uk
2013/4/10 Tom tomdavie...@yahoo.co.uk:
Hi :)
I thought
wants
at least LibreOffice Calc to be able to use it for calculations,
making the 355 over 113 object approximately equal to 3.14159292.
Johnny Rosenberg
It might be nice if it could handle simple things like 1/2 but
aren't there special characters for most of those anyway?
Regards from
Tom
2013/4/2 Johnny Rosenberg gurus.knu...@gmail.com:
A few spreadsheets of mine, those with a lot of formulas with
references to other cells, sometimes (or rather often in some cases)
throw error 522 (circular reference) at me.
In most cases, Ctrl+Shift+F9 cures the problem. Another way
report, I am not really sure what to
write, I'm just too confused right now, I don't know what happens;
maybe I'm just dreaming all this…
Johnny Rosenberg
From: Johnny Rosenberg gurus.knu...@gmail.com
To: LibreOffice Användare users@global.libreoffice.org
2013/4/24 Alex Thurgood alex.thurg...@gmail.com:
Le 02/04/2013 19:48, Johnny Rosenberg a écrit :
Hi Johnny,
Just a few thoughts in an attempt to narrow down the problem :
- which version of OpenOffice.org did you originally use to create the file
?
I am not sure, but I have four
Incompetent Relay Chat…? ;P
Or what about IRC for people with bad memory: Internet Replay Chat…
Ok, it's hard to make jokes in English when your native language is a
quite different one…
Johnny Rosenberg
Andrew Pitonyak wrote an excellent guide for how to write macros. It costs a
little bit
the list addres from ”CC:” to ”To:” (also optional),
type your reply.
Maybe I should just get used to ALWAYS ”Reply To All”, no matter what list.
Johnny Rosenberg
--
View this message in context:
http://nabble.documentfoundation.org/Crashing-OOo-Creating-Dialogs-in-the-IDE
2013/5/1 Brad Rogers b...@fineby.me.uk:
On Wed, 1 May 2013 17:48:39 +0200
Johnny Rosenberg gurus.knu...@gmail.com wrote:
Hello Johnny,
Maybe I should just get used to ALWAYS ”Reply To All”, no matter what
list.
Alternatively, use an MUA that allows you to set optimal reply methods on
a per
think. Not
that it matters anymore, since you seem to have your problem solved,
but next time you could upload the file somewhere and just give us the
link here.
Johnny Rosenberg
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help
2013/5/11 Tom Davies tomdavie...@yahoo.co.uk:
Hi :)
Errr, you know you can write your reports in Writer rather than in Base?
And you can use Calc instead of Base for those tables too… he he he…
Sorry, couldn't resist…
Johnny Rosenberg
It gives a lot more flexibility that way. You 'just
I have had this problem for quite some time now (months if not years)
in LibreOffice and OpenOffice. The problems are maybe a little bit
worse in LibreOffice, but I didn't exactly measure it…
It looks like a graphics card problem, but why are nothing else
affected? It only happens to OpenOffice
2013/5/11 Johnny Rosenberg gurus.knu...@gmail.com:
I have had this problem for quite some time now (months if not years)
in LibreOffice and OpenOffice. The problems are maybe a little bit
worse in LibreOffice, but I didn't exactly measure it…
It looks like a graphics card problem, but why
another
computer with a non-blacklisted graphics card…
Johnny Rosenberg
On 05/11/2013 08:52 AM, Johnny Rosenberg wrote:
I have had this problem for quite some time now (months if not years)
in LibreOffice and OpenOffice. The problems are maybe a little bit
worse in LibreOffice, but I didn't
2013/5/11 David Fletcher d...@thefletchers.net:
On Sat, 2013-05-11 at 15:04 +0200, Johnny Rosenberg wrote:
Here's a screenshot with Apache OpenOffice Calc 3.4.1. I added some
arrows pointing at the problem areas:
http://ubuntuone.com/0wvqcaN38PC5835t4uJVPv
The worst thing is when I try
2013/5/14 D.R. daulat.rai...@gmail.com:
Hello
Is it possible for a document to be converted to PDF format?
Well, that's been one of the main features of
OpenOffice.org/LibreOffice for over ten years.
Johnny Rosenberg
--
*Daulat Raikar*
--
To unsubscribe e-mail to: users+unsubscr
2013/5/14 Kieran Peckett crazyske...@gmail.com:
Choose File Export to export to a PDF.
There is even a button for it in the tool bar…
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting
… On the other hand, there are a lot
of other buttons as well, so maybe it's easy to miss it…
Johnny Rosenberg
On 15 May 2013 16:13, Johnny Rosenberg gurus.knu...@gmail.com wrote:
2013/5/14 Kieran Peckett crazyske...@gmail.com:
Choose File Export to export to a PDF.
There is even a button
2013/5/15 Johnny Rosenberg gurus.knu...@gmail.com:
2013/5/15 Ric Moore wayward4...@gmail.com:
On 05/12/2013 03:47 PM, Johnny Rosenberg wrote:
I am not sure it's even possible to replace my graphics card; it's a
laptop. I have been planning to replace it with a desktop computer
since 2010
the whole concept, so how is it supposed to be done?
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
list archive at Nabble.com.
http://api.libreoffice.org/
or
http://lmgtfy.com/?q=libreoffice+apil=1
And more than that, the xray plugin might help you a bit.
Johnny Rosenberg
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get
2013/6/1 Mirosław Zalewski mini...@poczta.onet.pl:
On 31/05/2013 at 22:10, Johnny Rosenberg gurus.knu...@gmail.com wrote:
I obviously misunderstood the whole concept, so how is it supposed to be
done?
Like that:
{=MAX((C1:C1=P3)*(YEAR(D1:D1)=YEAR(TODAY()))*E1:E1)}
(C1:C1
there, but I need to edit my files. So what I do right now, is that I
enter new stuff in a Google Docs spreadsheet, and when I come home, I
just copy and paste into the ”real” spreadsheet in Apache OpenOffice.
It works, but isn't very convenient…
Johnny Rosenberg
--
To unsubscribe e-mail to: users
Ok, sorry. Did it again. Replied privately, that is. Here's to the list:
-- Forwarded message --
From: Johnny Rosenberg gurus.knu...@gmail.com
Date: 2013/6/8
Subject: Re: [libreoffice-users] CNET is claiming the best free MSO
alternative is not LO
To: Jay Lozier jsloz
to achieve this.
It should be easy to find and install the plug-ins without leaving the
program, I think.
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
.
Of course, a private person might not use that feature frequently, but any
company which wants to advertise does this very often.
Especially if we talk about 10 000 friends. I don't even know ig I met
10 000 people all together in my whole life yet… I think I have like
10 friends…
Johnny
didn't try any of these distributions myself, so I can't tell, sorry.
Johnny Rosenberg
You can also check the arch wiki about libreoffice:
https://wiki.archlinux.org/index.php/Libreoffice
Best Regards,
Kevin Suo
Beijing, China.
06/09/2013 09:45 AM, Anthony Easthope:
Hi!
I was curious
, Gimp,
MyPaint and Pinta.
Johnny Rosenberg
Draw is excellent, especially for what you were using it for. The arrows
problem could have been solved in gimp by creating a 2nd layer and then put
the arrow in there. Then keep an original in xcf format and save as png, or
gif (or even jpg
2013/6/9 Ken Springer snowsh...@q.com:
On 6/9/13 8:11 AM, Johnny Rosenberg wrote:
The Linux magazine ”Linux Format” compared image editors in their
LXF171 issue. The combatabts were GIMP, Inkscape, Krita, MyPaint and
Pinta. MyPaint won the user interface round, but was worst in a few
there is no Apache
OpenOffice for Android, so I guess you are talking about LibreOffice
all the time, right?
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
do, the reply is sent privately (by mistake, but I
don't bother to correct it – I have a life).
If that's what's people want, fine with me.
Johnny Rosenberg
Brian Barker
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems?
http://www.libreoffice.org/get-help
sometimes
when I close Opera, telling me that Opera needs to do something with
my email database (which doesn't exist anyway since I only use the web
interfaces for my email) or whatever…
Johnny Rosenberg
At the time of
announcement early builds for Windows and Macs were available and Linux
Once again I sent privately. I'm getting tired of this so I really
don't care, but I decided to be nice today, so here's to the list.
I also added some stuff at the end.
-- Forwarded message --
From: Johnny Rosenberg gurus.knu...@gmail.com
Date: 2013/7/10
Subject: Re
2013/7/10 Johnny Rosenberg gurus.knu...@gmail.com:
Once again I sent privately. I'm getting tired of this so I really
don't care, but I decided to be nice today, so here's to the list.
I also added some stuff at the end.
-- Forwarded message --
From: Johnny Rosenberg
2013/7/10 Johnny Rosenberg gurus.knu...@gmail.com:
2013/7/10 Johnny Rosenberg gurus.knu...@gmail.com:
Once again I sent privately. I'm getting tired of this so I really
don't care, but I decided to be nice today, so here's to the list.
I also added some stuff at the end
.
Why not upload it somewhere and give us the link? Maybe someone else
want to study it. Me, for instance…
Johnny Rosenberg
I couldn't bear the thought of Charles spending valuable coffee time
manually sorting tables.
Errol
On 2013/07/11 03:05 PM, Tanstaafl wrote:
Thanks for your efforts
' Choice Awards!”
Okay, maybe they live in a special time zone. Here in Sweden it has
been 2013 for quite a while now. I guess we are a little bit ahead… :P
Johnny Rosenberg
--Jean
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems?
http://www.libreoffice.org/get
, or is there yet another new
level of understanding to be mastered here?
trj
They probably hide it because the macro recorder is crap anyway. Just
don't use it. Write your code manually instead. There is a slightly
better macro recorder available somewhere, though.
Johnny Rosenberg
--
To unsubscribe e
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 Rosenberg
step I sort D1:E4.
Caesar 90 \ / Bert111
Adam 45 -\/– Adam 103
Bert 42 / \ /David 96
David 33/ \Caesar 90
However, this is not what happens. No lines are moved at any
direction. Is there a way to do this?
Kind regards
Johnny Rosenberg
ジョニー・ローゼンバーグ
--
For unsubscribe
regards
Johnny Rosenberg
ジョニー・ローゼンバーグ
--- On Sat, 30/6/12, Johnny Rosenberg gurus.knu...@gmail.com wrote:
From: Johnny Rosenberg gurus.knu...@gmail.com
Subject: [libreoffice-users] Tie a line to two cells
To: LibreOffice Användare users@global.libreoffice.org
Date: Saturday, 30 June, 2012, 15
use Caps Lock for compose, just like
you, and it worked fine in LibreOffice Calc 3.3.4. I will install a
more recent version soon and try, I've just been lazy lately, or maybe
busy (I'm in the middle of my vacation right now)…
Kind regards
Johnny Rosenberg
ジョニー・ローゼンバーグ
If I type
2012/7/16 J.A. de Vries hdv.ja...@gmail.com:
On 2012-07-16 12:25, Johnny Rosenberg wrote:
I can not reproduce the problem, but I use another operating system
(Ubuntu 10.10) and an older LibreOffice (3.3.4), the LibreOffice
website version. Maybe this is a LibreOffice 3.5.4 problem? I would
from
Tom :)
Nobody is never wrong. Not even me… :P
Kind regards
Johnny Rosenberg
ジョニー・ローゼンバーグ
--- On Mon, 16/7/12, Regina Henschel rb.hensc...@t-online.de wrote:
From: Regina Henschel rb.hensc...@t-online.de
Subject: Re: [libreoffice-users] Unexpected behavior while writing Calc
Functions
thing is probably to
select one cell, select FOOD, hit Ctrl+c, select all the other cells
in which you want the word FOOD (using Ctrl or Shift), hit Ctrl+v. Not
too much extra work, I think.
Kind regards
Johnny Rosenberg
ジョニー・ローゼンバーグ
--
For unsubscribe instructions e-mail to: users+h
2012/7/17 Johnny Rosenberg gurus.knu...@gmail.com:
2012/7/17 Gilles codecompl...@free.fr:
Thanks for the tip. Didn't think of this.
In the same vein, after I created a list of possible items for the drop-down
box to be displayed in that column, is it possible to select some cells
through
yourself.
Still, I wonder why IsLocked didn't work. On the other hand, if it
worked, I suppose there would be a method for it, like
CellProtection.Lock() or something like that.
Kind regards
Johnny Rosenberg
ジョニー・ローゼンバーグ
--
For unsubscribe instructions e-mail to: users+h
the first cell in the A
column that is REALLY empty – no formula, no value.
To me this seems like a bug, but for someone else, hopefully, it might
seem like I'm just stupid, so feel free to call me stupid and, more
important, tell me what I'm doing wrong and how I should do instead…
Kind regards
Johnny
said, I will do some more tests and come back here later.
Thanks for replying.
Kind regards
Johnny Rosenberg
ジョニー・ローゼンバーグ
Fernand
Just can't figure it out. I have a column of 2000 formulas and values.
Right now, A1:A1620 contains values, and A1621:A2000 contains
formulas. The formulas
your file, Tools → Extension → Add…,
the extension is now in the list. Now what…? How do I use it? Can't
find it. Can I see the code?
Sorry for these idiot questions…
Kind regards
Johnny Rosenberg
ジョニー・ローゼンバーグ
--
View this message in context:
http://nabble.documentfoundation.org/Searching
the dialogue that pops up at Ctrl+h
(Ctrl+f in earlier versions) gives the result I want, but I can't
implement it into a macro using the ”createSearchDescriptor()” thing,
as it seems.
Kind regards
Johnny Rosenberg
ジョニー・ローゼンバーグ
On 07/20/2012 03:31 AM, Fernand Vanrie wrote:
Johnny,
I suppose you
2012/7/20 Johnny Rosenberg gurus.knu...@gmail.com:
2012/7/20 Andreas Säger ville...@t-online.de:
Try my SpecialCells extension which selects combinations of cell types:
http://user.services.openoffice.org/en/forum/download/file.php?id=11048
Okay, I didn't install any extensions before
2012/7/20 Johnny Rosenberg gurus.knu...@gmail.com:
2012/7/20 Andrew Douglas Pitonyak and...@pitonyak.org:
You may also try using the cell range and calling GetDataArray() to get all
of the data including numbers and strings. If you are simply running through
about 2000 cells, this should
that in a macro? How?
Kind regards
Johnny Rosenberg
ジョニー・ローゼンバーグ
--
View this message in context:
http://nabble.documentfoundation.org/Searching-for-empty-cell-LibreOffice-BASIC-macro-tp3996513p3996716.html
Sent from the Users mailing list archive at Nabble.com.
--
For unsubscribe instructions
2012/7/20 Fernand Vanrie s...@pmgroup.be:
Op 20/07/2012 13:31, Johnny Rosenberg schreef:
2012/7/20 Fernand Vanries...@pmgroup.be:
Johnny,
I suppose you have to run the check 2 Times, first SearchType = 0 here
we
find if there is a formula use .
What do you mean? Use . as the search
2012/7/20 Johnny Rosenberg gurus.knu...@gmail.com:
2012/7/20 Fernand Vanrie s...@pmgroup.be:
Op 20/07/2012 13:31, Johnny Rosenberg schreef:
2012/7/20 Fernand Vanries...@pmgroup.be:
Johnny,
I suppose you have to run the check 2 Times, first SearchType = 0 here
we
find
[ReadWrite]
The blank field (0) uses c.s.s.sheet.FilterOperator.EMPTY with any content.
The empty string field (1) uses c.s.s.sheet.FilterOperator.EQUAL with string
content .
Thanks. I'll take a closer look at it tomorrow. Too tired and confused
right now.
Kind regards
Johnny
2012/7/20 MiguelAngel mari...@miguelangel.mobi:
El 20/07/12 21:33, Johnny Rosenberg escribió:
2012/7/20 Johnny Rosenberg gurus.knu...@gmail.com:
2012/7/20 Fernand Vanrie s...@pmgroup.be:
Op 20/07/2012 13:31, Johnny Rosenberg schreef:
2012/7/20 Fernand Vanries...@pmgroup.be:
Johnny
and Courier New, it's
recommended that you use the free fonts from the package
fonts-liberation instead (probably already installed on your system.
Those are called something like Liberation Sans (looks like Arial) and
so on.
Kind regards
Johnny Rosenberg
ジョニー・ローゼンバーグ
--
antiso...@myopera.com
that happens is that rows not
containing a date at all in Column A are hidden. In this case I only
want to hide those rows older than a week. I guess I am just not doing
it right, right?
Kind regards
Johnny Rosenberg
ジョニー・ローゼンバーグ
--
For unsubscribe instructions e-mail to: users+h
.
Kind regards
Johnny Rosenberg
ジョニー・ローゼンバーグ
--- On Sun, 22/7/12, Johnny Rosenberg gurus.knu...@gmail.com wrote:
From: Johnny Rosenberg gurus.knu...@gmail.com
Subject: Re: [libreoffice-users] Microsoft Core Fonts
To: users@global.libreoffice.org
Date: Sunday, 22 July, 2012, 6:04
2012/7/21
the parentheses. Now knowing that's not
needed, it will make things somewhat easier for me from now on…
Kind regards
Johnny Rosenberg
ジョニー・ローゼンバーグ
Then I filled this formula down the column and across the table.
How does this work? The VLOOKUP() function searches the first column of the
Weapons array
errors, unless the person who gave you the line typed it wrong, of
course.
Kind regards
Johnny Rosenberg
ジョニー・ローゼンバーグ
Then there are the differences with the desktop environments. For 12.04 I
have used Unity, GNOME 3, and MATE for desktop environments. I prefer MATE.
IT works more like
2012/7/22 Andreas Säger ville...@t-online.de:
Am 22.07.2012 13:27, Johnny Rosenberg wrote:
I searched for Standard Filter examples and the only thing I found had
a string or a number in the Value fields. I want to use an expression
instead, but that doesn't seem possible, or maybe I'm just
…
Kind regards
Johnny Rosenberg
ジョニー・ローゼンバーグ
On 07/22/2012 01:50 PM, Jay Lozier wrote:
On 07/22/2012 01:04 AM, Johnny Rosenberg wrote:
2012/7/21 Anthony Easthope antiso...@myopera.com:
Hi
I was wondering what would be considered the core fonts on Microsoft.
After ages fruitless
2012/7/22 Andreas Säger ville...@t-online.de:
Am 22.07.2012 19:31, Johnny Rosenberg wrote:
Thanks for the suggestion. However, I failed making it work. I tried a
few different variations on that and either nothing happened at all,
or I got an error message saying that there are no valid
= TRUE
oDateTime.NumberFormat = FindCreateNumberFormatStyle(_
DD. , oDoc)
oText.insertTextContent(oTCurs,oDateTime,FALSE)
oText.insertString(oTCurs, ,FALSE) Else
MsgBox Sorry, this macro requires a TextDocument
End If
End Sub
Kind regards
Johnny Rosenberg
ジョニー
2012/7/23 webmaster-Kracked_P_P webmas...@krackedpress.com:
On 07/23/2012 05:29 AM, Johnny Rosenberg wrote:
snip
One big problem, for people like me whose native language is not
English, is that many of those thousands of free fonts miss all
language specific characters, in my case åäöÅÄÖ
language settings?
Kind regards
Johnny Rosenberg
ジョニー・ローゼンバーグ
--
Guy
using LibO 3.6.0 on a iMac Intel DualCore Lion 10.7.4
-- please reply only to users@global.libreoffice.org --
Dodoes can't afford to have headaches
--
For unsubscribe instructions e-mail to: users+h
, and I never will. Just hate when people use presentation
software.
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
2012/7/25 anne-ology lagin...@gmail.com:
yes, I agreed with you -
except don't blame the U.S. for that silly ISO ;-)
On Wed, Jul 25, 2012 at 7:00 AM, Joep L. Blom jlb...@neuroweave.nl wrote:
On 25-07-12 10:40, anne-ology wrote:
The ISO is not U.S.;
A gets
deleted when done
*
OK, that is
$ cat fileA.csv fileB.csv | sort | uniq fileC.csv
And then:
$ rm fileA*
Kind regards
Johnny Rosenberg
ジョニー・ローゼンバーグ
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists
is then formatted to a ”human
readable time format”, but the cell still contains a number.
Kind regards
Johnny Rosenberg
ジョニー・ローゼンバーグ
I have tried both LibO 3.5.5.3 and 3.6.0.4
Thanks.
--
View this message in context:
http://nabble.documentfoundation.org/Can-t-Sum-time-measurements
3.5.5.3 and 3.6.0.4
Thanks.
The easiest way to find out is, as far as I know:
1. Create a spreadsheet that displays the problem.
2. Upload the spreadsheet somewhere (like DropBox, UbuntuOne or whatever).
3. Post the link in this thread.
Kind regards
Johnny Rosenberg
ジョニー・ローゼンバーグ
Did you
to write them?
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
Johnny Rosenberg
ジョニー・ローゼンバーグ
Completely not understanding, I was doing some text manipulation (copy to
notepad, add 00: to the front end, copy back) to try to get the values
recognized as minutes and seconds, and that appears to have caused the
screw-up. I suppose pursuing why those cells add like
I'm subscribed to quite a few lists by now, and some of them has had
this ”new” behaviour for quite some time. I was kind of hoping THEY
would change…
Kind regards
Johnny Rosenberg
ジョニー・ローゼンバーグ
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http
to hit reply to list as
that is what it is. anyway as the cliche goes I was jus sayin
Regards
Anthony
When you say Opera mail, do you mean the Opera web mail or the Opera
M2 email client?
Kind regards
Johnny Rosenberg
ジョニー・ローゼンバーグ
On Mon, 13 Aug 2012, at 09:19 PM, anne-ology wrote
1 - 100 of 526 matches
Mail list logo