Re: [libreoffice-users] busca de soluções para Excel

2013-08-26 Thread Brian Barker
At 10:57 25/08/2013 +0100, Tom Davies wrote: Again using Quick Translate but this time from English into Portuguese. Unfortunately machines are not good at speaking human languages so this might be nonsensical. Which is why it's always best to leave messages in the writer's own language and

[libreoffice-users] Re: Cross Platfrom Support Question

2013-08-26 Thread Alexander Thurgood
Le 24/08/13 11:21, Jay Ridgley a écrit : Hi Jay, there were no regular installation files available and to make another selection She is running MAC OSX How should she proceed? There is currently no fully functional mobile version of LibreOffice available for Android or iOS touchscreen

Re: [libreoffice-users] LibreOffice paragraph styles exported to other software/formats?

2013-08-26 Thread Virgil Arrington
In my experience, most paragraph styles tend to translate well to MS-Word formats. However, I've had problems with the alignment of automatic numbering and/or bullets. LO and MSW seem to align them differently. One bigger difference, however, is the way the two formats handle page formatting.

[libreoffice-users] Sorting a MySQL Database

2013-08-26 Thread Ian Whitfield
Hi All I now have my new MySQL/LO Base Database up, running and fully edited from the old one. And what a pleasure it is to work with!! This IS the way to go, One question - It seems to have a strange way of sorting the Data as displayed in the Form I designed and I have to select 'Sort' in

Re: [libreoffice-users] Sorting a MySQL Database

2013-08-26 Thread Jay Lozier
Ian, Is there an id key field? If there is the default sorting is by the id key (usually numerical order). In SQL you can add the line: ORDER BY Last-Name, First-Name The default order is ascending (ASC) if descending is needed ORDER BY Last-Name DESC, First-Name DESC On Mon, 26 Aug

[libreoffice-users] .docx file format disturb in libreoffice 4.0 Writer

2013-08-26 Thread Satish Srivastava
Dear Friends, I am facing a issue in open office migration from microsoft office. when i am trying to open .docx file it is opening but header format disturb means not properly. So please give any solution for this. Thanks regards Satish -- To unsubscribe e-mail to:

Re: [libreoffice-users] .docx file format disturb in libreoffice 4.0 Writer

2013-08-26 Thread Tom Davies
Hi :) You would probably find the same thing happen in other versions of MS Office.  The DocX format keeps changing in each different version of MS Office and possibly on different versions of Windows.  So a DocX made with 2007 on Xp might look quite different in MS Office 2010 on Win7. 

Re: [libreoffice-users] .docx file format disturb in libreoffice 4.0 Writer

2013-08-26 Thread Kracked_P_P---webmaster
To restate Tom's info If you save a .docx file using MSO 2013, it most likely will not read properly in MSO 2010 or 2007. This will happen more often as the document becomes more complex. I always tell my MSO users that if you want to make sure all of the different versions of MSO can read

Re: [libreoffice-users] .docx file format disturb in libreoffice 4.0 Writer

2013-08-26 Thread saraysri .
On Mon, Aug 26, 2013 at 9:38 PM, Kracked_P_P---webmaster webmas...@krackedpress.com wrote: To restate Tom's info If you save a .docx file using MSO 2013, it most likely will not read properly in MSO 2010 or 2007. This will happen more often as the document becomes more complex. I always

Re: [libreoffice-users] .docx file format disturb in libreoffice 4.0 Writer

2013-08-26 Thread Tom Davies
Hi :) Backwards incompatibility is not a huge surprise.  There is always a chance that some complex thing got inserted even though it probably didn't get used it might still be hidden in the document's coding.  What surprises me is that documents created in an earlier version of MS Office

Re: [libreoffice-users] .docx file format disturb in libreoffice 4.0 Writer

2013-08-26 Thread Mirosław Zalewski
On 26/08/2013 at 17:23, Satish Srivastava satish.srivast...@fosteringlinux.com wrote: So please give any solution for this. There are three possible solutions: - create good bug report (providing example file and image showing how it should look like) and hope it will get fixed in future

Re: [libreoffice-users] LibreOffice paragraph styles exported to other software/formats?

