[sw-issues] [Issue 112163] Multiple "sheets" in Writ er
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=112163 User timdeaton changed the following: What|Old value |New value CC|''|'timdeaton' --- Additional comments from timdea...@openoffice.org Mon Jun 7 03:43:06 + 2010 --- The "tabs" in issue 12686 would be separate odt files that just APPEAR together, much like the tabs in Mozilla Firefox. The "tabs" in OO.o Calc may be thought of as separate documents, but they are all part of ONE ods file. I believe the Calc-style tabbed sheets is what dotancohen is after, and I think that would be an excellent improvement for Writer. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sw.openoffice.org For additional commands, e-mail: issues-h...@sw.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sw-issues] [Issue 97112] templates listed by titles , not filenames
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=97112 --- Additional comments from timdea...@openoffice.org Fri Apr 2 04:49:28 + 2010 --- In my opinion, the "Title" field should always default to the Filename any time a document is saved with a new filename. I have recently discovered that when I make documents using these templates, the "Title" of the new document is the "Title" of the original template. And since the "Title" is what shows up at the top of the screen when someone opens that document, that can be VERY confusing. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sw.openoffice.org For additional commands, e-mail: issues-h...@sw.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 56938] Need [ctrl]-["] to copy co ntents of cell above active cell
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=56938 --- Additional comments from timdea...@openoffice.org Sat Oct 24 16:25:22 + 2009 --- I just tested this again in version 3.1.1, and it still is not there. Is there any likelyhood of getting it added in the near future? - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[framework-issues] [Issue 68223] Allow to use templates wit h the same title in the same group.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=68223 User timdeaton changed the following: What|Old value |New value CC|'cornouws'|'cornouws,timdeaton' - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@framework.openoffice.org For additional commands, e-mail: issues-h...@framework.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sw-issues] [Issue 97112] templates listed by titles , not filenames
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=97112 User timdeaton changed the following: What|Old value |New value CC|''|'timdeaton' - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sw.openoffice.org For additional commands, e-mail: issues-h...@sw.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sw-issues] [Issue 97112] templates listed by titles , not filenames
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=97112 --- Additional comments from timdea...@openoffice.org Wed Jun 24 03:42:11 + 2009 --- Correction to my earlier post. On re-reading, I guess issue 68223 IS talking at least partially about this same bug. But I found the thread there to be difficult to follow and misunderstood it. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sw.openoffice.org For additional commands, e-mail: issues-h...@sw.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sw-issues] [Issue 97112] templates listed by titles , not filenames
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=97112 --- Additional comments from timdea...@openoffice.org Wed Jun 24 03:32:29 + 2009 --- This is MOST DEFINITELY a defect. It is exactly what I wrote about in Issue 102756 on 6/14/09, which has now been closed as a "duplicate of 68223. (It appears to me that 68223 is a related, but different bug.) I had an existing template named "ltr.PersTemplate.ott". It lives at: c:\Documents and Settings\Tim\Application Data\OpenOffice.org\3\user\template\" When I decided to create the new template, I navigated to that directory, opened that .ott file, and then chose |File|Save As| to rename it as a template filetype to "ltr.PersTemplate5x8.ott" (making sure it got saved in that same directory). I then made my changes and saved it again (not 'save as', just 'save'). On the 14th, I started Writer and clicked on the dropdown arrow beside the NewFile icon (first icon on the left), then chose |Templates and Documents|. I immediately knew something was wrong, because the "ltr.PersTemplate5x8.ott" template name was not in the list. I then selected the original "ltr.PersTemplate.ott" template. But what opened was a new document based on the "..5x8.." template. I then navigated back to the directories the two templates live in. Both files were still there. I opened both files and started looking thru the Properties of both files. I also used Windows Explorer to check the properties of both files. What I found was that in both files the "Title" field shown in the Description tab of the window that appears when you click |File|Properties| still showed the original template file's name. (The correct filenames appeared in all other 'Properties' locations I found.) In the "..5x8.." file, I changed that field to its proper filename, saved it, and closed both template files. I then went back to the dropdown arrow beside the NewFile icon, chose |Templates and Documents| again, and now both templates appeared in the file list. And clicking on each name now opened a new doc with the contents of the proper template. Basing the list of templates in the |Templates and Documents| list on an internal "title" field rather than on the actual template file names is an invitation to corruption. Most users are never going to even be aware that the "title" field exists, much less be aware that they need to change it. So if OOo is going to use that field, then not automatically changing the "title" field to agree with the actual filename is indeed a defect. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sw.openoffice.org For additional commands, e-mail: issues-h...@sw.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sw-issues] [Issue 102756] cloned template name prob lem
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=102756 --- Additional comments from timdea...@openoffice.org Thu Jun 18 15:11:12 + 2009 --- The original template is named "ltr.PersTemplate.ott". It lives at: c:\Documents and Settings\Tim\Application Data\OpenOffice.org\3\user\template\" When I decided to create the new template, I navigated to that directory, opened that .ott file, and then chose |File|Save As| to rename it as a template filetype to "ltr.PersTemplate5x8.ott" (making sure it got saved in that same directory). I then made my changes and saved it again (not 'save as', just 'save'). On the 14th, I started Writer and clicked on the dropdown arrow beside the NewFile icon (first icon on the left), then chose |Templates and Documents|. I immediately knew something was wrong, because the "ltr.PersTemplate5x8.ott" template name was not in the list. I then selected the original "ltr.PersTemplate.ott" template. But what opened was a new document based on the "..5x8.." template. I then navigated back to the directories the two templates live in. Both files were still there. I opened both files and started looking thru the Properties of both files. I also used Windows Explorer to check the properties of both files. What I found was that in both files the "Title" field shown in the Description tab of the window that appears when you click |File|Properties| still showed the original template file's name. (The correct filenames appeared in all other 'Properties' locations I found.) In the "..5x8.." file, I changed that field to its proper filename, saved it, and closed both template files. I then went back to the dropdown arrow beside the NewFile icon, chose |Templates and Documents| again, and now both templates appeared in the file list. And clicking on each name now opened a new doc with the contents of the proper template. I hope that helps. It seems unnecessarily complex tho. In MS Office 97, all I have to do to create a template is to give it the correct extension and put it in the proper directory. MS Office then uses the actual filename, and I don't have to worry about any internal properties fields. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sw.openoffice.org For additional commands, e-mail: issues-h...@sw.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sw-issues] [Issue 102756] cloned template name prob lem
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=102756 Issue #|102756 Summary|cloned template name problem Component|Word processor Version|OOO310m11 Platform|PC URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|editing Assigned to|writerneedsconfirm Reported by|timdeaton --- Additional comments from timdea...@openoffice.org Sun Jun 14 01:58:59 + 2009 --- A few days ago I opened an existing Writer template (the actual .ott file in ..\OpenOffice.org\3\User\Template under Application Data), modified it and saved it to a new name. Today I couldn't find the new one in the Templates list (under the "New" icon, then "Templates and Documents), but when I tried to use the original template, the new one was what appeared. It turns out that when I gave a new name to the cloned/changed template, that name change was not made everywhere it should have been. The "Title" field shown in the Description tab of the window that appears when you click |File|Properties| still showed the original template file's name. And that's the name that the Templates list (under the "New" icon) displays. This needs to be fixed so that when you rename a template, that new name is reflected everywhere. In fact, it would probably be better if the Templates list was changed so that it showed the actual filename instead of an internal "Description" title. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sw.openoffice.org For additional commands, e-mail: issues-h...@sw.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[framework-issues] [Issue 94561] allow separate default fol ders for different document types
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=94561 --- Additional comments from [EMAIL PROTECTED] Fri Oct 3 02:00:16 + 2008 --- Depending on how it's implemented, I think it could be very useful. But what I think of when reading your suggestion is something MS Office has always done, and which I assumed OO was already doing as well. I don't really have the experience with OO to know, because most of my work so far is still in MS Office. (I hope to change that after v3.0 is finalized.) My OO work has been limited thus far to either creating or opening one file, working on it, saving it, and then closing the file and the whole program. Word, Access, and Excel always open looking at their default directories. But if I tell Excel to go get a file in xyz folder, it remembers that for the rest of the session unless I tell it something else. Any old file I had open will remember it's home and be saved back there, but any new file I create & save will default to that xyz folder. If that's not how OOo already works, then I would consider that a bug in desperate need of being fixed. -- Tim - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[framework-issues] [Issue 90463] PATHS for user files missi ng from Tools|Options
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=90463 --- Additional comments from [EMAIL PROTECTED] Thu Oct 2 02:24:48 + 2008 --- Cornouws, thank you for your response. Rather than continuing here, I've now done as rainerbielefeld suggested. I created a new Issue #94561 and responded to you there. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[framework-issues] [Issue 94561] allow separate default fol ders for different document types
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=94561 Issue #|94561 Summary|allow separate default folders for different document |types Component|framework Version|OOo 3.0 Beta 2 Platform|PC URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|ENHANCEMENT Priority|P3 Subcomponent|ui Assigned to|tm Reported by|timdeaton --- Additional comments from [EMAIL PROTECTED] Thu Oct 2 02:17:52 + 2008 --- I would like to be able to set separate default paths (under |Tools|Options|OpenOffice.org|Paths|) for each type of document (Writer, Calc, Impress, Base). As a heavy user of Microsoft Office for more than 10 years, I have so many of each type of files that I like to keep them segregated into their own directories under "My Documents". (I'm running Windows XP Home SP2.) I originally mentioned this as a 2nd comment in a bug-report I had filed (closed Issue 90463), and 'cornouws' didn't think it was a good idea, because the files ought to be separated by subject matter and not by file type. I can appreciate that. That's what we do where I now work - a separate folder for each client. But there are also many times where subjects don't seem predictable or users just don't have the time & patience to organize, and hundreds of documents from a dozen different programs all end up in one big mess in the 'My Documents' folder. At my last employer, that was the norm. Having the ability to set MS Office up on their computers and at least default all spreadsheets to an 'Excel' folder and all word-processing documents to a 'Word' folder helped a great deal. And having one default place for all my Access databases and nothing else also made life much easier. THAT's why I'd like to be able to set such defaults. The user wouldn't have to have separate folders if he didn't want to, and you can always override them and save your documents someplace else. But making those separate defaults possible at least provides a minimum level of organization - especially for those who accept Microsoft's default of hiding file extensions. Thanks, Tim - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[framework-issues] [Issue 90463] PATHS for user files missi ng from Tools|Options
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=90463 --- Additional comments from [EMAIL PROTECTED] Sun Aug 10 01:27:28 + 2008 --- Thanks, Cor. I've now got OOo 3 beta2, and checked it. The "My Documents" document type is indeed back in beta2. Is there any chance of getting additional document types added, to allow separate default paths for Writer, Calc, Base, etc? - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 90476] Image cropping in Calc nee ds mouse tools
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=90476 --- Additional comments from [EMAIL PROTECTED] Thu Jul 10 01:29:27 + 2008 --- The apostrophe problem had nothing to do with OpenOffice. That was a problem with this website at the time I was typing that message. Apparently it's not a problem tonite, so I don't know if it was a one-time glitch or if it's something that's been fixed since my original comments. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 90476] Image cropping in Calc nee ds mouse tools
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=90476 Issue #|90476 Summary|Image cropping in Calc needs mouse tools Component|Spreadsheet Version|OOo 3.0 Beta Platform|PC URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|editing Assigned to|spreadsheet Reported by|timdeaton --- Additional comments from [EMAIL PROTECTED] Sat Jun 7 17:32:51 + 2008 --- I have long found that when I need to print something from the computer screen, the easiest way to do it was to hit PrintScreen, then paste it into an Excel spreadsheet, then crop and resize it till I have what I want. I just tried the same thing using OOo Calc 3.0Beta, and discovered that it is much more difficult. Calc brings up a window with measurements you can change, and its own snapshot of the graphic that shows where you are moving the borders to. It works, but it is hard to get it just right. You cannot see it well, and must often invoke the tool, change the measurements, and quit the tool several times to get it just where you want it. PLEASE add a mouse tool that can be used directly on the image in the spreadsheet. The cropping icon could still bring up the window, and then a button in that window could close the window and replace it with the mouse tool. Thanks, Tim (WinXP Home SP2, AMD Duron 950 processor) PS: Why does hitting the apostrophe while I_m typing (like just then! I put a line where I tried to put the apostrophe.) bring up a QuickFind tool instead. That_s very frustrating! - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[framework-issues] [Issue 90463] PATHS for user files missi ng from Tools|Options
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=90463 Issue #|90463 Summary|PATHS for user files missing from Tools|Options Component|framework Version|OOo 3.0 Beta Platform|PC URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|ui Assigned to|tm Reported by|timdeaton --- Additional comments from [EMAIL PROTECTED] Sat Jun 7 03:58:19 + 2008 --- I just downloaded & installed OOo 3.0.0 Beta tonite (Jun 6 2008). While setting it up, I discovered that there is no place to set the default path to the user's files. In v2.4 under |Tools|Options|OpenOffice.org|Paths| there is a document type called "My Documents" where you can set the path. But that document type is missing from 3.0.0 Beta. Actually, I would like to be able to set separate default paths for each type of document (Writer, Calc, Impress, Base). As a heavy user of Microsoft Office for more than 10 years, I have so many of each type of files that I like to keep them segregated into their own directories under "My Documents". (I'm running Windows XP Home SP2 on a 'white-box' pc with an AMD Duron 950mhz processor & 1gb ram.) Thanks, Tim - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 54039] add NOPRINTROW and NOPRINT COL functions
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=54039 --- Additional comments from [EMAIL PROTECTED] Sun May 18 03:55:22 + 2008 --- Please do not close this out. And please DO try to find someone to work on it. A "NOPRINT" function (especially for rows) really is a very handy tool to have whenever you have many rows of data but only want a few of them to print out. (For instance, you have a list of 100 products, but only want those with a quantity greater than zero to print.) - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 56938] Need [ctrl]-["] to copy co ntents of cell above active cell
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=56938 --- Additional comments from [EMAIL PROTECTED] Sun May 18 03:39:58 + 2008 --- I just tested this in v2.4, and it does not work. I guess it's not something many people use, since no one else has commented on this thread. I can understand that, since I had been heavily using Excel for 9 or 10 years before discovering this feature. But once I DID discover it, I've used it probably every day. It would definitely be nice to have in OO Calc. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 42464] [RFE] allow to link tables from dfferent sources into one database file
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=42464 User timdeaton changed the following: What|Old value |New value CC|'ibarnard,martin9959,maxwe|'ibarnard,martin9959,maxwe |ber,pmike'|ber,pmike,timdeaton' - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 8949] [RFE] query on several tabl es of a DBase/Calc database
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=8949 --- Additional comments from [EMAIL PROTECTED] Fri Dec 29 07:47:05 -0800 2006 --- I agree that doing queries on multiple tables (or on a combination of tables & other queries, or on multiple other queries) should be a top priority. I'm an Access97 user, and 80%-90% of everything I do in Access involves queries on multiple datasets (tables, other queries, or both). Base is pretty near useless to me unless it can do that, and it needs to be able to do it using Access tables as well as dBase (both ADO/Access2000 and the older DAO/Access97 tables). There's no way I can migrate to Base until it does. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 8949] [RFE] query on several tabl es of a DBase/Calc database
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=8949 User timdeaton changed the following: What|Old value |New value CC|'ggabriel,hwoarang,mandrei|'ggabriel,hwoarang,mandrei |ana,mfedyk,mhatheoo,sgauti|ana,mfedyk,mhatheoo,sgauti |' |,timdeaton' - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 4904] Dynamic ranges of named ce lls, OpCode ocRange
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=4904
--- Additional comments from [EMAIL PROTECTED] Sat Jan 14 19:26:11 -0800
2006 ---
Perhaps this is unnecessary effort, but I spent tonite looking back at all the
other issues closed into this one, in order to understand the problem. It
helped. With 22 other issues (so far) combined into this one, I decided it
might help generate movement on this if all of that history was summarized
below:
Issues Problem
4904(May 2002)(empii)
Cell C9 has name defined "test1"
Cells c10,c11 contain 1(numeric value)
cell d9 contains formula =SUM(test1:c11)
Cell d9 results "#NAME?"
Neither the SUM nor the COUNT functions respect references
to named cells.
5052(Jul 2002)(empii)
Excel allows using named ranges in formulas. When importing Excel
sheets that use this feature formulas get screwed up.
11799(Feb 2003)(jwlemke)
The following cell contents works fine with Excel, but gives an
error 508 with OO.
=SUM(INDIRECT("C"&F8+1):C8)
The only way I've found to make this work with OO is:
=SUM(INDIRECT("C"&F8+1&":C8"))
20587(Oct 2003)(timdeaton)
Column F contains the following formula:
(row 8): =IF(E8=0,"",F$6+SUM(E$7:OFFSET(F8,0,-1)))
When I open this spreadsheet in OpenOffice.org (version 1.1.0)
the formula is corrupted to read as follows:
(row 8): =IF(E8=0;"";F$6+SUM(#NAME!(E$7;OFFSET(F8;0;-1
26004(Mar 2004)(gardenal)
while Excel allows you to use dynamic ranges in SUM(), Calc does not.
32483(Aug 2004)(dankegel)
=sum(a1:a2:a3) and =sum(d23,d7) display as #NAME
displayed fine in Microsoft Office and in Gnumeric
37351(Nov 2004)(micrond)
when importing an Excel spreadsheet containing formula
"=IF(COUNT(C9:E9:G9:I9:K9:M9:O9)=0;"";((C9+E9+G9+I9+K9+M9+O9)/COUNT(C9:E9:G9:I9:K9:M9:O9)))"
in OpenOffice version 680m59 and 1.1, the formula is not imported
properly. The problem seems to be in the enumeration C9:E9:I9:...
that is shown as "#name?(#name?(#name?(..."
38413(Dec 2004)(urlgrrrl)
The following formula imported from Excel returns Err:508:
=CORREL($G60:INDIRECT(CONCATENATE("g"&F6));H60:INDIRECT(CONCATENATE("h"&F6)))
The problem appears to be with specifying the cell ranges using
INDIRECT. Rewriting the formula as follows does work:
=CORREL($G60:G244;H60:H244)
This problem was reproducted in OOo 2.0 (1.9.62) of 12 Nov.
42678(Feb 2005)(patrick_catel)
Preliminary note: I am french and use french OOo 1.1.4 version.
Involved function names are SOMME and DECALER in french,
may be SUM and SHIFT in english.
Problem is
SOMME and DECALER functions work separetaly. But to write in a cell
of an OOo calc-sheet =SOMME(A3:DECALER(A8;-1;0)) appears impossible
[the cell references are example] , whatever the way of doing it
(import from Excel sheet or direct typing).
43804(Mar 2005)(tulitanssi)
The sumif function gives err:508 when args to it are complex,
e.g. indirect function etc.
46210(Apr 2005)(lucianomw)
The offset function does not return a reference when used as
parameter to another function. This produces an error message in the
cell that was calling the function.
47976(Apr 2005)(nbwepaul)
Importing a XLS file into OOo Calc it fails to correctly import some
things. It shows Err:508 (Error: in bracketing) instead. It seems to
happen when a range is used that contains a formula rather than a
fixed cell address. This real-life example works in Excel but becomes
Err:508 when imported into Calc:
=SUM($'Dept Sales'.$B119:OFFSET($'Dept Sales'.$B119;0;+($B$3-1);1;1))
48761(May 2005)(sinewalker)
When entering a cell range into calc for the SUM() function, it does
not parse the colon syntax if I use a reference function such as
INDIRECT(). Non-range formulas do work however.
SUM(INDIRECT(ADDRESS(CELL("ROW";A8);3)):INDIRECT(ADDRESS(CELL("ROW";A10);3)))
results in Err508 (missing parameter).
51186(Jul 2005)(tommyads)
Enter
=SUM(I2:ADDRESS(ROW()-1;COLUMN();4))
in any cell zzz within column I below row 2.
This should always give the sum of all cells above the cell zzz,
starting from the second row (my first row contains a Header).
But this does not work!!!
53262(Sep 2005)(opp)
[sc-issues] [Issue 4904] Dynamic ranges of named ce lls, OpCode ocRange
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=4904 --- Additional comments from [EMAIL PROTECTED] Mon Oct 31 18:35:12 -0800 2005 --- Has there been any progress on this issue? Any idea yet when a resolution is likely to see the light of day? - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 56945] New - need more help for c onnecting to other-type databases
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=56945 Issue #:|56945 Summary:|need more help for connecting to other-type databases Component:|Database access Version:|OOo 2.0 Platform:|All URL:| OS/Version:|Windows XP Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|ENHANCEMENT Priority:|P3 Subcomponent:|none Assigned to:|dbaneedsconfirm Reported by:|timdeaton --- Additional comments from [EMAIL PROTECTED] Sat Oct 29 19:45:30 -0700 2005 --- I was hoping to be able to convert some Access97 databases into OOo Base. I saw the |Tools|Options|OOo Base|Connections| references to ODBC and ADO drivers, and tried to figure out how to use them, but have had little success. The help files talk about choosing |Edit|Database|Properties|, but it took me forever to figure out (just a minute ago) that I had to do that in a "new", blank database. Now I still don't know how to make that data available to a different (OOo) database. All I'm used to is Access 97, and being able to easily link to tables in other projects. I look at "linking" and "importing" and whatever else I can think of in the OOo help files, and can't find anything that seems to relate. Anything that you can add to either the program and/or the help files to help MS Access users (and database neophytes) understand how to get to their Access data and how to use that data from within OOo would be very helpful. Particularly, I expect there are a lot of Access97 users who would be attracted to OOo. Part of my confusion tonite was that I didn't think I could use the ADO driver (since Access97 uses DAO instead). Please target those users and make it easy for us to understand how to migrate to OOo. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 56938] New - Need [ctrl]-["] to c opy contents of cell above active cell
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=56938 Issue #:|56938 Summary:|Need [ctrl]-["] to copy contents of cell above active |cell Component:|Spreadsheet Version:|OOo 2.0 Platform:|All URL:| OS/Version:|Windows XP Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|FEATURE Priority:|P3 Subcomponent:|editing Assigned to:|spreadsheet Reported by:|timdeaton --- Additional comments from [EMAIL PROTECTED] Sat Oct 29 15:20:54 -0700 2005 --- One Excel97 feature I only recently discovered, but which I now use heavily, is the [ctrl]-["] shortcut. It copies TO the active cell the contents of the cell above it. IE: if cell A1 contains the number "12.5", and I'm in cell A2 and hit [ctrl]-["], then "12.5" is copied to cell A2. If cell A1 contained the function "=b6", then "=b6" would be copied to cell A2. It would be very helpful to have that shortcut in OpenOffice. (In Office97, the same shortcut works in Access, copying the contents of the same field of the previous record.) - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 56936] problem with OFFSET() fun ction
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=56936 --- Additional comments from [EMAIL PROTECTED] Sat Oct 29 15:08:39 -0700 2005 --- (I had also saved it as an .ods file instead of .xls.) - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 56936] problem with OFFSET() fun ction
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=56936 --- Additional comments from [EMAIL PROTECTED] Sat Oct 29 15:04:46 -0700 2005 --- After editing the formula to see how OFFSET() would work inside the SUMIF() and SUBTOTAL() functions (which both returned a "#NAME?" error), when I returned the formula to it's original state (as written above), it too now returns a "#NAME?" error. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 56936] New - problem with OFFSET( ) function
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=56936 Issue #:|56936 Summary:|problem with OFFSET() function Component:|Spreadsheet Version:|OOo 2.0 Platform:|All URL:| OS/Version:|Windows XP Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P3 Subcomponent:|code Assigned to:|spreadsheet Reported by:|timdeaton --- Additional comments from [EMAIL PROTECTED] Sat Oct 29 14:36:32 -0700 2005 --- When I use the Offset() function inside a SUM() function, it results in an error message. I have many Excel97 spreadsheets using the offset function, generally inside another function. Used in an IF() function, it seems to work okay. But when I loaded an Excel97 sheet with the formula =-SUM(H$6:OFFSET(H147;-1;0)) in E147 Yesterday it gave me an "Error 508" message in that and all dependent cells. Today, the same formula in the same place gave me an "#N/A" error message. I use this type of formula so that I can move its row anywhere I want it in the table and it will always sum all rows above it. Anyway, I guess this exposes two problems: 1. Why is OFFSET() not working inside SUM() the same way it works inside IF()? 2. Why does it produce one error one day, and a different error the next day (in the same cell of the same UNEDITED spreadsheet)? - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 54039] New - add NOPRINTROW and N OPRINTCOL functions
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=54039
Issue #:|54039
Summary:|add NOPRINTROW and NOPRINTCOL functions
Component:|Spreadsheet
Version:|OOO 2.0 Beta2
Platform:|All
URL:|
OS/Version:|All
Status:|UNCONFIRMED
Status whiteboard:|
Keywords:|
Resolution:|
Issue type:|FEATURE
Priority:|P3
Subcomponent:|code
Assigned to:|spreadsheet
Reported by:|timdeaton
--- Additional comments from [EMAIL PROTECTED] Wed Aug 31 07:37:53 -0700
2005 ---
I would like to urge you to add a NOPRINTROW and a NOPRINTCOL function to
OpenOffice. I'll explain what I mean below, and include the details of what I
do now (in hopes that it helps). I've never seen what I do in print, but
because of how frequently I use it, I'd be very surprised if many others
didn't find such functions to be almost indispensible once they found them.
The first spreadsheet program I used (ancient shareware: ExpressCalc) had a
function called NOPRINT. I could put it in a cell by itself, or use it inside
another function (like IF(G15=0,NOPRINT,"")). Either way, if any cell in a
given row evaluated to "NOPRINT", then that row would not be printed when I
printed the spreadsheet.
This function was very handy whenever I wanted to build a re-usable table that
might allow for 100 rows of data entry & related calculations, but in which
not all rows are likely to be filled every time. For instance, I might have
an invoice sheet listing 30 different possible items, but I only want the 5
that happen to have quantities filled in to actually show up on the printout.
Unfortunately, I've never found a similar function in any other spreadsheet
program. However, in Excel97, I can achieve the same result using a couple of
macros, some predefined range names, and a "Print" button that runs the
macros. I define a convenient column with the range name "NOPRINT", the cell
that I want to appear (after printing) at the upper-left corner of the screen
as "PRESTART", and the cell that I want to be active when printing is finished
as "START". If there happen to be any columns I don't want printed, I define
them in a fourth range name called "COLNOPRINT". Finally, in the NOPRINT
column, I put the NA() function on each row that I never want printed, and I
use an IF() statement that evaluates to NA() unless the row should be printed.
Then, the macros basically do this:
1) Unprotect the sheet.
2) Go to the PRESTART and START cells to get to the view I want to return to.
3) Create a "TempView" view for later use.
4) Hide any columns included in a COLNOPRINT range.
5) Find all cells in the NOPRINT column that evaluate to NA(), and hide those
rows.
6) Print the sheet.
7) Return to the "TempView" view (to undo all the things hidden in this
process).
8) Delete the "TempView" (so it doesn't interfere with future use and other
sheets)
9) Protect the sheet.
The macros are as follows:
'
'==
' FindRange Function
' Macro from MS Excel Tech support 5/1/96 by Paul Peck
' to find if a range exists
'
'
Function FindRange(r)
Dim x As Range
On Error Resume Next
Set x = ActiveSheet.Range(r)
On Error GoTo 0
If Not (x Is Nothing) Then FindRange = True
End Function
'
'==
' Print_Valid Macro
' Macro recorded & edited 11/24/99 by Tim Deaton
'
'
Sub Print_Valid()
On Error GoTo ErrorMsg
ActiveSheet.Unprotect
'set up & create the view to return to when finished
If FindRange("PRESTART") Then
Application.Goto Reference:="PRESTART", Scroll:=True
End If
If FindRange("START") Then
Application.Goto Reference:="START"
End If
ActiveWorkbook.CustomViews.Add "TempView", True, True
'Hide any columns that should not be printed
If FindRange("COLNOPRINT") Then
Application.Goto Reference:="COLNOPRINT"
Selection.EntireColumn.Hidden = True
End If
'select "noprint" range, then "n/a" cells, then hide "n/a" rows
Application.Goto Reference:="NOPRINT"
Selection.SpecialCells(xlFormulas, 16).Select
Selection.RowHeight = 0
'delete any defined print range so the entire visible area will print
If FindRange("Print_Area") Then
ActiveWorkb
