[libreoffice-users] Re: BASE refuse TIMESTAMPDIFF syntax

You are right, it works with direct mode enabled. Thank you for your help. -- View this message in context: http://nabble.documentfoundation.org/BASE-refuse-TIMESTAMPDIFF-syntax-tp4083921p4083959.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: user

[libreoffice-users] Any Manuals available for Spreadsheet and/or base,?

To Users: I have not used either the Spreadsheet nor the Base parts of Libre office, as I do not know how to. -- Old Sarge-John Boyle IN GOD WE TRUST! -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubs

Re: [libreoffice-users] Re: Softmaker

Hi :) Errr, you did say you knew the list wouldn't be happy about the suggestion! No need to defend your choice further! Personally i think people should try out alternatives because i believe LibreOffice is so much better that people will return to it. With some alternatives they are better for

Re: [libreoffice-users] Exporting Impress Slide Show

Hi :) Prezi, htmlslidy, smil, html5 sound worth quickly looking up and maybe exploring. Good to see some good suggestions buried away in there. Delivery was a bit off-putting but it's good to have someone fairly extreme reminding us that life is worth enjoying rather than going that way ourselves

Re: [libreoffice-users] Re: paypal

Hi :) +1 Yes. It is fairly clear if you read the text but people probably expect to have to pay for something this good. $10 is a pittance compared to other alternatives and people who feel tricked into giving the donation get far more from LibreOffice than they would if they had been forced into

Re: [libreoffice-users] Re: file-endings

Hi :) Sorry i got side-tracked today. I did manage to get some contact details for them so i'll let them know what they need to do tomorrow. I am kinda assuming their xml is not compatible with MS purely because the first file-ending i tried was .odt and that worked. I guess i should try .docx a

[libreoffice-users] file-endings

Hi :) Just downloaded some interesting files from a 'professional' company involved in communications. no-one else can open their files but thanks to a little wisdom i learned from this mailing list years ago i was. Their files end either in .zip or fail to have any file-endings. I changed them

Re: [libreoffice-users] Re: [Libreoffice-qa] Easy QA Task - Need Volunteer(s)

Hey Anne-ology, I recommend commenting on the bug report itself and collaborating with the three other people who are taking a look at the page :) none should be technical, no translation needed, just checking for errors and making it read well :) Thanks! Joel On 11/19/2013 09:47 AM, ann

[libreoffice-users] Re: CALC convert text to numbers

The only way I have to know that the numbers are in reality text, are that they are originally left aligned. Numbers are right aligned. In other matter, I get the ' when I apply a number format to a cell previously formatted as text. If I edit it (F2) I can reach the ' and edit it by hand.

Re: [libreoffice-users] Re: Softmaker

May be Denis could try it on his 10 minute calc sheet and compare speeds. Steve On 2013-11-20 16:27, Doug wrote: On 11/19/2013 09:10 PM, Jay Lozier wrote: On 11/19/2013 07:30 PM, Virgil Arrington wrote: FreeOffice is interesting. In many ways, it resembles LO or OOo. Does anyone know if it wa

Re: [libreoffice-users] Re: Softmaker

On 11/19/2013 09:10 PM, Jay Lozier wrote: > > On 11/19/2013 07:30 PM, Virgil Arrington wrote: >> FreeOffice is interesting. In many ways, it resembles LO or OOo. Does >> anyone know if it was some form of fork or dirivative? >> >> Virgil > Virgil > > I believe FreeOffice is proprietary and is th

[libreoffice-users] Re: CALC convert text to numbers

El 2013-11-14 05:07 p.m., mariosv escribió: I have forgot in my previous post, another option: First copying the text to convert [Ctrl+c]. From the right-arrow in the icon. selecting unformatted text, we get the same option as importing csv files.

[libreoffice-users] Re: Softmaker

On 11/19/2013 08:50 PM, John Jason Jordan wrote: On Tue, 19 Nov 2013 19:30:24 -0500 "Virgil Arrington" dijo: FreeOffice is interesting. In many ways, it resembles LO or OOo. Does anyone know if it was some form of fork or dirivative? You can download a free version for Linux or Windows; I di

