Integrated office software and implementation method thereof

By saving word processing, spreadsheet, and PowerPoint information into an integrated file, and employing a tabbed interface and generalized spreadsheet design, it solves the problems of non-automatic data updates and complex interfaces in existing office software, achieving a simplified user interface and efficient data updates.

CN120874764APending Publication Date: 2025-10-31HENAN XINGFU WATER CONSERVANCY INFORMATION TECHNOLOGY CO LTD
View PDF 0 Cites 0 Cited by

Patent Information

Application Number
CN202510894450.8
Authority / Receiving Office
CN · China
Patent Type
Applications(China)
Current Assignee / Owner
Filing Date
2025-06-30
Publication Date
2025-10-31

AI Technical Summary

Technical Problem

Existing office software designs result in non-automatic data updates, complex user interfaces, lack of linked auditing functions, lack of prominent prompts, overly simplistic target objects, lack of on-the-spot editing capabilities, and insufficiently broad spreadsheet functionality, making secondary development difficult.

Method used

It saves information from word processing, spreadsheets, and presentations into a single integrated file, uses a tabbed interface, allows for link auditing by creating reference and dependent objects, expands into a generalized spreadsheet, supports in-place editing, and provides prominent prompts and a generalized formula editing bar.

Benefits of technology

It enables editing of information in different formats on the same page, simplifies the user interface, improves ease of operation, reduces data update errors, provides link approval support, and enhances the ability to automatically update data.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN120874764A_ABST
    Figure CN120874764A_ABST
Patent Text Reader

Abstract

The invention relates to integrated office software and an implementation method thereof, and belongs to the technical field of office automation. According to the method, the information of word processing, the spreadsheet and the slide is stored in one integrated file, the information of each format corresponds to one application object, the interface is simple, and the convenience of user operation is improved. Meanwhile, when the link is created, a first object (reference object) and a second object (subordinate object) are created for the created link, the first object (reference object) is used for storing position information of a data source corresponding to the link, and the second object (subordinate object) is used for storing position information of the link. Link auditing can be achieved based on the created first object (reference object) and second object (subordinate object), and support is provided for link modification.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] This invention relates to an integrated office software and its implementation method, belonging to the field of office automation technology. Background Technology

[0002] In business activities and scientific research, a single data point and its derivatives may be cited in one or more places in a report or PowerPoint presentation. This citation could be in the main text, in one or more tables, or in one or more charts. Data in reports or PowerPoint presentations often needs to be modified. If this data needs to be modified, the software user must check and change it one by one. A report may contain a lot of data, and manual data modification is prone to errors and omissions.

[0003] In spreadsheets, when a summation function is present below a column of data, a change in any of the data will automatically update the summation result without manual recalculation. This is because data changes trigger a Chang event, and the corresponding code in the spreadsheet software automatically executes the calculation to update the summation function's result. However, current word processing software (such as Microsoft Word) and spreadsheet software (such as Excel) are designed as independent applications, making it impossible for word processing software to respond to Chang events in spreadsheets. Therefore, the task of automatically updating data, which should be done by a machine, is instead performed manually, reducing efficiency and significantly increasing the likelihood of errors.

[0004] From the perspective of whether data can be updated automatically, current office software designs can be basically divided into two categories: one is office software such as Microsoft Office, and the other is Yongzhong Office software.

[0005] Microsoft Office, the standard office suite, typically includes three components: Microsoft Word, Excel, and PowerPoint. Many similar solutions exist, such as WPS Office, Tencent Docs, Shimo Docs, and Google Docs. These so-called "Office" programs are essentially just word processing, spreadsheets, and presentation software bundled together. These three components correspond to three different file types, and the information in each file is unrelated to the others.

[0006] Unlike the software mentioned above, Yongzhong Office should be considered a true Office application because it saves word processing, spreadsheets, and presentations into a single file. These three types of information can share data through links. When the source information changes, the referenced information will also automatically change. Therefore, as long as the user correctly establishes the links when creating the application, any change in one place will automatically affect the others, saving the user time in modifying data.

