ReoGrid Forum

Fast and powerful .NET Spreadsheet Component

You are not logged in.

Announcement

This forum has been archived and no longer accepts new user registrations. Please report your questions, problems, and feedback to the issue page of ReoGrid on GitHub. Thank you for your cooperation.

https://github.com/unvell/ReoGrid/issues

#1 2015-09-03 10:28:33

khurram.hits
Member
Registered: 2015-09-03
Posts: 18

MaxContentRow and MaxContentCol does not return user filled last row

in Version “0.8.9.2”, MaxContentRow and MaxContentCol does not return the user filled last row index/number and column index/number.

Instead of this, it returns the last row and last column of sheet, whether its filled or not.

Kindly fix it asap. Its urgent

Offline

#2 2015-09-03 10:34:23

Jingwood
Moderator
From: jing at reogrid.net
Registered: 2014-06-03
Posts: 615

Re: MaxContentRow and MaxContentCol does not return user filled last row

OK, thanks for the report. Will fix this as soon as possible, and make the next release once it done.

Offline

#3 2015-09-03 10:37:02

khurram.hits
Member
Registered: 2015-09-03
Posts: 18

Re: MaxContentRow and MaxContentCol does not return user filled last row

When I can expect this to be released? as I am stuck with this. I had no idea your product is not mature yet.

Offline

#4 2015-09-03 13:53:19

Jingwood
Moderator
From: jing at reogrid.net
Registered: 2014-06-03
Posts: 615

Re: MaxContentRow and MaxContentCol does not return user filled last row

I couldn't confirm this problem, MaxContentRow and MaxContentCol return expected value. Did you have borders on worksheet? borders will affect that values.

Offline

#5 2015-09-03 13:58:27

khurram.hits
Member
Registered: 2015-09-03
Posts: 18

Re: MaxContentRow and MaxContentCol does not return user filled last row

Kindly check this scenario;

1) Default rows for worksheet = 20
2) User enters values in just first 5 rows

Here CurrentWorksheet.MaxContentRow should return "5" or "4" (Index/Row# of last entered row)

Offline

#6 2015-09-03 15:40:12

Jingwood
Moderator
From: jing at reogrid.net
Registered: 2014-06-03
Posts: 615

Re: MaxContentRow and MaxContentCol does not return user filled last row

grid.CurrentWorksheet.Rows = 20;

grid.CurrentWorksheet[5, 0] = "hello";

MessageBox.Show(grid.CurrentWorksheet.MaxContentRow + "," + grid.CurrentWorksheet.MaxContentCol);

The result is 5,0.

I tried edit at 10 row, and it returns 9,0.
Please tell me your use case, or provide some code.

Offline

#7 2015-09-03 16:05:30

khurram.hits
Member
Registered: 2015-09-03
Posts: 18

Re: MaxContentRow and MaxContentCol does not return user filled last row

I got it. Below line was the issue as I had set ReoGridRange.EntireRange;

sheet.SetRangeDataFormat(ReoGridRange.EntireRange, CellDataFormatFlag.Number, null);

Thanks for your quick response and support.

Offline

#8 2015-09-07 03:01:26

Jingwood
Moderator
From: jing at reogrid.net
Registered: 2014-06-03
Posts: 615

Re: MaxContentRow and MaxContentCol does not return user filled last row

You are welcome!

Offline

Board footer

Powered by FluxBB