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

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

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

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

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

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 'enha

[libreoffice-users] Excel file in LibreOffice Calc

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

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

Hi, On Wed, 2011-09-21 at 17:02 -0700, stripedtomato wrote: > Thanks for the help by providing the links and your insight. > > I thought the community here was larger. I will stay with Access for now > and maybe convert to Base in the future. > > The rest of LibreOffice works like a charm fo

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

Hi all On Wed, 2011-09-21 at 17:06 -0700, NoOp wrote: > 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 fee

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

Hi :) LibreOffice is larger.  It's just that almost everyone avoids Base.  While Writer and Cal and the rest attract a LOT of devs they just avoid Base. Regards from Tom :) --- On Thu, 22/9/11, stripedtomato wrote: From: stripedtomato Subject: [libreoffice-users] [Solved] Auto Filling Drop Dow

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

Hi :) Best answer so far by a long way.  Thanks NoOp :)  The wikipedia page was interesting.  Apparently MS are stopping developing the spec for rtf and MS Office 2010 no longer supports it!  Doc (without the X at the end) is better.  File - "Save As ..." - "MS Word (97/2000/Xp)" It's about th

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

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

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

Hi :) Hmm, sorry for the double post. When you save with LibreOffice it doesn't seem to make much difference which format you use as long as the recipient opens the document in any version of LibreOffice.  Even other programs such as google-docs seem to be fine with it.  It's just when you try

[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

[libreoffice-users] [Solved] Auto Filling Drop Down Boxes

Thanks for the help by providing the links and your insight. I thought the community here was larger. I will stay with Access for now and maybe convert to Base in the future. The rest of LibreOffice works like a charm for me. :) - MS free as of 09/13/08 @ 13:27:25 CST -- View this message

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

Hi :) I don't know what the problem is or whether it's a format problem or not.  I have noticed that images saved in doc or docX format often move around when opened in a different office suite.  LibreOffice ones opened in MS Office often look a bit wrong.  MS Office ones opened in LibreOffice o

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

I'm puzzled. Tom, are you saying the differences that are being talked about here are attributable to differences between the ODF 1.1 and ODF 1.2 specification? (I.e., Microsoft Office supports the former, and not the latter at this time.) Or are they discretionary differences in implementatio

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

Hi :) I think it might be best to just file a bug-report about it http://wiki.documentfoundation.org/BugReport The guide helps you search to see if other people have had the same issue and reported it.  The 2nd file (russian table) opened fairly fine in Writer on Gnu&Linux (Ubuntu 10.04 (i thin

RE: [libreoffice-users] Lo 3.4.3 Recovery mode

Hi :) There is one more release due in the 3.3.x branch.  The 3.3.5 is due in mid November http://wiki.documentfoundation.org/ReleasePlan#3.3_release but the more important issue is that the 3.3.x branch was claimed to have 1 year's support from release date.  I'm not sure that will hold for the

Re: [libreoffice-users] Contribute to 'Copy only visible cells' extension project

Thank Gustavo, I understand now. Regards. El 21/09/11 17:52, Gustavo Pacheco escribió: > Hi Miguel! > > Do you use a filter (AutoFilter, Sardard Filter, Advanced Filter) to hide > some rows? > In this case, yes, copy only the visible cells is the normal behavour. > > But, if you hide your c

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

Le 21/09/11 19:09, Tom Davies a écrit : Hi Tom, > 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 The poster's question is a common one, which has been answered many times on the OpenOffice.org

RE: [libreoffice-users] Lo 3.4.3 Recovery mode

Hi again, Thank you for your advice, which I finally followed. I installed both version and everything seems to work fine! Well, I might have one other question. Is LibreOffice 3.3.X still in development or the efforts are now all in the 3.4.X branch and even 3.5.X? Thanks! Simon > Date: Wed

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

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 :) --- On Wed, 21/9/11, stripedtomato wrote: From: stripedtomato Subject: [libreoffice-users] Auto Filling Drop Down Boxes To: users@globa

