[libreoffice-users] Re: Excel file in LibreOffice Calc

2011-09-22 Thread Andreas Säger
Hi, It has nothing to do with formatting. It is all about data types. The leading apostrophe tags numeric expressions and formula expressions as literal text. This is _exactly_ the same in Lotus 1-2-3, in all versions of Excel and in Gnumeric. You are responsible for the data types. You have

Re: [libreoffice-users] Re: Excel file in LibreOffice Calc

2011-09-22 Thread Tom Davies
Hi :) It is possible to change types of columns, rows, other selected areas or even individual cells.  Select area or whatever and then Format - Cells - Numbers Then in the left-hand box select which data-type is most relevant. Regards from Tom :) --- On Thu, 22/9/11, Andreas Säger

Re: [libreoffice-users] Excel file in LibreOffice Calc

2011-09-22 Thread Tom Davies
Hi :) The ' marks defines the cell as being text.  It is so that zip codes, telephone numbers and such can be displayed with leading zeros and other things that wouldn't display properly if imported as number. Regards from Tom :) --- On Thu, 22/9/11, planas jsloz...@gmail.com wrote: From:

Re: [libreoffice-users] Re: Dead End or Evolution?

2011-09-22 Thread Tom Davies
Hi :) Yes, but another advantage is longer term support.  Corporate organisations and people who don't have unilmited broadband don't have time to download test and install a new version every few weeks.  Many would like something that lasts a year or few even if that means not having the

[libreoffice-users] Re: MySQL Native Connector

2011-09-22 Thread Alexander Thurgood
Le 21/09/11 12:11, Tom Davies a écrit : Hi Tom, So, it's a race between you and Heinrich then :) I like the idea of different people contributing builds as the need arises. More a community effort and it spreads the knowledge a bit. Regards from Tom :) I have now built a 32bit

[libreoffice-users] Re: Excel file in LibreOffice Calc

2011-09-22 Thread Andreas Säger
Am 22.09.2011 09:26, Tom Davies wrote: Hi :) It is possible to change types of columns, rows, other selected areas or even individual cells. Select area or whatever and then Format - Cells - Numbers Then in the left-hand box select which data-type is most relevant. Regards from Tom :) In

[libreoffice-users] Re: Auto Filling Drop Down Boxes

2011-09-22 Thread Andreas Säger
Am 21.09.2011 19:00, stripedtomato wrote: I have three drop down boxes: City, State, Zip as part of an address record. As of now, I have to make independent selections for each of these drop down boxes. What I would like to do is when selecting a city from the drop down box list, then related

[libreoffice-users] Re: Auto Filling Drop Down Boxes

2011-09-22 Thread Andreas Säger
Am 21.09.2011 19:09, Tom Davies wrote: Hi :) I would stay with Access for now. There is almost no-one working on Base so it's gradually getting worse as regressions slip in. Regards from Tom :) These things use to work since OOo 1.0 (long before Base) and when they break, the whole office

[libreoffice-users] Laggy Calc in Win 7

2011-09-22 Thread gnulab
Hi, I'm trying out LibreOffice Calc in Win 7 32bit. I'd tried Open Office 3.3 and it worked flawlessly but made the switch to LO when my intuition says that Open Office might be quite dead. However, the weird thing is the Calc program seems be very laggy. After typing few letters, it will take

[libreoffice-users] Re: Laggy Calc in Win 7

2011-09-22 Thread gnulab
gnulab wrote: Hi, I'm trying out LibreOffice Calc in Win 7 32bit. I'd tried Open Office 3.3 and it worked flawlessly but made the switch to LO when my intuition says that Open Office might be quite dead. However, the weird thing is the Calc program seems be very laggy. After typing

[libreoffice-users] Re: Laggy Calc in Win 7

2011-09-22 Thread Andreas Säger
Close the office and rename both of your user profiles for LibreOffice and OOo. About the user profile: http://user.services.openoffice.org/en/forum/viewtopic.php?f=74t=12426 -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems?

[libreoffice-users] Re: RTF files rendering: huge differencies in LO 3.4.2 and MSO 2010 -- bug?