2013-08-26 Thread Info/UX
Hi Tom :-) I can probably get away with sending .docs, but I would like the option to convert to .docx later if need be. At the final stages I can work on an MS computer in MS Office. The documents have no images, they are basic articles with only prose and references. They need to look

Re: [libreoffice-users] .docx file format disturb in libreoffice 4.0 Writer

2013-08-26 Thread Tom Davies
Hi :) I would definitely prefer that people do ask us so that they can get the truth of it and then maybe test what we say to confirm it.  The other option is to ask MS why and their answer will be that they have to buy their latest version of their MS Office and then put up with people who

Re: [libreoffice-users] LibreOffice paragraph styles exported to other software/formats?

2013-08-26 Thread Info/UX
Thanks, Virgil. I can probably alter any lists when I work in an MS environment at the final stage of formatting. Regarding page formatting — I'm wondering if I use slightly more advanced features of LibreOffice to get my results whether it would cause more problems when working in Word. I

Re: [libreoffice-users] .docx file format disturb in libreoffice 4.0 Writer

2013-08-26 Thread Tanstaafl
On 2013-08-26 12:49 PM, saraysri . satishsrivasta...@gmail.com wrote: So please give me solution for this because users have multiple fils. they can not save as all files in .doc formats. Have everyone buy Microsoft Office 2013. Seriously. This is the only real 'solution' that you can

[libreoffice-users] Suggestions

2013-08-26 Thread Jonathon Waterman
Where/who can you email a Libreoffice suggestion for improvement? -- 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

Re: [libreoffice-users] Re: Formulas in text instead of result - LO Calc

2013-08-26 Thread David Stuckey
Thanks to all. It is amazing how such a little action can cause so much anxiety. | David Stuckey, MBA. MHSA. On Fri, Aug 23, 2013 at 11:01 AM, Pedro pedl...@gmail.com wrote: Open Calc, go to Tools Options. In the Options dialog click on the plus sign to the left of LibreOffice Calc (on the

Re: [libreoffice-users] regular expression in formula to investigate

2013-08-26 Thread yahoo-pier_andreit
On 08/25/2013 01:35 AM, Brian Barker wrote: At 23:26 24/08/2013 +0200, Pier Andreit wrote: [...] I cannot understand this part: SEARCH(/[^/]*$, CELL(filename)) I know it search in CELL(filename) but I cannot understand the criteria /[^/]*$ from the tests it seems to find the last / in any

Re: [libreoffice-users] LibreOffice paragraph styles exported to other software/formats?

2013-08-26 Thread Tom Davies
Hi :) If you can use MS Office to do some final proof-reading then you are unlikely to have any problems.  We have been assuming that is not possible and that would make the final outcome uncertain.  Being able to quickly scroll through before sending it out into the world kinda eliminates

Re: [libreoffice-users] .docx file format disturb in libreoffice 4.0 Writer

2013-08-26 Thread Jay Lozier
On Mon, 26 Aug 2013 14:42:32 -0400, Tanstaafl tansta...@libertytrek.org wrote: On 2013-08-26 12:49 PM, saraysri . satishsrivasta...@gmail.com wrote: So please give me solution for this because users have multiple fils. they can not save as all files in .doc formats. Have everyone buy

Re: [libreoffice-users] Suggestions

2013-08-26 Thread Jay Lozier
On Mon, 26 Aug 2013 15:02:44 -0400, Jonathon Waterman peedyswo...@gmail.com wrote: Where/who can you email a Libreoffice suggestion for improvement? The easiest way is to file a bug report on Bugzilla and mark the bag as feature/enhancement. -- Jay Lozier jsloz...@gmail.com -- To

Re: [libreoffice-users] .docx file format disturb in libreoffice 4.0 Writer

2013-08-26 Thread Gordon Burgess-Parker
On 26/08/13 21:37, Jay Lozier wrote: Or refuse to buy or use any version of MSO until MS correctly uses odf formats as default formats. Certainly in Office 2010 you have the option to set ODF as the default document type, and I believe that in Office 2013/365 they've fixed the ODSExcel bug of

Re: [libreoffice-users] LibreOffice paragraph styles exported to other software/formats?

