SBGrid Documentation

website·Indexed 31 days ago

https://sbgrid.co.kr

Documentation and implementation examples for SBGrid, a grid library featuring data visualization with bar, line, and pie charts. The resources cover version 2.5, including release notes for builds 2.5.3204 through 2.5.3130, and version 3 API guides. Key features include row data management, theme application, Excel integration, and specialized functions like rowctrlupdown.

Tokens
50.4K
Snippets
340
Records
445
Agent score
48%

What's inside SBGrid

  1. Visualize data trends using SBGrid Sparklines

    The Sparkline feature allows developers to insert small charts directly into grid cells. This enables users to intuitively identify trends and volatility in continuous data (such as monthly/yearly sales or weekly/monthly performance) without leaving the tabular view.

    Key capabilities include:

    • Support for multiple chart types: Line, Column, and Win/Loss.
    • Integration with Excel: Sparklines are preserved during Excel export, and data modified in Excel can be uploaded back into the grid.
    • Improved decision-making by visualizing large sets of numerical data within the grid structure.
  2. SBGrid V3 Core Features and Compatibility

    SBGrid V3 is a certified web grid solution with the following technical capabilities:

    • Framework Support: Compatible with React, Vue, and Angular.
    • Browser Support: W3C compliant; supports Chrome, Edge, Safari, and Firefox.
    • Performance: Uses virtual scrolling for high-volume data rendering.
    • Key Features: Pivot grids, multi-platform support (Desktop/Tablet/Mobile), Excel import/export (preserving formulas and formatting), and Sticky (fixed) rows/columns.
  3. Implement Totals and Subtotals in SBGrid

    SBGrid allows the calculation and display of totals and subtotals across both rows and columns. This can be used to show aggregate data such as maximum scores, minimum scores, total sums, and averages. Calculations can be placed in standard areas or in custom positions (top, bottom, or right) using specific calculation formulas.
  4. Purchase and Licensing Overview for SBGrid, SBUx, and SBChart

    Softbowl provides three primary products with the following licensing and support terms:

    • SBGrid Ver 3.0: Licensed based on Core count. Includes full grid functionality, code generator, and sample code.
    • SBUx Ver 2.6: Licensed based on Core count. Includes 52 types of components across 40 categories (including SBGrid and SBChart), an assist toolkit, and templates.
    • SBChart V2: Licensed based on Server. Provides various chart types including Map, Heartbeat, Wing, Org, Heatmap, Line, Bar, Bubble, and Donut charts.

    Common Terms across all products:

    • Technical Support: Provided during the project period via on-site or remote support (Omni-channel: KakaoTalk, phone, email). Response time is within 1 business day.
    • Maintenance: 1 year of free maintenance following project inspection.
    • Upgrades: Minor upgrades are provided for those under active maintenance.
    • Certifications: All products are GS certified and registered in the procurement shopping mall (SBGrid also has SA certification).
  5. Purchase and Licensing Overview for SBGrid, SBUx, and SBChart

    Softbowl provides three primary products with the following licensing and support terms:

    SBGrid Ver 3.0

    • Pricing Basis: Core-based
    • Deliverables: Full grid functionality, Code Generator, sample code, and customized technical support.
    • Certifications: SA, GS, and registered in the public procurement mall.

    SBUx Ver 2.6

    • Pricing Basis: Core-based
    • Deliverables: 52 types of components across 40 categories (includes SBGrid and SBChart), Assist Toolkit, templates, and customized technical support.
    • Certifications: GS and registered in the public procurement mall.

    SBChart V2

    • Pricing Basis: Server-based
    • Deliverables: Various chart types (Map, Heartbeat, Wing, Org, Heatmap, Line, Bar, Bubble, Donut) and customization support.
    • Certifications: GS and registered in the public procurement mall.

    Common Terms for All Products:

    • Technical Support: Provided during the project period via on-site visits, remote support, and omni-channel communication (KakaoTalk, phone, email). Response is guaranteed within 1 business day.
    • Maintenance: 1 year of free maintenance following project inspection.
    • Upgrades: Minor upgrades are provided for products under active maintenance.
  6. Visualize data trends using SBGrid Sparklines

    The Sparkline feature allows you to insert small charts directly into grid cells to visualize trends and volatility for continuous data (e.g., monthly/yearly sales or weekly/monthly performance) within a tabular format. It supports Line, Column, and Win/Loss chart types. This feature improves decision-making and data analysis efficiency compared to viewing raw numerical data.
  7. Implement Paging in SBGrid

    SBGrid supports two types of paging for managing large datasets: Front-end Paging (Client-side) and Server-side Paging.

    • Front-end Paging: The grid handles the pagination of data already loaded into the client. Users can navigate pages by clicking page numbers at the bottom of the grid or by using the mouse scroll to move to the next page automatically.
    • Server-side Paging: The grid requests specific pages of data from the server as the user navigates, reducing the initial load time and memory usage for very large datasets.
  8. Implement Right-Click Context Menus in SBGrid

    SBGrid provides a context menu extension that triggers when a user right-clicks within the grid's data area. It supports 15 built-in functions (such as sorting, resetting sorts, copying, pasting, and column freezing) and allows for custom menu items to be added.

    Key capabilities include:

    • Customization: Add custom menu items beyond the default provided functions.
    • Column-Specific Menus: Configure different context menus for different columns to prevent incorrect operations and improve user workflow based on the specific data in that column.
  9. Implement Totals and Subtotals in SBGrid

    SBGrid allows the calculation and display of totals and subtotals across both rows and columns. This can be used to show aggregate data such as maximum scores, minimum scores, total sums, and averages. Calculations can be placed in standard areas or in custom locations (top, bottom, or right) using specific calculation formulas.
  10. SBGrid V3 Framework Compatibility and Features

    SBGrid V3 is a web grid solution compatible with React, Vue, and Angular. Key technical features include:

    • Virtual scrolling for large datasets
    • Excel import/export preserving formulas and formatting
    • Sticky rows and columns (Freeze)
    • Pivot Grid capabilities
    • Multi-platform support (Desktop, Tablet, Mobile)
    • W3C Web Standard compliance (Chrome, Edge, Safari, Firefox)
  11. Recommended Workflow for AI-Assisted SBGrid V3 Development

    To minimize errors and reduce the number of code revisions, follow this three-step prompting strategy with an MCP-enabled AI:

    1. Verify Feature Existence: Ask if a specific feature exists (e.g., "Does SBGrid V3 have a cell merge feature?") to prevent the AI from hallucinating capabilities.
    2. Request Documentation Evidence: Instruct the AI to find the specific option in the API documentation first (e.g., "Find and show me the relevant option from the API documentation.").
    3. Request Implementation: Ask the AI to write the code based on the verified options to fit your specific screen requirements.
  12. Quickly install SBGrid V3 without build tools

    SBGrid V3 supports a 'No-Build' setup. It does not require a bundler or a complex installation process. You can run it immediately by placing the library files in your desired directory and including them in the HTML head.
    <!-- Include these three files in the <head> section -->
    <script src="sbgrid3.js"></script>
    <script src="license.js"></script>
    <link rel="stylesheet" href="sbgrid3.css">