PlutoGrid is a dataGrid that can be controlled by the keyboard on desktop and web. Of course, it works well on Android and IOS.

the scanned characters is not binding properly in editable column, scanning barcode using external barcode scanner

original barcode value: 99585858585888 in editable column: 85858585888

same thing is working fine in flutter textbox widget

Hi,

Question: 1 I am able to add the new row into table every time when user do some action but i have created footer record as below where i want to update the total count (number of rows), total amount (there is column in each row called amt and i want to sum up this amt column and show in footer). it seems to be footer is called only once (first time). whenever i add new row, how to update the footer record?

class TableFooter extends StatelessWidget {
  final EventAttendeeRegistrationController eventAttendeeRegistrationController;
  const TableFooter({
    Key? key,
    required this.eventAttendeeRegistrationController,
  }) : super(key: key);

  String totalCount() {
    return eventAttendeeRegistrationController.attendeeDataTableList.length
        .toString();
  }

  String totalAmt() {
    double totAmount = 0;
    for (var element
        in eventAttendeeRegistrationController.attendeeDataTableList) {
      totAmount = totAmount + num.parse(element.amt.toString());
    }
    return totAmount.toString();
  }

  @override
  Widget build(BuildContext context) {
    return Container(
      color: const Color(0xFFE3F2FC),
      height: 45,
      child: Row(mainAxisAlignment: MainAxisAlignment.end, children: [
        const VerticalDivider(),
        const Text('Total count:  ',
            style: TextStyle(fontWeight: FontWeight.bold, fontSize: 15)),
        Text(totalCount(),
            style: const TextStyle(fontWeight: FontWeight.bold, fontSize: 15)),
        const SizedBox(width: 50),
        const VerticalDivider(),
        const SizedBox(width: 20),
        const Text('Total Amt:  ',
            style: TextStyle(fontWeight: FontWeight.bold, fontSize: 15)),
        Text(totalAmt(),
            style: const TextStyle(fontWeight: FontWeight.bold, fontSize: 15)),
        const SizedBox(width: 150)
      ]),
    );
  }
}

Question:2 lets say i have only one row where i want to edit some column. i am able to edit it but if i press enter its not saved. i have to give tab to make this save but tab takes me to next cell in edit mode. i basically want to update the cell when hit enter. how to do it? this is happening when i have only one row or last row.

enterKeyAction: PlutoGridEnterKeyAction.editingAndMoveDown

i see this option but it takes me to next row when i hit enter but in my case, what if i have only one row or if i want to edit last row?

Question:3 is there a way to hide the entire column header row alone? i am able to hide the specific column but i want to hide the entire column header as i want to show only the rows and i dont want to show any column headers. is it possible?

Question: 4 how to auto size the row height? i see the row height parameter but i want to auto size the row height based on the content available in the cell? kind of text wrap. as of now i am using text overflow parameter in text widget to hide some of the additional data that goes beyond the cell size. but i want to show entire data in the cell by wrapping the text so that it can take multiple lines within the cell and row height also needs to adjusted accordingly. is there a way to do this?

also, is there a way to auto fit the column size according to the cell content size?

Question:5

is there a way to hide the menu icon for the one specific column?

Question:6

is there a way to give background color to the entire column header row? as of now i am giving column background color for each column.

Question: 7

what does mean rowRef? why are we reducing the length-1 here? this works fine but i dont understand the rowRef usage here?

    stateManager.appendRows([buildPlutoRow(widget.currentAttendee!)]);
      stateManager.moveScrollByRow(
        PlutoMoveDirection.down,
        stateManager.refRows.length - 1,
      );

Question:8

I am raising all these questions here so that others can make use of it in future. Is there a place where i can find out the good documentation for this package? as of now i am referring the demo example and go to code/debug to understand the usage. Atleast for me, its really hard to understand each functionality. it would be really helpful if its documented well so that it will be useful for junior developers like me. Package is really awesome but understanding the functionality and usage of it without documentation is really hard and need to spend lot of time to do research etc. Not many posts in google or any other forum about this package and related questions. i am sharing these information in a positive note.

Appreciate your response!.. Thanks.

This fixes #260

My friend here, Mohamed, fixed a bug that appears when resizing a column in a RTL app. also there was a problem with aligning the columns icon, it supported right/left only, they supported start/end too. and moving cells using arrows now works properly

Farouk added Arabic locale to the grid too.

