Ideas

Modify Excel Export for Boolean Values

1

Login To Vote

Modify Excel Export for Boolean Values

Reporting

Exporting grids to Excel currently represents boolean values as "true" and "false". This makes it difficult to look at the spreadsheet and quickly identify the relevant data.

Reporting "X" for true and "" (empty string) for false would eliminate the necessity of doing global replacements on every export we do.

(See SetExcelValue() in Rock.Utility.ExcelHelper. Create a special case for "exportValue is bool || exportValue is bool?".)

Photo of Steve SwaringenSubmitted by Steve Swaringen, Lakepointe Church  ·   ·  Reporting
Remove Votes
Login to add a comment...

Submission Success Tips

Cultivate your ideas for maximum impact with these helpful submission tips that will increase the chances of your brilliant concepts becoming reality.

  • Clear Title: Craft a straightforward and descriptive title that instantly conveys the essence of your idea.
  • Concise Description: Provide an idea description that is succinct, ensuring it effectively communicates the concept without unnecessary verbosity.
  • Provide Additional Details: With a concise description complete, now provide any other details that are needed to better understand the requirements.
  • Thorough Ministry Need Review: Provide a comprehensive overview of the ministry need your idea addresses, emphasizing its significance.
  • Cover the WHY: Clearly articulate the rationale behind your idea, explaining why it's essential and how it aligns with the organization's goals and mission. Oftentimes a clear "why" sheds light into other possible options.