Selective Spreadsheet Transmission for Printing

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

When printing multiple spreadsheets, existing techniques require transmitting and converting all data to a server, leading to prolonged processing times due to unnecessary data transmission and conversion of non-selected sheets.

Innovation Solution

An information processing device and method that selectively transmit only target spreadsheets for conversion, identified using tag information, reducing the amount of data sent to the server and shortening the time required for image data reception and printing.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Loss of time

If all spreadsheets are transmitted to the server for conversion, then complete data conversion is achieved, but processing time increases significantly

Engineering Contradiction:
Improveprocessing timeVSAvoiddata conversion completeness
Core Design Contradiction:
Loss of timeVSReliability

Solution Approach 1:

The patent segments the spreadsheet data by identifying individual sheet boundaries using tag information (e.g., <sheet> tags in XML format). This allows the system to separate and process only the selected target sheets rather than treating the entire workbook as a single unit, thereby reducing processing time while maintaining conversion completeness for the selected portions.

Inventive Principle:
Principle #1Segmentation

Solution Approach 2:

The patent extracts only the necessary target spreadsheets from the complete workbook based on user selection criteria. By using tag information to identify and extract specific sheets (e.g., extracting sheets with particular names, ranges, or properties), the system transmits minimal necessary data to the server, reducing transmission and processing time while ensuring all required sheets are converted.

Inventive Principle:
Principle #2Taking out (Extraction)

2Loss of time

If all spreadsheet data is transmitted to the server, then no data is lost, but transmission time and server load increase

Engineering Contradiction:
Improvetransmission timeVSAvoiddata completeness
Core Design Contradiction:
Loss of timeVSLoss of information

Solution Approach 1:

The patent extracts only the selected target spreadsheets from the complete workbook using tag information identification. The control unit parses the markup language structure, locates specific sheets based on user selections (e.g., by sheet name, index, or properties), and extracts only those portions for transmission. This extraction process ensures that transmission time is minimized while the extracted data remains complete and conversion-ready.

Inventive Principle:
Principle #2Taking out (Extraction)

Solution Approach 2:

The patent performs preliminary identification and extraction of target spreadsheets on the terminal device before transmission to the server. By pre-processing the workbook locally to identify which sheets need conversion and preparing them in the appropriate format, the system reduces the amount of data that needs to be transmitted and ensures that the server receives only the necessary information, thereby reducing transmission time and server processing load.

Inventive Principle:
Principle #10Preliminary action

3Productivity

If selective transmission of target spreadsheets is implemented, then processing time is reduced, but system complexity increases

Engineering Contradiction:
Improveconversion efficiencyVSAvoidsystem complexity
Core Design Contradiction:
ProductivityVSDevice complexity

Solution Approach 1:

The patent uses the existing markup language structure (with clear tag boundaries like <sheet> and </sheet>) to segment the spreadsheet data. This leverages the inherent structure of the data format rather than requiring complex custom parsing logic. The control unit simply needs to locate and extract the relevant tagged sections based on user selections, which is a relatively straightforward operation compared to creating entirely new data structures or formats.

Inventive Principle:
Principle #1Segmentation

4Loss of time

If all sheets are converted to image data, then complete printing capability is ensured, but unnecessary conversion of non-selected sheets increases processing time

Engineering Contradiction:
Improveconversion timeVSAvoidprinting flexibility
Core Design Contradiction:
Loss of timeVSAdaptability or versatility

Solution Approach 1:

The patent segments the conversion process by applying the conversion function only to the selected target sheets rather than converting the entire workbook. The control unit identifies which sheets are selected for printing and transmits only those to the server for image data conversion. This segmented approach reduces conversion time significantly while maintaining full printing capability for the selected sheets, as each sheet is independently converted to high-quality image data suitable for printing.

Inventive Principle:
Principle #1Segmentation

Data Source

PatentUS9069500B2Information processing device, method and computer-readable medium therefor configured to generate transmission information associated with selected target spreadsheets
Publication Date: 2015.06.30 BROTHER KOGYO KK
  • US9069500B2 patent drawing
  • US9069500B2 patent drawing
  • US9069500B2 patent drawing

AI summary

An information processing device including a communication unit communicating with a conversion device, and a control unit configured to select one or more target spreadsheets from among spreadsheets contained in target information, the target information being described in a format of a markup language and contains the spreadsheets, each of the spreadsheets being individually identified based on tag information contained in the target information, generate transmission information based on the one or more selected target spreadsheets, control the communication unit to transmit the generated transmission information to the conversion device, and control the communication unit to receive one or more pieces of image information from the conversion device, each of the one or more pieces of image information being generated through conversion by the conversion device based on a corresponding one of the one or more selected target spreadsheets included in the transmission information transmitted to the conversion device.