[0007] It's very common for data and its derivatives to be repeatedly referenced. Microsoft Office, a leading example of Office software, is designed to store files generated by its word processing, spreadsheet, and presentation components independently. This makes it difficult to link these components together. A change in one piece of data in a spreadsheet will affect the derived data; data in word processing files won't update automatically, requiring users to modify each entry individually; and for charts, copying and pasting is necessary. This wastes a lot of unnecessary time; it's particularly prone to errors when dealing with large amounts of data, and even more so when there's a lot of derived data.

[0008] Yongzhong Office saves information generated by its word processing, spreadsheet, and presentation components into a single integrated file. Users can reference information from spreadsheets (including cell or cell range values, charts, etc.) within the word processing module, and also reference presentation slides (also known as presentation creation). Although Yongzhong Office provides the ability to create links, its efficiency is not significantly improved, primarily due to the following reasons:

[0009] 1) Complex user interface

[0010] The interface of Yongzhong Office is as follows Figure 1 As shown, if you have spreadsheets, word processing, and PowerPoint presentations all at the same time, you often need to view them in a tree diagram or switch between multiple tabs, which can appear loose, disorganized, and quite complex.

[0011] 2) Lack of link verification function

[0012] Links are a core feature of integrated Office software. When creating links, users may accidentally create incorrect links due to carelessness or other reasons. They may need to check the subordinate or reference information to track the information and modify the links. Obviously, providing a link auditing function is essential. However, Yongzhong Office does not provide this function.

[0013] 3) The link lacks a prominent prompt.

[0014] When the source information being referenced becomes the focus, the software should provide a prominent prompt to inform the user: This information is referenced in one or more places, and modifying or deleting this information will have a chain reaction; please operate with caution! Obviously, this is essential, however, Yongzhong Office does not provide this function.

[0015] 4) The target object created is too simple.

[0016] When inserting a region or chart from a spreadsheet into word processing in Yongzhong Office, it is done by... Figure 2 The steps involved are as follows. The result of this operation is to generate an image D within the word processing module, containing links to a cell range (or a chart in a spreadsheet). Because the object in word processing is an image, not a spreadsheet or chart object, the font size in the image will change when stretched or scaled, which is inconsistent with user habits.

[0017] 5) Lacks the design concept of "in-place editing"

[0018] The ability to create a visually appealing table (e.g., a 2x3 table) within a word processing document or presentation, but which is actually a portion of a spreadsheet, allows direct editing of the spreadsheet within the word processing document or presentation – this is the "in-place editing" feature. However, Yongzhong Office does not offer in-place editing; when editing cell ranges or chart objects that reference spreadsheets in Yongzhong Office, you need to switch to the spreadsheet interface. Similarly, if a presentation references a word processing document, you also need to switch to the presentation's view when editing the presentation.

[0019] 6) Lack of the concept of "generalized spreadsheet"

[0020] Managing and displaying information in tabular form is very convenient. Word processing software like Ms-Word can save formulas and image objects, but spreadsheet software like Excel can only save strings and numbers. If Office software is integrated, its spreadsheet software should also be able to save formulas, images, and even rich objects such as audio and video. This kind of spreadsheet that can save numbers, strings, spreadsheet formulas, word processing software formulas, images, audio, and video is called a "generalized spreadsheet." Yongzhong Office lacks a "generalized spreadsheet," which makes its word processing tables different from its spreadsheet tables, limiting the improvement of work efficiency.

[0021] 7) Secondary development is difficult

[0022] Yongzhong Office uses Java as its secondary development programming language, which is more difficult to learn and use than Microsoft's VBA.

[0023] In summary, the current integrated system still suffers from problems such as a complex user interface and the inability to verify links. Summary of the Invention

[0024] The purpose of this invention is to provide an integrated office software and its implementation method to solve the problems that current integrated systems still have complex user interfaces and cannot implement link verification.

