InputDate in PivotGrid's cells

InputDate in PivotGrid's cells

Posted by: georgekam96 on 4 December 2019, 12:35 am EST

• 

  georgekam96

  • Post Options:
  • Link
    Copy

  Posted 4 December 2019, 12:35 am EST - Updated 3 October 2022, 9:33 am EST

  Greetings,

  When the user tries to select a specific year (via the year-selector) from an inputDate which is in a cell of a PivotGrid while using Chrome, the calendar in the background disappears (see attachment images).

  

  This happens only on Chrome (on Firefox it works properly) and only during the first year-selection (in every subsequent year-selection the calendar does not disappear).

  Check the example here: https://stackblitz.com/edit/angular-wijmo-playground

  To replicate the issue, click on the “Add datepicker” button, then go to the (0, 0) cell (where the inputDate is located) and change the year.

• 

  ashwin.saxena

  

  • Post Options:
  • Link
    Copy

  Posted 4 December 2019, 11:01 pm EST

  Hi George,

  We are working on this and will update you as soon as possible.

• 

  ashwin.saxena

  

  • Post Options:
  • Link
    Copy

  Posted 8 December 2019, 4:29 pm EST

  Hi George,

  Sorry for the delayed response.

  I was able to replicate the issue. But before forwarding it to the dev team, could you let me know the use case because PivotGrid is not an editable grid. It is only used to display aggregated data.
  
  If you could provide me with the use case, maybe I can provide you with a different solution.

  Regards,
  
  Ashwin

• 

  georgekam96

  • Post Options:
  • Link
    Copy

  Posted 8 December 2019, 6:24 pm EST

  Greetings again,

  Essentially, we want to add some InputDates in certain cells of the grid. Currently, we do not perform any aggregations. We, only, use the PivotGrid for its pivoting features.

• 

  ashwin.saxena

  

  • Post Options:
  • Link
    Copy

  Posted 9 December 2019, 4:12 pm EST

  Hi George,

  I am sorry but I did not understand you completely. You said that you are using the PivotGrid for its pivoting features but not for data aggregation. But the PivotGrid is used only to display the aggregated data. Could you shed some light on what you said?
  
  Also, if you wish to add InputDate controls, I would suggest you use the FlexGrid control because it is editable and you can easily use the CustomGridEditor class to add InputDate and other various input controls as the cells.

  ~regards

• 

  georgekam96

  • Post Options:
  • Link
    Copy

  Posted 9 December 2019, 6:26 pm EST

  Hey,

  Yes, we use the PivotGrid mainly for altering dimensions, for example to move a dimension from row to column.

• 

  ashwin.saxena

  

  • Post Options:
  • Link
    Copy

  Posted 11 December 2019, 2:57 pm EST

  Hi George,

  I understand that you are using PivotGrid only for altering dimensions. Regarding InputDate control, I believe that you are using InputDate to show the dates in a proper format. But you can do this by using the format property of the Column class.

  Please let me know if my understanding is correct.

  ~regards