Re: [libreoffice-users] Re: Softmaker

On Tue, 19 Nov 2013 19:30:24 -0500 "Virgil Arrington" dijo: >FreeOffice is interesting. In many ways, it resembles LO or OOo. Does >anyone know if it was some form of fork or dirivative? You can download a free version for Linux or Windows; I didn't see a Mac option. It appears to be a complet

[libreoffice-users] Re: Libreoffice 4.1.3.2 slow

It is slow opening a 42 MB calc file; last 10 min. It is slow too, specifying a crosstab table. I don't know if the previous version could be faster than the actual version, but it speed is impractical. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://w

Re: [libreoffice-users] Re: Softmaker

On 11/19/2013 07:30 PM, Virgil Arrington wrote: FreeOffice is interesting. In many ways, it resembles LO or OOo. Does anyone know if it was some form of fork or dirivative? Virgil Virgil I believe FreeOffice is proprietary and is the free version of SoftMaker's office suite. Jay -Or

Re: [libreoffice-users] [Win LO4.1.3] All symbols in autocorrect

At 07:41 19/11/2013 -0600, Dan Chaltiel wrote: I would like to use several symbols in LO. I use autocorrect a lot, like /^ would do North-East arrow, and \v South-East arrow. Unfortunately, I can only choose the "Segoe UI" font in autocorrect "insert symbol" right-click menu, and SE arrow doe

Re: [libreoffice-users] Re: Softmaker

FreeOffice is interesting. In many ways, it resembles LO or OOo. Does anyone know if it was some form of fork or dirivative? Virgil -Original Message- From: Doug Sent: Monday, November 18, 2013 7:10 PM To: users@global.libreoffice.org Subject: Re: [libreoffice-users] Re: Softmaker On

[libreoffice-users] Re: file-endings

Maybe is their way to avoid make public or spread too much, what file formats they are using. The best thing, they are using ODF. Miguel Ángel. -- View this message in context: http://nabble.documentfoundation.org/Re-file-endings-tp4084021p4084059.html Sent from the Users mailing list archiv

[libreoffice-users] Re: paste special problem

I was just experiencing the same problem. I'm using KDE with the Klipper clipboard tool. Trying to copy from a web page then paste special into LO spreadsheet. The paste special option was grayed out. Clearing the Klipper history fixed the problem. Cheers, --Algot -- - A

Re: [libreoffice-users] Re: paypal

2013/11/19 Jean-Francois Nifenecker > Hi, > > Le 19/11/2013 04:29, NoOp a écrit : > > It's irritating as hell. It makes LO look as if a donation is required > > (even though it says otherwise) and IMO is a bit of an embarrassment > > when referring LO to others. Several have commented & were sure

Re: [libreoffice-users] Re: paypal

Hi, Le 19/11/2013 04:29, NoOp a écrit : > It's irritating as hell. It makes LO look as if a donation is required > (even though it says otherwise) and IMO is a bit of an embarrassment > when referring LO to others. Several have commented & were sure to > mention that AOO doesn't require this nonse

Re: [libreoffice-users] [Win LO4.1.3] All symbols in autocorrect

You should be able to change fonts to suit whatever you're working on at the time - [go to options to set accordingly first] then with the most appropriate font, you can add to it by clicking on 'character map' which will pop up a box containing various additions -

[libreoffice-users] Re: file-endings

I'm interested in hearing more re. this ... sounds fascinating, and arouses my curiosity ;-) From: Date: Tue, Nov 19, 2013 at 7:24 AM Subject: file-endings To: users-moderat...@global.libreoffice.org Hi :) Just downloaded some interesting files from a 'professional' company

Re: [libreoffice-users] Re: [Libreoffice-qa] Easy QA Task - Need Volunteer(s)

