rt Builder, 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
ting perhaps days 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.
er with working docs about how-to
>inform the user how 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
see this as a question of defining 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
ng to argue about: LibO must be
easy-to-use, stable and free from any basic problems if it wants to be
really accepted.
Note: I am talking about ordinary 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
er all its 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
uot;IT-literate" --
perhaps even "non-morons".
Some weeks ago LibO invited 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 re
ly,
stable, reliable, free of bugs and problems. These will then make 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 i
LibO-Base and its
docs. (I am now back to OO and tries to learn MySQL)
You may take 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 som
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
tention with these posts of mine is that LibO should be
enough better to beat MS/MSO as a market leader.
Regards
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
*s
ula in(e.g.)cellD3" =IF(c3<1;0;INT(c3))"
b >>copy the formula to d4..d6
The formula translated into english:
"if value in cell c3 is /_less than_/ '1' then d3 shall be '0', else (--
if c3 is '1' or bigger then -- ) use the integer of value in c3)&
an imagine 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
r 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
ion needed 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 caus
ll 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
ncrease the acceptance 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
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
y paying some money to MS - in the
long run it is cheaper.
I think that is obvious.
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 + more: http:/
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
. an IF() function);
the definition of it in Calc/Help is obviously at least unclear if not
wrong.
Cannot get the Fixed() -- when trying to eliminate the separator/dot
that way -- working in this 'project' either.
Any advice and help is greatly appreciated.
Best regards
Pertti Rönnber
of any thousand
separator -- I have never used it neither private, in technical planning
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 so
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 lis
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
nd if so, how 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
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 & PHP&SQLite3 as separate
programs but the config process was too much for me wh
xpect
having 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
I shall proceed 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
hos
ry very slw.
My 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
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
ports and analyses.
So now it is not the MySQL/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, Andre
e (32bit) must first start
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 kindnes
reports. 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,
ed or not.
Even if I install the AMPPS package I would like to enjoy LO-Base's
flexibility as a report engine - which also seems to be impossible.
Best regards
Pertti Rönnberg
On 8.2.2012 18:53, Tom Davies wrote:
--- On Wed, 8/2/12, Tom Davies wrote:
From: Tom Davies
Subject: Re: Inst
r the barriers'. One point of view seemed
to be that ordinary non-professional users feel it too difficult to
design dbs and then also to use them. 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
he car.
You did not focus 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
all be divided by 12 (as Drew
said). Alternatively do DATEDIFF('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 quit
#x27;mm', "BirthDate", CURRENT_DATE ) / 12
- CASE WHEN MONTH("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 wrot
rop down list shows the text box control's 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.lib
it is on every page - first
page included - but placed above the report name
>if the column heading fields are put in the section 'Report
Header' all the text in this section is visible on every page
Please somebody, tell me how to do?
Where can I find any instructions ab
;find 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.201
, how?
I tried to do like I used to do 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 uns
n? Let me say again how much I 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
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
nstall.exe" on Java Home Page.
That is how January went by - since 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ön
o 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 Jav
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.
nt. Perhaps I have
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
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
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
h?
>>can I 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 DistroWatc
ave 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
ctions about JRE: needed or not needed, how and when 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.
Be
hat that negative change has been done deliberately in
LibO-Calc -- normally every 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 Win7Pr
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 lo
with rate and
loan length (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 interes
is 2.2.x? What about e.g. 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/ho
im to compete the commercials, it is a
waste of valuable resources when open source developersoverlap or
compete each others . 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 instructi
d visible on the form.
You know how to do 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
(and a subform) manually using Form Design View
>>in LibO (with embedded HSQL) you 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
er 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 Rönnberg
8.5.2012 8:01, Kelly Holman wrote:
I need to take data
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:
breO being 32-bits and my laptop 64-bits?
Do the LibOs on my machines communicate with each 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 i
? -- what
JRE-version (surely OK on Win7/64bit)?
c >>what 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-P
o have a
perfectly well working program with less features than one with plenty
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
o remove the module from the package until it has 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 alre
ry to check the results 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 pointin
controlling team (if any?).
The sort feature is a very important 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
rganization.
It is better to fix problems 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 progra
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 <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 laptop (Win7, 64bi
y, 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 wrote:
Joel Madero,
Thank you for your reply.
But this is one of the confusing details: does your answer not lead to
ins
talling
the 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
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
.
Download from their own homepage.
Pertti Rönnberg
On 19.11.2015 17:33, Ken Springer wrote:
On 11/19/15 6:20 AM, dave boland wrote:
Thanks all. If I make a suggestion to LO - add some more CAD abilities
to Draw such as higher precision. LOD is a very useful program, and
could be even more useful
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
Z
20 nokia 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/mail
gards
Pertti
On 8.11.2016 11.58, James E Lang wrote:
Correction: replace 25 with 0.
--
Jim
-Original Message-
From: "James E. Lang"
To: "users@global.libreoffice.org" ,
"Pertti Rönnberg"
Cc: "Pertti Rönnberg"
Sent: Tue, 08 Nov 2016 1:52
Subj
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://ww
79 matches
Mail list logo