[0025] To solve the above-mentioned technical problems, this invention provides a method for implementing an all-in-one office software, the method comprising:

[0026] 1) Save information in different formats into an integrated file, with each format corresponding to an application object. Use the worksheet interface as the working interface and the application objects of each format as worksheet tabs. The formats include at least one of word processing, spreadsheet, and PowerPoint.

[0027] 2) When a link is created in an application object, a reference object is created for the created link to store the location information of the data source corresponding to the link, and a subordinate object is created at the location of the data source corresponding to the link to store the location information of the link. The created reference object and subordinate object are used to verify the link.

[0028] Furthermore, the locations corresponding to the storage locations of both referenced and dependent objects are prominently displayed to prompt the user, and an auditing function is provided to track references. The auditing function includes tracking references and tracking dependents. Tracking references corresponds to the Selection.ShowPrecedents method, which is used to display the reference path, and tracking dependents corresponds to the Selection.ShowDependents method.

[0029] Furthermore, the method also includes extending the spreadsheet to a generalized spreadsheet, where each cell or cell range in the generalized spreadsheet is a Range object with Value and Formula properties, used to store data, strings, formulas, or images, audio, video, and word processing formulas from a regular spreadsheet.

[0030] Furthermore, when inserting a spreadsheet into word processing or PowerPoint presentations, the inserted spreadsheet is treated as a generalized spreadsheet.

[0031] Furthermore, when it is necessary to insert a slide into the word processing, a Slide object is created in the word processing, and the slide number to be inserted is edited using the Slide object to insert the slide into the word processing.

[0032] Furthermore, word processing, spreadsheet, and PowerPoint applications all have a formula editing bar similar to that in spreadsheets, which serves as a generalized formula editing bar.

[0033] Furthermore, if the current interface is a word processing or slideshow, after entering a formula in the generalized formula editing bar, if the formula returns a single value, a string is returned and inserted into the user's current focus position; if the function returns multiple values, a spreadsheet is generated at the user's current position, which is a generalized spreadsheet with the same height and width as the returned array.

[0034] Furthermore, when a cell in a word processing table is selected, the generalized formula bar displays the corresponding cell's value or formula, and this value or formula is editable. If the current interface is a word processing or slideshow, and the user selects a series in a chart, the generalized formula bar will display the series formula, and the series formula is editable.

[0035] Furthermore, the method also includes selecting a cell range in a spreadsheet, performing a "copy" operation, and then switching to word processing or PowerPoint to perform a "paste" operation. This will generate a generalized spreadsheet pointing to the copied cell range at the current location in word processing or PowerPoint, while the generalized formula bar displays the corresponding reference string.

[0036] The present invention also provides an all-in-one office software, which adopts the above-described method for implementing all-in-one office software.

[0037] The beneficial effects of this invention are as follows: As an improved invention, this invention saves information from word processing, spreadsheets, and presentations into an integrated file. Each information format corresponds to an application object, using a tabbed interface similar to current spreadsheets as the working interface for each format. This allows for editing of different format information on a single page, resulting in a simple interface and improved user convenience. Furthermore, when creating links, this invention creates reference objects and dependent objects for each link. The reference object stores the location information of the data source corresponding to the link, while the dependent object stores the location information of the link itself. Based on these reference and dependent objects, link review can be implemented, providing support for link modification. Attached Figure Description

[0038] Figure 1 This is a schematic diagram of the user interface of Yongzhong Office;

[0039] Figure 2 This is a diagram illustrating the referencing operations in Yongzhong Office;

[0040] Figure 3This is a menu diagram of the integrated office software of the present invention;

[0041] Figure 4 This is a schematic diagram of the icon displayed when the integrated office software of this invention is started;

[0042] Figure 5 This is a schematic diagram of the spreadsheet interface in the integrated office software of this invention;

