C1Flexgrid in APA style

C1Flexgrid in APA style

Posted by: anildabral3k on 25 February 2018, 4:45 pm EST

• 

  anildabral3k

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 25 February 2018, 4:45 pm EST

  Hi,
  
  Is there a way to display C1Flexgrid in APA (American Psychological Association) style? If yes. How to do it?
  
  Also, can I export same APA style table to MS-Word or other word processing softwares?

  More details about APA stype can be found in following link:
  
  https://owl.english.purdue.edu/owl/resource/560/19/

  Thanks,
  
  AD

• 

  Ruchir.Agarwal

  

  • Post Options:
  • Link
    Copy

  Posted 27 February 2018, 7:53 am EST

  Hello AD,

  Thank you for sharing the reference documentation, it really helped.

  After reading the reference, we comprehend following are your requirements with grid:

  1. Display multi-type data in columns.
  2. Ability to show aggregate values for each column.
  3. Show custom text in Cell: 0 of grouped row.
  4. Show table’s Header and Title.
  5. Hide gridlines (cell borders)
  6. Underline Column Headers.
     
     We are happy to let you know that all the above requirements except 4 can be met directly using C1Flexgrid. Also, the Header and Title can be shown using two TextBlock elements and binding their Text to C1FlexGrid’s Name/Tag property.
     
     To demonstrate this, I have attached a sample application and also attached the output observed with it.

  Please feel free to get back, if I missed anything.

  Regards,
  
  Ruchir Agarwal
  
  
  
  C1FlexGrid_APAStyle.zip

• 

  anildabral3k

  • Post Options:
  • Link
    Copy

  Posted 27 February 2018, 3:38 pm EST

  Hi Ruchir.agarwal,
  
  Thanks a lot for providing the sample project. That should work for me. One question though, is there a way to export this APA style table to MS-Word, as is (appearing exactly same as in this sample)? How can I do that?

  Regards,
  
  AD

• 

  Ruchir.Agarwal

  

  • Post Options:
  • Link
    Copy

  Posted 28 February 2018, 7:47 pm EST

  Hi AD,

  Please refer attached modified sample application exporting ANA table to word format.
  
  Note: In order to run the application, you need to add reference to microsoft.office.interop.word.dll to the project.
  
  Let me know if you face any issues.
  
  Also, attached is a screen-shot of the generated word file.

  Regards,
  
  Ruchir Agarwal
  
  C1FlexGrid_APAStyle_export.zip

• 

  anildabral3k

  • Post Options:
  • Link
    Copy

  Posted 1 March 2018, 3:07 am EST

  Hi Ruchir.agarwal,
  
  You are awesome and quick. Thanks for all the hard work you have been putting into this. Your sample code worked just fine, but I need more.

  Apologies, I forgot to mention that, exported table should be editable in MSWord. So that people can edit the values/text in MSWord if they want to. Or say change title or other things after C1Flexgrid gets exported to MSWord.

  Hope I am not causing you too much trouble.

  Thanks,
  
  AD

• 

  Ruchir.Agarwal

  

  • Post Options:
  • Link
    Copy

  Posted 4 March 2018, 8:10 pm EST

  Hello AD,

  Thank you for acknowledging our efforts.
  
  However, exporting FlexGrid to editable Word file is not possible.

  ~Ruchir Agarwal

• 

  anildabral3k

  • Post Options:
  • Link
    Copy

  Posted 4 March 2018, 11:27 pm EST

  Hi Ruchir.agarwal,
  
  Thank you for clarifying.

  Regards,
  
  AD