AutoMark range w out scrolling down and works in openoffice

[dsteved]

EXCELLENT!!! Very useful in business. It works in openoffice (latest edition) . Just go into macro area and run the _click macro.
The reason why it is great is because you delete row with out deleting rows like Walkenbacks search form for Excel (new record routine etc.) Why reserve a whole row is my data uses only 50 cells to the right. A whole 1028 to the right. I could have something else out to the right (In over 1000 columns). Well done!!!!
For latter, below
Attached , Hopefully, is a file that had code for finding the last NonBlank row in a column. You could loop through as save the highest row number without marking thousands of rows down. Free code by Villoroy and another person.
Way in the future, Copy Paste is a better idea then Cut and Paste which is what you used. But most of the time it makes no difference.
GetHublastCel.ods

[rafaelhlima]

Hi! Thanks for the feedback.

Way in the future, Copy Paste is a better idea then Cut and Paste which is what you used. But most of the time it makes no difference.

I am preparing a new version 0.10 (to be released soon) that changes the logic. I'm using mainly RemoveRange to delete empty rows/columns in the selected range. No Copy/Paste. There's also a new "Fast mode" that uses DataArray, which are many times faster, but they do not maintain formatting.

Attached , Hopefully, is a file that had code for finding the last NonBlank row in a column. You could loop through as save the highest row number without marking thousands of rows down. Free code by Villoroy and another person.

Thanks for the code. I learned some things from it, but I won't be able to use it for the upcoming new version.

It works in openoffice (latest edition)

It is cool that it works in OpenOffice. However, in future versions this extension will use API that are exclusive to LibreOffice. So just warning that the extension may not be compatible with OO in the future.

[dsteved]

DelBlankRws.ods loops (with Villoroy's  free code) column to column in range and saves the highest row number , then runs your delete rows sub.  You can have it if you think it would be useful. Either way. It is better than scrolling down thousands of rows.                                                                                       You do a great job                                                                                                   steve dulaney

…

-----Original Message----- From: Rafael Lima ***@***.***> To: rafaelhlima/remove_blank_cells ***@***.***> Cc: dsteved ***@***.***>; Author ***@***.***> Sent: Tue, Feb 8, 2022 1:47 pm Subject: Re: [rafaelhlima/remove_blank_cells] AutoMark range w out scrolling down and works in openoffice (Issue #5) Hi! Thanks for the feedback. Way in the future, Copy Paste is a better idea then Cut and Paste which is what you used. But most of the time it makes no difference. I am preparing a new version 0.10 (to be released soon) that changes the logic. I'm using mainly RemoveRange to delete empty rows/columns in the selected range. No Copy/Paste. Attached , Hopefully, is a file that had code for finding the last NonBlank row in a column. You could loop through as save the highest row number without marking thousands of rows down. Free code by Villoroy and another person. — Reply to this email directly, view it on GitHub, or unsubscribe. Triage notifications on the go with GitHub Mobile for iOS or Android. You are receiving this because you authored the thread.Message ID: ***@***.***>