[0043] Figure 6 This is a schematic diagram of the Chinese character processing interface in the integrated office software of this invention;

[0044] Figure 7 This is a schematic diagram of the slideshow interface in the integrated office software of this invention;

[0045] Figure 8 This invention allows you to move charts from a spreadsheet into a word processor or a slideshow.

[0046] Figure 9 This is a schematic diagram of the spreadsheet located in word processing in this invention;

[0047] Figure 10 This is the effect of maximizing the spreadsheet in word processing in this invention;

[0048] Figure 11 This is the spreadsheet settings option located in word processing in this invention;

[0049] Figure 12 This is the display diagram when entering the referenced cell area in this invention;

[0050] Figure 13 This is a schematic diagram of the menu for reviewing links in this invention;

[0051] Figure 14 This is a schematic diagram of the review function linked in this invention;

[0052] Figure 15 This is a schematic diagram illustrating how the present invention edits spreadsheet cells in word processing;

[0053] Figure 16 This is a schematic diagram illustrating the selection or editing of an icon series in word processing according to the present invention. Detailed Implementation

[0054] The specific embodiments of the present invention will be further described below with reference to the accompanying drawings.

[0055] This invention centers on the user's work tasks, sets the top-level object as Application, defines each opened Office file as an Office object, and all opened Office objects as Offices, which is a collection.

[0056] Implementation methods of integrated office software

[0057] This invention saves information from word processing, spreadsheets, and presentations into an integrated file. Each information format corresponds to an application object, and a tabbed interface serves as the working interface for this information, enabling the opening of different information formats within the same working interface. Furthermore, when creating links, this invention creates a first object and a second object for each link. The first object (reference object) stores the location information of the data source corresponding to the link, and the second object (dependent object) stores the location information of the link itself. Link approval can be implemented based on the created first object (reference object) and second object (dependent object). In addition, this invention also enables prominent link prompts, in-situ editing, and generalized spreadsheet functionality. A detailed description follows.

[0058] 1. Save information in different formats into an integrated file.

[0059] This implementation method targets information in three formats: word processing, spreadsheets, and presentations. Therefore, the information in these three formats is saved into an integrated file. Each Office file in the integrated file corresponds to an Office object, and the word processing, spreadsheet, and presentations correspond to Documents, Worksheets, and Presentations objects, respectively.

[0060] The word processing, spreadsheet, and presentation applications are represented by tabs similar to Excel worksheets. Each tab corresponds to a Sheet object, which can be a Document object, a Worksheet object, or a Presentation object. Sheets is a collection of all Sheet objects, with the currently active tab corresponding to the ActiveSheet. Thus, the word processing, spreadsheet, and presentation applications use the same menu with navigation buttons, and this menu dynamically changes depending on the application being switched to. The menu looks like this: Figure 3 As shown, the startup screen displays three large icons corresponding to three different applications for the user to choose from, such as... Figure 4 As shown.

[0061] To facilitate operation, this invention includes buttons for switching between different information. Specifically, users can use the Page Up and Page Down keys on the keyboard to switch between different Sheet objects. Pressing the Page Up key corresponds to the ActiveSheet.Previous.Select method, which switches to the previous Sheet; pressing the Page Down key corresponds to the ActiveSheet.Next.Select method, which switches to the next Sheet. ActiveSheet.Previous and ActiveSheet.Next represent the previous (left) and next (right) Sheet objects of the currently active tab, respectively.

[0062] To facilitate object creation, this invention also includes a button for creating new objects. This button allows the creation of word processing, spreadsheet, and presentation files (note: not just spreadsheet worksheets). These correspond to Application.AddNewDocument, Application.AddNewWorksheet, and Application.AddNewPresentation, respectively. Figure 5 As shown, you can click the "+" sign in the worksheet interface to create a new spreadsheet. The word processing interface and the slideshow interface are shown below. Figure 6 and Figure 7 As shown, to create a new word processing program, simply click the "+" sign in the word processing interface; to create a new slide, simply click the "+" sign in the slide interface.