2011-09-22 Thread Arkady
Just for note: Bug 41109 (https://bugs.freedesktop.org/show_bug.cgi?id=41109) was posted on bugzilla. -- View this message in context: http://nabble.documentfoundation.org/RTF-files-rendering-huge-differencies-in-LO-3-4-2-and-MSO-2010-bug-tp3355881p3358335.html Sent from the Users mailing list

Re: [libreoffice-users] Excel file in LibreOffice Calc

2011-09-22 Thread Stefan Weigel
Hi, Am 21.09.2011 18:25, schrieb Luciano R. Moreira - Desenvolvimento: I'm having problem saving the report generated by my system developed in Delphi 7 to Excel (XLS) using the component with component QuickReport 5.2 Gnostice eDocEngine company. Are you sure, you are creating a real

Re: [libreoffice-users] Re: MySQL Native Connector

2011-09-22 Thread Heinrich Stoellinger
Thanks, Alex, you have certainly beaten me to it. I will try to download/install the connector on my Debian system this evening and then report on my findings. Regards Heinrich P.S.: I am actually president (=worker) of a wind band. This weekend we will be giving 5 concerts - organising these

Re: [libreoffice-users] Re: RTF files rendering: huge differencies in LO 3.4.2 and MSO 2010 -- bug?

2011-09-22 Thread Tom Davies
Hi :) Thanks Arkady :) Regards from Tom :) --- On Thu, 22/9/11, Arkady pen@yandex.ru wrote: From: Arkady pen@yandex.ru Subject: [libreoffice-users] Re: RTF files rendering: huge differencies in LO 3.4.2 and MSO 2010 -- bug? To: users@global.libreoffice.org Date: Thursday, 22 September,

Re: [libreoffice-users] Laggy Calc in Win 7

2011-09-22 Thread Tom Davies
Hi :) If you don't use base or wizards or forms then switching off java speeds a few things up quite a lot.  Tools - Options - General/LibreOffice - Java The tick box at the top can be unticked to stop java from being used.  You can always re-tick it later if you find you do need it after all.

[libreoffice-users] Re: MySQL Native Connector

2011-09-22 Thread NoOp
On 09/22/2011 01:22 AM, Alexander Thurgood wrote: Le 21/09/11 12:11, Tom Davies a écrit : Hi Tom, So, it's a race between you and Heinrich then :) I like the idea of different people contributing builds as the need arises. More a community effort and it spreads the knowledge a bit.

[libreoffice-users] Re: MySQL Native Connector

2011-09-22 Thread Alexander Thurgood
Le 22/09/11 19:21, NoOp a écrit : Hi NoOp,, Unfortunately... loading component library failed: file://home/username/.libreoffice/3/user/uno_packages/cache/uno_packages/Ap2E1u_/msql-native-connector-1.0.1-linux-32bit.oxt/mysqlc.uno.so 32bit Ubuntu Maverick (10.10). LO 3.4.3. Same results

[libreoffice-users] Re: MySQL Native Connector

2011-09-22 Thread NoOp
On 09/22/2011 10:46 AM, Alexander Thurgood wrote: Le 22/09/11 19:21, NoOp a écrit : ... Interestingly, the Ubuntu OOo version (OOo 3.2.1 - go-oo build) is 207.5KB: $ ls -l /usr/lib/openoffice/share/extension/install/mysql-connector-ooo.oxt . 212436 2011-01-28 23:56

RE: [libreoffice-users] Re: RTF files rendering: huge differencies in LO 3.4.2 and MSO 2010 -- bug?

2011-09-22 Thread Dennis E. Hamilton
Gary, Thanks for the links and analysis. I haven't attempted the obvious test, which is to save the RTF that fails in LO back to RTF and then compare to see what got left by the side of the road. My superficial impression of the 96.rtf and the RTF specifications revealed to me that there are

[libreoffice-users] Re: Auto Filling Drop Down Boxes

2011-09-22 Thread NoOp
On 09/21/2011 10:09 AM, Tom Davies wrote: Hi :) I would stay with Access for now. There is almost no-one working on Base so it's gradually getting worse as regressions slip in. You keep dishing out this advise... that and It's just that almost everyone avoids Base. why? At every turn I see

[libreoffice-users] Fwd: Saving Window sizing

2011-09-22 Thread Andy Lavarre
Hello. How do I save a window size in LibreOffice (LO)? I try resizing and saving the document and closing and restarting LO, but when I open the document it has reverted to the original small size. I then tried creating a new document, saving it as a template, making it the default template, but

RE: [libreoffice-users] Re: Auto Filling Drop Down Boxes

2011-09-22 Thread Bruce Carlson
Am 21.09.2011 19:00, stripedtomato wrote: I have three drop down boxes: City, State, Zip as part of an address record. As of now, I have to make independent selections for each of these drop down boxes. What I would like to do is when selecting a city from the drop down box list, then

[libreoffice-users] Re: Auto Filling Drop Down Boxes

2011-09-22 Thread NoOp
On 09/22/2011 01:40 AM, Andreas Säger wrote: Am 21.09.2011 19:00, stripedtomato wrote: I have three drop down boxes: City, State, Zip as part of an address record. As of now, I have to make independent selections for each of these drop down boxes. What I would like to do is when selecting a

[libreoffice-users] In Writer, how can I type characters from the IPA (International Phonetic Alphabet)?

2011-09-22 Thread Winston C. Yang
I'm using LibreOffice 3.3.3 on Linux (Trisquel 5.0). In Writer, how can I type characters from the IPA (International Phonetic Alphabet)? Thank you. Winston -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems?