Re: [tdf-discuss] LO Base Enhancements
On Mon, 2014-07-28 at 20:58 +0100, Nigel Verity wrote: Hi Thank you for your interest in Base. Sqlite has a large and well-organised development team. It performs really well even with very large datasets. I feel that making Sqlite the default database for LO Base in place of HSQLDB would free resources for more development of the front-end. A big downside of Sqlite is its dynamic typing, a.k.a. advisory typing. IMO, this is simply broken. Terry. -- To unsubscribe e-mail to: discuss+unsubscr...@documentfoundation.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.documentfoundation.org/www/discuss/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [tdf-discuss] LO Base Enhancements
With respect to dynamic column typing in SQLite, On Mon, 2014-07-28 at 20:34 -0400, Andrew Douglas Pitonyak wrote: I think that this is intentional, so, I don't think it is actually broken. I never bothered to investigate the motivation for it. Certainly intentional. Indeed, the web site for SQLite describes it as a positive virtue. I should have written broken by design. I find it personally annoying, but not broken. I think that what you really mean is that you find it not usable for a certain application that you have in mind. The cost is in thinking about what a query may return: comparisons do not mean what we are used to. For that matter, what does a value mean when it is not in the domain in which it is supposedly defined? Terry. -- To unsubscribe e-mail to: discuss+unsubscr...@documentfoundation.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.documentfoundation.org/www/discuss/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [tdf-discuss] Better PDF import?
On Sat, 2014-06-21 at 11:22 +0200, Italo Vignoli wrote: PDF is based on PostScript, which is a page description language, and as such is extremely difficult to convert into an editable document. I have heard about OCR, but I have never been desperate enough to try it. Likely there is some OCR package with a licenced which would let us incorporate it into LibreOffice. I do not have an opinion about whether it would be worth the increase in the size of our project and the ongoing maintenance burden. Terry. -- To unsubscribe e-mail to: discuss+unsubscr...@documentfoundation.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.documentfoundation.org/www/discuss/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [tdf-discuss] memory leak in 4.0
On Wed, 2014-03-05 at 13:55 -0800, edo1 wrote: LO 4.2.0 is showing a memory problem that's making it unusable. When I open a file in it, the RAM usage starts to climb until LO locks up. I get Fatal Error osl:Thread:create failed. I am sorry that you are having problems. I presume that it is some particular file that you are unable to open rather that all files. Right? We can best help you if you file a bug report. The bug submission assistant is at https://www.libreoffice.org/get-help/bug/. The need for you to create an account is a nuisance, but we *do* need to be able to contact you. Feel free to add me, lo_b...@iseries-guru.com, as a CC in the bug report. It will help a lot if you attach the problematic file to the bug report. If necessary, you can disguise the contents by changing all letters to x's, or some such thing. After LO has pushed the RAM use to 3.9GB frozen I must close it completely, i.e., kill the processes swriter.exe *32, soffice.bin * 32. soffice.exe *32 Ah, that sounds like Windows. Be sure to tell us the version of Windows. Things that haven't helped: increasing paging size repairing LO helpfile in Control Panel running in a clean boot I don't recall this problem occurring in LO 4.1, the previous version I was running. My box is a Dell 530s, Intel E2500 CPU at 2.5GHz, 4GB RAM. I sure hope someone can help me get beyond this problem; I'm not getting any work done. - edo1 You may find it helpful to update your LibreOffice. Within 4.2, version 4.2.1 is current, and 4.2.2 is available as a pre-release. Within 4.1, version 4.1.5 is offered; it should be pretty stable. Terry. -- To unsubscribe e-mail to: discuss+unsubscr...@documentfoundation.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.documentfoundation.org/www/discuss/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [tdf-discuss] Re: Start 2014 with Freedom, Adopt LibreOffice in your life!
On Sat, 2014-01-04 at 22:45 +0700, Urmas wrote: Vitorio Furusho - LibreOffice: Start 2014 with Freedom, Adopt LibreOffice in your life! Do you call the absolute dependence on developers' powertrips and their uncontestable decisions 'freedom'? I have bad news for you then. I do see freedom here, even if I do not quite see the negative things that you name. I do not remember anything that I would call a powertrip. In every interaction I have had with a developer, the developer has been polite and helpful. The fact that decisions are made by those who know what they are doing strikes me as a *good* thing. Terry. -- To unsubscribe e-mail to: discuss+unsubscr...@documentfoundation.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.documentfoundation.org/www/discuss/ All messages sent to this list will be publicly archived and cannot be deleted
[tdf-discuss] Re: Is this a bug?
Pedro wrote Hi Terry, all Tanstaafl wrote This list is NOT intended for general Libreoffice support, it is intended for discussion of topics related to: The Document Foundation. If you want support for Libreoffice, please use the Libreoffice users list: users@.libreoffice I agree that this list is not for support (it isn't for discussions either, as the name might lead you to think) and that the User list is the best place to go (simply because there are more people there). Best regards, Pedro Tanstaafl's response did help me to clarify my confusion, so-to-speak. From the user's viewpoint, this has to be a bug; from the programmer's viewpoint, it is just another example of garbage-in-garbage out. I conlude that it is a bug but it is not *our* bug; no bug report is required. Thanks, Terry. -- View this message in context: http://nabble.documentfoundation.org/Is-this-a-bug-tp4075137p4075201.html Sent from the Discuss mailing list archive at Nabble.com. -- To unsubscribe e-mail to: discuss+unsubscr...@documentfoundation.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.documentfoundation.org/www/discuss/ All messages sent to this list will be publicly archived and cannot be deleted
[tdf-discuss] Is this a bug?
All, BTW, thank you, Pedro, for noticing that this list has been unhelpful in the past. If questions like these should go somewhere else, guidance is welcome. I notice that Writer merges a bunch of lines into one flowing paragraph when you do this improbable-sounding sequence of operations on Linux: (*) Open a file from MacOS in gedit. (*) In gedit, copy the text. (*) In Writer, paste the text. In the resulting .fodt, the line endings from the original file are represented by x0d;. The result is ugly and useless, but I am unsure whether it is a bug. I invite your opinions. FWIW, I found this behavior while looking at fdo#69679 EDITING: Problem in Copy-Paste when text contains characters with code 0Dh [1], but I concluded that that report is about something different. fdo#63319 EDITING: copy paste text from gedit editor [2] is a bit closer, but still different. Thanks, Terry. References: [1] https://bugs.freedesktop.org/show_bug.cgi?id=69679 [2] https://bugs.freedesktop.org/show_bug.cgi?id=63319 -- View this message in context: http://nabble.documentfoundation.org/Is-this-a-bug-tp4075137.html Sent from the Discuss mailing list archive at Nabble.com. -- To unsubscribe e-mail to: discuss+unsubscr...@documentfoundation.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.documentfoundation.org/www/discuss/ All messages sent to this list will be publicly archived and cannot be deleted
[tdf-discuss] Save-version-on-close, proposed enhancement
Hi all, According to the help for Always save a version on closing https://help.libreoffice.org/Common/Versions#Always_save_version_when_closing, this option does not save a version on closing unless you have changed the document since you last saved it. I think it would be more useful for the program to automatically save a version if the document has cnaged since the last saved version. Thoughts, anyone? You access the option in question through menu option File Versions, and the option is to the right of the button Save New Version. BTW, this suggestion arises from fdo#65055 (FILESAVE: Versioning – Always save a version on closing doesn’t work), which is now fixed, Terry. -- To unsubscribe e-mail to: discuss+unsubscr...@documentfoundation.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.documentfoundation.org/www/discuss/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [tdf-discuss] Bug in Contour Editor - Writer 4.0.2
On Fri, 2013-05-17 at 09:18 +0200, Fernand Vanrie wrote: Terrence, the bug report is there since 2012 https://www.libreoffice.org/bugzilla/show_bug.cgi?id=57079 but it is from 4.01 ion must worser and contour becomes unusable because off double clicking do crasch the office, OO 4.0 do not have this problem so a fix can been found there ? Thank you. That led me to bug 62965 EDITING: image contour editing crashes https://bugs.freedesktop.org/show_bug.cgi?id=62965, and I have marked the new bug as a duplcate of that. Terry. -- To unsubscribe e-mail to: discuss+unsubscr...@documentfoundation.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.documentfoundation.org/www/discuss/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [tdf-discuss] Bug in Contour Editor - Writer 4.0.2
Hello, For your problem with the contour editor in Writer, I think you should file a bug report. The easiest way is to use the Bug Submission Assistant https://www.libreoffice.org/get-help/bug/. Please add me lo_b...@iseries-guru.com to the report, and I shall try to confirm your report. Terry, On Tue, 2013-05-07 at 10:19 -0400, fobe...@rcn.com wrote: Hi: This bug in the contour editor is apparently new in the 4.x version, since I've used this quite a bit in earlier versions and never had an issue. When attempting to set a contour, everything goes ok until attempting to finish the selection, at which time the entire app crashes and disappears. The check mark icon never becomes clear/active, so the problem seems to be in the closing of the polygon. Nothing happens to the document that I can tell, and it seems to get recovered with no issues. I've confirmed this with images are in .png and .jpg formats if that matters. I didn't try this with anything other than polygonal selections. I went back and looked at a few graphics that I had placed and contoured in earlier versions (same document) and the contour definition that had been previously set seems to still be honored. I did NOT, however, go into the contour editor because I was afraid of screwing up the layout. Thanks. On Wed, 2013-05-08 at 17:24 -0400, fobe...@rcn.com wrote: Hi: I'm using 64 bit Ubuntu 12.04 and recently updated LibreOffice to 4.0.2.2, and I hope I've been sending these reports to the right place. Today I attempted to delete a table, which I have always done by placing the cursor in the table, then using the menu sequence Table | Delete | Table but when I tried to do that with 4.0.2.2, and chose the Table | Delete menu option, everything was greyed out and I couldn't do it. I ended up selecting the table as well as the paragraph markers above and below it to delete it. I'm assuming that Writer knew the cursor was in the table because the Table Tool bar appeared as usual when I entered the table. I used the Ubuntu software center to install this version (and yes - I removed the earlier version I was using first), so I assume I'm not using a pre-release candidate or anything, but I seem to be encountering more anomalies than usual with Writer (I've sent three possible bugs to this address in the past few days and believe I've only sent in one or two in the past couple years). Is there any sort of sanity check I should be running to insure the stuff I have is ok? Also, by the way, I've noticed that Writer tends to bog down and stop for a while in large documents (such as the book I'm currently working on which is about 350 pages or so), which it didn't do in earlier versions. Is there some sort of memory management configuration that's changed that I should know about? Thanks, by the way, for a great program - I've used countless word processors - both early stand alone machines as well as personal software - since the late 70s, and Writer is as well thought out as anything I've encountered (just don't be like Microsoft and completely change the interface every couple years or so while leaving the long-standing bugs in place.) If you have questions about this report or my recent ones, or need examples, feel free to contact me. -- To unsubscribe e-mail to: discuss+unsubscr...@documentfoundation.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.documentfoundation.org/www/discuss/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [tdf-discuss] Bug (??) Table deletion in Writer 4.0.2.2
On Wed, 2013-05-08 at 17:24 -0400, fobe...@rcn.com wrote: Also, by the way, I've noticed that Writer tends to bog down and stop for a while in large documents (such as the book I'm currently working on which is about 350 pages or so), which it didn't do in earlier versions. Is there some sort of memory management configuration that's changed that I should know about? If you are willing to attach your 350-page book to the bug report, and if you can tell us what to do to see the slowdown, then a bug report is the way to go. Remember, of course, that attachments to a bug report are available to the whole world; you may not want to do that. If you do file a bug report, please add me lo_b...@iseries-guru.com to the cc. I do not know how bad a performance regression must be to count as a bug. Discussion on the developer list, New test to automatically importing all bugzilla documents http://nabble.documentfoundation.org/New-test-to-automatically-importing-all-bugzilla-documents-td4038484.html, shows some interest in tracking these things. Guidance, anyone? Terry. -- To unsubscribe e-mail to: discuss+unsubscr...@documentfoundation.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.documentfoundation.org/www/discuss/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [tdf-discuss] Python trademark at risk in Europe: Python Software Foundation calls for help
On Sat, 2013-02-16 at 19:21 +0100, Jean-Baptiste Faure wrote: Hi, As LibreOffice uses more and more the Python language, TDF may be interested by this call for help: http://pyfound.blogspot.ca/2013/02/python-trademark-at-risk-in-europe-we.html The Python Software Foundation is reporting http://pyfound.blogspot.ca/2013/03/python-software-foundation-reaches.html that it has reached a favourable agreement ... The amicable agreement reached between the two sides will result in a rebranding of Veber's Python cloud server and backup services, which continue to be available at http://www.veber.co.uk. Veber will rebrand the Python services later under a yet to be determined name. -- Unsubscribe instructions: E-mail to discuss+h...@documentfoundation.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.documentfoundation.org/www/discuss/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [tdf-discuss] Python trademark at risk in Europe: Python Software Foundation calls for help
On Sat, 2013-02-16 at 16:22 -0500, webmaster-Kracked_P_P wrote: On 02/16/2013 01:21 PM, Jean-Baptiste Faure wrote: Hi, As LibreOffice uses more and more the Python language, TDF may be interested by this call for help: http://pyfound.blogspot.ca/2013/02/python-trademark-at-risk-in-europe-we.html I wonder if the Python people should contact all the Python book writers and publishers. Groklaw has an article http://www.groklaw.net/article.php?story=20130215074839583 on the topic. PJ is encouraging her readers to help the cause ... Any pack rats out there? If so, this is what you've been saving all those conference programs for. Anyone can research, and I'll try to find things, but I know you guys usually know where to find such items better than I do. The older the reference, the better, of course. Since the challenger showed up thirteen years ago, anything older than that would be ideal. and commenters are reporting that they have found quite a bit. Yes, it would be a real pain if Python has to change its name. Terry. -- Unsubscribe instructions: E-mail to discuss+h...@documentfoundation.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.documentfoundation.org/www/discuss/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [tdf-discuss] LibreOffice and Java Security:
I cannot address the important question, but ... On Sun, 2013-01-13 at 14:22 +1100, lj wrote: Can I use LibreOffice without Java enabled on my computer?? As I receive annoying pop up windows when I first use libreoffice to install Java on Apple OS X Mountain Lion. One of my systems lacks java, and I quite often run LibreOffice there. I understand that Base (i.e., database access) requires java, but everything else should work. My experience is with Linux; you might find things a bit different. HTH, Terry. -- Unsubscribe instructions: E-mail to discuss+h...@documentfoundation.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.documentfoundation.org/www/discuss/ All messages sent to this list will be publicly archived and cannot be deleted
[tdf-discuss] user qestions, where should they go now?
Another usere has stumbled into the development list [1]. Clearly, he needs to be directed elsewhere, but I am unsure where to direct him. The situation w.r.t. forums seems to be in flux, and I am reluctant to send him to a mail list that I not follow myself. Is there a simple answer? Thanks, Terry. References -- [1] http://lists.freedesktop.org/archives/libreoffice/2012-October/039289.html -- Unsubscribe instructions: E-mail to discuss+h...@documentfoundation.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.documentfoundation.org/www/discuss/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [tdf-discuss] Re: AskLibO blitzes
On Mon, 2012-05-21 at 06:52 -0700, Pedro wrote: Terrence Enger wrote I was excited when AskLibo started, only to find that OpenId is required for using it. And the OpenId providers advertised all have impressive terms of use, impressive as in long and daunting. What if BrowserID was added (or replaced OpenID)? The first couple of pages about BrowserID that I found do not suggest that I would have to understand any legalese. That sounds good. Is this easy to implement? I have not heard that anybody else is worried by OpenID, and I cannot realistically expect that my contributions will be worth awfully much. Thanks, Terry. -- Unsubscribe instructions: E-mail to discuss+h...@documentfoundation.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.documentfoundation.org/www/discuss/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [tdf-discuss] Re: AskLibO blitzes
On Sun, 2012-05-20 at 18:07 -0400, Marc Paré wrote: It is also a good exercise for the LibreOffice membership who may have forgotten to pop by once in a while on the AskLibO pages; Sigh! I was excited when AskLibo started, only to find that OpenId is required for using it. And the OpenId providers advertised all have impressive terms of use, impressive as in long and daunting. Please forgive my whining. Terry. -- Unsubscribe instructions: E-mail to discuss+h...@documentfoundation.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.documentfoundation.org/www/discuss/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [tdf-discuss] Mail Merge to Email in Writer
On Fri, 2012-04-13 at 12:30 +0100, Gordon Burgess-Parker wrote: I had cause the other day to do a Mail Merge to Email in Writer. I was horrified to discover that the Mail Merge to Email function does NOT call the default email client, but uses an in-built smtp function within Writer. The major problem with that as far as I can see is that there is NO RECORD ANYWHERE of the emails sent by that process. Surely in the days of Sarbanes-Oxley and other legislation that is an appalling omission? Sarbanes-Oxley applies to financial accounting, does it not? And the sending of an email is generally not recorded in the financial records of a business. What do the two have to do with each other? What am I missing? I am neither an American nor an accountant (not even a bookkeeper grin /), so please deal gently with my ignorance. My intention here is not to resist improvements to LibreOffice. Rather, I am questioning the basis for your words horrified and appalling. Terry. -- Unsubscribe instructions: E-mail to discuss+h...@documentfoundation.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.documentfoundation.org/www/discuss/ All messages sent to this list will be publicly archived and cannot be deleted
[tdf-discuss] Re: Naming builds. Please???
Bjoern wrote the dev list. I am responding on discuss because of the vagueness of my comment. On Wed, 2011-12-07 at 13:25 +0100, Bjoern Michaelsen wrote: Hi all, On Tue, Dec 06, 2011 at 11:18:02PM +0100, Lionel Elie Mamane wrote: On Tue, Dec 06, 2011 at 04:09:15AM -0800, Pedro wrote: [very long thread] I think the whole concept of manually tracking masterbuilds is mostly broken. I think I have a better solution, and will post about it RSN. I would urge you to suspend this topic for a bit, as it might be obsolete soon wth that anyway. Details follow. I wonder if I can get away with suggesting some additional functionality? Quite often, as I take notes about what I see happening, I want to note just what version of LO is involved. Perhaps others around here do the same thing. So, we could make LibreOffice copy its identification to the clipboard in a form suitable for pasting into a Writer document (yes, I usually have two versions of LO running), or into an email, or into a bug report. This could be available either as a button on the About dialog or as an option on the Help menu. The benefit, if there *is* any benefit, would come from consistent-looking emails and bug reports. The actual effort of copying selected info is so small as not to justify much programming effort. Just a random idea, Terry. -- Unsubscribe instructions: E-mail to discuss+h...@documentfoundation.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.documentfoundation.org/www/discuss/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [tdf-discuss] Re: Naming builds. Please???
On Wed, 2011-12-07 at 18:22 +0100, Uwe Altmann wrote: Hi Terry Am 07.12.11 15:13, schrieb Terrence Enger: So, we could make LibreOffice copy its identification to the clipboard in a form suitable for pasting into a Writer document (yes, I usually have two versions of LO running), or into an email, or into a bug report. This could be available either as a button on the About dialog or as an option on the Help menu. Since recently, you can just copy the content of the upper About-Dialog textbox; looks like LibreOffice 3.4.4 OOO340m1 (Build:402) Would that be good enough or what Information else is needed there? That question has has provoked a long discussion Naming builds. Please??? http://lists.freedesktop.org/archives/libreoffice/2011-December/021742.html on the dev list. I should have thought to include that link with my original comment; sigh. The proposals include identification of the downloaded package file, commit ids of each contributing repository, times of commit to each contributing repository, configuration options. Then perhaps it should be visible (and copyable) in this box too?? Presumably the implementation of whatever is chosen will allow copying. The suggesion here is that we may get easier-to-read reports by making it easy for people to copy the same stuff the same way. Terry. -- Unsubscribe instructions: E-mail to discuss+h...@documentfoundation.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.documentfoundation.org/www/discuss/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [tdf-discuss] Re: Naming builds. Please???
On Wed, 2011-12-07 at 13:50 -0500, Marc Paré wrote: Le 2011-12-07 12:58, Terrence Enger a écrit : On Wed, 2011-12-07 at 18:22 +0100, Uwe Altmann wrote: Hi Terry Am 07.12.11 15:13, schrieb Terrence Enger: So, we could make LibreOffice copy its identification to the clipboard in a form suitable for pasting into a Writer document Why not just make it automatic by having a Submit bug button somewhere and it would already fill in all of the identifying fields without the user having to fill them out. This would make sure the devs get the right information on the bug submissions all the time and the button would be programmed right into the software. Probably the best place to put it would be in the About menu. That sounds good, but I see some difficulties, too. (*) The user may be writing notes to herself or an email to a list instead of a bug report. (*) The user's intention may be a comment on an existing bug rather than a new bug report. (Having created bug 43468 https://bugs.freedesktop.org/show_bug.cgi?id=43468, I came back later with observations (more useful ones, I hope) of later version of maaster.) (*) For a bug report, it would be tempting to collect information about not just the build, but about the particular situation as well. (Klutz that I am, I kepp forgetting that the list of undo actions can help me remember what I was doing.) Where does this end? (*) This sounds so good that we might want to include it in product builds. But then, we have to explain to users under what conditions the program collects what information for what purpose. That is a can of worms that we may not want to open. Each point boils down to a version of where is it going to end?. To say it ends where the work exceeds the benefit is true but unhelpful. That's why we have the discuss list, right? grin / Terry. -- Unsubscribe instructions: E-mail to discuss+h...@documentfoundation.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.documentfoundation.org/www/discuss/ All messages sent to this list will be publicly archived and cannot be deleted
[tdf-discuss] funny movement of character cursor within Calc cell
subject --- funny movement of character cursor within Calc cell body On ubuntu-natty, in a local build from master, the movement of the character cursor sometimes surprises me when I edit the non-numeric contents of a cell ... (*) When I type F2, the character cursor goes to the end of the text in the cell. (*) When I type home, the character cursor goes to the beginning of the text in the cell. (*) When I type a letter, the program inserts the character in front of the text already in the cell (as I expect) and then moves the character cursor to the end of the cell (surprisingly). This behaviour differs from Ubuntu package 1:3.3.3-1ubuntu2. So I ask ... (*) Does anybody else see this? (*) Is there anything by way of auto-whatever that could be asking for this behaviour? (*) Is this clearly a bug? Thanks, Terry. -- Unsubscribe instructions: E-mail to discuss+h...@documentfoundation.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.documentfoundation.org/www/discuss/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [tdf-discuss] Error in scripting framework
I apologize for the length of my comment. Also for the length of the lines; turn of wrapping if you can. On Fri, 2011-09-16 at 00:48 -0400, Andrew Douglas Pitonyak wrote: On 09/12/2011 11:39 AM, Olivier Hallot wrote: Couldn't we write just Oh dear, I am unable to find a macro you asked me to execute!? What I would prefer to see on an error is: error for a dummy error for a technical person Rather than just error for a dummy The trick is to find a way to express the error such that a non-technical person is not horrified, yet, a technical person has a chance to find the actual problem. A dialog with a details button is great. IMHO, the messages on the IBM i, a.k.a. AS/400, do a good job of providing a second level of explanation. I am used to a system which lets me dig deeper into a message; it feels strange not to have this available. (For the examples, remember that the user being addressed is a programmer. That is the reason for the programming jargon; the technology lets you use the jargon you choose.) In the images here, the text of Message is what the user sees first. For more, the system displays Message, Cause, and Recovery. Some messages have an additional Technical description which gives information expected to be less commonly interesting. For example, here is the English definition of one message. Items of the form digit-string are place-holders for items to be supplied by the program at run-time. | Display Formatted Message Text | System: PUB1 | Message ID . . . . . . . . . : CPF2103 | Message file . . . . . . . . : QCPFMSG |Library . . . . . . . . . : QSYS | | Message . . . . : Library 1 already exists in library list. | Cause . . . . . : The library 1 already exists in the library search list. |The library was not added. | Recovery . . . : If 1 is the library you specified omit the command. If |you did not specify library 1 then change the library name (LIB parameter). |Then try the command again. Oooh. I think I know how to make that happen. Here is a bit of the terminal session. The right pointy bracket is this system's analog of the trailing $ of a bash prompt string. | Previous commands and messages: | addlible tenger1 | Library TENGER1 added to library list. | addlible tenger1 | Library TENGER1 already exists in library list. Digging into the completion message from the second command above, we see ... | Additional Message Information | | Message ID . . . . . . : CPF2103 Severity . . . . . . . : 40 | Message type . . . . . : Escape | Date sent . . . . . . : 09/16/11 Time sent . . . . . . : 11:50:28 | | Message . . . . : Library TENGER1 already exists in library list. | Cause . . . . . : The library TENGER1 already exists in the library search |list. The library was not added. | Recovery . . . : If TENGER1 is the library you specified omit the command. |If you did not specify library TENGER1 then change the library name (LIB |parameter). Then try the command again. The message has an existence independent of its appearance on the screen. Just for fun, let me change the date format of my job to one I like better and look at the same message again. | Additional Message Information | | Message ID . . . . . . : CPF2103 Severity . . . . . . . : 40 | Message type . . . . . : Escape | Date sent . . . . . . : 11/09/16 Time sent . . . . . . : 11:50:28 | | Message . . . . : Library TENGER1 already exists in library list. | Cause . . . . . : The library TENGER1 already exists in the library search |list. The library was not added. | Recovery . . . : If TENGER1 is the library you specified omit the command. |If you did not specify library TENGER1 then change the library name (LIB |parameter). Then try the command again. Another benefit of the technology is that the program is generally unconcerned with the language of the display. Here is the message description in German ... | Display Formatted Message Text | System: PUB1 | Message ID . . . . . . . . . : CPF2103 | Message file . . . . . . . . : QCPFMSG |Library . . . . . . . . . : QSYS2929 | | Nachricht . . . : Bibliothek 1 in Bibliotheksliste bereits vorhanden. | Ursache . . . . : Die Bibliothek 1 ist in der Bibliothekssuchliste bereits |vorhanden. Die Bibliothek wurde nicht hinzugef�gt. | Fehlerbeseitigung: Wenn 1 die angegebne Bibliothek ist, den Befehl |auslassen. Wurde Bibliothek 1 nicht angegeben, dann den Bibliotheksnamen |(Parameter LIB) �ndern. Anschlie�end den Befehl wiederholen. and a message instance ... | Additional Message Information | | Message
[tdf-discuss] wiki edit: suggesting further edit, requesting approval
I have just edited the wiki page How to build LibreOffice http://wiki.documentfoundation.org/index.php?title=Development% 2FNative_Buildaction=historysubmitdiff=36230oldid=36124 to say that ccache is enabled by default if found. The edit which removed that information (because it was not true at the time) http://wiki.documentfoundation.org/index.php?title=Development% 2FNative_Buildaction=historysubmitdiff=32426oldid=32398 also removed instructions about the Mac. As I know nothing about the Mac, I have said nothing about it. Perhaps somebody with the appropriate knowlege would care to think about whether the instructions should go back into the page? This is my first edit to the LibreOffice wiki. Should I generally expect missteps to be noticed quickly? Or should I tell people (here?) when I have done something? Thanks, Terry. -- Unsubscribe instructions: E-mail to discuss+h...@documentfoundation.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.documentfoundation.org/www/discuss/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [tdf-discuss] how change macro security level?
On Thu, 2011-09-08 at 09:35 +0100, Caolán McNamara wrote: On Mon, 2011-08-29 at 12:55 -0400, Terrence Enger wrote: On Mon, 2011-08-29 at 09:00 +0100, Caolán McNamara wrote: On Sun, 2011-08-28 at 07:34 -0400, Terrence Enger wrote: The remaining questions are ... Does anybody else share the problem of the ineffective MacroSecurity... button? No, works fine here. Does anybody care? Sure, but it works for me. Thank you. I shall relax about the issue until I know more. Its because of your --disable-mozilla. The relevant macro security dialog code is included in a library only built and installed when moz is included. Fixed this now in master to always include the dialog. Thank you, Caolán. That is awsome. Terry. -- Unsubscribe instructions: E-mail to discuss+h...@documentfoundation.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.documentfoundation.org/www/discuss/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [tdf-discuss] how change macro security level?
On Sun, 2011-08-28 at 14:40 +0200, Johnny Rosenberg wrote: I don't know if it's mentioned already, in that case I just missed it, or if it's even relevant, but what Java are you running? From the LibreOffice home page: ”If you run Linux, the GCJ Java variant has known issues with LibreOffice, we advise to e.g. use OpenJDK instead.” You got me excited by saying java: I know that Base uses java, and I have a mystery with Base. But, I see that my system already has OpenJDK Runtime Environment (IcedTea6 1.10.2) (6b22-1.10.2-0ubuntu1~11.04.1). Thank you for the suggestion. Terry. -- Unsubscribe instructions: E-mail to discuss+h...@documentfoundation.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.documentfoundation.org/www/discuss/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [tdf-discuss] how change macro security level?
On Mon, 2011-08-29 at 09:00 +0100, Caolán McNamara wrote: On Sun, 2011-08-28 at 07:34 -0400, Terrence Enger wrote: The remaining questions are ... Does anybody else share the problem of the ineffective MacroSecurity... button? No, works fine here. Does anybody care? Sure, but it works for me. Thank you. I shall relax about the issue until I know more. Terry. -- Unsubscribe instructions: E-mail to discuss+h...@documentfoundation.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.documentfoundation.org/www/discuss/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [tdf-discuss] identifying version of soffice.bin
On Mon, 2011-08-29 at 09:05 +0100, Caolán McNamara wrote: On Sun, 2011-08-28 at 08:29 -0400, Terrence Enger wrote: Hello, all. Now that my system holds more than one build from master, my small mind is even more subject to confusion than it used to be. So, I wonder ... (*) Is there an easy way to display the build id of soffice.bin to the sysout or syserr? Well, because we use a continuous master we're now using git ids as the build-ids, i.e. the string in help about is derived from ./g -s log -n 1 --pretty=format:%h- at make dev-install/package generation time make dev-install in my work directory libo_20110825/ seems to have changed the result in work directory libo/ too. You can find that id in the install set in program/setuprc so grep buildid install/program/setuprc should match the output of ./g -s log -n 1 --pretty=format:%h- if there was no intervening pull Well, my confusion started after I tried to follow the instructions How to Build LibreOffice Multiple Work Dirs http://wiki.documentfoundation.org/Development/How_to_build#Multiple_Work_Dirs. The branch argument to git-new-workdir is optional, and I omitted it. Maybe I fat-fingered something else. Or maybe my expectation was wrong. Anyway, I was surprised to find that `git pull` in the new work dir changed the result of `git branch --verbose` in the previous work directory. Meanwhile, Regina Henschel has told me a couple of ways I can make it clear to myself just which soffice I am running. Thanks, Terry. -- Unsubscribe instructions: E-mail to discuss+h...@documentfoundation.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.documentfoundation.org/www/discuss/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [tdf-discuss] identifying version of soffice.bin
On Sun, 2011-08-28 at 17:15 +0200, Regina Henschel wrote: No answer to your questions, Then, how come I feel like my questions are answered? because I have only got WinXP. But other ideas: You find the version information in the file program\version.ini (Windows here). It is a textfile, so it should be easily displayed. Thank you. I have found install/program/versionrc, which I can just grep to the terminal in my debug session. You can edit the text, which is shown in the title bar of a running LO. This string is in share (that of top level)\registry\brand.xcd. It is node Product and therein node ooName. So you can enter the information you want to see. That is shorter than opening HelpAbout. Again, thank you. Would these tips be worth mentioning in How To Build LibreOffice http://wiki.documentfoundation.org/Development/How_to_build under the heading Multiple Work Dirs? Is there a better place to say these things? Terry. -- Unsubscribe instructions: E-mail to discuss+h...@documentfoundation.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.documentfoundation.org/www/discuss/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [tdf-discuss] how change macro security level?
On Fri, 2011-08-26 at 13:08 -0400, Terrence Enger wrote: [snip] Meanwhile, looking under Tools Options LibreOffice Paths, I see that my local builds put things under ~/.config/libreoffice, and sure enough there is ~/.config/libreoffice/3/user/registrymodifications.xcu. I shall go try that. That file lacked the entry for MacroSecurityLevel. Adding it changed the program behaviour, but not for the better. And then the program wiped out the entry. Better news: In the build from aa51fd4-4eb4f62-260b7c1, the program allows execution for a new module. The build from c305fc3 is not quite so cooperative: bug 40420 SIGSEGV, basicbox.cxx:544 https://bugs.freedesktop.org/show_bug.cgi?id=40420. So, I have what I need for my own playing around. Thank you, Regina, for your pointers. The remaining questions are ... Does anybody else share the problem of the ineffective MacroSecurity... button? Does anybody care? Thanks, Terry, -- Unsubscribe instructions: E-mail to discuss+h...@documentfoundation.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.documentfoundation.org/www/discuss/ All messages sent to this list will be publicly archived and cannot be deleted
[tdf-discuss] identifying version of soffice.bin
Hello, all. Now that my system holds more than one build from master, my small mind is even more subject to confusion than it used to be. So, I wonder ... (*) Is there an easy way to display the build id of soffice.bin to the sysout or syserr? (Since I created my second work dir and did `git pull`, `git branch --verbose` in the first directory shows the later version. Did I screw up creating the second work directory?) (*) Is there an easy way to change the appearance of an execution of soffice, something like the application of a gnome theme changes all applications? Thanks, Terry. -- Unsubscribe instructions: E-mail to discuss+h...@documentfoundation.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.documentfoundation.org/www/discuss/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [tdf-discuss] how change macro security level?
On Wed, 2011-08-24 at 14:43 +0200, Cor Nouws wrote: [snip] In the build from master (Build ID: 117281b-4eb4f62-260b7c1), on Ubuntu too, that I have, Macro security works fine. No idea if the problem is a local one (your build) an older or newer version than I have, or... Around 19:22 UTC yesterday I did `git pull`, and the build just finished. My autogen.lastrun contains ... --with-linked-git=/home/terry/lo_hacking/git/libo/clone --with-external-tar=/home/terry/lo_hacking/git/libo/src --disable-mozilla --enable-symbols --enable-dbgutil --enable-crashdump --disable-build-mozilla --without-junit and the program identifies itself in the About dialog as ... LibreOffice 3.5.0 Build ID: c305f3c-4eb4f62-260b7c1 The button MacroSecurity... still fails to bring up the dialog that I expect. Suggestions welcome. Thanks, Terry. -- Unsubscribe instructions: E-mail to discuss+h...@documentfoundation.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.documentfoundation.org/www/discuss/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [tdf-discuss] how change macro security level?
On Fri, 2011-08-26 at 14:54 +0200, Regina Henschel wrote: [snip] I don't know, why it fails, likely a problem with Java. But if you need macros, you can set the value directly. Make a backup of your registrymodificaitions.xcu. I do not find that file anywhere in my working directory. Do you mean the one that I see in ~/.libreoffice/3/user/? Something else? Then edit it. In path /org.openoffice.Office.Common/Security/Scripting set property MacroSecrityLevel to 1, that is medium, which means, that you are prompt. Thanks, Terry. -- Unsubscribe instructions: E-mail to discuss+h...@documentfoundation.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.documentfoundation.org/www/discuss/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [tdf-discuss] how change macro security level?
On Fri, 2011-08-26 at 16:39 +0200, Regina Henschel wrote: [snip] I forgot, you are on Linux. Yes I mean the file in your user directory. How is its name for you? I have found $ ls -l ~/.libreoffice/3/user/registrymodifications.xcu -rw--- 1 terry terry 157661 2011-08-26 11:17 /home/terry/.libreoffice/3/user/registrymodifications.xcu but I came up empty on both of $ find /home/terry/lo_hacking/git/libo -name registrymodificaitions.xcu $ find /home/terry/lo_hacking/git/libo_20110825 -name registrymodificaitions.xcu the latter directory being where I rebuilt yesterday following the instruction under Multiple Work Dirs in http://wiki.documentfoundation.org/Development/How_to_build. And I changed that file, but LibreOffice as received with ubuntu-natty still shows High under Tools Options LibreOffice Security MacroSecurity... Security Level. I must have done something wrong. Meanwhile, looking under Tools Options LibreOffice Paths, I see that my local builds put things under ~/.config/libreoffice, and sure enough there is ~/.config/libreoffice/3/user/registrymodifications.xcu. I shall go try that. ( I did look at the paths options before, but was put off by the fact that none of the paths seemed obviously relevant to security. ) Thanks, Terry. -- Unsubscribe instructions: E-mail to discuss+h...@documentfoundation.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.documentfoundation.org/www/discuss/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [tdf-discuss] how change macro security level?
On Wed, 2011-08-24 at 14:43 +0200, Cor Nouws wrote: [snip} In the build from master (Build ID: 117281b-4eb4f62-260b7c1), on Ubuntu too, that I have, Macro security works fine. No idea if the problem is a local one (your build) an older or newer version than I have, or... Your version is newer, if I am interpreting aright the output from git. I guess I shall try to pull and build. The dev list has announced patches to the build process, so I hope to have less trouble than last time. In general, IMO if you build and test on the master, best for questions is IRC #libreoffice-dev. Is that easier for the experts? My experience on the dev and discuss lists is that the response time is at least as fast as I would hope for, and faster by far than I can act on the answers grin attitude=wry /. Thanks, Terry. -- Unsubscribe instructions: E-mail to discuss+h...@documentfoundation.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.documentfoundation.org/www/discuss/ All messages sent to this list will be publicly archived and cannot be deleted
[tdf-discuss] how change macro security level?
Greetings, I find that I am unable to run macros: the dialog box presented by Tools Options LibreOffice Security offers a button labelled Macro Security..., and the button responds to a mouse click by showing itself depressed and taking focus, but that is all that happens. In particular, this does not call up the dialog box that I expected. Is there something I need to know about macro security? OTOH, am I alone in this situation? I am on ubuntu-natty (11.04), running a local build from master, commit id aa51fd4; my autogen options are ... --disable-mozilla --enable-symbols --enable-dbgutil --enable-crashdump --disable-build-mozilla --without-junit Thank you, all, for your attention. Terry. -- Unsubscribe instructions: E-mail to discuss+h...@documentfoundation.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.documentfoundation.org/www/discuss/ All messages sent to this list will be publicly archived and cannot be deleted
[tdf-discuss] Writer printing paragraph formats it into following bulletted list
Hello, all. In writer I selected a paragraph and the following bulleted list. Then I printed Selection. To my surprise, the printout formats the first paragraph as one item in the bulleted list. Can this be anything but a bug? Thanks, Terry. -- Unsubscribe instructions: E-mail to discuss+h...@documentfoundation.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.documentfoundation.org/www/discuss/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [tdf-discuss] Writer printing paragraph formats it into following bulletted list
On Sat, 2011-08-20 at 19:26 +0100, Mike Hall wrote: [snip] Bug confirmed with Lo 1.4.2 under Vista. Best if you submit a bug report. Let me know if you can't - in that case I will do it. Done, bug 40258 Writer PRINTING a paragraph like following list https://bugs.freedesktop.org/show_bug.cgi?id=40258. I took the liberty of adding you the CC List of the bug. Thanks, Terry. -- Unsubscribe instructions: E-mail to discuss+h...@documentfoundation.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.documentfoundation.org/www/discuss/ All messages sent to this list will be publicly archived and cannot be deleted
[tdf-discuss] A failed query to ODBC data source
I have a failing query. The curious specificity of the difficulty has already led me into spending more time than the problem is worth to me, but I would be glad to work further if perchance somebody else cares. The problem is the message The data content could not be loaded. when I include a particular field from a particular table in the select list of a query. The curious specificity is that I can with success include char() of that field in the select list, and I can include the field in the where clause or the order-by clause. If I create another table and from the same SQL DDL and DML statements, LibreOffice has no problem. On the other hand, the problem is again evident with a table which I create with (please pardon jargon specific to the IBM i) CRTDUPOBJ. It hurts to give up on a problem, but there is the possiblity spending a lot of effort with the only result being a more specific failure message, along the lines of You gotta upgrade your remote server to a supported version of the O/S or Please lobby IBM to fix their ODBC driver. So I ask, does anybody care? Thanks, Terry. -- Unsubscribe instructions: E-mail to discuss+h...@documentfoundation.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.documentfoundation.org/www/discuss/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [tdf-discuss] Re: A failed query to ODBC data source
Thank you, Alex. You have evidently paid quite some attention to my question. Does this mean that you think the issue is worth following up on? For comparison, the competitor for my attention (and the thing that got me into this mess) is bug 34309 Error on importing a timestamp field from db2 via ODBC https://bugs.freedesktop.org/show_bug.cgi?id=34309. On Wed, 2011-08-17 at 19:13 +0200, Alexander Thurgood wrote: Le 17/08/11 16:30, Terrence Enger a écrit : Hi Terry, [snip] Is your field perchance being flagged as an OBJECT ? It should not be. The field is KEYFIELD in table AA6411 described in bug 34309 Error on importing a timestamp field from db2 fia ODBC https://bugs.freedesktop.org/show_bug.cgi?id=34309. The field specification is keyfield intnot null primary key, [snip] However, I do remember there previously being problems with DB2 ODBC drivers. Well, OO.o bug 110236 Error: operator delete mismatch http://openoffice.org/bugzilla/show_bug.cgi?id=110236 jumps to mind because I am still seeing those assertions raised. (I am user 400guy on that bug tracker.) Beside the fact that my field is a common garden-variety integer, I have to think that the ODBC driver works in at least some contexts because LibreOffice received with ubuntu-natty, which identifies itself as LibreOffice 3.3.3 OOO330m19 (Build:301) tag libreoffice-3.3.3.1, Ubuntu package 1:3.3.3-1ubuntu2 can query the table without difficulty. [snip] Have you searched to see if anything is in the old OOo dba mailing list archives on this topic ? I am subscribed to that (now very quiet) list. I think I would have noticed a reference to db2/i. (But let's see what google can find. ... Okay, I'm back.) [ db2 The data content could not be loaded. site:openoffice.org ] returns 57 hits. This would be a place to start, if the issue is worth considering. That, of course, is my underlying question. I suppose you could always try canvassing someone from IBM over at the Apache-OOo project, but they might just tell you to use the JDBC driver instead. Well, it was a bug report that got me into this, not a real need to use db2 from LibreOffice. So I think it a good idea not to spread my attention to JDBC. However, I catch the implication that IBMers hang out over there. Maybe somebody could agitate there for a fix to the operator delete mismatch in the ODBC driver. Does LibreOffice have a minister of external affairs, so to speak? I think the first step toward such an approach should be a new bug report on which I can hang stack backtraces and so forth, right? OTOH, I hesitate to clutter up the bug tracker when OO.o already resolved the problem INVALID. I don't think there are many db2 users on this list, or even on the users list. Yes, whineI feel lonely/whine. On Wed, 2011-08-17 at 19:19 +0200, Alexander Thurgood wrote: [snip] I had a trawl in my old dba messages, and found a reference to a problem where OOo did not respect the Concurrency and SCROLL_SENSITIVITY settings that were being passed by the driver from the DB server connection. Perhaps this is where your problem lies ? http://www.mail-archive.com/dba-cvs@openoffice.org/msg00858.html Well, I do not see a parameter to adjust that in my data source configuration. Does that mean that LibreOffice is setting the (connection?) attributes on its own? Is there a reason why these should have changed since ubuntu-natty? This i just a long way to say I dunno. On Wed, 2011-08-17 at 19:22 +0200, Alexander Thurgood wrote: Le 17/08/11 16:30, Terrence Enger a écrit : Possibly a wild goose chase, but I also found this : http://openoffice.2283327.n4.nabble.com/ResultSetType-Settings-in-Openoffice-Base-td2783193.html My case is different in that the failing query can be as simple as select * from AA6411. Still, this is a good reminder that macro coding is available for exploring attributes that the GUI does not make manifest. Thanks, Terry. -- Unsubscribe instructions: E-mail to discuss+h...@documentfoundation.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.documentfoundation.org/www/discuss/ All messages sent to this list will be publicly archived and cannot be deleted