[0063] The current chart is a Chart object. If the user wants to move the chart, after selecting the menu "Move Chart (V)," a pop-up window will display "In Slide" and "In Word Processing" (instead of Excel's "New Worksheet" and "Object in..."), which correspond to Chart.MoveToNewPresentation and Chart.MoveToNewDocuments respectively. Figure 8 As shown. In this way, when the user selects "OK", the current chart will be moved and inserted into the focus of the word processing or slide.

[0064] 2. Perform generalized spreadsheet expansion.

[0065] Managing and displaying information in tabular form is very convenient. For example, Ms-Word's tables can save formulas and images, but Excel can only save strings and numbers. When inserting tables into word processing or PowerPoint presentations, a generalized spreadsheet needs to be generated to allow the input of strings, word processing formulas, and worksheet functions (such as the SUM function) into the cells. Therefore, spreadsheets are extended to generalized spreadsheets. In a generalized spreadsheet, each cell or cell range is a Range object, which can not only save regular spreadsheet data, strings, and formulas (with Value and Formula properties), but also word processing formulas, and even images, audio, or video.

[0066] When you need to copy content from a spreadsheet to a word processor or PowerPoint presentation, select a cell range in the spreadsheet, copy it, then switch to the word processor or PowerPoint and paste it. This will create a generalized spreadsheet in the word processor or PowerPoint presentation that points to the copied cell range, and the generalized formula bar will display the corresponding reference string. For example, if you select "Copy" the cell range A1:C2 in the spreadsheet named Sheet1, switch to the word processor (or PowerPoint presentation), and press "Paste," a generalized spreadsheet will be created in the word processor (or PowerPoint presentation) that points to the copied cell range A1:C2, and the generalized formula bar will display the reference string = "Sheet1"!A1:C2.

[0067] When you need to insert a 4-row, 3-column table into a word processor, such as... Figure 9 As shown, semi-transparent row and column numbers will be automatically displayed. Simultaneously, two semi-transparent buttons will appear on the right side of the table: a maximize button and a settings button, corresponding to the `ActivedSheet.Maximize` and `ActivedSheet.Setup` methods respectively. By using the maximize button, the table can be expanded into a complete spreadsheet, as shown below. Figure 10 As shown; if you press the minimize button in a full spreadsheet, the full spreadsheet will be immediately hidden (corresponding to ActiveSheet.Visual=False), and the word processing or slideshow interface will be automatically displayed (corresponding to ActiveSheet.Visual=True).

[0068] 3. Link verification.

[0069] When creating a link, this invention creates a first object (also called a reference object) and a second object (also called a dependent object) for the created link. The first object is used to store the location information of the data source corresponding to the link, and the second object is used to store the location information of the link. Link verification can be achieved based on the created first object (reference object) and second object (dependent object).

[0070] Specifically, Selection represents the object currently receiving focus, where focus refers to the established link. When focus moves to the second object (the subordinate object), the boundary around the referenced object flashes (corresponding to Selection.Attention = True) to prompt the user to operate with caution. Simultaneously, an approval button and a trace reference button appear in the upper right corner, corresponding to Selection.Examination = True and Selection.ShowTraceArrows = True, respectively. Figure 12 As shown. Link review includes two aspects: tracking references and tracking dependencies. Therefore, clicking the review button will bring up the corresponding menu, such as... Figure 13 As shown, this includes arrows for tracking references, tracking dependencies, and deletion. Tracking references corresponds to `Selection.ShowPrecedents`, and tracking dependencies corresponds to the `Selection.ShowDependents` method. Clicking the "Track References" button will display the corresponding reference path (the location information of the linked data source), such as... Figure 14 As shown. Clicking on a word processor or a slide will jump to the corresponding location, which corresponds to Selection.Dependents.Documents.Select and Selection.Dependents.Presentation.Select.

[0071] This invention will bring up a settings window by manipulating the settings button, such as... Figure 11 As shown, by checking "Auto hide when out of focus" in the settings, the maximized spreadsheet window will be automatically hidden when switching to word processing, thus reducing visual interference for the user.

[0072] 4. Set up the generalized formula editing bar.

[0073] Applications such as word processing, spreadsheets, and presentations all have a formula bar similar to that in Excel spreadsheets, which serves as a generalized formula bar. When the current interface is a word processing or presentation, entering a formula into the generalized formula bar will return a string if the formula returns a single value, which is then inserted at the user's current focus point. If the function returns multiple values, a spreadsheet will be generated at the user's current location, and this spreadsheet will have the same height and width as the returned array. When a cell in a word processing table is selected, the generalized formula bar displays the corresponding cell's value or formula, and this value or formula is editable. If the current interface is a word processing or presentation, and the user selects a series in a chart, the generalized formula bar will display the series formula, and the series formula is also editable.

[0074] Specifically, when you need to insert a slide into word processing, you can create a Slide object in word processing by copying it from the slide worksheet and pasting it as a link. This object will appear as an image. For example, to paste the third slide from the worksheet named "Slide 1" into word processing, you can enter the following formula (function) in the word processing general formula bar:

[0075] =Slides("Slide 1"!3)

[0076] To reference slide 5, simply change the 3 in the generalized formula editing bar to 5.

[0077] If the slides in the word processing section need to be edited, you can switch to the slide interface. The slides embedded in the word processing section can be cropped on the spot like cropping an image, and the cropping will not affect the original slide information.

[0078] If the current user interface is a spreadsheet, the method and effect are the same as in Excel; if the current user interface is a word processing or PowerPoint presentation, the method for entering formulas is the same as in Excel, but the effect after the user presses Enter or clicks OK with the mouse varies depending on whether the function returns a single value or multiple values. If it is a single value, a string is returned and inserted into the user's current focus position; if the function returns multiple values ​​(an array), a table is generated at the user's current position—a generalized spreadsheet with the same height (number of rows) and width (number of columns) as the returned array.

[0079] If a user selects a cell in the word processing table, the corresponding cell's value or formula will be displayed in the general formula bar, and this value or formula is editable, such as... Figure 15As shown. When the user presses the F2 key, the referenced cells will also be highlighted, just like editing cell formulas in Excel. If the current interface is a word processing or slideshow, and the user selects a series in a chart, the general formula bar will display the series formulas, and these formulas will be editable, as shown below. Figure 16 As shown.

[0080] If you are currently editing a word processor or a presentation, enter the following in the general formula editing bar (Note: Enter via keyboard or mouse click). or This will return the content of cell A1 in the spreadsheet worksheet "Worksheet 1", regardless of whether the content of cell A1 is a number, a string, or an image.

[0081] If you are currently editing a word processor or a presentation, enter the formula in the generalized formula bar. If the worksheet Exists, generate a table range locally as follows A broad spreadsheet with cell ranges; if the worksheet If it does not exist, a table range will be generated locally. A broad definition of a spreadsheet, the corresponding worksheet name is The software detects that the worksheet name entered by the user does not exist, so it creates a worksheet in the background. This eliminates the need for the user to create a separate worksheet and then create a link in the word processing or presentation application, realizing the concept of "in-place editing".

[0082] If you are currently editing a word processor or a slideshow, enter the formula in the general formula bar. Then create one at the current position. A generalized spreadsheet.

[0083] This invention saves information in three formats—word processing, spreadsheets, and PowerPoint—into a single file, establishing links to share information in different formats. This allows changes in one location to automatically update others, and includes a link verification mechanism. It also introduces the concept of a broadened spreadsheet to enable on-the-spot editing. This integrated design automatically updates and replaces data, preventing inconsistencies and effectively reducing user workload while improving efficiency.

[0084] 5. Link updated

[0085] The link update offers three options: "Automatic Update", "Manual Update", and "Scheduled Update", with "Automatic Update" being the default.

[0086] 1) Automatic updates