2013-08-26 Thread Virgil Arrington
Ryan wrote: Regarding page formatting — I'm wondering if I use slightly more advanced features of LibreOffice to get my results whether it would cause more problems when working in Word. I think that's a good way of phrasing the issue. I think the more we use methods that are unique to LO,

Re: [libreoffice-users] .docx file format disturb in libreoffice 4.0 Writer

2013-08-26 Thread Tom Davies
Hi :) MS Office 2010 and earlier used a bad implementation of an old version of the ODF formats which meant that Word/Writer was fine but Calc/Excel lost all the formulas and just gave fixed values instead.  They were able to give a reasonable excuse for shunning the ODF 1.2 that everyone else

Re: [libreoffice-users] Suggestions

2013-08-26 Thread Tom Davies
Hi :) It depends on what sort of suggestion.  If you can run it past us then we might be able to point you in the right direction.  If it's a marketing strategy or idea for an event then the Marketing List might be good.  Like all the other lists it is also widely accessible to the general

Re: [libreoffice-users] .docx file format disturb in libreoffice 4.0 Writer

2013-08-26 Thread Tom Davies
Hi :) Accidents happen.  I thought it was fairly easy to tell who said what just by the different word-usage and sentence structure.  So, no need to fret.  The odf-converter-integrator sounds like a good idea but with a 3rd party tool you have got to wonder who makes it and what their

Re: [libreoffice-users] LibreOffice paragraph styles exported to other software/formats?

2013-08-26 Thread Info/UX
Thanks, Tom, Virgil. If I wanted to use different text body styles throughout I would probably have made new styles and called them text body 1, 2, etc. Luckily nothing like that is needed in this case. But I have created my simple template with basic paragraph and page styles. So, in

Re: [libreoffice-users] LibreOffice paragraph styles exported to other software/formats?

2013-08-26 Thread Tom Davies
Hi :) Tweaking in MS office is probably the best time to convert Doc to DocX.  However you then risk the DocX looking different if they are not using the same version of Windows and the same version of MSO.  Mind you any editable format changes a bit due to external issues such as different

Re: [libreoffice-users] LibreOffice paragraph styles exported to other software/formats?

2013-08-26 Thread Tom Davies
Hi :) I think my way is the best, unless it doesn't work out and then i need to find someone else to blame.  Virgil's plan also has merit and it sounds like he has used it on more and different types of documents than me.  Mine tend to have quite a lot of logos.  Not sure if Virgil's documents

Re: [libreoffice-users] LibreOffice paragraph styles exported to other software/formats?

2013-08-26 Thread Tom Davies
Hi :) iow.  Both ways are good.  Pick one.  Use it.  (or modify one) Neither is perfect because DocX and even Doc is not perfect.  Odt usage is on the rise and beginning to be the best choice for long-term storage.  Hopefully it will 'soon' become the best choice for active collaboration too. 

Re: [libreoffice-users] LibreOffice paragraph styles exported to other software/formats?

2013-08-26 Thread Virgil Arrington
My documents tend to be *really* basic in terms of formatting. Typically, they are either legal or academic style papers. I'm a heavy user of paragraph styles and won't work without them. I tend to do my entire document as an .odt and then at the end convert to .doc as necessary. I'd use the

Re: [libreoffice-users] LibreOffice paragraph styles exported to other software/formats?

2013-08-26 Thread Info/UX
Thanks, Virgil. My documents are similar to yours. One last question then I'll give you guys some peace. :-) Would making a page style with page size letter and with a footer be considered LO specific? I don't need anything more intricate than that. Thanks for the tip regarding Atlantis. I

Re: [libreoffice-users] LibreOffice paragraph styles exported to other software/formats?

2013-08-26 Thread Info/UX
Thanks, Tom. I'll do as you say. I'll start with a blank .odt and assess the method/results as I go. I agree with your comments about why this process is made difficult for profit by certain entities. The current problem with collaboration is that once the file leaves your computer.. you

Re: [libreoffice-users] LibreOffice paragraph styles exported to other software/formats?

2013-08-26 Thread Virgil Arrington
Before answering your question, I did a little test. I loaded a simple .odt two page document in LO. It has some basic paragraph styles, and a few outline styles with automatic numbering, along with a footer with a page number. Basic stuff. I then saved the document as a .doc (Word 2003). I

