ian please, once more) what is the formula to calculate
(now in a LOBase/Firebird form or query) a person's age out of her birth
date?
All advice is very much appreciated!
Pertti Rönnberg /Finland, 79yrs
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.
Pertti
On 8.11.2016 11.58, James E Lang wrote:
Correction: replace 25 with 0.
--
Jim
-Original Message-
From: "James E. Lang" <jim+...@lang.hm>
To: "users@global.libreoffice.org" <users@global.libreoffice.org>,
"Pertti Rönnberg" &l
5,o
21 fiskars 12,o
22 kone 41,o
Any suggestion will be very interesting.
Thank you in advance
Pertti Rönnberg/Finland
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-t
the
outmostopposite end of
these qualities. No wonder there are wars in the world.
Stop behaving like a lowminded complete idiot.
At least you could from your signature delete your address – that you
are from Australia!
Best regards
Pertti Rönnberg, 76 yrs/ Finland
On 28.1.2016 15:33, Philip
new one in this Ubuntu?
(b)when upgrading LibreO in Ubuntu does the help-pack upgrade
automatically together with the main program or must it be installed
separately?
Please forgive me, I am trying to learn Ubuntu.
Pertti Rönnberg
On 11.11.2015 0:03, Joel Madero wrote:
It is possible. If
Joel, Jean-Baptiste and especially Andreas,
thank you so very much for your help and kindness!
Pertti Rönnberg
On 11.11.2015 17:49, Joel Madero wrote:
I think you really need to figure out what it is that you want. For
additional help I suggest going to the #libreoffice IRC channel. What
you
the new one?.
Thanks in advance.
Pertti Rönnberg
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http
apt-get update;
sudo apt-get install libreoffice
Best,
Joel
On Tue, Nov 10, 2015 at 12:57 PM, Pertti Rönnberg <p...@elisanet.fi
<mailto:p...@elisanet.fi>> wrote:
Hello Linux experts,
May I ask for help -- the instructions on the web are too
confusing for me.
On my
he 5.1 repository, update, then upgrade).
Currently 5.0.2 is the latest version in 5.0 so that's the version that
will be installed.
On Tue, Nov 10, 2015 at 1:32 PM, Pertti Rönnberg <p...@elisanet.fi> wrote:
Joel Madero,
Thank you for your reply.
But this is one of the confusing details
at a stage of planning and production than
after a global distribution(ref. to Quality Management Systems).
regards Pertti Rönnberg
On 27.3.2015 15:25, Brian Barker wrote:
At 12:38 27/03/2015 +0200, Pertti Rönnberg wrote:
A spreadsheet program that cannot be fully trusted is totally
worthless
feature why these faults have to be
corrected immediately
the function of both the sort buttons set to normal sort of a
selected range
all selections set to blanc in Data=sort=options
Pertti Rönnberg
On 26.3.2015 2:12, Tim Lloyd wrote:
Hi,
while LO does allow a certain amount
in every project of importance.
Mr Asaibene's message is alarming: if a spreadsheet behaves odd in
small then there can be more serious issues.
I think mr Asaibene should post a bug report.
Regards
Pertti Rönnberg
On 19.2.2015 16:18, Cley Faye wrote:
I'm pointing the obvious, but anyway
printer does not work either.
I know -- this not a LO-issue, so I must try to get help from Ubuntu-forum.
Best regards
Pertti Rönnberg
On 25.1.2015 12:12, Tim---Kracked_P_P---webmaster wrote:
Is there any need to have Linux in a VirtualBox or could you just boot
to Linux on your computer
LO/Base as a front end.
Am I to understand from this thread that I am getting printing problems
with
Linux in such an installation?
If so, what version of Ubuntu is then safe and reliable?
My printer is a KonicaMinolta magicolor 1600w.
Grateful for any advice
Pertti Rönnberg
On 23.1.2015 11:33
to get SQLite(3) to run in
Ubuntu are welcome.
Kind regards
Pertti Rönnberg
On 24.1.2015 14:22, CVAlkan wrote:
Pertti:
If you are running Ubuntu (or anything else as far as I know) in a Virtual
Box, you don't have access to any hardware unless it is recognized by the
host system. But if your
On 17.12.2014 10:30, Alex Thurgood wrote:
Le 16/12/2014 14:21, Pertti Rönnberg a écrit :
Hi Pertti,
My prime intention is to start building database applications using
SQLite3. I first tried to install Apache PHPSQLite3 as separate
programs but the config process was too much for me why I installed
shall it be done -- where can I find a guide?
Is the process similar as when connecting to MySQL?
My system is Windows7prof64bit; LO4.3.4.
Thanks in advance
Pertti Rönnberg (Finland)
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get
nor in (international)business.
Thanks again and
best regards
Pertti Rönnberg
On 12.1.2014 19:22, Paul wrote:
I haven't so much tried to answer your question directly, instead I
attempted to solve the same problem you did. For me, this gives a
simpler answer. Given:
Col A: The initial bank
Larry,
Here is a copy/paste copy of Brian's comments to my message.
I hope Brian does not mind.
Regards
Pertti Rönnberg
Since years back I have copied my bank's digital listing of my bank
account(s); first using MSOWord and later on MSOExcel. My intention is
to transform these listings so I
Brian,
Your formula workes perfect! Fantastic!
And I learned a little more about creating formulas.
Thanks again!
Cheers ; skål (swedish) ; kippis (finnish)
Pertti Rönnberg
On 13.1.2014 3:13, Brian Barker wrote:
At 17:55 12/01/2014 +0200, Pertti Rönnberg wrote:
Since years back I have copied
appreciated.
Best regards
Pertti Rönnberg
computer: PC, win7prof/64bit; LO4.0.4.2
--
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
Merry Christmas and Happy New Year to you all
from Finland too!
and thanks for all advice and interesting reading on this list.
Pertti Rönnberg
On 22.12.2012 13:58, rost52 wrote:
Also from Japan a Merry Christmas and Happy New Year to all.
Reinhold
On 2012-12-22 4:22, webmaster-Kracked_P_P
and
usability of LibO and
I am sure that we are many that would be happy.
Regards
Pertti Rönnberg
On 6.11.2012 9:54, Steve Edmonds wrote:
On 2012-11-06 20:41, Ian Whitfield wrote:
Thanks Guys!! (Girvin, Henirich, Dan, Mas and maybe others!!)
You have all added some pieces to the Jigsaw
Thank you Dan, IanW and Heinrich
for your kind answering and encouraging!
The other day when some spare time I shall study your advice and try again.
Is it not fantastic that we like this can discuss things all across the
word!!!
Pertti Rönnberg (Finland)
On 6.11.2012 15:12, Dan Lewis wrote
that it is never fun to afterwards repair mistakes - so
better not to make them.
Waiting for the results of your wise decisions - especially regarding
Windows with some 90% of the users.
Pertti Rönnberg
On 20.10.2012 23:57, webmaster-Kracked_P_P wrote:
The freezing and word count issues
for Base (if
anymore needed)?
I have read the release notes and got an picture but what is your opinion?
My version now is LibO3.4.6 on Win7Pro/32 and Win7/64.
Pertti Rönnberg
On 18.10.2012 12:41, Tom Davies wrote:
Hi :)
The upgrade from 3.5.x to 3.5.7 is extremely unlikely to cause problems
for the time being can be
considered as the most reliable and productive -- especially regarding
Base.
It would also be interesting to see an (valid) evaluation of that
reliable usability on a scale 1-10 for each of the the different modules
of versions 3.4.xx, 3.5.xx.x, 3.6.xx.x
Pertti Rönnberg
that Gilles (and me too) is curious to know what is the
best answer to his problem.
Even if I did (I admit) some overthinking I cannot see that my answer
is wrong.
So, what is the best way for Gilles to continue?
Pertti Rönnberg
Original Message
Subject:Re: [libreoffice-users
Pertti Rönnberg
On 6.10.2012 22:49, Wolfgang Keller wrote:
I think the market share of MSO has nothing to do with the users
being idiots or not. The 90% share is caused by 3 things
*snip*
2 - Not many people know about alternatives.
That's what I call ignorance. Ignorance plus unwillingness
this as some sort of a contribution too.
Best regards
Pertti Rönnberg
On 4.10.2012 18:04, Mark Stanton wrote:
Question: How many people do you know use Base, or have tried to use
Base?
Whilst there is some quite valid criticism of Base, I don't think answering
this question says as much about
Hi Wolfgang,
Most certainly you must be right.
I only cannot understand what you mean and on what arguments.
But don´worry, be happy!
and have a nice weekend.
Pertti Rönnberg
On 5.10.2012 19:12, Wolfgang Keller wrote:
If MSO is a 90% market leader all its users cannot be complete idiots
users cannot be complete idiots.
The very simple fact is: LibO has to become better in a SWOT analysis!
Idealism is a good power if correctly focused -- extremism never.
Pertti Rönnberg
On 30.9.2012 23:17, Jay Lozier wrote:
On 09/30/2012 03:31 PM, Wolfgang Keller wrote:
Just had a classic
people to take part to make LibO better.
Would it not be an good idea that you - instead of blaming others - took
the opportunity to practice your high quality IT-knowledge to the
benefit of LibO.
Best regards
Pertti Rönnberg
On 30.9.2012 23:17, Jay Lozier wrote:
On 09/30/2012 03:31 PM
it
easier for companies to convert to OpenSource/LibO.
Best regards
Pertti Rönnberg (Finland)
The End!
On 1.10.2012 13:51, Joep L. Blom wrote:
On 01-10-12 11:57, Pertti Rönnberg wrote:
Dear Wolfgang Jay,
A.so in your opinion people - both young and old - not yet knowing
anything about
priorities - and a strategy.
If the goal seems clear and clever then then the resources will at least
not disappear.
Pertti Rönnberg
On 27.9.2012 10:08, Gordon Burgess-Parker wrote:
On 26/09/12 12:01, webmaster-Kracked_P_P wrote:
I have seen listings on Mozilla's archive system
people and ordinary companies, who
value their time.
Pertti Rönnberg
On 27.9.2012 17:07, Tom Davies wrote:
Hi :)
On the contrary. MS do not fix their problems quickly at all. Even
known malware threats remain for months and even years. Their strategy
is to blame the users. A typical one being
for an answer that might help if I only happen to
understand the advice.
Frustration can easily be limited by paying to Microsoft.
Best regards
Pertti Rönnberg
On 19.9.2012 21:48, webmaster-Kracked_P_P wrote:
I have not bought any MSO past MSO-2003. I moved to OpenOffice.org
[as soon as it read/saved
to make a cover page (Mainform) for the
database from where to open forms, reports, etc
That as a beginning.
If or when Base works without problems and without bothering that list,
I am lazy enough to start using the rest of the LibO-suite.
Best regards
Pertti Rönnberg
On 20.9.2012 14:37, Dan
, all included.
And to complete-update the guiding documents (esp. LibO Help) to an good
working quality level so it is understandable and usable for every one.
Better late than never if you want LibO to be really accepted!
Regards
Pertti Rönnberg
On 19.9.2012 15:40, webmaster-Kracked_P_P wrote
of fantastic features that does not work and that produces problems
already when being installed!
Please, start with fixing Base!
Regards
Pertti Rönnberg
On 4.6.2012 3:49, Andreas Säger wrote:
Am 04.06.2012 00:59, Tom Davies wrote:
Andreas' and e-letter's answer is to tell people that to use
been
completed and is working properly.
Best regards
Pertti Rönnberg
On 4.6.2012 18:25, Tom Davies wrote:
Hi :)
Thanks for your kind words :)
Simplest answer is grab the 3.4.6 now if you don't already have LO on your system.
If you already have LO then wait 4 weeks until the release of 3.5.5
kind of issues do I have to be prepared for with LibO in
general, and because of LibO being 32-bits and my laptop Win7/64-bits?
d does that recommended LibO (on laptop) communicate without
problems with my PC (Win-Prof/32 bit LibO-3.4.6)?
Best regards
Pertti Rönnberg
--
For unsubscribe
other without problems
when my PC's OS is Win-Prof/32 bit and it's LibreO v.3.4.6?
Best regards
Pertti Rönnberg
On 17.5.2012 14:57, Andreas Säger wrote:
Am 17.05.2012 02:32, NoOp wrote:
Perhaps if you would include some quotation from the post others could
understand what you are replying to. I
' the cell A2 (as above) to (e.g.) B4 in Dec
then drag-copy the cell B4 over range B4-E4
then mark the row-range B4-E4 and drag-copy it downwards to E14
The absolute reference ($-signs) can be used here too.
I hope I could describe the proceeding - and that it is to help.
Best regards
Pertti
Kelly,
Most certainly you see the flexibility of that use of the 'remote ref':
you can have what ever calculations, analyzes and data on different
sheets and then
collect these values to a dynamic report or for further manipulations.
Pertti
On 8.5.2012 15:51, Pertti Rönnberg wrote:
Kelly
are bound to create a form based
on a table only (= each form on one table!) - you can not create a form
on a query!
These errors must be immediately corrected to increase the usability and
flexibility of LibO.
Best regards
Pertti Rönnberg
On 6.5.2012 23:01, Tom Davies wrote:
Hi :)
Nice
in MSAccess but not in LibO-Base.
Start by pushing the LibreOffice Help button (lifebuoy)
Good luck!
Pertti Rönnberg
--
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
. Cooperate globally?
LibO can only hope that the BoD will review its strategy planning or
change the members.
Best regards
Pertti Rönnberg
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how
(time) as variables.
It is easy and rather straight forward to use after a little training.
Best regards
Pertti Rönnberg
To others
On 16.4.2012 23:35, Regina Henschel wrote:
Hi Pertti,
Pertti Rönnberg schrieb:
Hello, LibO folks,
In LibO-Calc there is a very interesting and useful tool Data
. SQLite?
As Peter said:thus making the life easier -- and if not easier but not
more difficult!
Regards
Pertti Rönnberg
--
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
to install
and what version is recommended and where that version can be found - if
needed. As a nice short step-by step instruction.
That to be compared with OpenO that rather clearly says that In OpenO
the JRE is already included.
Best regards
Pertti Rönnberg
On 11.4.2012 22:48, Preston
cell in a spreadsheet can refer to and can
be referred to from remote cells no matter if these cells have a formula
or not.
Is it a bug or what is the explanation? Can I correct this in any way?
My PC is a Win7Prof/32bit.
Thanks in advance
regards
Pertti Rönnberg
--
For unsubscribe
Hello,
Try to 'google' for OpenOffice Report Builder.
May be there are info about if it works with LibO in Ubuntu.
regards
Pertti Rönnberg
On 12.4.2012 19:49, Tom Davies wrote:
Hi :)
Is it somewhere here
http://extensions.libreoffice.org/
? I'm not sure and haven't looked, sorry!
Regards
On 11.4.2012 6:48, Dan Lewis wrote:
On Tue, 2012-04-10 at 20:32 +0300, Pertti Rönnberg wrote:
On 1.4.2012 20:27, Alexander Thurgood wrote:
Le 08/02/12 20:02, Pertti Rönnberg a écrit :
Hi Pertti,
What exactly is the issue you have had with using the MySQL JDBC
connector on Windows
install Ubuntu without a LibO -- and install LibO
separately ? Or OpenO?
what LibO version is today best in the Linux/Ubuntu world?
Thanks in advance
Pertti Rönnberg
On 11.4.2012 12:00, Tom Davies wrote:
Hi :)
I generally get details like that from DistroWatch
http://distrowatch.com
a soul: it is not once that I
threated my lawn-mower that if you not.. then it starts immediately;
and the same is with my boat motors and other).
Regards
Pertti Rönnberg
On 11.4.2012 14:48, Tom Davies wrote:
Hi :)
Ok, it's only got 512Mb of Ram so choosing the heaviest distro in the world (Ubuntu
On 1.4.2012 20:27, Alexander Thurgood wrote:
Le 08/02/12 20:02, Pertti Rönnberg a écrit :
Hi Pertti,
What exactly is the issue you have had with using the MySQL JDBC
connector on Windows ?
Documentation :
Prerequisites : a JDK or JRE, access to a running mysql server instance,
either
been lucky.
Best regards
Pertti Rönnberg
On 15.3.2012 7:55, Doug wrote:
Hi my name is Doug. i was interested in downloading and running LibreOffice.
I currently have ms office home and student 2010 installed. My question is
can i run both programs on my computer at the same time with-out
Hello,
That was interesting. Like Alexander below I also often used VBA in
Excel and Access in my earlier days.
Question: Is it possible to program with VBA (or VB) directly in
LibreO3.4.5 Calc or/and Base?
If 'yes' where can I find some guides?
Regards
Pertti Rönnberg
On 11.3.2012 20:41
then to now I have
studied-tried-experimented-guessed-cried-damned to get an idea about
LibreO-Base.
It is hard days life to be a non-expert LO-user.
Good luck - glad if that is to help!
Pertti Rönnberg
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems
for your good advice concerning subforms (thread
Subforms in LibreO). I looked at it preliminary and seems like I got
the idea; I shall work on it at the weekend.
Pertti Rönnberg
On 9.3.2012 15:49, Andreas Säger wrote:
Am 09.03.2012 13:40, Pertti Rönnberg wrote:
4 the Java/JRE is said
Rönnberg
On 7.3.2012 13:39, Alexander Thurgood wrote:
Le 06/03/12 19:28, Pertti Rönnberg a écrit :
Oh and this :
http://listarchives.libreoffice.org/global/users/msg07304.html
Alex
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http
button 'Form' (on my PC screen it is the fourth button from
up on a vertical toolbar to the left)
that 'Form'-button opens the main form's properties
click 'Data' tab = find 'Navigation bar'
OK?
Pertti Rönnberg
On 6.3.2012 18:16, Sylvain Bromberber wrote:
No data tab under properties
in MSAccess but it did not work.
In MSAccess you can have several parallell subforms (e.g. on separate
tabs) and even a main form with a subform in a subform.
(My LibreO is 3.4.5/embedded HSQL/Windows7, 32bit)
Best Regards
Pertti Rönnberg
--
For unsubscribe instructions e-mail to: users+h
appreciate the time and
thought you put in helping me.
Sylvain
-Original Message- From: Pertti Rönnberg
Sent: Tuesday, March 06, 2012 12:12 PM
To: users@global.libreoffice.org
Subject: Re: [libreoffice-users] Re: Table Format
Hi Sylvain,
I don´t think that you are missing anything - sometimes
in this section is visible on every page
Please somebody, tell me how to do?
Where can I find any instructions about the logic procedure in that mixing?
A minor problem:
There is a tool/button 'horizontal line' but the line drawn is not
visible in preview!
Regards
Pertti Rönnberg
--
For unsubscribe
properties =
find 'border'
click the selection arrow (at right hand) and select the border
property you desire: e.g. 'no border'
OK?
Pertti Rönnberg
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how
(BirthDate)=MONTH(CURRENT_DATE) AND
DAY(BirthDate)DAY(CURRENT_DATE) THEN 1 ELSE 0 END AS Age
FROM Table
Regards
Pertti Rönnberg
On 18.2.2012 3:21, Dennis E. Hamilton wrote:
You should display =Now() to see what date format is being understood. If it
is dd/mm/, you haven't had your 73rd birthday
('dd',...)/365.
2.in most other SQL db-generators '' is a valid abbreviation
for 'year' but obviously not in HSQLDB (v.2.2) and thus not in
LibreO-Base either..
I think that this was not quite clear for all you neither.
I apologize for being a little irritated.
All the best
Pertti
. What do you think if considering
my writings above?
I really want to think that you are an expert on databases - show it!
Please, try again and give me an adequate answer on my first problem.
Without wasting any more of your time.
Pertti Rönnberg
_PS: ref to Tom's and Dan's kind answers today_
on my main issue: /_how to get a correct calculation
result._/
Now you are wasting not only your time but also mine.
I remain waiting
Best regards
Pertti Rönnberg
On 16.2.2012 23:10, Andreas Säger wrote:
The problem has nothing to do with LibreOffice. It is a built-in function of
the HSQL database
. Another is that when a nspreadsheet is flat a (relational)
database can handle data multi-dimensional which gives you the
possibility to mix/combine data and get the most interesting analyzing
results.
All the best
Pertti Rönnberg
On 7.2.2012 14:24, e-letter wrote:
On 06/02/2012, Dan
/SQLite, it is the PHP-language and getting
the MySQL/PHP/Apache combination working that I feel uncomfortable - I
also have tried WASP.
Again - thanks and all the best!
Pertti Rönnberg
On 1.2.2012 9:43, Alex Thurgood wrote:
Le 31/01/2012 22:07, Andreas Säger a écrit :
Hi Andreas,
Am
working stable with or without a JRE.
That's why I now put my question how to your admirable community.
Best regards
Pepe
On 1.2.2012 20:51, Andreas Säger wrote:
Am 01.02.2012 19:36, Pertti Rönnberg wrote:
All of you.
Thanks very much for your kindness to bother answering - and for the
very
Dear Ladies and Gentlemen out there.
I am confused -- can you help me? I recently installed
LibreOffice-v3.4.5 after beeing a happy OO-user in many many years. I
now need to make a couple of relational databases (subforms -reports)
and decided to try LibreO's Base. On my main-PC (AMD Athlon
75 matches
Mail list logo