Apache OpenOffice (AOO) Bugzilla – Issue 49380
enable find and replace buttons when 'Search For' box is empty
Last modified: 2017-05-20 10:44:30 UTC
I would appreciate the ability to replace empty cells in the data block in a spreadsheet to have at least a single character (a period for instance). One of my tasks is using OpenOffice.org's XSLT filter feature to convert spreadsheet information to SQL or MySQL-specific insert statements to port data into these types of databases. But empty SQL fields are not generated from empty cells. I still need the presence of the empty SQL fields to keep the data aligned to the columns. This can be accomplished by at least enabling the find and replace buttons even when the 'Search For' box is empty. Currently I have to fall back onto Microsoft Office Excel to handle the fields and then open the spreadsheet into Calc.
One for the requirements team
OpenOffice.org Issue Tracker - Feedback Request. The Issue you raised is currently assigned to 'Requirements' pending review, but has not been updated within the last 3 years. Please consider re-testing with one of the latest versions of OOo, as the problem(s) may have already been addressed. Either use the recent stable version: http://download.openoffice.org/index.html or consider trying the new OOo 3 BETA (still in testing): http://download.openoffice.org/3.0beta/ Please report back the outcome so this Issue may be Closed or Progressed as necessary - otherwise it may be Resolved as Invalid in the future. You may also wish to search for (and note) any duplicates of this Issue that may have advanced further by checking the Issue Tracker: http://www.openoffice.org/issues/query.cgi Many thanks, Andrew Cleaning-up and Closing old Issues as part of: ~ The Grand Bug Squash, pre v3 ~ http://marketing.openoffice.org/3.0/announcementbeta.html
No change in Find and Replace dialog UI behavior in version 2.4 or 3 Beta. However I have noticed that blank cells are now preserved if at least one cell even in a later row and column has content. This satisfies the feature request. Thanks and keep up the good work - can't wait for OOo 3.
Created attachment 60352 [details] proposed patch for sc
Created attachment 60353 [details] proposed patch for svx
These are my proposed changes to support this requested functionality.
*** Issue 66555 has been marked as a duplicate of this issue. ***
*** Issue 44688 has been marked as a duplicate of this issue. ***
Eicke, this change is in demand. Is it possible that we integrate this patch for 3.3? Regards, KP. Kohei, thanks a lot for this enhancement!
Sigh.. forgot about this, sorry, grabbing issue from requirements queue.
Let's be aware of Issue 108087 also while we are at it. That touches on similar areas.
Created attachment 70124 [details] latest patch from ooo-build master
Created attachment 70125 [details] latest patch from ooo-build master
What is the expected date for integration of this patch? Regards, KP.
@kpalagin: see target milestone, OOo3.4
Eike, too many times issues miss their target milestone. I would greatly appreciate if this patch gets included in the code as early as possible. Kohei, is there a CWS for this patch? Regards, Kirill.
I'm adding this comment to all open issues with Issue Type == PATCH. We have 220 such issues, many of them quite old. I apologize for that. We need your help in prioritizing which patches should be integrated into our next release, Apache OpenOffice 4.0. If you have submitted a patch and think it is applicable for AOO 4.0, please respond with a comment to let us know. On the other hand, if the patch is no longer relevant, please let us know that as well. If you have any general questions or want to discuss this further, please send a note to our dev mailing list: dev@openoffice.apache.org Thanks! -Rob
Reset the assignee to the default "issues@openoffice.apache.org".