Re: [libreoffice-users] LibreOffice paragraph styles exported to other software/formats?

2013-08-26 Thread Tom Davies
Hi :) Good point about using US-letter!  That might make the biggest difference!  Even though US-letter is only widely available in the US and the rest of the world tends to print on A4 it is still fairly rare to find computers set-up to print to A4.  That might make more difference than

Re: [libreoffice-users] LibreOffice paragraph styles exported to other software/formats?

2013-08-26 Thread Virgil Arrington
When will you guys across the pond realize that “normal” letter paper is 8.5 by 11 inches? Virgil From: Tom Davies Sent: Monday, August 26, 2013 7:04 PM To: Info/UX ; Virgil Arrington Cc: users@global.libreoffice.org Subject: Re: [libreoffice-users] LibreOffice paragraph styles exported to

Re: [libreoffice-users] LibreOffice paragraph styles exported to other software/formats?

2013-08-26 Thread Info/UX
Thanks a lot for that, Virgil. Based on the information you and Tom have provided, my workflow will go: .ott (with paragraph and page styles) -- .odt (copy and paste .doc content, load style from template, format, save) -- export to PDF -- save as .doc -- send to MS computer -- Manually clean

Re: [libreoffice-users] LibreOffice paragraph styles exported to other software/formats?

2013-08-26 Thread Info/UX
Hahaha. I just wish we could have an agreed standard! ;-) Ryan On 27/08/13 00:15, Virgil Arrington wrote: When will you guys across the pond realize that “normal” letter paper is 8.5 by 11 inches? Winking smile Virgil *From:* Tom Davies mailto:tomdavie...@yahoo.co.uk *Sent:* Monday, August

Re: [libreoffice-users] LibreOffice paragraph styles exported to other software/formats?

2013-08-26 Thread Virgil Arrington
I think you've got a good process there. Fonts! It's one problem I see with interaction between Linux and Windows. I have a dual boot Windows/Linux laptop, and the font issue is a constant problem. I've found that many Windows fonts install quite nicely into Linux, but I do want to respect

Re: [libreoffice-users] regular expression in formula to investigate

2013-08-26 Thread Brian Barker
At 21:35 26/08/2013 +0200, Pier Andreit wrote: as you know is there some way to start search from the right of strings?? Not directly that I know of. I think you just need to use the $ character - as here - to lock the pattern you are matching to the end of the text (or of a paragraph, in

Re: [libreoffice-users] LibreOffice paragraph styles exported to other software/formats?

2013-08-26 Thread Tom Davies
Hi :) What's an inch?  Regards from Tom :)  From: Info/UX inf...@gmx.com To: Virgil Arrington cuyfa...@hotmail.com Cc: Tom Davies tomdavie...@yahoo.co.uk; users@global.libreoffice.org Sent: Tuesday, 27 August 2013, 0:22 Subject: Re: [libreoffice-users]

Re: [libreoffice-users] LibreOffice paragraph styles exported to other software/formats?

2013-08-26 Thread Tom Davies
Hi :) There used to be a package called something like ms core fonts which had arial, times new roman, trebuchet, verdana and maybe a couple other things.  I must have got the name a bit wrong because i cna't find it in my package manager now.  I've copied across a few fonts from Ubuntu to

Re: [libreoffice-users] LibreOffice paragraph styles exported to other software/formats?

2013-08-26 Thread Don C. Myers
In Ubuntu 13.04, the package in the software center is called: Installer for Microsoft TrueType core fonts Don On 08/26/2013 08:00 PM, Tom Davies wrote: Hi :) There used to be a package called something like ms core fonts which had arial, times new roman, trebuchet, verdana and maybe a couple

Re: [libreoffice-users] LibreOffice paragraph styles exported to other software/formats?

2013-08-26 Thread Brian Barker
At 00:22 27/08/2013 +0100, Ryan Noname wrote: Hahaha. I just wish we could have an agreed [paper size] standard! ;-) We do: it's ISO 216 - see http://en.wikipedia.org/wiki/ISO_216 . The only problem is that a tiny, tiny minority of countries don't respect it. Brian Barker -- To