Re: [libreoffice-users] Excel file in LibreOffice Calc
On Sep 21, 2011, at 18:25 , Luciano R. Moreira - Desenvolvimento wrote: > Hi, > > The problem is: > > - The date fields and values ??are being displayed in the program "Open > Office / BR Office / LibreOffice" with the character (apostrophe) and cause > error in the calculation of the value field because they are as text. Take > the example of incorrect visualization in OpenOffice / BROffice / > LibreOffice: '$ 100.00 > > Is there any solution or configuration LibreOffice to view the date fields > and value to its corresponding type in the program "Open Office or BROffice > or LibreOffice"? Is there a solution to correctly view this way: $ 100.00? Forgive a probably stupid input in this discussion, but your problem reminds me of one I had recently with gnucash. Are you sure that there is complete agreement between the locale settings in a) your system, b) LibreOffice and c) your program? In particular the system settings can be crucial, especially if you have a 'blended' so-called custom setting there. You may, for example, have the US setting, modified to account for Brazilian variations. In linux and on the Mac you can actually fix this using the LC_xxx locale settings, but I don't know how you would do this on Windows, and since you're also using Excel, you are presumably using Windows. > > Remember that Microsoft's Excel has no problems. Regards, //James -- 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://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] In Writer, how can I type characters from the IPA (International Phonetic Alphabet)?
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? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Auto Filling Drop Down Boxes
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 city from the drop down >> box list, then related state and zip information would automatically be >> filled in, in their respective drop down boxes, and the information stored >> in their respective db cells. >> > > This is impossible because big cities have more than one ZIP and there > are ambiguous city names. Actually it's not if you have (in the US) the USPS 5 digit Zip Code database: https://www.usps.com/business/address-information-systems.htm# Five-Digit ZIP® Product Provides 5-digit ZIP Code data that can be appended to computerized mailing lists via address-matching software. With that (or similar) I think that you could easily build a dropdown that links to that. You'd probably need to fine tune by address as each city, street, business may have differing Zip/Postal Codes Unfortunately the USPS doesn't offer an easy way to order: For more information on the AIS View, please contact the National Customer Support Center at 1-800-238-3150, Option 6 and then Option 2 to speak to a customer service representative. > You may enter a city name and then choose the actual city and zip from > suggested data. > > I use to enter zip codes. Each zip code belongs to one particular city > in one state. > > Apart from this, big companies and public sectors have their own zip codes. > > -- 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://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
RE: [libreoffice-users] Re: Auto Filling Drop Down Boxes
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 state and zip information > would automatically be filled in, in their respective drop down boxes, > and the information stored in their respective db cells. > == 22/09/2011: Andreas S�ger Wrote:- >This is impossible because big cities have more than one ZIP and there are >ambiguous city names. >You may enter a city name and then choose the actual city and zip from >suggested data. >I use to enter zip codes. Each zip code belongs to one particular city in one >state. >Apart from this, big companies and public sectors have their own zip codes. == Hi stripedtomato, What you want to do is actually very easy. At least in Australia where it is possible to download a postcode file from the post office (what USA folk call a zip code we call a postcode (with no spaces)). However even without starting from a set data file it is still possible to create the tables and code and add zip codes as and when required. In the City/Suburb drop down list, all cities, suburbs, towns, villages and other zip codes for the relevant country are listed and should be sorted alphabetically then if there are thirty instances of "Bridge Town" for example each would have additional columns in the dropdown list for State, zip code and any other information needed to quickly identify the correct "Bridge Town" then in the afterupdate or onvalidate event (etc. depending on programming platform) simply write code to add the relevant data from the state and zip code columns in the list. Of course to do this you will need a dropdown control capable of handling multiple columns. You could do as Andreas S�ger suggested and sort the list by zip code but that would mean that everyone using the system would need to know the zip codes but this is not very practicable as most people find it much easier to remember actual names rather than the relevant code. So if there was a Bridge Town MA or Bridge Town CA or Bridge Town NJ most users would know instantly which Bridge Town they wanted. (I'm only guessing with "Bridge Town" because the last time I was in the United States of America I lost count of the number of Bridge Towns I drove through. A bit like Kingston in Australia. Every state's got at least one.) Also in Australia, I'm guessing that it's much the same in your country, there are many small adjoining suburbs with the same postcode. So just entering a "zip" code would not necessarily give the correct data for location name and state. In Great Brittan and parts of Europe it is much more difficult because each street has at least one or more postcodes, however these codes come in two parts, the first part represents the area and the second part represents a section of the street. Cheers, if you need any code samples, let me know what platform you are using and I'll see if I can help, Bruce Carlson. -- 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://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- 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://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Fwd: Saving Window sizing
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 still no joy, the window opens in the original small size. Thanks in advance, Cheers, Andy -- 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://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Auto Filling Drop Down Boxes
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 you advising users on this list to 'avoid' Base, stick with Access, use something else. Base is a primary component of LO, and before LO, OOo. Do you have some link to facts that within LO "there is almost no-one (sic) working on Base"? ... -- 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://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
RE: [libreoffice-users] Re: RTF files rendering: huge differencies in LO 3.4.2 and MSO 2010 -- bug?
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 extensive provisions in the RTF
specification (and, specifically, how the 96.rtf is coded), to
accommodate all manner of up-/down-level adjustments between
different versions and capabilities of software. I wonder if
this is not being handled well in the currently-implemented
import-export features, but I did not dig in deep enough to
determine that one way or the other.
- Dennis
DEEPER ANALYSIS
I did waste a fun evening becoming re-acquainted with RTF though.
My first romance with the format was around 1989 by tricking
Borland Paradox (MS-DOS version) to produce text files of reports
that were actually RTF documents that I could import into a Xerox
workstation desktop publisher and make nice, paginated documents
from. (I was compiling a glossary built in a database.)
In examining the actual RTF of the 96.rtf example, it was very
interesting to see how little of the RTF file is actually needed
to accomplish the result. (There is a ton of overhead material.)
I also started looking through the RTF specifications, using RTF
Specification 1.9.1 (Office 2007 level). It reminded me what a
fascinating format the underlying RTF structure is. And there's
sample code in the specification, although I am attempted to see
how fast I could make a processor on my own that serves as the basis
for an RTF forensic analysis and validation tool.
The number of control-word (sort of like an XML element tag) details
is immense, of course, but very little is needed to make a simple
document.
One important feature: Since the *1987* specification the "\*"
prefix feature has been used to identify control words whose data
should be completely ignored if the control word is not recognized
or supported. For a control word that is not recognized and that
lacks the prefix, the content is presumably to be kept in-line
assuming it is in a place where content is being expressed. Drawing
objects tend to be introduced by {\*\do ...}, for example, and those
are used in important ways in 96.rtf.
There are other interesting facets in the specification. For
example, an RTF can have non-Unicode and Unicode-based alternatives
of the same content, for selective use depending on the capabilities
of the processor that is consuming the RTF.
In addition, there are Word97-2007 shape objects in {\shp ...} and
those also figure significantly in 96.rtf. These also permit an
optional Word 6.0/95 alternative {*\shprslt ...} and I see that
those are present as well in 96.rtf.
Finally, although some of OOXML is mapped into RTF (for example,
MATHML), other parts of OOXML that are newer than the binary formats
are included as XML and the OOXML specification applies. (The way
XML is embedded in RTF is a bit gnarly - the XML is coded in hex
streams so the RTF parser is not confused.) This may be one way that
it has not been necessary to update the RTF specification for Office
2010.
There are many other provisions for up- and down-level compatibility
and soft adjustment to the capabilities of a given RTF consumer. It
is rather remarkable though it depends on the quality of the producer
that such material is included and of the consumer that such material
is exploited.
-Original Message-
From: NoOp [mailto:gl...@sbcglobal.net]
Sent: Wednesday, September 21, 2011 17:06
To: users@global.libreoffice.org
Subject: [libreoffice-users] Re: RTF files rendering: huge differencies in LO
3.4.2 and MSO 2010 -- bug?
On 09/21/2011 09:02 AM, Arkady wrote:
> Hi all!
>
>
> There's a trouble opening simple RTF file in LO 3.4.2. It is opened, but
> it's rendering is incorrect. Same file is correctly opened by MSO 2010. May
> someone provide feedback on the issue?
RTF has always been an issue in OOo and LO. While some recommend using
it, OOo & LO opinion has always been otherwise. I'm not sure exactly
why, as Microsoft has had a published RTF spec for many years. But the
spec seems to be a moving target[1]. Perhaps it's because Microsoft
doesn't always follow their own spec? Samples:
1.
[1]
http://www.microsoft.com/download/en/details.aspx?DisplayLang=en&id=7105
[Word 2003: Rich Text Format (RTF) Specification, version 1.8]
http://www.microsoft.com/download/en/details.aspx?id=10725
[Word 2007: Rich Text Format (RTF) Specification, version 1.9.1]
>
>
> For reference:
>
>
> Image ofLO 3.4.2 with opened file 96.rtf
> http://nabble.documentfoundation.org/file/n3355881/file_96_in_libreoffice_342.jpg
>
>
>
> Image of MSO 2010 with opened file 96.rtf
> http://nabble.documentfoundation.org/file/n3355881/file_96_
[libreoffice-users] Re: MySQL Native Connector
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 >> /usr/lib/openoffice/share/extension/install/mysql-connector-ooo.oxt > > So the answer may well lie in the specificity of the build environment > because this connector appears to work on the machine I built it on in > the master build, i.e. the future 3.5 code. > > Perhaps, it is necessary to build with the 3.4 build source in order to > adapt it to that particular set of code ?? Or then again, perhaps your > Maverick and my Natty have other differences that mean that it doesn't > work. I really don't know enough about it to say, unfortunately and I > won't be able to setup a new build with 3.4 source soon, at least > probably not until next week. > > > Alex > > Just took a look at the libreoffice-mysql-connector that comes from the Natty 11.04 repo & it's install size is 496KB, but it also depends (and installs) libmysqlcppcon4 which is 782KB. $ apt-cache depends libreoffice-mysql-connector libreoffice-mysql-connector Depends: libc6 Depends: libgcc1 Depends: libmysqlclient16 Depends: libmysqlcppconn4 Depends: libstdc++6 Depends: libstlport4.6ldbl Depends: ure Depends: libreoffice-core Suggests: mysql-server Conflicts: ure I also have Oneiric (11.10) installed in a VM. 11.10 has Ubuntu's LO 3.4.3. In 11.10: libreoffice-mysql-connector = 492KB libmysqlcppcon4 = 676KB I'll poke around later today to see what the differences might be. Gary -- 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://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: MySQL Native Connector
Le 22/09/11 19:21, NoOp a écrit : Hi NoOp,, > Unfortunately... > > loading component library failed: > file://home//.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 with LO 3.3.4. > Well thanks for testing anyway. > Note that my profile path for LO 3.4.3 is: > ~/.libreoffice.3.4/3 > However the connector is attmepting to install into: > ~/.libreoffice/3/user/uno_packages > rather than using the modified data in bootstraprc. > > Just to ensure that my path settings for LO 3.4.3 (I do this on purpose > so that I can run multiple instances of LO) wasn't the issue, I then > attempted to install on 3.3.4, where my profile path is the standard: > ~/.libreoffice/3/user > Same results. So it's not a profile path issue. Hmmm, interesting. > > > Added note: the OOo mysql native connector is 4.1MB and yours is > 375.6KB. That's quite a difference: > $ ls -l mysql* > . 4285738 2011-09-20 09:19 mysql-connector-ooo-1.0.1-linux-intel.oxt > . 384635 2011-09-22 10:02 mysql-native-connector-1.0.1-linux-32bit.oxt Yes, the Mac one I built is over 1Mb too, I noticed how small the Linux one was when I copied it over. I didn't seem to get any errors though when building. > > 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 > /usr/lib/openoffice/share/extension/install/mysql-connector-ooo.oxt So the answer may well lie in the specificity of the build environment because this connector appears to work on the machine I built it on in the master build, i.e. the future 3.5 code. Perhaps, it is necessary to build with the 3.4 build source in order to adapt it to that particular set of code ?? Or then again, perhaps your Maverick and my Natty have other differences that mean that it doesn't work. I really don't know enough about it to say, unfortunately and I won't be able to setup a new build with 3.4 source soon, at least probably not until next week. Alex -- 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://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: MySQL Native Connector
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. >> Regards from >> Tom :) >> > > I have now built a 32bit version of the connector extension for Linux, I > shall be putting it on the extensions site today. It was built on my > XBuntu Natty box. I can safely say that compared to building on Mac, > building on Linux was a doddle. > > > Alex Unfortunately... loading component library failed: file://home//.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 with LO 3.3.4. Note that my profile path for LO 3.4.3 is: ~/.libreoffice.3.4/3 However the connector is attmepting to install into: ~/.libreoffice/3/user/uno_packages rather than using the modified data in bootstraprc. Just to ensure that my path settings for LO 3.4.3 (I do this on purpose so that I can run multiple instances of LO) wasn't the issue, I then attempted to install on 3.3.4, where my profile path is the standard: ~/.libreoffice/3/user Same results. So it's not a profile path issue. Added note: the OOo mysql native connector is 4.1MB and yours is 375.6KB. That's quite a difference: $ ls -l mysql* . 4285738 2011-09-20 09:19 mysql-connector-ooo-1.0.1-linux-intel.oxt . 384635 2011-09-22 10:02 mysql-native-connector-1.0.1-linux-32bit.oxt 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 /usr/lib/openoffice/share/extension/install/mysql-connector-ooo.oxt -- 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://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Laggy Calc in Win 7
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. Good luck and regards from Tom :) --- On Thu, 22/9/11, gnulab wrote: From: gnulab Subject: [libreoffice-users] Laggy Calc in Win 7 To: users@global.libreoffice.org Date: Thursday, 22 September, 2011, 10:37 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 at least 30 seconds before any of them appear and respond to any further keystrokes. I have Office 2007 open simultaneously and it doesn't suffer the same problem. LO Writer is fine, though from time to time it shows intermittent lag. How do I solve this problem? Thank you Henry -- View this message in context: http://nabble.documentfoundation.org/Laggy-Calc-in-Win-7-tp3358202p3358202.html Sent from the Users mailing list archive at Nabble.com. -- 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://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- 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://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: RTF files rendering: huge differencies in LO 3.4.2 and MSO 2010 -- bug?
Hi :) Thanks Arkady :) Regards from Tom :) --- On Thu, 22/9/11, Arkady wrote: From: Arkady 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, 2011, 11:37 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 archive at Nabble.com. -- 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://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- 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://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: MySQL Native Connector
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 feats keeps me FAR MORE than busy. The reason I am actually bothering with all that software is that I have been wanting to write a software package (based on PHP) for the administration of such a band. I should maybe also state that I used to work for Mother Blue for a long time as a systems engineer. AD in most of its ramifications was my subject then. Can't let got of it (even though I definitely prefer to play music!) :) On Thu, 22 Sep 2011 10:22:07 +0200, 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. Regards from Tom :) I have now built a 32bit version of the connector extension for Linux, I shall be putting it on the extensions site today. It was built on my XBuntu Natty box. I can safely say that compared to building on Mac, building on Linux was a doddle. Alex -- Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/ -- 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://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Excel file in LibreOffice Calc
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 Excel-File, or just a CSV-File named .xls ? At least this could be an explanation for the symptoms you are describing. > - The date fields and values ??are being displayed in the program > "Open Office / BR Office / LibreOffice" with the character > (apostrophe) and cause error in the calculation of the value > field because they are as text. Take the example of incorrect > visualization in OpenOffice / BROffice / LibreOffice: '$ 100.00 Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- 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://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: RTF files rendering: huge differencies in LO 3.4.2 and MSO 2010 -- bug?
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 archive at Nabble.com. -- 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://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Laggy Calc in Win 7
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=74&t=12426 -- 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://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Laggy Calc in Win 7
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 few letters, it will take at least 30 seconds before any of them > appear and respond to any further keystrokes. I have Office 2007 open > simultaneously and it doesn't suffer the same problem. > > LO Writer is fine, though from time to time it shows intermittent lag. > > How do I solve this problem? > > Thank you > Henry > BTW, I'm using LO 3.4.3 -- View this message in context: http://nabble.documentfoundation.org/Laggy-Calc-in-Win-7-tp3358202p3358204.html Sent from the Users mailing list archive at Nabble.com. -- 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://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Laggy Calc in Win 7
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 at least 30 seconds before any of them appear and respond to any further keystrokes. I have Office 2007 open simultaneously and it doesn't suffer the same problem. LO Writer is fine, though from time to time it shows intermittent lag. How do I solve this problem? Thank you Henry -- View this message in context: http://nabble.documentfoundation.org/Laggy-Calc-in-Win-7-tp3358202p3358202.html Sent from the Users mailing list archive at Nabble.com. -- 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://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Auto Filling Drop Down Boxes
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 suite would be useless for many millions of potential users. -- 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://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Auto Filling Drop Down Boxes
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 state and zip information would automatically be filled in, in their respective drop down boxes, and the information stored in their respective db cells. This is impossible because big cities have more than one ZIP and there are ambiguous city names. You may enter a city name and then choose the actual city and zip from suggested data. I use to enter zip codes. Each zip code belongs to one particular city in one state. Apart from this, big companies and public sectors have their own zip codes. -- 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://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Excel file in LibreOffice Calc
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 any spreadsheet program each and every cell is supposed to take any type of data at any time (well, the validation layer can not really prevent anything). Formatting attributes control the font type, color, border, or the representation of numbers. It is granted that no formatting attribute will ever modify your data. The number format locale determines how _newly_ entered data will be interpreted (1,234.99 vs 1.234,99 and 12/01/99 vs 01/12/99) Some special number formats, mainly "@", may also affect evaluation of _newly_ entered data without having any effect on existing data nor formula results (and this is a really important feature). A formula starts with a = An explicit text entry starts with a ' Number format "@" _prepares_ cells for literal input where = and ' and all thinkable numeric expressions, are taken as literal characters. If you want numbers enter/paste/import numbers. If you want text explicitly enter/paste/import text. If your numbers look strange, format your numbers. Text always looks the same (apart from font, color, borders...) Since decades Excel users enter text and then complain about their data being text. MS "solved" this problem in order to please the dumbest category of users. Excel may evaluate a text "1.234" to one-thousand-two-hundred-and-thirty-five on one machine and to one-point-234 on another machine. 12/01/2011 evaluates to 12th of January on one machine and first of December on another machine. In Excel SUM(A1:A2) returns 0 while A1+A2 returns a sum of evaluated text. Unfortunately, the latter may happen in LibO as well but only with pure sequences of digits (integers) and with strings that represent an unambiguous ISO date. -- 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://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: MySQL Native Connector
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 version of the connector extension for Linux, I shall be putting it on the extensions site today. It was built on my XBuntu Natty box. I can safely say that compared to building on Mac, building on Linux was a doddle. Alex -- 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://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Dead End or Evolution?
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 latest new features (which may or may not work as intended even after QA). Longer term support would have to include bug-fixes and a forum or mailing list for answers. Regards from Tom :) --- On Thu, 22/9/11, planas wrote: From: planas Subject: Re: [libreoffice-users] Re: Dead End or Evolution? To: users@global.libreoffice.org Date: Thursday, 22 September, 2011, 5:16 On Wed, 2011-09-21 at 17:29 -0700, gomadtroll wrote: > I use GNU Linux Debian and LO is the same code & many developers as the > previous OO that was released with this distro. > > That said , the LO devs are doing a lot of work on the code, cleanups, their > words, and I have noticed some 'enhancements' in LO 3.4.3. > > LO ver 3.3.4 looks & acts the same as my previous ver, OO 3.2.1, for my use. > The enhancement to how Tables line styles is configured has changed, and it > is not rendering double lines the same as ver 3.3.4 and previous OO > versions.. If your documents, the archived ones, have tables, they won't be > readable with LO ver 3.4.3. There are bug(s) filed against this issue, > something like #38542. > > I would say LO ver 3.3.4 is a replacement for all previous versions of OO > and in time LO version 3.4.x will be even better. No need to run multiple > versions. > I think the idea is to have on version a little more bleeding edge and one version that is stable. The stable version is for those who can not tolerate a slightly quirky version of LO, particularly in business. > -- > View this message in context: > http://nabble.documentfoundation.org/Dead-End-or-Evolution-tp3352009p3357342.html > Sent from the Users mailing list archive at Nabble.com. > -- Jay Lozier jsloz...@gmail.com -- 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://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- 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://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Excel file in LibreOffice Calc
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 wrote: From: planas Subject: Re: [libreoffice-users] Excel file in LibreOffice Calc To: users@global.libreoffice.org Date: Thursday, 22 September, 2011, 5:26 Hi, On Wed, 2011-09-21 at 13:25 -0300, Luciano R. Moreira - Desenvolvimento wrote: > Hi, > > I am a software developer Folhamatic Systems Company in Brazil > > 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. > > The problem is: > > - The date fields and values ??are being displayed in the program "Open >Office / BR Office / LibreOffice" with the character (apostrophe) and cause >error in the calculation of the value field because they are as text. Take the >example of incorrect visualization in OpenOffice / BROffice / LibreOffice: '$ >100.00 > > Is there any solution or configuration LibreOffice to view the date fields > and value to its corresponding type in the program "Open Office or BROffice > or LibreOffice"? Is there a solution to correctly view this way: $ 100.00? > > Remember that Microsoft's Excel has no problems. I am trying to remember why the ' is used, I think it has something to do with controlling the formatting. When I tried using the ' with a number I was able to add it to another number. And when I used it with a date what I noticed that 'date displayed as it was entered but the date alone used the system default. Are you having any problems with formulas or calculations giving incorrect results? > > Thanks > > Luciano Ricardo Moreira > Desenvolvimento > Tel.:+55 (19)3471-3909 > www.folhamatic.com.br > > > > -- Jay Lozier jsloz...@gmail.com -- 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://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- 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://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Excel file in LibreOffice Calc
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 wrote: From: Andreas Säger Subject: [libreoffice-users] Re: Excel file in LibreOffice Calc To: users@global.libreoffice.org Date: Thursday, 22 September, 2011, 7:04 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 to enter/import/paste data as numbers or as text. If you import everything as text, the application treats it as text. -- 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://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- 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://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