I was able to view this site - and would be glad to help with translation, or whatever - just not the really technical stuff ;-) From: Richard Date: Mon, Nov 18, 2013 at 3:33 PM Subject: [libreoffice-users] Re: [Libreoffice-qa] Easy QA Task - Need Volunteer(s) T

Re: [libreoffice-users] QA Easy Task - Wiki Cleanup

great idea. From: Joel Madero Date: Mon, Nov 18, 2013 at 3:59 PM Subject: [libreoffice-users] QA Easy Task - Wiki Cleanup To: "users@global.libreoffice.org" , Libreoffice-qa Hi All, Yet another easy task that needs done but has sat on my plate for months. https://bugs.freedesktop.or

Re: [libreoffice-users] Language Translation on LibreOffice

On 11/17/2013 07:53 PM, Michael Kanthal wrote: > Is there a language-translation feature in the 4.1 L.O. release? "language translation feature". If, by that term, you mean something that does automatic/machine translation, then no. Sadly, that extension was broken during one of the upgrades of

Re: [libreoffice-users] CALC convert text to numbers

On Sun, 17 Nov 2013 19:57:10 -0700 Oogie McGuire wrote: > > On Nov 17, 2013, at 4:41 PM, Paul wrote: > > >> Or if I know they are text (but there is ABSOLUTELY NO WAY TO SEE > >> THAT IN LO) > > How would you see it in Excel? I recall the display in Excel being > > the same as in LO. The only

Re: [libreoffice-users] Re: Installing Apache OO on same distro as LO - for alternate use

On 2013-11-18 6:08 PM, NoOp wrote: I've found that AOOo 4.x takes over*all* mime associations for opendoc's. It's not too much of a problem re-associating the documents via Nautilus or Nemo, but it totally screws up other applications like Firefox & SeaMonkey. I've even tried leaving out openof

[libreoffice-users] [Win LO4.1.3] All symbols in autocorrect

Hello everyone My first post here, I'm not used to mailing-lists so please forgive any use-mistake. I would like to use several symbols il LO. I use autocorect a lot, like /^ would do North-East arrow, and \v South-East arrow. Unfortunately, I can only choose the "Segoe UI" font in autocorrect "i

[libreoffice-users] Re: BASE refuse TIMESTAMPDIFF syntax

Le 19/11/13 10:23, polch a écrit : Hi Paul, According to this : https://forum.openoffice.org/en/forum/viewtopic.php?p=220192 you need to run your query in SQL Direct mode. Alex -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-he

[libreoffice-users] Re: BASE refuse TIMESTAMPDIFF syntax

Le 19/11/13 10:23, polch a écrit : Hi Paul, It might help us a bit more if we knew which db engine you were using ? Alex -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines +

Re: [libreoffice-users] Re: paypal

Hi, I in fact do not have any problems with downloading LO: I just click on the big green button on http://www.libreoffice.org/download (the topmost one from three similar buttons, the rest are for localizations - in case others do not see them). A new page (donate.libreoffice.ord...) opens and

Re: [libreoffice-users] Exporting Impress Slide Show

On 18/11/2013, Dave Liesse wrote: > > 2. Saved as .pps file. Copied presentation and audio file directory -- > pathing kept intact -- to thumb drive. > > 3. Open .pps file on another computer that doesn't have LibreOffice > installed. Slide show runs, music does not play. Confirmed music file

Re: [libreoffice-users] BASE refuse TIMESTAMPDIFF syntax

polch, dit you try this in "native' mode (LO just send the statement) Hi. I would like to build an SQL request that use TIMESTAMPDIFF. As i encounter some problems of rejected syntax i try a minimal example in sql editor : SELECT TIMESTAMPDIFF(MONTH,'2003-02-01','2003-05-01') But either with

[libreoffice-users] BASE refuse TIMESTAMPDIFF syntax

Hi. I would like to build an SQL request that use TIMESTAMPDIFF. As i encounter some problems of rejected syntax i try a minimal example in sql editor : SELECT TIMESTAMPDIFF(MONTH,'2003-02-01','2003-05-01') But either with this example, the sql editor doesn't want to save the request neither exe