Printer Cell Size Adjustment for Complete Formula Display
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Conventional spreadsheet software often truncates formulas when printing tables, preventing the complete display of formulas within cells due to inadequate cell size adjustment.
Innovation Solution
A printer system that includes an input unit, cell-size changing unit, and print data creating unit, capable of altering cell sizes to ensure formulas fit entirely within cells, using a CPU to determine and adjust cell sizes based on print data to accommodate the entire formula.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Loss of information
If the cell size is adjusted to fit the formula, then the formula can be displayed in the cell, but the cell size may become too large to fit the entire table on the printing sheet
Solution Approach 1:
The patent applies local quality by adjusting only the cell sizes that contain formulas, rather than uniformly increasing all cell sizes. The cell-size changing unit specifically targets cells with formulas and increases their size to accommodate the complete formula display, while leaving other cells at their original sizes. This localized adjustment resolves the contradiction by ensuring formula completeness in affected cells without causing the entire table to become too large for the printing sheet.
2Loss of information
If the cell size is kept at the adjusted size, then the formula fits within the cell, but the table cannot be printed completely on the recording sheet
Solution Approach 1:
The patent applies dynamics by making the cell size adjustable rather than fixed. The cell-size changing unit dynamically modifies cell sizes based on the content requirements (formula length) while the print data creating unit dynamically adjusts the table layout to fit the recording sheet. This dynamic adaptation resolves the contradiction by allowing the system to balance formula completeness with printable table size, ensuring both the formula fits in the cell and the entire table can be printed on the recording sheet.
3Productivity
If the formula is truncated to fit the cell, then the table can be printed completely, but the user cannot view the entire formula
Solution Approach 1:
The patent applies preliminary action by pre-adjusting cell sizes to accommodate complete formulas before generating print data. The cell-size changing unit proactively increases cell sizes to fit formulas, and the print data creating unit then creates optimized print data that arranges the table to fit the recording sheet. This preliminary sizing prevents formula truncation while ensuring the table can be printed completely, resolving the contradiction between printing efficiency and formula completeness.
Data Source
AI summary
A printer includes an input unit, a cell-size changing unit, a print data creating unit, and a printing unit. The input unit receives table data describing a table including a plurality of cells. Each of the plurality of cells has a size. The cell-size changing unit is configured to be capable of changing the size of a cell that is associated with a formula. The print data creating unit creates print data for printing a cell-size changed table that includes the size changed cell in a predetermined part of a recording sheet such that the formula fits entirely within the size changed cell, if the cell-size changing unit changes the size of the cell. The printing unit prints the cell-size changed table based on the print data in the predetermined part of the recording sheet.