The basic standard of real Excel-like reporting tool

Discussion in 'Software' started by freezea, Aug 4, 2009.

  1. freezea

    freezea

    Joined:
    May 21, 2009
    Messages:
    7
    Nowadays, many reporting tools claim that they are Excel-like, and they support Excel-like report design after improvements. Then, what is a real Excel-like reporting tool?

    Today, we will discuss this problem from two aspects.

    1. What are the most basic functions a real Excel-like reporting tool should have?
    2. According to the data characteristics of report, what are the extended functions a real Excel-like reporting tool should have?

    Generally, programmers and end users are familiar with Excel, and programmers often choose to develop reports in an Excel-like style. The main purposes are to realize complex report forms and improve report creation efficiency. For users’ convenience, reporting software companies should provide a report IDE closer to Excel usage pattern as much as possible. In other words, besides Excel-like appearance, they need to spend more time on operation details to improve its service efficiency.

    In my opinion, a real Excel-like reporting tool should have the basic functions below:

    Same Cell Naming
    Cells in Excel are named according to their horizontal and vertical positions in the table. If set another naming mechanism, on the one hand it is very troublesome, on the other hand it will bring some inconveniences in expression editing.

    Cell’s Properties Definition
    It should be able to define those most basic properties of a cell: font, font size, color, border, foreground, background, edit style for whole row or column or table, and format painter supporting, etc.

    Cell Content Editing
    The editing method of expression should be the same with that of Excel. For example, “=sum(A3+B5)”. When insert or delete a related row or column, the expression is supposed to transform automatically without manual updating.
    When the content/expression of a cell is too long to display in it, the entire content/expression should be displayed in the edit box in the toolbar of the reporting tool.

    Custom Functions
    It should provides a great number of common functions, and retain some application programming interfaces for users to add their own custom functions.

    Import and Export Excel files
    Commonly, before involving a reporting tool or starting an information project, users may have had a lot of Excel files. Therefore, it is requisite to allow users to import and export Excel files.

    This post is from freezea's blog. You are welcomed cc it anywhere, and please indicate the source.

    If you would like to read more articles about reporting tool, you are also welcome to refer to my blog.
    freezea, Aug 4, 2009
    #1
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Extraxi
    Replies:
    0
    Views:
    669
    Extraxi
    Mar 2, 2004
  2. vashdev

    Cisco ACS Reporting Tool

    vashdev, Aug 26, 2004, in forum: Cisco
    Replies:
    0
    Views:
    1,372
    vashdev
    Aug 26, 2004
  3. Heath Roberts
    Replies:
    6
    Views:
    1,998
    Johan
    Dec 4, 2005
  4. freezea
    Replies:
    0
    Views:
    1,101
    freezea
    May 21, 2009
  5. freezea
    Replies:
    0
    Views:
    1,656
    freezea
    Sep 9, 2009
Loading...

Share This Page