You are not logged in.
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.
Pages: 1
Topic closed
Hi,
How can we allow users to move/reorder rows and columns?
Regards,
R
Offline
Hi, currently it's impossible to do that by dragging mouse. It will be supported in future versions.
To copy/move a range (rows or columns) in current versions by programming, use the PartialGrid:
// -1 means all rows (entire column)
var range = new ReoGridRange(0, 0, -1, 1);
// set cells sample data and borders
sheet[range] = new object[] { "A", "B", "C" };
sheet.SetRangeBorder(range, ReoGridBorderPos.All, ReoGridBorderStyle.SolidBlack);
// copy a range into memory (including data and borders)
var pg = sheet.GetPartialGrid(range);
// copy to worksheet from memory (like paste)
sheet.SetPartialGrid(new ReoGridRange(0, 3, -1, 1), pg);
// remove original range (like cut)
sheet.RemoveRangeBorder(range, ReoGridBorderPos.All);
sheet.DeleteRangeData(range);Or use copy/paste/cut methods directly. (some bugs in copy/paste/cut from 0.8.7, they will be fixed in 0.8.8)
thanks, Jing
Last edited by Jingwood (2014-10-31 00:20:37)
Offline
Hi Jing,
How should I enable dragging rows and columns by mouse?
It is not enabled by default.
Regards,
R
Offline
Ah I misread it, "impossible to do that by dragging mouse"!
When the new version is expected?
Regards,
R
Offline
I think it should be available after 2-3 weeks. The version 0.8.8 is planning to be released with some new features such as Excel loading/saving. I will try to add this in the release.
Last edited by Jingwood (2014-10-31 06:30:52)
Offline
This feature has been implemented from 0.8.8.0 version.
Offline
Pages: 1
Topic closed