[0087] When a piece of information changes, all places that directly or indirectly reference that information will also change accordingly.

[0088] 2) Manual update (F9)

[0089] When a piece of information changes, places that directly or indirectly reference this information do not change accordingly; the changes only occur when the user selects the "Manual Update" menu or presses the shortcut key "F9".

[0090] 3) Update regularly

[0091] When a piece of information changes, places that directly or indirectly reference that information will only change accordingly after a certain interval. The default interval is 60 seconds.

[0092] Implementation of all-in-one office software

[0093] The all-in-one office software in this embodiment adopts the above-described method for editing information in different formats on a single page. The specific implementation process of this method has been detailed in the method implementation description and will not be repeated here. The method can be developed using an object-oriented programming language; or developed using a web page language to achieve cross-platform operation. On the Windows platform, the user interface can be modified so that users are unaware that it was developed using a web page language.

Claims

1. A method for implementing an all-in-one office software, characterized in that, The law includes: 1) Save information in different formats into an integrated file, with each format corresponding to an application object, and use the application objects of each format as worksheet labels; the formats include at least one of word processing, spreadsheet, and PowerPoint. 2) When a link is created in an application object, a reference object is created for the created link to store the location information of the data source corresponding to the link, and a subordinate object is created at the location of the data source corresponding to the link to store the location information of the link. The created reference object and subordinate object are used to verify the link.

