Transposed FlexSheet

Transposed FlexSheet

Posted by: namnguyen12399.coder on 22 September 2024, 11:40 pm EST

• 

  namnguyen12399.coder

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 22 September 2024, 11:40 pm EST

  I want to create a transposed grid with formula. Since grid does not support formula, I have to use FlexSheet.
  
  Is it possible to create a transposed FlexSheet?

• 

  vivek.pannu

  

  • Post Options:
  • Link
    Copy

  Posted 24 September 2024, 7:57 am EST

  Hi,

  You can use the Flexsheet and make it look like a transposedGrid, however it will have it’s limitations and benefits, you’ll be able to use all FlexSheet features including formulas, but it will only work for unbound data, you’ll have to manually set data for cells using ‘setCellData’ method.

  Here’s a sample for your reference - https://stackblitz.com/edit/vue-example-1-ritglt?file=src%2FApp.vue

  We have used some custom CSS to make it look like a transposedGrid. You can use this approach if it fits your requirements well.

  Regards

• 

  namnguyen12399.coder

  • Post Options:
  • Link
    Copy

  Posted 24 September 2024, 8:01 am EST

  Thanks for your answer, I will apply the solution and give feedback if encountering further problems