[libreoffice-users] Auto Filling Drop Down Boxes

Hello, I am wanting to do something in Base, but I am not sure what the “action” (auto filling?) is called, so I am not sure what subject to research. If you could let me know what I should be researching, or provide an example, it would be appreciated. I have three drop down boxes: City, State

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

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? For reference: Image ofLO 3.4.2 with opened file 96.rtf http://nabble.documentfoundation.org/fil

Re: [libreoffice-users] Contribute to 'Copy only visible cells' extension project

Hi Miguel! Do you use a filter (AutoFilter, Sardard Filter, Advanced Filter) to hide some rows? In this case, yes, copy only the visible cells is the normal behavour. But, if you hide your cells by the Hide command, all cells should be pasted. You can see the diference at: http://help

Re: [libreoffice-users] How to use LibreOffice on ms windows as a background server and in interactive mode at the same time?

Hi :) Unfortunately i think the only way around this is to install a 2nd instance of LibreOffice using this guide http://wiki.documentfoundation.org/Installing_in_parallel Another way around is to install a virtual machine and install the other instance of LibreOffice to that, either as the serv

Re: [libreoffice-users] LO Navigator and MS .doc files containing Section Breaks

On Tue, Sep 20, 2011 at 10:24 PM, Jonathon Waterman wrote: > Hi all, > > I need to review a .doc document that was created in MS Word 2007. > > This document contains both Page breaks and Section breaks. > > While I can get the Navigator in LO to GOTO the next page - how can I get > it > to GOTO w

Re: [libreoffice-users] Contribute to 'Copy only visible cells' extension project

Thanks for the answer Gustavo, but copy only the visible cells is the normal behavour in Libo and OOo, in 3.3 and 3.4. Regards El 21/09/11 2:21, Gustavo Pacheco escribió: > Hi Miguel! > > The purpose of the extension is just copy the non hidden rows or columns. > > In other words, suppose two wa

[libreoffice-users] How to use LibreOffice on ms windows as a background server and in interactive mode at the same time?

Hello, I am developing a tool that in the batch mode trough UNO generates a scalc documents. Users have to have an ability to open generated and saved documents. On the windows I can start office as a server (in the background mode) using either of the commands start soffice -headless -nologo

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

Hello Alex, Thanks for the advice! To start with, I am VERY busy (outside IT!) for the coming week, so I simply won't have the time to do anything in this respect at the moment. The funny thing is that on my W/Vista-LO 3.3.4 System that connects to a MySQL database server running on my GNU-Linux

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

Hi :) 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 :) --- On Wed, 21/9/11, Alexander Thurgood wrote: From: Alexander Thurgood Subje

[libreoffice-users] Re: email merge across sessions

Le 21/09/11 01:16, Brian Katzung a écrit : Hi Brian, > Is there a way to do this that I have not found, or is one limited to > performing the individual customizations and emailing the results in the > same session? If it is possible, can you tell me where is the process > documented so I know wh

[libreoffice-users] Re: MySQL Native Connector

Le 21/09/11 06:00, Tom Davies a écrit : Hi Tom, > Hi :) > Thanks :) So Building neatly avoids the packagiong issues of .rpm versus > .deb? We just need 1 for 32bit Gnu&Linux and 1 for 64bit, not 1 for each of > the main families (Arch? Slackware, Debian, RedHat, errr)? So, Heinrich's > buil

[libreoffice-users] Re: MySQL Native Connector

Le 20/09/11 18:25, NoOp a écrit : Hi NoOp, > ... > According to: > > > > the source is here: > > [MySQL Connector/C++ Download] > http://dev.mysql.com/downlo

Re: [libreoffice-users] Re: docx format troubles

Il 20/09/2011 22:16, planas ha scritto: On Tue, 2011-09-20 at 16:07 +0200, Marcello Romani wrote: Il 17/09/2011 14:30, David B Teague sr ha scritto: On 9/16/2011 6:56 AM, Tom Davies wrote: If you were able to ring-fence about 20% of the features of MS Office then about 80% of users never stra