Bug 54552

I reproduce the described behavior, but I am not sure that it is not intended because it allows to know all cells which are involved in the current sheet.

@Kohei: please, can you confirm if this behavior is intended or not?

Best regards. JBF

This is very much intended behavior.

Actually wait, I misunderstood the description.  I would have expected the end of the data to be A1 in this case.  This is odd.

And this is a regression since which version?

(In reply to comment #3)
> I would have expected the end of the data to be A1 in this case. 

+1

If it was a new feature that would undermine all applications using the method gotoEndOfUsedArea

Please also look at the bug 54553 appears to be a direct consequence of this one.

(In reply to comment #4)
> And this is a regression since which version?

I do not know for sure but with version 3.5.0rc1 (nothing currently available for testing) the result is the expected one (A1 end of data).

Regards
Pierre-Yves

(In reply to comment #4)
> And this is a regression since which version?

LO 3.5.7.1 gives the expected result: A1 selected instead of C3.

Problem seems not to be connected to bug 54553. In LO 3.6.3.0+ (Build ID: 9d3af8d) bug 54553 is fixed and this one not.

Status set to new.

Best regards. JBF

Added regression keyword, accordingly to comment #4

Best regards. JBF

Hello

This bug could seem minor in the interface (user's keystroke <Ctrl><End>
and the cursor can go "further" than the last input cell) but IMHO it is
very inconvenient for applications : many (most) of them use
the gotoEndOfUsedArea method whose result is not the same !

Regards
Pierre-Yves

May be related to Bug 55712

Markus Mohrhard committed a patch related to this issue.
It has been pushed to "master":

http://cgit.freedesktop.org/libreoffice/core/commit/?id=40377a6e26aa61a1c0788cad1c97a10911d38da8

only use non blank cells in the visible data methods, fdo#54552



The patch should be included in the daily builds available at
http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
http://wiki.documentfoundation.org/Testing_Daily_Builds
Affected users are encouraged to test the fix and report feedback.

Markus Mohrhard committed a patch related to this issue.
It has been pushed to "libreoffice-3-6":

http://cgit.freedesktop.org/libreoffice/core/commit/?id=23e6bac62ef6482c287bb0f55c662ac2047ebb33&g=libreoffice-3-6

only use non blank cells in the visible data methods, fdo#54552


It will be available in LibreOffice 3.6.4.

The patch should be included in the daily builds available at
http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
http://wiki.documentfoundation.org/Testing_Daily_Builds
Affected users are encouraged to test the fix and report feedback.

Markus Mohrhard committed a patch related to this issue.
It has been pushed to "libreoffice-3-6-3":

http://cgit.freedesktop.org/libreoffice/core/commit/?id=c38b67a171615ddc444e0fe849e10d7cada74b6a&g=libreoffice-3-6-3

only use non blank cells in the visible data methods, fdo#54552


It will be available already in LibreOffice 3.6.3.

The patch should be included in the daily builds available at
http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
http://wiki.documentfoundation.org/Testing_Daily_Builds
Affected users are encouraged to test the fix and report feedback.

Hello

Verified as fixed with Version 3.6.4.0+ (Build ID: b1f308d) and Windows 7 64bits

Thank you very much :)

Regards
Pierre-Yves

Verified in LO 3.6.3.2

Thank you.

As part of our regular FDO management we are going back and checking regression versions to see earliest version we can confirm problem. I have been able to confirm this regression on:

Version 3.6.0.0.beta1

Changing version to reflect this