2. The method for implementing the integrated office software according to claim 1, characterized in that, The locations corresponding to the storage information of the referenced object and the storage information of the dependent object are both prominently designed to prompt the user, and an audit operation is set up to track the reference. The audit operation includes tracking the reference and tracking the dependent. Tracking the reference corresponds to the Selection.ShowPrecedents method, which is used to display the reference path, and tracking the dependent corresponds to the Selection.ShowDependents method.

3. The method for implementing the integrated office software according to claim 1, characterized in that, The method also includes extending the spreadsheet to a generalized spreadsheet, where each cell or range of cells is a Range object with Value and Formula properties, used to store data, strings, formulas, or images, audio, video, and word processing formulas from a regular spreadsheet.

4. The method for implementing the integrated office software according to claim 3, characterized in that, When inserting a spreadsheet into a word processor or PowerPoint presentation, the inserted spreadsheet is treated as a generalized spreadsheet.

5. The method for implementing the integrated office software according to claim 1, characterized in that, When you need to insert a slide into a word processor, create a Slide object in the word processor, and use the Slide object to edit the slide number to insert the slide into the word processor.

6. The method for implementing the integrated office software according to claim 3, characterized in that, Word processing, spreadsheets, and PowerPoint applications all have a formula editing bar, which can be considered a generalized formula editing bar.

7. The method for implementing the integrated office software according to claim 6, characterized in that, If the current interface is a word processing or slideshow, after entering a formula in the generalized formula editor, if the formula returns a single value, a string is returned and inserted into the user's current focus position; if the function returns multiple values, a spreadsheet is generated at the user's current position, which is a generalized spreadsheet with the same height and width as the returned array.

8. The method for implementing the integrated office software according to claim 6, characterized in that, When a cell in a word processing table is selected, the generalized formula bar displays the corresponding cell's value or formula, and this value or formula is editable. If the current interface is a word processing or slideshow, and the user selects a series in a chart, the generalized formula bar will display the series formula, and the series formula is editable.

9. The method for implementing the integrated office software according to claim 6, characterized in that, The method also includes selecting a cell range in a spreadsheet, performing a "copy" operation, and then switching to word processing or PowerPoint to perform a "paste" operation. This will generate a generalized spreadsheet pointing to the copied cell range at the current location in word processing or PowerPoint, while the generalized formula bar displays the corresponding reference string.

10. An all-in-one office software, characterized in that: The office software adopts the implementation method of the integrated office software as described in any one of claims 1-9.