Search found 14 matches

by stoffman
Thu May 25, 2023 8:39 pm
Forum: VCL
Topic: GroupBy with multiple fields
Replies: 1
Views: 47375

GroupBy with multiple fields

Hi, How can do multiple group-by consolidation? As mentions in the docs that can be done, But I didn't find a way. For example suppose I wish to group by by both "Country" and "City": S:= TSummary.Create(nil); S.AddGroupBy(Data['Country']); S.AddGroupBy(Data['City']); S.AddMeasure( Data['City'], TAg...
by stoffman
Sat Apr 22, 2023 11:16 am
Forum: VCL / FMX
Topic: Performance issues and a bug
Replies: 0
Views: 31583

Performance issues and a bug

I'm working with a TDataset that contains 100,000 records. I noticed some a performance issue and while resolving it I also noticed a bug. 1. I'm using TZMemTable (zeoslib 8.0) which is a in memory TDataset (i.e. all the records are loaded into the memory) 2. I noticed that every time the grid acces...
by stoffman
Fri Apr 07, 2023 2:25 am
Forum: VCL / FMX
Topic: Grid view changes after sorting
Replies: 2
Views: 11832

Re: Grid view changes after sorting

Missing is the first state of the grid:
by stoffman
Fri Apr 07, 2023 2:24 am
Forum: VCL / FMX
Topic: Grid view changes after sorting
Replies: 2
Views: 11832

Grid view changes after sorting

To recreate:
1. The user scrolls vertically (to the right) and put into view a column that was not first visible
2. Then sorts by this column

The grid scrolls back back to the left (the sort is being maintained)

I'm using: windows 10, Lazarus 2.2.4, Grid 1.1
by stoffman
Wed Nov 02, 2022 6:23 am
Forum: VCL / FMX
Topic: TeeGrid and tab
Replies: 1
Views: 12478

TeeGrid and tab

How can I prevent the "tab" key to move between cells?

I want to reserve "tab" and "shift+tab" to move the focus between the controls on the form. not within the grid itself.

Thanks.
by stoffman
Tue Apr 26, 2022 12:47 pm
Forum: VCL / FMX
Topic: Bug - Pasting into a cell while in readonly mode
Replies: 1
Views: 14463

Bug - Pasting into a cell while in readonly mode

Hi, I have a gird with ReadOnly set to true. While I tried to copy data from one of the cells I accidently pressed ctrl+v (paste) and got the following error: "Dataset is read-only" That should never happen, if the grid is in ReadOnly mode it should block any attempts to change the content from user...
by stoffman
Sat Apr 23, 2022 8:14 pm
Forum: VCL / FMX
Topic: Bug/Usability Issue: Column with data renders as empty
Replies: 2
Views: 14917

Re: Bug/Usability Issue: Column with data renders as empty

Hi Marc,

Thank you, but that is a good solution when the application uses static queries. When the user defines its own query the *default* should not be blank. It gives the false impression that the field is null.

The default should me something like: {unprintable data...}

Thanks,
Yoni
by stoffman
Fri Apr 15, 2022 5:51 am
Forum: VCL / FMX
Topic: Bug/Usability Issue: Column with data renders as empty
Replies: 2
Views: 14917

Bug/Usability Issue: Column with data renders as empty

Hi, Please see the attached image for reference. The column "authors" in the database has a none standard type, but while in the standard grid the user *knows * it has some kind of value, In TeeGrid the user get to think that is has none. As it involves a postgressql database, I cannot send an examp...
by stoffman
Sat Apr 09, 2022 1:41 pm
Forum: VCL / FMX
Topic: Usability Issue: Keyboard navigation doesn't put the column into view correctly
Replies: 5
Views: 17856

Re: Usability Issue: Keyboard navigation doesn't put the column into view correctly

I suppose I didn't explain myself... You can see the issue I talked about in the example you prepared. Look at the "company" column on the first row , you never see the entire content of it. Only after the user leaves the column and moves to the "address" you see the rest of the name. but never its ...
by stoffman
Fri Mar 25, 2022 8:57 am
Forum: VCL / FMX
Topic: Feature Request: OwnerDraw event in certain cases
Replies: 1
Views: 13880

Feature Request: OwnerDraw event in certain cases

Please enable user OwnerDraw event for the following situations: 1. Before any datasource is attached to the grid 2. When the datasource is attached but is *empty* 3. When data is being fetched from the server (so you can have "Loading..." text or animation) For example, see the difference for use c...
by stoffman
Fri Mar 25, 2022 8:42 am
Forum: VCL / FMX
Topic: Usability Issue: Keyboard navigation doesn't put the column into view correctly
Replies: 5
Views: 17856

Re: Usability Issue: Keyboard navigation doesn't put the column into view correctly

Attached is a simple source code for a project that reproduce the problem.

You need to download sqlite3.dll and place it in the project's directory (due to size limit I couldn't upload it directly)

https://www.sqlite.org/2022/sqlite-dll- ... 380100.zip
by stoffman
Mon Mar 21, 2022 9:20 am
Forum: VCL / FMX
Topic: Usability Issue: Keyboard navigation doesn't put the column into view correctly
Replies: 5
Views: 17856

Re: Usability Issue: Keyboard navigation doesn't put the column into view correctly

Hi, I cannot find the TeeGrid_Themes_VCL. I do not own Delphi, so when I specify Lazarus it doesn't get installed (Lazarus has 2 demos installs that I cannot run, I'll open another issue regarding the demos). I'll prepare a small project that only uses the default components (I'm using ZEOS in the f...
by stoffman
Thu Mar 10, 2022 9:08 am
Forum: VCL / FMX
Topic: Usability Issue: Keyboard navigation doesn't put the column into view correctly
Replies: 5
Views: 17856

Usability Issue: Keyboard navigation doesn't put the column into view correctly

ENV: Lazarus 2.0.8, Windows 10 When navigating with the keyboard (moving right). A column that is not in full view, is only being shown *after* the user leaves the cell. Leading to a situation that the user will not see the content of the column. In the attached images you can see what happens to th...
by stoffman
Thu Mar 10, 2022 7:34 am
Forum: VCL / FMX
Topic: Usability Issue: Horizontal and Vertical Scroll jump
Replies: 1
Views: 13833

Usability Issue: Horizontal and Vertical Scroll jump

Env: Lazarus 2.0.8, Windows 10 When the user scroll the grid with the mouse and he exits the window boundaries while still holding the button (the window is not maximize) the scroll bar jumps back (it is true for both vertical and horizontal scrolling) While some windows applications exhibit this be...