Also, They've coded a way to allow users of the grid to save the order of columns (so it's restored when the app is restarted), that's convenient to the end-user. I know it shouldn't be on this pull request, so we can revert it, or refactor it to be more clean, whatever convenient.

Steps to reproduce the bug

Edit a cell that contains number with decimals on IPhone

Try opening https://weblaze.dev/pluto_grid/build/web/#feature/number-type-column on IPhone or in emulator.

Expected results

When soft keyboard opens on IOS it should contain decimal point button.

Actual results

Only 0 - 9 available.

Code sample

PlutoColumn(
          enableContextMenu: false,
          title: 'Price',
          field: 'price',
          formatter: (str) => f.formatAmount(str, 'DKK'),
          type: PlutoColumnType.number(negative: false, format: '#,###.########')),

Execution Environment

Flutter version Flutter version is 3.0.5

PlutoGrid version PlutoGrid version is 5.0.4

OS IOS 15.6.1

Is it possibble to rerender data in datagrid? Im using provider with Consumer. Consumer is running but data doesn't change.

Consumer is embracing complete Plutogrid widget.

hi, after i upgrade flutter to version 1.26.0-17.3.pre i cannot typing anything inside table. and i try to open your documentation and cannot typing anything inside table. this link https://weblaze.dev/pluto_grid/build/web/#feature/number-type-column

can you help me?

I just got an Unhandled Exception when selecting a row, keep selecting a row but different columns it will keep giving the same exception.

[ERROR:flutter/lib/ui/ui_dart_state.cc(198)] Unhandled Exception: LateInitializationError: Field '_column@454200100' has not been initialized. #0 PlutoCell._column (package:pluto_grid/src/model/pluto_cell.dart) #1 PlutoCell.column (package:pluto_grid/src/model/pluto_cell.dart:44:29) #2 ColumnState.currentColumn (package:pluto_grid/src/manager/state/column_state.dart:318:54) #3 EditingState.autoEditing (package:pluto_grid/src/manager/state/editing_state.dart:54:23) #4 CellState.setCurrentCell (package:pluto_grid/src/manager/state/cell_state.dart:213:16) #5 PlutoGridCellGestureEvent._selectMode (package:pluto_grid/src/manager/event/pluto_grid_cell_gesture_event.dart:142:20) #6 PlutoGridCellGestureEvent._onTapUp (package:pluto_grid/src/manager/event/pluto_grid_cell_gesture_event.dart:52:7) #7 PlutoGridCellGestureEvent.handler (package:pluto_grid/src/manager/event/pluto_grid_cell_gesture_event.dart:24:9) #8 PlutoGridEventManager._handler (package:pluto_grid/src/manager/pluto_grid_event_manager.dart:77:11)

NOTE: the application don't quit. and the debugger can't catch anything.

PlutoGrid version PlutoGrid version is 5.0.1

OS Windows 10

I have been wanting to create an excel like sheet but also being able to scroll to a cell I want to search just like excel does.

more details here https://stackoverflow.com/questions/72399829/how-can-i-create-an-excel-like-sheet-with-flutter-widgets?noredirect=1#comment127905020_72399829

is this possible?

Hi There!

Couple of questions:

1. Is it possible to completely override the sorting logic? What I want to be able to do is click on the header cell and get sorted records from the server without applying the Pluto sorting. I still want to be able to update the icon though to indicate the sorting order.
2. Is there a way to have separate icons for the sort indication and the pop-up menu? Right now the menu icon changes to a sorting icon when you sort, but I want to be able to still see the menu icon separately even when sort is applied.

When using event.stateManager.setSelectingMode(PlutoGridSelectingMode.horizontal), the following code does not return the selected rows.

List selectedRows = Set.from(stateManager!.currentSelectingRows.map((e) => e.sortIdx)).toList();

I did a test, the purpose is, click on a table row to open another new interface。 I added onSelected event, and click one row, but it seems invalid, no trigger onSelected event.

is it possible to use different colors for check box and activate border color

like in this picture the check box color is from PlutoGridStyleConfig.activatedBorderColor and also the cell activated border color is from the same attribute. can we make them different colors?

So my PlutoGrid has an edit mode where you can edit/delete rows from it. Once a row has been marked for deletion, I want that row to not be editable without making all other rows not editable since the only way I've found to make this is to change the whole colum's enableEditingMode which make the whole column non-editable if set to false or changing GridMode to readOnly which disable all rows.

Is there a way to achieve this?