Re: [libreoffice-users] Re: Writer: Page Number/Page Count problem.
I don't really care about the extension but *many* people use docx. It's not something specific to me. Thank you for your advice but you get funny when you say "It's coming, sooner than you might think." I like LO, I appreciate the developers and I'm so willing to install LO everywhere I can and I'm fighting in my company with people but i'm nearly alone with this here. There are 200 pc users, I can't control who receive what document in which format. But I know they want it working good, they want it to be compatible with doc and docx format and they don't want to face bugs like I told yesterday. When anything goes wrong, they want to give up, they want to go back to mso. The documents I talk about is being used in contracts with pfizer , novartis, etc which are imporant documents here. LO have "office" in it's name, so I can presume it's targeted for the office use. If you have success over convincing people to use an office application which can't do page numbering while they need it, I wan't to know how you manage it. Users here really don't want to spend time with bugs or any conversions and memorize every workaround for every situation. And most of the problems I face here is about compatibility. This is nothing personal, nothing emotional and I am sure there are many other companies in a similar profile. If you think docx can be avoided and it's unnecessary, propose dropping it from the distro. But I wish it can do page numbering instead. On 08.03.2011 04:27, MR ZenWiz wrote: On Mon, Mar 7, 2011 at 5:17 AM, Arda Tunccekic wrote: If the "x format" is the default format in the leading&mainstream office product, you can't escape from it unfortunately. Sure you can, especially when the "leading [for $]& mainstream" office product supports both formats: just change your default format to .doc (.xls, etc) and your output documents will be 100% compatible with the .???x formats (if you're using MSO), or 95+% compatible if you're using OO or LO. It is useful for me because the documents are smaller in size. Better to use .odf formats for this, and they work even in MSO 2007+. I know it's so much pain for the development team but LO should be compatible in every possible way. They are and do, but there are limits when you don't have the resources of a market giant with monopoly power (so far) and a proprietary format that no one likes. If someday LO market takes over, LO can set the rules. It's coming, sooner than you might think. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
Re: [libreoffice-users] Re: Writer: Page Number/Page Count problem.
I can use any format, it's not a problem for me, but you or I cannot tell using other formats to any computer illiterate who only know ms office which they learn in school. And I think, if there is an option in any software, it should work. If it cannot work in the supposed way, that option should be fixed or dropped. And in this case, I think this is a trivial feature and it should be fixed. On 07.03.2011 16:04, webmaster for Kracked Press Productions wrote: On 03/07/2011 08:36 AM, Glenn wrote: I haven't had a chance to check out the various options, but there are some free conversion tools and some tools for pay that translate docx to doc and, I think, vice versa. Does anyone have any experience with these? On Mar 7, 2011, at 8:17 AM, Arda Tunccekic wrote: If the "x format" is the default format in the leading&mainstream office product, you can't escape from it unfortunately. It is useful for me because the documents are smaller in size. I know it's so much pain for the development team but LO should be compatible in every possible way. If someday LO market takes over, LO can set the rules. MSO tried to add the ODF formats to their package, but did not try hard enough. Yes MS sets the rules since it has the most market share. It bought the votes to have its XML format made a "second" ISO "international standard" after ODF was made THE "international standard", and there should not be two "standards" for the same "item" by regulations of the ISO group. He who had the biggest stick [or most money] makes the rules and gets away will not obeying court rulings for years, since the fines for doing so is just "pocket change" for MS. But since more and more Governments are moving to Open Source, then that should mean also that a single company should not control the file formats as well. So ODF is the way they should go unless you use MS's non-XML formats. On 07.03.2011 15:14, webmaster for Kracked Press Productions wrote: On 03/07/2011 05:30 AM, David Griffiths wrote: Arda Tunccekic wrote: I have a document with 3 pages and I have a footer in it and I want to see the pagenumber/pagecount there. I select the footer and I insert the page number and page count like this Insert -> Fields -> Page Number , I type "/" , Insert -> Fields -> Page Number When I do a print preview it looks ok. But when I save the document and open it again I see -1-3 , -2-3 , -3-3 instead. I use the current version : LibreOffice 3.3.1 Build:8 The file extension is docx Hi I can confirm this behaviour. Seems like you've hit upon a bug within the .docx format. All works as expected in .odf Regards Dave Do yourself a favor. If you must have your documents readable in Word, use the ".doc" format instead of that bloated/complex ".docx" format. I really wonder what MS people was thinking about when they created that XML based format. I know a lot of MSO people who do not touch .docx and .xltx formats. They stick with .doc and .xlt since it is able to be used my more MS Office versions. Since I do not use MSO, I stick with ODF formats like .odt and .ods. But try to avoid MSO's "x" file formats. See if you can get all the people you know that use MSO to stop using "x" file formats. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity *** Glenn glenns...@gmail.com -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
Re: [libreoffice-users] Re: Writer: Page Number/Page Count problem.
If the "x format" is the default format in the leading&mainstream office product, you can't escape from it unfortunately. It is useful for me because the documents are smaller in size. I know it's so much pain for the development team but LO should be compatible in every possible way. If someday LO market takes over, LO can set the rules. On 07.03.2011 15:14, webmaster for Kracked Press Productions wrote: On 03/07/2011 05:30 AM, David Griffiths wrote: Arda Tunccekic wrote: I have a document with 3 pages and I have a footer in it and I want to see the pagenumber/pagecount there. I select the footer and I insert the page number and page count like this Insert -> Fields -> Page Number , I type "/" , Insert -> Fields -> Page Number When I do a print preview it looks ok. But when I save the document and open it again I see -1-3 , -2-3 , -3-3 instead. I use the current version : LibreOffice 3.3.1 Build:8 The file extension is docx Hi I can confirm this behaviour. Seems like you've hit upon a bug within the .docx format. All works as expected in .odf Regards Dave Do yourself a favor. If you must have your documents readable in Word, use the ".doc" format instead of that bloated/complex ".docx" format. I really wonder what MS people was thinking about when they created that XML based format. I know a lot of MSO people who do not touch .docx and .xltx formats. They stick with .doc and .xlt since it is able to be used my more MS Office versions. Since I do not use MSO, I stick with ODF formats like .odt and .ods. But try to avoid MSO's "x" file formats. See if you can get all the people you know that use MSO to stop using "x" file formats. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
[libreoffice-users] Writer: Page Number/Page Count problem.
I have a document with 3 pages and I have a footer in it and I want to see the pagenumber/pagecount there. I select the footer and I insert the page number and page count like this Insert -> Fields -> Page Number , I type "/" , Insert -> Fields -> Page Number When I do a print preview it looks ok. But when I save the document and open it again I see -1-3 , -2-3 , -3-3 instead. I use the current version : LibreOffice 3.3.1 Build:8 The file extension is docx -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
Re: [libreoffice-users] row count
So it's the exporting tool I use which is limiting the rows. Thank you. On 04.03.2011 16:04, Scott Jones wrote: LO 3.3.1 can handle 1 million rows On 3/4/2011 8:07 AM, Arda Tunccekic wrote:Hi, Is there a way to have over 65500 rows? -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
[libreoffice-users] row count
Hi, Is there a way to have over 65500 rows? -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
Re: [libreoffice-users] Multi language settings?
I would really like to download 200 more, with the chinese and the zulu language in it than to have problems like that :) On 02.03.2011 22:27, MR ZenWiz wrote: On Wed, Mar 2, 2011 at 7:10 AM, Arda Tunccekic wrote: In Ubuntu Natty Narwhal (11.04) Alpha2, libreoffice comes with the system pre installed. That's cool, it also updates itself with the general system update, but the deb files I download from the official site does not install. Let me try again... #dpkg -i libobasis3.3-tr_3.3.1-19_i386.deb .. Unpacking libobasis3.3-tr .. dpkg: dependency problems prevent configuration of libobasis3.3-tr libobasis3.3-tr depends on libobasis3.3-core01; #dpkg -i libobasis3.3-tr-calc_3.3.1-19_i386.deb Unpacking libobasis3.3-tr-calc dpkg: dependency problems prevent configuration of libobasis3.3-tr-calc ... Package libobasis3.3-tr is not configured yet ... In that case, until the repos for Natty are properly populated, your best bet is to uninstall the pre-installed LO and use the TDF debs to install what you need. I ran into a similar situation in CentOS when I wanted to use a more recent OOo than that with which it shipped, and every time they updated the older OOo, it blew mine away (difference in the generation revision sequencing). I ultimately put an exception in the yum repos files to skip OOo on system updates and all was fine. Haven't needed to do this with Ubuntu yet, but I expect there's a similar setting capability with apt*. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
Re: [libreoffice-users] Multi language settings?
In Ubuntu Natty Narwhal (11.04) Alpha2, libreoffice comes with the system pre installed. That's cool, it also updates itself with the general system update, but the deb files I download from the official site does not install. Let me try again... #dpkg -i libobasis3.3-tr_3.3.1-19_i386.deb .. Unpacking libobasis3.3-tr .. dpkg: dependency problems prevent configuration of libobasis3.3-tr libobasis3.3-tr depends on libobasis3.3-core01; #dpkg -i libobasis3.3-tr-calc_3.3.1-19_i386.deb Unpacking libobasis3.3-tr-calc dpkg: dependency problems prevent configuration of libobasis3.3-tr-calc ... Package libobasis3.3-tr is not configured yet ... On 02.03.2011 17:03, Lorenzo Sutton wrote: Hi, Arda Tunccekic wrote: Thanks. I have tried, but it doesn't work, I can't install any language deb file. I have Ubuntu Natty Alpha2, I have updated it and I have LibreOffice 3 (Build 8) installed. The language packs I download from libreoffice.org site are somehow uncompatible.. I give up. I think it would be better if the release included the language libraries. It would be easier to download 200 mb more than spending time trying to fix like this. In your original message you say you did apt-get install, so I imagine you are installing from some repository or PPA. It seems LibreOffice will be default on Natty but, as it is alpha I wonder what version you installed and if the language packs have made it in the repos. I'm sure they'll all be there by release. Meanwhile, I also use two languages (English and Italian) and I think the best way is to use the debs provided on the website as suggested by webmaster for Kracked Press Productions. Install the US deb and then the language pack(s) of interest. Lorenzo. On 25.02.2011 19:09, webmaster for Kracked Press Productions wrote: On 02/25/2011 07:16 AM, Arda Tunccekic wrote: Hi , I installed LibreOffice on my ubuntu pc with the following command: apt-get install libreoffice Now, under Tools->Options->Language Settings->Languages menu, there is only one Language available. User Interface : Default English (USA) How can I install/choose another language? Thank you. Download and install the language and help packs for those languages. You can go to LibreOffice.org's download page and use the "Other way to download LibreOffice, the productivity suite" option. Click on you .deb type - I use 64-bit Ubuntu so it is Linux x64 (deb) Click on the "Languagepacks" and you will get the full list of the languages you can install. There are 113 localized languages. You can use the "boxed" option above that, but my way you can click on every language in a group - Alt right-click - and not need to go through any more steps that that. Once you download the language packs you want, you will need to install the deb files in order [?] like you would need to do if you used the *sudo dpkg -i *.deb* command[s] for each folder of deb files. When you use Windows version you can choose multi-language that has included for your choice in "custom install" a limited amount of languages that is "felt" to be the more used ones. Or, you can use the Windows all-languages install and have the entire list of languages to choose from, so it is a larger set of files. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
Re: [libreoffice-users] Multi language settings?
Thanks. I have tried, but it doesn't work, I can't install any language deb file. I have Ubuntu Natty Alpha2, I have updated it and I have LibreOffice 3 (Build 8) installed. The language packs I download from libreoffice.org site are somehow uncompatible.. I give up. I think it would be better if the release included the language libraries. It would be easier to download 200 mb more than spending time trying to fix like this. On 25.02.2011 19:09, webmaster for Kracked Press Productions wrote: On 02/25/2011 07:16 AM, Arda Tunccekic wrote: Hi , I installed LibreOffice on my ubuntu pc with the following command: apt-get install libreoffice Now, under Tools->Options->Language Settings->Languages menu, there is only one Language available. User Interface : Default English (USA) How can I install/choose another language? Thank you. Download and install the language and help packs for those languages. You can go to LibreOffice.org's download page and use the "Other way to download LibreOffice, the productivity suite" option. Click on you .deb type - I use 64-bit Ubuntu so it is Linux x64 (deb) Click on the "Languagepacks" and you will get the full list of the languages you can install. There are 113 localized languages. You can use the "boxed" option above that, but my way you can click on every language in a group - Alt right-click - and not need to go through any more steps that that. Once you download the language packs you want, you will need to install the deb files in order [?] like you would need to do if you used the *sudo dpkg -i *.deb* command[s] for each folder of deb files. When you use Windows version you can choose multi-language that has included for your choice in "custom install" a limited amount of languages that is "felt" to be the more used ones. Or, you can use the Windows all-languages install and have the entire list of languages to choose from, so it is a larger set of files. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
[libreoffice-users] Multi language settings?
Hi , I installed LibreOffice on my ubuntu pc with the following command: apt-get install libreoffice Now, under Tools->Options->Language Settings->Languages menu, there is only one Language available. User Interface : Default English (USA) How can I install/choose another language? Thank you. * * -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
Re: [libreoffice-users] Egypt
Sorry for them. I hope people get what they want. And I wish one day every nation have a great goverment. And Tom, I appreciate English people like you because you know what's going on in the world. Maybe it's the English culture, I don't know. You live in uk, don't you? On 28.01.2011 20:58, Tom Davies wrote: Unbelievable news from Egypt! We work hard to help people, organisations, government departments and others communicate and give a new choice to help them do that. Many of us live fairly comfortably in countries that at least pay "lip-service" to the notion of "Freedom of Speech". Many of us see the struggle against proprietary formats and programs as part of pushing at the boundaries of our current freedoms. Try pinging an Egyptian server today and you apparently get no response. From 12:34 am today the Egyptian government switched off the internet into or out of the country. Some but not many satellite communications and some proxy servers are keeping a few things open. Sms is down, twitter is down, facebook is down while outside Egypt we hardly notice any of it. Lets hope more lives are not lost there! Regards to all from Tom -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
[libreoffice-users] Page numbering issues..
I use LO rc3 When I insert a footer and insert something like Page : (pagenumber)/(pagecount) I save it, reopen it. I see Page: -1/-3 there :-/ And I was ( giving section numbers) When I saved the document and re-opened it, I saw shapes instead of numbers. I used Tahoma as the main font. Nothing fancy in the document. I started it writing from scratch. The numbering are in Times New Roman font. What is strange is, 1, 2, 3, 4 was not changed, but 6, 7 & 8 was replaced with some shape-like characters. When you are short on time, things like this become stressing.. I trust in the development team.. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
[libreoffice-users] xml support
Is there a way or extension to open up xml files in LibreOffice? It can open it, but raw text. I received an xml file that can be opened up beautifully in Ms. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
Re: [libreoffice-users] Having trouble installing Libre Office in Ubuntu
Hi Tom, We need more fibers here! I guess the latest release of pardus 2011 is postponed, because it says there are 37 days left on the web page now. When it's out I will also have a look, but for now, it's okay with ubuntu 10.10 :) On 20.01.2011 11:41, Tom Davies wrote: Dohhh, i just spent ages downloading Pardus to give it a try! There didn't seem to be a faster mirror nearer me so i left it downloadign while i was out yday. Good to hear there is a new release extremely imminent. A lot of people are saying good things about it. So, i will d/l again in a couple of days i guess :) Regards from Tom :) ____ From: Arda Tunccekic To: users@libreoffice.org Sent: Thu, 20 January, 2011 1:18:06 Subject: Re: [libreoffice-users] Having trouble installing Libre Office in Ubuntu Yes, this is a great idea to make it accessible from the Software Manager at least, if LO will not be installed by default in the next release of Ubuntu. In Turkey, we have a national distro named as pardus. The pardus development team switched to LO in a very short time after LO's initial announcement. That was good. :) I think the new version, pardus 2011 is going to be released sometime today. Including LO. On 20.01.2011 01:46, baldwin linguas wrote: Or at least installable all pointy-clicky like in Synaptic or something of that sort. I'm sure, since OOo will soon be going the way of Wordperfect, that LO will eventually be a default staple in FOSS land. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity *** -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
Re: [libreoffice-users] Having trouble installing Libre Office in Ubuntu
Yes, this is a great idea to make it accessible from the Software Manager at least, if LO will not be installed by default in the next release of Ubuntu. In Turkey, we have a national distro named as pardus. The pardus development team switched to LO in a very short time after LO's initial announcement. That was good. :) I think the new version, pardus 2011 is going to be released sometime today. Including LO. On 20.01.2011 01:46, baldwin linguas wrote: Or at least installable all pointy-clicky like in Synaptic or something of that sort. I'm sure, since OOo will soon be going the way of Wordperfect, that LO will eventually be a default staple in FOSS land. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
Re: [libreoffice-users] Having trouble installing Libre Office in Ubuntu
My guess is %90 won't bother installing LO, if not installed by default. On 20.01.2011 01:18, MR ZenWiz wrote: On Wed, Jan 19, 2011 at 3:03 PM, Robert Holtzman wrote: On Wed, Jan 19, 2011 at 03:51:05PM -0500, wlb wrote: Will LIbreOffice eventually be available on Ubuntu without having to do all the technical stuff? Technical stuff..like turning on your computer, typing a command, and *gasp* learning something new? Clearly you would be amazed at how many people give up right there -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
Re: [libreoffice-users] How to sort this dataset in Calc?
Ms Excel does it :) On 18.01.2011 13:55, Stefan Weigel wrote: Hi Arda, Am 18.01.2011 12:21, schrieb Arda Tunccekic: I wish it could also be done by clicking on Column A and clicking on the Sort Icon (simpler) No, not simpler, because when you click on column A, how should your Computer know, that you do not want to sort only the values in column A, but move also the corresponding values in column B? Stefan -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
Re: [libreoffice-users] How to sort this dataset in Calc?
Thank you, it works. :) I wish it could also be done by clicking on Column A and clicking on the Sort Icon (simpler) On 18.01.2011 12:30, Stefan Weigel wrote: Hi Arda, Am 18.01.2011 11:08, schrieb Arda Tunccekic: I have a dataset like this. There are empty rows. Is there a way to sort these values by choosing the first column? (1) Select the whole range from "90" on the top left to "g" on the bottom right, including the empty cells. (2) Use the TAB-Key to navigate the active cell within your selection to a position in the first column. (3) Click the Sort-Icon Stefan -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
[libreoffice-users] How to sort this dataset in Calc?
I have a dataset like this. There are empty rows. Is there a way to sort these values by choosing the first column? 90 e 5a 15 d 95 f 12 c 7b 96 g -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
Re: [libreoffice-users] which is better?
I can assure you LibreOffice is better, it has more features and it is better in Ms Office compatibility. But it still needs some bug fixes and still have some problems with Office compatilibity. I think, if the development team works hard for some 6-12 months and takes bug reports seriously, it can be a real alternative for even hardcore Ms Office users. Regards On 17.01.2011 17:06, Edmund Laugasson wrote: Users are quite confused - three opportunities: LibreOffice, Go-OO and OpenOffice.org - which to choose... Which will be included in Ubuntu? I heard, that LibreOffice I use myself Ubuntu already years... -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
Re: [libreoffice-users] Re: Re: Should a reported bugs be mentioned in here?
I will be there :)) On 10.12.2010 19:41, Maurice Batey wrote: > On Fri, 10 Dec 2010 12:19:07 -0400, Clio wrote: > >> What about an issues mailing list > So people could opt in to receiving notices of new bug reports for > a specific compnennt of LO? > Sounds useful! > > I would be interested in new Writer bug reports. > -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://www.libreoffice.org/lists/users/ *** All posts to this list are publicly archived for eternity ***
[libreoffice-users] Problem with Turkish characters
Hi people, Today I installed LibreOffice RC1 to one of the computers in our accounting department. I exported some data from the main accounting program they use, to xls format. When I checked the file, I saw that the Turkish characters are not displayed correctly. I checked the operating system of the computer, it was a Win7 TR, having a Turkish keyboard and regional settings. I copied the file to my XP computer, which I know it has no problems with Turkish character sets, opened it with LibreOffice RC1 and the Turkish characters were not displayed correctly again. I opened the file in OpenOffice 3.2, the result was the same. The menus and the language options are selected as Turkish in LO and OO. In the cell properties I tried with many common fonts like Arial, Times New Roman, with Turkish language option, nothing changes. For ex : BÝYOLOJÝK should be BİYOLOJİK Tarih Aralýðý should be Tarih aralığı When I open the xls file with notepad, just to check the text, I can see the text with Turkish chars correctly. Turkish characters are displayed correctly when I open the file with MS Excel 2003. I didn't try other MS versions, they probably can display properly too. Any suggestions? -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://www.libreoffice.org/lists/users/ *** All posts to this list are publicly archived for eternity ***
Re: [libreoffice-users] Selecting all objects(text-graphics and tables) in a document that has a table at the beginning
Cor, Thank you! Your solution saves my day :) To select all objects and text in a document starting with a table ; 1. Press Alt-Enter for new page (when the cursor is at the start of the table) 2. Press Ctrl-A to Select All 3. Press Ctrl-Ins or Ctrl-C to copy 3. Open up a new text document 4. Press Ctrl-V or Shift-Ins to paste 5. Press Ctrl-Home to go to the begining of the document 6. Press Delete (to delete the unnecessary new page) On 08.12.2010 15:02, Cor Nouws wrote: Alt-Enter when the cursor is at the start of the table, -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://www.libreoffice.org/lists/users/ *** All posts to this list are publicly archived for eternity ***
Re: [libreoffice-users] Selecting all objects(text-graphics and tables) in a document that has a table at the beginning
And this issue is opened in "17 Sep 2002" !? Not fixed for 8 years.. http://www.openoffice.org/issues/show_bug.cgi?id=7747 In our company, we have many documents written over time in Ms Word, which include a "header like" part about company information at the top and they are placed in a table. So we have many existing documents starting with a table. Any ideas? On 08.12.2010 14:17, Arda Tunccekic wrote: Is it "Issue 7747" ? So it's a bug and there is no solution yet? :( On 08.12.2010 13:11, Cor Nouws wrote: Hi Arda, Arda Tunccekic wrote (08-12-10 11:56) Hello folks, it's me again :-) I have a .doc file, starting with a table. I can't do Select All? Whereever I click and Ctrl-A (or select all from the menu) , it selects only a part of the document. Is there a way to do it? There is an OpenOffice.org issue for this. Can you try to find it yourself? Thanks, Cor -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://www.libreoffice.org/lists/users/ *** All posts to this list are publicly archived for eternity ***
Re: [libreoffice-users] Selecting all objects(text-graphics and tables) in a document that has a table at the beginning
Is it "Issue 7747" ? So it's a bug and there is no solution yet? :( On 08.12.2010 13:11, Cor Nouws wrote: Hi Arda, Arda Tunccekic wrote (08-12-10 11:56) Hello folks, it's me again :-) I have a .doc file, starting with a table. I can't do Select All? Whereever I click and Ctrl-A (or select all from the menu) , it selects only a part of the document. Is there a way to do it? There is an OpenOffice.org issue for this. Can you try to find it yourself? Thanks, Cor -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://www.libreoffice.org/lists/users/ *** All posts to this list are publicly archived for eternity ***
[libreoffice-users] Selecting all objects(text-graphics and tables) in a document that has a table at the beginning
Hello folks, it's me again :-) I have a .doc file, starting with a table. I can't do Select All? Whereever I click and Ctrl-A (or select all from the menu) , it selects only a part of the document. Is there a way to do it? Thank you -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://www.libreoffice.org/lists/users/ *** All posts to this list are publicly archived for eternity ***
Re: [libreoffice-users] Re: Converting text to numbers
Yes, that's a solution, thank you Sndl :-) In this case, the values are; -- A1(text) : "1.2 " A2(text) : "2.5 " B1(number) : =SUM(A1:A2) (it shows 0 now, it can't calculate..) -- The operation is (as Sndl described) -- 1. Choose Column A 2. Chose Data-> Text to Columns from the top menu In the wizard form; 3. Select the Column 4. Select "US English" from the Column type Combo 5. Click OK -- B1 now shows the sum of the values (3.7 in this case) Data type of A1 and A2 are still text, but that's not important for me when the functions are working :) On 07.12.2010 16:04, Sndl wrote: Le 07/12/2010 09:31, Arda Tunccekic a écrit : Hi , I have an auto generated xls file, and I have a column in it, which is defined as text. I have numbers in that column, with trailing spaces which look like ; "1.2 " "12.9 " "3.4 " When I right click to the column, choose "Format Cells" and "Number", it doesn't convert. I can't use the values in any formula. How can I convert them to numbers? Is there a "quick convert" feature? Excel can use those values in formulas, even if I don't convert and with trailing spaces.. Thank you Imho the easiest way to convert text to numbers or numbers to text is to use Data -> Text to Columns. You select you column (click the column header) In menu Data -> Text to Columns At the bottom of the wizard window, you select your column and change type to "Us English" And that's all folks ! Usually, this function is used to split one column to many ... but with only one colum it's really useful to make "inplace" type conversion -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://www.libreoffice.org/lists/users/ *** All posts to this list are publicly archived for eternity ***
Re: [libreoffice-users] Converting text to numbers
Yes, I'm sorry, there is one more step in MS Excel. Select A1, A2 and A3 and use the small box next to them (Convert to number tool) Then the sum of the values give the real value. It's easier in Ms Excel (That's why they wrote that small conversion toolbox, appearing next to the cell) On 07.12.2010 15:22, Stefano Fraccaro wrote: Il 07/12/2010 14.10, Arda Tunccekic ha scritto: But this is can be a hard step for regular users. And again, they say me "ms excel does it, what is this now" :) This is not right... not in all cases. My test with Excel 2000: * Column A -> Cell format = Text * A1 = "1,25" * A2 = "3,46" * A3 = "0,3 " * B1=SUM(A1:A3) the result in cell B1 is 0 (zero) not the expected sum. Maybe Office XP and later version works better... -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://www.libreoffice.org/lists/users/ *** All posts to this list are publicly archived for eternity ***
Re: [libreoffice-users] Converting text to numbers
Hi Gérard, My example is with spaces.. They are numbers like "3.51" Using Find&Replace, with regular expressions checked , searching for *[:space:]?$* , replacing with nothing removes spaces. But this is can be a hard step for regular users. And again, they say me "ms excel does it, what is this now" :) On 07.12.2010 15:05, Gérard Fargeot wrote: Arda Tunccekic wrote (07-12-10 13:27) - Now type "1.22 " , "2.4 ", "3.51 " in the first 3 rows. With or whithout the " ? Using Find & Replace, Regular expression checked Without the " Search : .* Replace : & With the " Search : "(.*)" Replace : $1 Gérard -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://www.libreoffice.org/lists/users/ *** All posts to this list are publicly archived for eternity ***
Re: [libreoffice-users] Converting text to numbers
Hi Cor, I think it did not work. You can try it yourself. - Open up a new spreadsheet. Choose Column A, right click on it and click on Format Cells. Make them Text. - Now type "1.22" , "2.4 ", "3.51 " in the first 3 rows. - Go to Column B, select the first cell, click on the sum function symbol and choose the values on column A. It doesn't calculate.. Nothing changes when I use the "Convert text to number" extension. Maybe the extension can first trim the trailing spaces, and then change the cell formatting to number, if it can be done.. Thank you On 07.12.2010 13:18, Cor Nouws wrote: Hi Arda, Arda Tunccekic wrote (07-12-10 09:31) I have an auto generated xls file, and I have a column in it, which is defined as text. I have numbers in that column, with trailing spaces which look like ; "1.2 " "12.9 " "3.4 " When I right click to the column, choose "Format Cells" and "Number", it doesn't convert. I can't use the values in any formula. How can I convert them to numbers? Is there a "quick convert" feature? The extension CT2N does help in many cases. You may want to try it: http://extensions.services.openoffice.org/project/CT2N (And if it does not work, pls let me know. Sometimes I make some changes, thus your situation might be covered by a future version.) Regards, Cor -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://www.libreoffice.org/lists/users/ *** All posts to this list are publicly archived for eternity ***
[libreoffice-users] Converting text to numbers
Hi , I have an auto generated xls file, and I have a column in it, which is defined as text. I have numbers in that column, with trailing spaces which look like ; "1.2 " "12.9 " "3.4 " When I right click to the column, choose "Format Cells" and "Number", it doesn't convert. I can't use the values in any formula. How can I convert them to numbers? Is there a "quick convert" feature? Excel can use those values in formulas, even if I don't convert and with trailing spaces.. Thank you -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://www.libreoffice.org/lists/users/ *** All posts to this list are publicly archived for eternity ***
[libreoffice-users] Converting text to numbers
Hi , I have an auto generated xls file, and I have a column in it, which is defined as text. I have numbers in that column, with trailing spaces which look like ; "1.2 " "12.9 " "3.4 " When I right click to the column, choose "Format Cells" and "Number", it doesn't convert. I can't use the values in any formula. How can I convert them to numbers? Is there a "quick convert" feature? Excel can use those values in formulas, even if I don't convert and with trailing spaces.. Thank you -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://www.libreoffice.org/lists/users/ *** All posts to this list are publicly archived for eternity ***
Re: [libreoffice-users] Re: Survey: Usage of LibreOffice components
Maybe Quickstarter was usefull with the slow loading StarOffice suite, but OO and LO already load up pretty quick. And no one uses it here as I see. I don't use it too. I think it would be switched off by default or removed.. On 30.11.2010 09:51, Rolf Gloor wrote: It would be OK, if you would say, that you don't like it and would prefer to have it switched off by default. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://www.libreoffice.org/lists/users/ *** All posts to this list are publicly archived for eternity ***
Re: [libreoffice-users] Re: I need more filters
:) Thank you On 11.11.2010 14:44, Gérard Fargeot wrote: Arda Tunccekic wrote: Yes if I understand what you mean, that could be a solution, copying the column to an other, and adding more filters to that column, but it would be a 'workaround', not a proper way doing the job :) I have some test codes in that colum, and I want to make a filter showing 15 or 20 test codes. For example, can I add a filter like Column B containing (4,20,50,66, 121,240, 255, 522,523,524,525,526,768,1000,1001,1002,1003,1004,1005) ? Data> Filter> Standard Filter Clic on more options and check Regular expressions use following criteria : Column B contains 4|20|50|60...etc (pipe character means OR) Gérard -- E-mail to users+h...@libreoffice.org for instructions on how to unsubscribe List archives are available at http://www.libreoffice.org/lists/users/ All messages you send to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] I need more filters
Yes if I understand what you mean, that could be a solution, copying the column to an other, and adding more filters to that column, but it would be a 'workaround', not a proper way doing the job :) I have some test codes in that colum, and I want to make a filter showing 15 or 20 test codes. For example, can I add a filter like Column B containing (4,20,50,66, 121,240, 255, 522,523,524,525,526,768,1000,1001,1002,1003,1004,1005) ? On 11.11.2010 13:32, Phil Hibbs wrote: Could you add a new column with a formula that tests the various conditions? -- E-mail to users+h...@libreoffice.org for instructions on how to unsubscribe List archives are available at http://www.libreoffice.org/lists/users/ All messages you send to this list will be publicly archived and cannot be deleted
[libreoffice-users] I need more filters
Hi people, in this current beta release there are 8 filters in the 'Standard filters' menu. I need about 10 different conditions on a single column. It there a setting to increase this 8 conditions, or is there place to submit any feature requests? Thank you -- E-mail to users+h...@libreoffice.org for instructions on how to unsubscribe List archives are available at http://www.libreoffice.org/lists/users/ All messages you send to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] LibreOffice Support
Hi Andy, welcome and thank you, that's great. On 10.11.2010 22:25, Andy Rogers wrote: Dear LibreOffice Users Mailing List Im newish to the mailing list for LibreOffice, but I would like to offer some help with LibreOffice in some shape or form going forward (but not programming at the moment). Basically I have been using Linux (mainly ubuntu) for the past 2+ Years and have been looking at trying to get involved in a project to give something back to the Linux community moving forward. I have a very good inside advance of computers in general, and use them day in and day out and this is my number 1 passion in life, and also Linux as my main operating system. I mainly come from an administration background in work, but am moving more and more to my preferred role as IT becomes more utilised in my work place. OpenOffice is what I use day in& day out out work& home and am very willing to help move this new project forward for the future. If you could suggest some areas which I can assist in longterm, or suggestions, or have any questions or need any more information please email me. Im not to sure of how best to start the LibreOffice community but am open for direction to the correct people etc. Thanks Andy On 10 November 2010 20:03, wrote: Welcome! You have been subscribed to the users@libreoffice.org mailinglist. To unsubscribe send a message to: users+unsubscr...@libreoffice.org And for help send a message to: users+h...@libreoffice.org -- E-mail to users+h...@libreoffice.org for instructions on how to unsubscribe List archives are available at http://www.libreoffice.org/lists/users/ All messages you send to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: MS Office -> LibreOffice (compatibility problem)
Thank you guys. On 03.11.2010 17:01, Stefano Fraccaro wrote: Filed as bug https://bugs.freedesktop.org/show_bug.cgi?id=31357 Il 03/11/2010 15.49, Marc Paré ha scritto: It looks like Stefano has identified it as a bug with LibreOffice. You can read his notes. Someone will submit it and hopefully it will be fixed for the final version. Marc -- E-mail to users+h...@libreoffice.org for instructions on how to unsubscribe List archives are available at http://www.libreoffice.org/lists/users/ All messages you send to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] MS Office -> LibreOffice (compatibility problem)
Yes, you are right Michel, we have a few 2007 licenses, I'm planning to keep them installed for compatibility issues. But then, there are some other non-techical problems like : "He has Ms Office installed, I want it too" :)) We can use the .doc extension for this specific problem, but what if a document like this comes from external sources. Some of our users are already unhappy and unwilling to use LibreOffice and I they can complain about problems like this. I hope there will be a solution for opening this docx file properly within LibreOffice On 03.11.2010 14:52, Michel Gagnon wrote: Le 2010-11-03 05:07, Arda Tunccekic a écrit : Actually we are doing this conversion one by one and after installing LibreOffice we are showing the user the most common tasks and they can use it. Now LibreOffice is installed on 20 computers and there is only this compatibility issue we are facing. And I don't know any proffesional local support for LibreOffice around. If the document is created with .doc extension, LibreOffice can open it up properly. If the document is created with .docx extension, you cannot see the graphic. Any ideas? With 200 computers, you could look for a mixed environment, where a few computers would keep Microsoft Office for compatibility issues. As for your specific problem, I would suggest you use MsOffice and first export the document as as .doc; then import it in LibreOffice. I have tried to do so with Ms Office 2003 and its 2007 import filters and it works. As long term solutions, if you keep a few computers with MsOffice, I would suggest you check the option requiring the ".doc" format for default. -- E-mail to users+h...@libreoffice.org for instructions on how to unsubscribe List archives are available at http://www.libreoffice.org/lists/users/ All messages you send to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: MS Office -> LibreOffice (compatibility problem)
Hi Mark, These are the files, thank you. Maybe feedbacks like this are valuable for LibreOffice? http://www.duzen.com.tr/doc/i1.doc http://www.duzen.com.tr/doc/i1.docx I've tried to open the docx file with OpenOffice, it's the same. On 03.11.2010 11:26, Marc Paré wrote: Le 2010-11-03 05:07, Arda Tunccekic a écrit : Actually we are doing this conversion one by one and after installing LibreOffice we are showing the user the most common tasks and they can use it. Now LibreOffice is installed on 20 computers and there is only this compatibility issue we are facing. And I don't know any proffesional local support for LibreOffice around. If the document is created with .doc extension, LibreOffice can open it up properly. If the document is created with .docx extension, you cannot see the graphic. Any ideas? Could you please put the document for us to download? Maybe we can help if it is a small problem. Marc -- E-mail to users+h...@libreoffice.org for instructions on how to unsubscribe List archives are available at http://www.libreoffice.org/lists/users/ All messages you send to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] MS Office -> LibreOffice (compatibility problem)
Actually we are doing this conversion one by one and after installing LibreOffice we are showing the user the most common tasks and they can use it. Now LibreOffice is installed on 20 computers and there is only this compatibility issue we are facing. And I don't know any proffesional local support for LibreOffice around. If the document is created with .doc extension, LibreOffice can open it up properly. If the document is created with .docx extension, you cannot see the graphic. Any ideas? On 03.11.2010 10:32, Cor Nouws wrote: Hi Arda, Arda Tunccekic wrote (03-11-10 09:11) Is this the place to get support for LibreOffice? I work in a company that have more than 200 computers and I am trying to migrate from MS Office to LibreOffice + Thunderbird. [...] Migration in a professional environment. 200 seats ... I would simply find local professional support. Regards, Cor -- E-mail to users+h...@libreoffice.org for instructions on how to unsubscribe List archives are available at http://www.libreoffice.org/lists/users/ All messages you send to this list will be publicly archived and cannot be deleted
[libreoffice-users] MS Office -> LibreOffice (compatibility problem)
Hi people. Is this the place to get support for LibreOffice? I work in a company that have more than 200 computers and I am trying to migrate from MS Office to LibreOffice + Thunderbird. Uninstalling MS Office and installing LibreOffice is fun but sometimes there are problems that I can't find a solution (yet). I have a document (.docx) that cannot be displayed properly with LibreOffice and because of this MS Office fans in my company say that we need MS Office, we cannot do business without MS Office.. I've installed odf-converter-integrator-0.2.3, but still I can't see the graphic inside. Where can I get support for this? Thank you -- E-mail to users+h...@libreoffice.org for instructions on how to unsubscribe List archives are available at http://www.libreoffice.org/lists/users/ All messages you send to this list will be publicly archived and cannot be deleted
