[libreoffice-users] Re: How do add percentage in Calc?
Thank you, all. -- View this message in context: http://nabble.documentfoundation.org/How-do-add-percentage-in-Calc-tp3794847p3795979.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] Get older Libreoffice version 3.3.4.1?
I need to get Lo version 3.3.4.1 (pretty sure that's the number...either than 3.3.4) I can't find it anywhere on the web. Accidentally, I think, my machine installed 3.5 which has (at least for me) the dreaded slow insert row in Calc problem. Does anyone have a link to 3.3 or so? -- View this message in context: http://nabble.documentfoundation.org/Get-older-Libreoffice-version-3-3-4-1-tp3797007p3797007.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: Python uno object comparison change in 3.5
Andreas Säger ville...@t-online.de writes: Hi, Your 3rd line is supposed to be: TABALIGN_LEFT = uno.Enum(com.sun.star.style.TabAlign, LEFT) Crud, I don't how how I missed that, sorry - it's a cut 'n paste error when posting. The test script didn't have that typo, but had other enumerations defined that I removed when posting. I definitely agree the code runs on the older versions of OO and LibO. That's sort of the point since it only started failing with 3.5 (I've been using the original script I first noticed this in for several years). I couldn't use 3.5.0 due to the uno loading error (the same exception you got), so first hit it with 3.5.1RC1. (Ironically, I suppose, I only got on board with 3.5.1 during the RC phase specifically to ensure the uno loading fix was working in my environment since the suggested workaround of removing some of the shared libraries didn't work.) Here's a simpler (interactive) example: /opt/libreoffice3.5/program/python Python 2.6.1 (r261:67515, Feb 24 2012, 08:33:41) [GCC 4.2.4] on linux2 Type help, copyright, credits or license for more information. import uno from com.sun.star.style import TabStop a = TabStop() b = TabStop() a==b False Since my original post, I have gotten a local build environment for LibO, and the issue appears to be in the use of the new rich comparison slot rather than the standard cmp slot 3.4.x was using. I'm not sure exactly where the error is yet, but returning to the 3.4.5 PyUno_cmp function and use of the older cmp slot works even with 3.5.1RC1. I've gone and and created a bug (46926) since I think this is a regression from 3.4.5. It seems to be an unintended consequence of an earlier Python 3 changeset (as does another issue I found in the uno.py wrapper which I added as bug 46926, though that's easier to work around as it's up in python code). At least when used with the internally delivered 2.6.1 interpreter. -- David -- 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] Get older Libreoffice version 3.3.4.1?
Hi, On Sun, Mar 4, 2012 at 12:47 AM, PDA1 wrote: I need to get Lo version 3.3.4.1 (pretty sure that's the number...either than 3.3.4) I can't find it anywhere on the web. Accidentally, I think, my machine installed 3.5 which has (at least for me) the dreaded slow insert row in Calc problem. Does anyone have a link to 3.3 or so? The Document Foundation Mirrors → http://download.documentfoundation.org/libreoffice/old/ mjk -- Wake Up Sheeple http://xkcd.com/1013/ -- 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: Help with date formatting
Am 03.03.2012 20:00, Duncan Murdoch wrote: - I want to be able to cut and paste lines from a web page into the file, to make small updates. This is why I'm using Calc for editing. OO lets me paste data and it gets treated as I want. Hopefully with your suggestions for configuring LO, it'll do the same. Collect the pasted HTML data on a sheet template if Calc handles the data the way you want. You can use a template sheet with the right locale and format settings in the right order of columns. Just paste the HTML as unformatted text which will preserve the formatting of the target cells rather than the HTML formatting of the source. Instead of saving the sheet as csv you may also paste the used cells into a text editor before saving which produces tab separated text with the numberic strings as displayed on the sheet. If some other software is supposed to read your data, English decimals with digits and one point only are the universally understood output formats for dcimal numbers, dates as ISO dates, percents as decimal fractions: Raw ISO data like this ... 23123.982009-08-30 13:45:59 0.23 are more universal than localized format strings: EUR 23'123,98 8 Aug 2009 1:45:59 pm 23,00% Including thousands separators, currencies, units or localized dates is counter productive when the importing software is interested in plain numbers or date values. All databases import English numerals and ISO dates without problems. -- 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] How to use GTK open dialog box in LibreOffice
On 04/03/2012 at 07:14, Arnaud Champollion arnaud.champoll...@laposte.net wrote: Le 03/03/2012 11:00, Mirosław Zalewski a écrit : I think that there are two problems: 1. LO can't recognize MATE as GTK-based environment. 2. Variable name suggest it's OpenOffice related, while it's for LibreOffice (and OpenOffice by the way). Maybe this way it is fine, maybe it should change. Should I add this to my bug report on the developper mailing list ? (Maybe you've seen it if you're suscriber of it) I am not subscribed to developers mailing list; if I were, I wouldn't ask you if you can report it there ;) . As of first problem, I think that this is simply bug and it can be added to bugzilla (see https://www.libreoffice.org/get-help/bug/ ). As for second, I think that developers should discuss it first, since this may or may not be considered bug. -- Best regards Mirosław Zalewski -- 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: Help with date formatting
On 12-03-04 6:00 AM, Andreas Säger wrote: Am 03.03.2012 20:00, Duncan Murdoch wrote: - I want to be able to cut and paste lines from a web page into the file, to make small updates. This is why I'm using Calc for editing. OO lets me paste data and it gets treated as I want. Hopefully with your suggestions for configuring LO, it'll do the same. Collect the pasted HTML data on a sheet template if Calc handles the data the way you want. You can use a template sheet with the right locale and format settings in the right order of columns. Just paste the HTML as unformatted text which will preserve the formatting of the target cells rather than the HTML formatting of the source. Instead of saving the sheet as csv you may also paste the used cells into a text editor before saving which produces tab separated text with the numberic strings as displayed on the sheet. If some other software is supposed to read your data, English decimals with digits and one point only are the universally understood output formats for dcimal numbers, dates as ISO dates, percents as decimal fractions: That all sounds much more complicated than the current workflow, which is: Load the .CSV file into OO Calc. Open the web page. Highlight and copy some lines from a table on the web page. Insert some lines to make space, and paste the lines into OO Calc. Save the .CSV file. The date format on the web page isn't ISO or the DD/MM/YY format the CSV file was using, it's like this: 02-Mar-12 but in OO it was recognized as a date and converted when the CSV file was written. I have control over the other software that needs to read the CSV file (it's an R program), but I don't have control over the formatting of the web page. I suppose I have control over the workflow, but I like the simple flow above. Raw ISO data like this ... 23123.982009-08-30 13:45:59 0.23 are more universal than localized format strings: EUR 23'123,98 8 Aug 2009 1:45:59 pm 23,00% Including thousands separators, currencies, units or localized dates is counter productive when the importing software is interested in plain numbers or date values. All databases import English numerals and ISO dates without problems. Yes, I would not have any problems if the CSV file used ISO dates. The problems arise earlier, when LO Calc isn't recognizing that the strings are dates. Duncan Murdoch -- 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] Base Faq
Hi :) Markers has almost completed the Base Faq at https://wiki.documentfoundation.org/Faq#Base The Report Builder section still needs to be translated from the original French. Has anyone found any inaccuracies so far? Regards from Tom :) -- 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: Base faq
On Sun, 2012-03-04 at 13:27 +, Tom Davies wrote: Hi :) Markers has almost completed the Base Faq at https://wiki.documentfoundation.org/Faq#Base The Report Builder section still needs to be translated from the original French. Has anyone found any inaccuracies so far? Regards from Tom :) Scanning the entries: this is perhaps more thorough than most FAQ's I've seen. Surprising! I made one change: create mode to Edit mode in one discussing modifying a form. How can I add a subform to a form?: inaccuracy about how to use design mode to do this. Toolbars are only available for use when the form is in Edit mode. (Click the form and then Edit Edit; or, right click the form and select Edit.) There are other inaccuracies as well. Perhaps, a good editing of them followed by proofing them like our documents get? --Dan -- 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] Table Format
On Sat, 2012-03-03 at 21:53 -0500, Sylvain Bromberber wrote: I once opened the table in one of my data bases and it popped up in a format I have not been able to duplicate. The upper half of the screen was the table in the form of a spread sheet but the lower half had the items of each row in a little table with the items under each other. I have been unable to duplicate this format, which I really liked. Any suggestions? With any form open hit the F4 key...that should do it //drew Sylvain -- 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] Base faq
I can take no credit for the completeness, it's just my (poor) best at translating the French FAQ. There were a couple of things that I changed/added/removed but mostly I just translated. Perhaps there could be something crediting the French team? The two pages about HSQLDB have a different link structure than (all?) the rest of it. They go FAQBaseArticle rather than FAQArticle, which causes a problem because there's no way back to the FAQ from the Base page, but I don't know what or how to do about that. Any suggestions/information? D'you think if I avoid the issue long enough Alex will translate the monster Report Builder tutorial? ;-) Regards Mark Stanton One small step for mankind... -- 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] Base faq
On Sun, 2012-03-04 at 18:45 +, Mark Stanton wrote: I can take no credit for the completeness, it's just my (poor) best at translating the French FAQ. There were a couple of things that I changed/added/removed but mostly I just translated. Perhaps there could be something crediting the French team? The two pages about HSQLDB have a different link structure than (all?) the rest of it. They go FAQBaseArticle rather than FAQArticle, which causes a problem because there's no way back to the FAQ from the Base page, but I don't know what or how to do about that. Any suggestions/information? D'you think if I avoid the issue long enough Alex will translate the monster Report Builder tutorial? ;-) Regards Hi Mark Very good - have added a new question and page to the FQA https://wiki.documentfoundation.org/Faq/Base/HSQLFunctions //drew -- 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] Spellcheck question
The spell check feature seems to stop at every word. Even simple words such as ball, hit, the, etc. and suggests changes. How can I set it so that it only stops at miss spelled words. Thanks for your help. Ed Matheson -- 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] Table Format
Thank you, but I meant my computer screen, not a screen on which the table was projected. Sylvain -Original Message- From: drew jensen Sent: Sunday, March 04, 2012 1:12 PM To: users@global.libreoffice.org Subject: Re: [libreoffice-users] Table Format On Sat, 2012-03-03 at 21:53 -0500, Sylvain Bromberber wrote: I once opened the table in one of my data bases and it popped up in a format I have not been able to duplicate. The upper half of the screen was the table in the form of a spread sheet but the lower half had the items of each row in a little table with the items under each other. I have been unable to duplicate this format, which I really liked. Any suggestions? With any form open hit the F4 key...that should do it //drew Sylvain -- 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] Table Format
On Sun, 2012-03-04 at 15:18 -0500, Sylvain Bromberber wrote: Thank you, but I meant my computer screen, not a screen on which the table was projected. Howdy Sylvain Right and that is what I was speaking to - albeit, too briefly I suppose. By-default, with a writer document window the F4 key will open the data source window, docked, in the top of the document window frame. This is often referred to as the 'beamer'...a name for whatever reason I just always liked.. OK - if you have a form definition within an ODB file, when that window is open (this is just a special case of a writer document window) and you hit F4 the beamer is displayed - however, as this is now attached to a Base embedded form it behaves differently. The record set linked to from the CURRENTLY FOCUSED DATA CONTROL on the form is displayed in a grid view in the beamer. (important to remember the bit about the focused control, the forum can have multiple record sets open at a time) This is just another live view to the record set, if you can update this record set in the form you can do so in the beamer. If you use filters to limit the result set in the beamer it also limits the records in the form detail control. I assumed that was what you where talking about. Best wishes, //drew -Original Message- From: drew jensen Sent: Sunday, March 04, 2012 1:12 PM To: users@global.libreoffice.org Subject: Re: [libreoffice-users] Table Format On Sat, 2012-03-03 at 21:53 -0500, Sylvain Bromberber wrote: I once opened the table in one of my data bases and it popped up in a format I have not been able to duplicate. The upper half of the screen was the table in the form of a spread sheet but the lower half had the items of each row in a little table with the items under each other. I have been unable to duplicate this format, which I really liked. Any suggestions? With any form open hit the F4 key...that should do it //drew Sylvain -- 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] Re: Base faq
Le 04/03/12 15:56, Dan Lewis a écrit : Hi all, Has anyone found any inaccuracies so far? Regards from Tom :) Well I know for sure that some of the FAQ entries I translated possibly don't have the correct term taken from the menu as (a) I wasn't working with LO at the time, and (b) my version of LO is currently in French. Scanning the entries: this is perhaps more thorough than most FAQ's I've seen. Surprising! I made one change: create mode to Edit mode in one discussing modifying a form. How can I add a subform to a form?: inaccuracy about how to use design mode to do this. Toolbars are only available for use when the form is in Edit mode. (Click the form and then Edit Edit; or, right click the form and select Edit.) There are other inaccuracies as well. Perhaps, a good editing of them followed by proofing them like our documents get? That could well have been me (I don't remember now which ones exactly I did, just looked at the list, clicked, if it led nowhere, then copied over the French text and translated it. So proofreading would probably be a good idea. 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: Python uno object comparison change in 3.5
Le 04/03/12 06:09, Andrew Douglas Pitonyak a écrit : Hi Andrew, Is there a dev list for questions of this sort? I have frequently seen polite responses that the dev list is for people doing development on LO. Probably moot since Andreas seems to have pointed out a bug in the script itself. No unfortunately there is no non-core code developer list as such (or at least none that I know of). Developing using the scripting framework, or using UNO, or the UDK for example, in contrast to the old OOo lists, does not appear to have a counterpart within the LO project. If problems with coding apps for LO is a result of a bug, then I would say it is always worthwhile posting them on the dev list anyway. 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: Presentation conversion to/from Powerpoint - layout
On Sat, 3 Mar 2012, Andreas Säger wrote: Am 02.03.2012 19:25, Dag Wieers wrote: I didn't reply to your post in this thread. I was replying to e-letter's post. Maybe you got lost and assumed I was replying to your post, I don't know. I wonder who got lost in this thread actually. This is the only answer to e-letter: There is nothing sensible in spelling Microsoft as 'm$', being condescending to users and force your opinions on others. It is not followed by any other posting. Yet, the link you carefully removed from my mail was *your* answer to my mail to e-letter's mail: http://www.mail-archive.com/users@global.libreoffice.org/msg17560.html So we are not discussing whatever mail you initially send to Roger, we are discussing the tone and content of e-letter's mail and how the LibreOffice project is representing itself to users. And e-letter is doing it again, Roger is offering to report a bug and is discouraged from the very start. Way to go ! -- -- dag wieers, d...@wieers.com, http://dag.wieers.com/ -- dagit linux solutions, i...@dagit.net, http://dagit.net/ [Any errors in spelling, tact or fact are transmission errors] -- 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: Presentation conversion to/from Powerpoint - layout
On Sat, 3 Mar 2012, e-letter wrote: On 02/03/2012, Roger Sawkins ro...@sawkins.name wrote: Well, having had your little spat I see we have got back to suggestions as to what I might do about my problem. What you choose to call a spat reveals your ignorance of the historical context of gnu/linux and consequent inability to comprehend the connection with your problem. Bear in mind I am new to this game. There is a suggestion of reporting a bug. I realise there is a link for that, but what is the best way? Should There is no shame in being new: everyone starts ignorant; it is now up to you to acquire the necessary knowledge to understand the fallacy of your problem. I include a sample of a Ppt conversion (and vice versa) with examples of the problems, or just list them. The former, not via a mailing list! Your original post does not explain nor justify why LO should be used to create m$ formats. As indicated by previous reply, if consistent conversion is so important to you and similar m$ fans, have you contacted m$ and asked an equivalent question: I want to be able to edit and save odf presentations ((f)odp) in m$o and LO, but formatting is lost. Please improve m$o. By the way, how do I submit a bug report to m$ -- 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 Please read the part of the Posting guidelines as is appended to every post: TDF/LibreOffice Mailing List Netiquette http://wiki.documentfoundation.org/Netiquette#Avoid_Advocacy It states: Avoid Advocacy TDF and LibreOffice mailing lists are for constructive discussions about TDF as a project, and LibreOffice as a personal productivity software. TDF as a community was born out of a positive attitude with regards to the future of free software and free office suites, and therefore we expect the subject and the tone of discussions to be in line with this positive attitude. TDF does not like negative attitudes in general, even when targeted to companies advocating proprietary software (e.g. about Microsoft being the root of all evil). So while I hate to have to bring up rules, in this case I want to make clear to Roger and other subscribers e-letter is not representing the LibreOffice project. -- -- dag wieers, d...@wieers.com, http://dag.wieers.com/ -- dagit linux solutions, i...@dagit.net, http://dagit.net/ [Any errors in spelling, tact or fact are transmission errors] -- 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: Presentation conversion to/from Powerpoint - layout
Am 04.03.2012 21:59, Dag Wieers wrote: Yet, the link you carefully removed from my mail was *your* answer to my mail to e-letter's mail: http://www.mail-archive.com/users@global.libreoffice.org/msg17560.html So we are not discussing whatever mail you initially send to Roger, we are discussing the tone and content of e-letter's mail and how the LibreOffice project is representing itself to users. And e-letter is doing it again, Roger is offering to report a bug and is discouraged from the very start. Way to go ! I can't see anything wrong with e-letters statements. If you don't like his style ignore him. -- 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: Table Format
Am 04.03.2012 19:12, drew jensen wrote: On Sat, 2012-03-03 at 21:53 -0500, Sylvain Bromberber wrote: I once opened the table in one of my data bases and it popped up in a format I have not been able to duplicate. The upper half of the screen was the table in the form of a spread sheet but the lower half had the items of each row in a little table with the items under each other. I have been unable to duplicate this format, which I really liked. Any suggestions? With any form open hit the F4 key...that should do it //drew Sylvain If Sylvain wants the additional grid view, that is accessible from the last button on the navigation tool bar or using a hyperlink button with URL .uno:ViewFormAsGrid. -- 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: Presentation conversion to/from Powerpoint - layout
On Fri, 2 Mar 2012, Roger Sawkins wrote: Well, having had your little spat I see we have got back to suggestions as to what I might do about my problem. Bear in mind I am new to this game. There is a suggestion of reporting a bug. I realise there is a link for that, but what is the best way? Should I include a sample of a Ppt conversion (and vice versa) with examples of the problems, or just list them. Including simple sample files would certainly be useful. Also a description of the various steps, as well as software versions and system environment (that can affect the issue, like the fonts installed etc...) Bugs that are attractive (i.e. are well-documented and look easy to verify without the need to have more interaction) tend to get more support than vague claims or complicated descriptions that require more work by bug triage people or developers. Make sure that what you contribute will be public and cannot contain content that is copyrighted or illegal to share. Incidentally, there has been some comment about the 'different fonts on different machines'. I am using Times New Roman (plain and bold) and as far as I know that is available on any Windows machine, so presumably that is not causing the problem. Even when the fonts appear to be installed on the system, software bugs in the filters might be causing such issues. I don't expect them to, but bugs tend to be unexpected... -- -- dag wieers, d...@wieers.com, http://dag.wieers.com/ -- dagit linux solutions, i...@dagit.net, http://dagit.net/ [Any errors in spelling, tact or fact are transmission errors] -- 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] Calc DATEVALUE() accepts only locale format
With the dutch localization DATEVALUE accepts 1-jan-2011 and 1-mrt-2011 (correct dutch format) but not 1-mar-2011 (english US) regardless if I set the standard language for the document to English US or not. Only if I set the 'locale setting' to US does it accept 1-mar-2011. I am trying make sense of some weird data format (2011MAR) which is English based. To me that seems a common situation, and I would not want to change the LO global localization settings as that changes all date formats in the spreadsheet to english. Couldn't datavalue take the locale of the formatted cell? Or is there a better trick to ge this done? The same probably holds for other localized conversions as well. Ferry -- 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: Calc DATEVALUE() accepts only locale format
Am 04.03.2012 22:35, Ferry Toth wrote: Couldn't datavalue take the locale of the formatted cell? Or is there a better trick to ge this done? The same probably holds for other localized conversions as well. Ferry Convert the text to number using the appropriate formulas and locale. CopyPaste-Special the resulting numbers without formulas. Format the numbers any way you like. -- 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] Spell check problem
Brian Thanks for the reply. I used OpenOffice for several years but for the past several days it crashed every few seconds. As a result I loaded Libreoffice. I opened one of my OpenOffice docs in Libreoffice and almost every word is underlined. When I look at the status bar it says English (USA). When I go to tools | Options | Language Settings | Language it is also set as English (USA). I had no problems with this doc in OpenOffice and my understanding is that both applications use the same spell check system. I am missing something. Any suggestions would be appreciated. Ed -- 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] Calc DATEVALUE() accepts only locale format
At 22:35 04/03/2012 +0100, Ferry Toth wrote: With the dutch localization DATEVALUE accepts 1-jan-2011 and 1-mrt-2011 (correct dutch format) but not 1-mar-2011 (english US) regardless if I set the standard language for the document to English US or not. Only if I set the 'locale setting' to US does it accept 1-mar-2011. I am trying make sense of some weird data format (2011MAR) which is English based. To me that seems a common situation, and I would not want to change the LO global localization settings as that changes all date formats in the spreadsheet to english. Couldn't datavalue take the locale of the formatted cell? Or is there a better trick to ge this done? If you cannot find a direct way of doing this sort of thing, you can always do the conversion yourself explicitly. It's no doubt sensible for you to keep Dutch settings, so you will probably need to write up the English month name abbreviations. Construct a table of these, with JAN, FEB, MAR, and so on in one column and the numbers 1 to 12 in the next column to the right. Select all twenty-four cells, go to Insert | Names | Define..., and give the table a name - perhaps Months. Suppose your value 2011MAR is in A1. Try this formula: =DATE(LEFT(A1;4);VLOOKUP(RIGHT(A1;3);Months;2;0);1) The LEFT() function takes the first four characters as the year. The RIGHT() function takes the last three characters, and the VLOOKUP() function looks these up in the Months list to produce a month number. These are combined by DATE() to give the first of the relevant month. I trust this helps. Brian Barker -- 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] Table Format
Hi Drew, Thank you for your long explanatory message, but I seem to miss something essential. Whenever I press the F4 key no matter where I am in Libre Office Base or Writer I get a set of four windows presuming that I have a projector on and giving me options on how to connect to it! I even tried the letter F key followed by the 4 one. No cigar! I don't know what this focused data control is about. I am puzzled but appreciate the trouble you are taking to help me. Sylvain -Original Message- From: drew jensen Sent: Sunday, March 04, 2012 3:33 PM To: users@global.libreoffice.org Subject: Re: [libreoffice-users] Table Format On Sun, 2012-03-04 at 15:18 -0500, Sylvain Bromberber wrote: Thank you, but I meant my computer screen, not a screen on which the table was projected. Howdy Sylvain Right and that is what I was speaking to - albeit, too briefly I suppose. By-default, with a writer document window the F4 key will open the data source window, docked, in the top of the document window frame. This is often referred to as the 'beamer'...a name for whatever reason I just always liked.. OK - if you have a form definition within an ODB file, when that window is open (this is just a special case of a writer document window) and you hit F4 the beamer is displayed - however, as this is now attached to a Base embedded form it behaves differently. The record set linked to from the CURRENTLY FOCUSED DATA CONTROL on the form is displayed in a grid view in the beamer. (important to remember the bit about the focused control, the forum can have multiple record sets open at a time) This is just another live view to the record set, if you can update this record set in the form you can do so in the beamer. If you use filters to limit the result set in the beamer it also limits the records in the form detail control. I assumed that was what you where talking about. Best wishes, //drew -Original Message- From: drew jensen Sent: Sunday, March 04, 2012 1:12 PM To: users@global.libreoffice.org Subject: Re: [libreoffice-users] Table Format On Sat, 2012-03-03 at 21:53 -0500, Sylvain Bromberber wrote: I once opened the table in one of my data bases and it popped up in a format I have not been able to duplicate. The upper half of the screen was the table in the form of a spread sheet but the lower half had the items of each row in a little table with the items under each other. I have been unable to duplicate this format, which I really liked. Any suggestions? With any form open hit the F4 key...that should do it //drew Sylvain -- 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 -- 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] Table Format
Are you on a laptop? Your function keys may have as default actions the control of laptop display functions and other provisions. (These are usually signified by a variety of symbols.) Usually, there is a way to obtain the F4 key function. If the legend is in blue, look for a blue Fn key down in the bottom row of the keyboard. Hold that key depressed and then press the F4 key, then release them both. - Dennis -Original Message- From: Sylvain Bromberber [mailto:sbrom...@mit.edu] Sent: Sunday, March 04, 2012 17:29 To: users@global.libreoffice.org Subject: Re: [libreoffice-users] Table Format Hi Drew, Thank you for your long explanatory message, but I seem to miss something essential. Whenever I press the F4 key no matter where I am in Libre Office Base or Writer I get a set of four windows presuming that I have a projector on and giving me options on how to connect to it! I even tried the letter F key followed by the 4 one. No cigar! I don't know what this focused data control is about. I am puzzled but appreciate the trouble you are taking to help me. Sylvain -Original Message- From: drew jensen Sent: Sunday, March 04, 2012 3:33 PM To: users@global.libreoffice.org Subject: Re: [libreoffice-users] Table Format On Sun, 2012-03-04 at 15:18 -0500, Sylvain Bromberber wrote: Thank you, but I meant my computer screen, not a screen on which the table was projected. Howdy Sylvain Right and that is what I was speaking to - albeit, too briefly I suppose. By-default, with a writer document window the F4 key will open the data source window, docked, in the top of the document window frame. This is often referred to as the 'beamer'...a name for whatever reason I just always liked.. OK - if you have a form definition within an ODB file, when that window is open (this is just a special case of a writer document window) and you hit F4 the beamer is displayed - however, as this is now attached to a Base embedded form it behaves differently. The record set linked to from the CURRENTLY FOCUSED DATA CONTROL on the form is displayed in a grid view in the beamer. (important to remember the bit about the focused control, the forum can have multiple record sets open at a time) This is just another live view to the record set, if you can update this record set in the form you can do so in the beamer. If you use filters to limit the result set in the beamer it also limits the records in the form detail control. I assumed that was what you where talking about. Best wishes, //drew -Original Message- From: drew jensen Sent: Sunday, March 04, 2012 1:12 PM To: users@global.libreoffice.org Subject: Re: [libreoffice-users] Table Format On Sat, 2012-03-03 at 21:53 -0500, Sylvain Bromberber wrote: I once opened the table in one of my data bases and it popped up in a format I have not been able to duplicate. The upper half of the screen was the table in the form of a spread sheet but the lower half had the items of each row in a little table with the items under each other. I have been unable to duplicate this format, which I really liked. Any suggestions? With any form open hit the F4 key...that should do it //drew Sylvain -- 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 -- 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