Hi,

Is it possible to change the position (or container) of the vertical scrollbar used in a grid?

In the example I have created, I have a very wide grid, 2 x width of screen and to show this I placed the grid on a Static sized panel; this works fine but the only problem is that the grid scrollbar can only be accessed by scrolling to the far right of the panel which actually make it unusable. Is there any way I can get the scrollbar to be in a fixed position so that it is visible at all times?

A couple of quick questions on grids...

1) Also, do you have plans to implement a horizontal scrollbar directly within the grid control? (if you did this would solve the above issue).

2) Are there any plans to implement "pinned" columns in grid? i.e. the ability to pin or fix the first X columns in a grid so that they remain visible if you scroll to the right? (assuming you implement a horizontal scrollbar that is).

3) Is it possible to synchronize the scrolling of two grids, so that if you scroll down a record in grid A then Grid B scrolls the same?

4) Do you have plans to implement a feature similar to AutoFilter in Excel in your grid control?

Thanks,

Craig.

asked 27 Apr '13, 21:18

Craig's gravatar image

Craig
1.1k245
accept rate: 6%


Hi Craig,

Let me quickly answer your questions

1) do you have plans to implement a horizontal scrollbar directly within the grid control? Yes. This is going to be released in May.

2) Are there any plans to implement "pinned" columns in grid? Yes. Coming in May.

3) Is it possible to synchronize the scrolling of two grids? No. What's the use case for this? What are you trying to achieve?

4) Do you have plans to implement a feature similar to AutoFilter in Excel in your grid control? What we've got is this: Demo: http://formspideronline.com/formspider/main.html?name=DemoMain#DemoInteractiveReport Tutorial: http://theformspider.com/learningcenter/tutorial-45-how-to-build-an-interactive-report/

Yalim

link

answered 28 Apr '13, 05:19

Yalim%20Gerger's gravatar image

Yalim Gerger ♦♦
1.8k5
accept rate: 15%

Hi Yalim,

Thanks for the response; I'm pleased to hear that horizontal scrollbars and pinned items will be supported in the upcoming release in May - excellent!!

Regarding two (or more) synchronized grids; we have implemented this sort of thing for a few scenarios, here are a couple of the most common...

1) You have a table with lets say 50 columns and you want to show all 50 on screen at once, we have done this is two or more grids stacked on top of each other, the top grid showing columns 1 through 20, grid 2 showing columns 21 through 40 and grid 3 showing columns 41 through 50.

2) You have two (or more) tables with a 1 to 1 relationship and you want to show data from both tables but it is better for the user for the data to be in two (or more grids) because more can be fit on screen without scrolling and/or it makes the grouping of logically related data easier.

I have built a small demo application that utilises the interactive report features including the filter option and this is great; however, what I was looking for specifically was the ability for the filter to show all possible values like it does in Excel for example, so rather than typing in criteria, you could select one or more values from an LOV.

A quick question for you regarding the filter feature, internally does it filter the data in the grid cache or does it requery the datasource with the filter applied to the where clause? The former would be preferable in most cases but the option to choose would be nice; if the query is re-issued, does it do so using bind variables for the filter values or does or hardcode the filter value into the where clause? Obviously the use of bind variables would be preferable.

Thanks,

Craig.

(28 Apr '13, 05:44) Craig

One other thing regarding the new horizontal scrollbar feature you are adding to grids, can you make it so that the scrollbar and be position on the let or right via a property setting?

For example...

<grid scrollbarposition="left"> )

(28 Apr '13, 09:39) Craig

I think moving vertical scrollbars to the left is unusual and also not so easy to implement. So i don't think we will implement this in near future.

(28 Apr '13, 11:29) oskansavli ♦♦

It is only unusual if you have not seen it often; I have seen it many times and some users prefer left sided scrollbars.

Historically left-sided scrollbars were more common in client-server environments and in recent years they have more and more moved to the right and I personally do prefer a right sided scrollbar but in any instance it would be better if the developer could determine the position rather than the framework.

(28 Apr '13, 12:00) Craig

Hi Craig,

As the answer of your previous question concerning the filter feature behavior: it requery the datasource with the filter applied to the where clause using bind variables for the filter values.

Regards,
Ibrahim

(29 Apr '13, 05:44) Ibrahim Sand... ♦♦

Hi Craig,

Just a comment on 3) Is it possible to synchronize the scrolling of two grids, so that if you scroll down a record in grid A then Grid B scrolls the same?

This is easy to implement already. 1 table / 2 or more grids: just create a single datasource, then create two grids on 1 panel using the same datasource. Scrolling on either grid will automaticaly sync the current row on the other grid since the two grids are using the same datasource.

2 tables / 2 or more grids: to keep these in sync works the same as creating a master/detail relationship, using the currentRowChanged event on the datasource (or the selectionChanged event on the grid). There is a demo and tutorial about that. You can have these events on all grids, so that a click on any grid will sync the other grid(s)

Regards, Michiel

link

answered 28 Apr '13, 10:37

Michiel%20A's gravatar image

Michiel A
5161749
accept rate: 13%

Hi Michiel,

Regarding 2) above, I have tried this already and it didn't work; I had two grids sharing the same datasource and the scrolling in them is totally independent; is there a special property I need to set to make this work?

For 3) above, I considered this but I thought that it would end up being just a master detail form, i.e. for the selected master row only the associated child rows would show whereas what I want is for all child rows to show.

Thanks,

Craig

(28 Apr '13, 11:37) Craig

Hi Craig,

On 2) You're right, i forgot. In order to keep the two grids from the same datasource in sync, you need to put a (dummy) action on the currentRowChanged event of the datasource. This will kee them in sync.

On 3) It just depends what you do on the master row changed event. You dont need to filter the detail rows, you could also setCurrenRow on the detil grid. That will leave all child rows in place. But i have no idea on such a usecase so don' t know for sure that will accomplish what you need.

best, Michiel

(29 Apr '13, 04:40) Michiel A

Hi Craig,

As Michiel mentioned, a Formspider event is needed to sync the grids. The currentRowChanged is the best event that can used in this case, but please note that this event does not trigger while using the grid's scrollbar, therefore it will not sync when the scollbar is used.

Regards,
Ibrahim

(29 Apr '13, 05:57) Ibrahim Sand... ♦♦
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×85
×8
×7

Asked: 27 Apr '13, 21:18

Seen: 1,714 times

Last updated: 29 Apr '13, 05:57


© Copyright Gerger 2017