Misplaced Pages

#228771

108-490: Google Sheets is a spreadsheet application and part of the free, web-based Google Docs Editors suite offered by Google . Google Sheets is available as a web application ; a mobile app for: Android , iOS , and as a desktop application on Google's ChromeOS . The app is compatible with Microsoft Excel file formats. The app allows users to create and edit files online while collaborating with other users in real-time. Edits are tracked by which user made them, along with

216-668: A database management system. Programs within a suite use similar commands for similar functions. Usually, sharing data between the components is easier than with a non-integrated collection of functionally equivalent programs. This was particularly an advantage at a time when many personal computer systems used text-mode displays and commands instead of a graphical user interface . Humans have organized data into tables , that is, grids of columns and rows, since ancient times. The Babylonians used clay tablets to store data as far back as 1800 BCE. Other examples can be found in book-keeping ledgers and astronomical records. Since at least 1906

324-622: A page description . PDF has (as of version 2.0) 25 graphics state properties, of which some of the most important are: As in PostScript, vector graphics in PDF are constructed with paths . Paths are usually composed of lines and cubic Bézier curves , but can also be constructed from the outlines of text. Unlike PostScript, PDF does not allow a single path to mix text outlines with lines and curves. Paths can be stroked, filled, fill then stroked, or used for clipping . Strokes and fills can use any color set in

432-526: A workbook . A workbook is physically represented by a file containing all the data for the book, the sheets, and the cells with the sheets. Worksheets are normally represented by tabs that flip between pages, each one containing one of the sheets, although Numbers changes this model significantly. Cells in a multi-sheet book add the sheet name to their reference, for instance, "Sheet 1!C10". Some systems extend this syntax to allow cell references to different workbooks. Users interact with sheets primarily through

540-403: A 3rd party for authentication or maintenance. Collabora Online runs LibreOffice kit at its core, which grew from StarOffice that was launched 39 years ago in 1985. Notable current spreadsheet software: Discontinued spreadsheet software: Several companies have attempted to break into the spreadsheet market with programs based on very different paradigms. Lotus introduced what is likely

648-496: A PDF are: In later PDF revisions, a PDF document can also support links (inside document or web page), forms, JavaScript (initially available as a plugin for Acrobat 3.0), or any other types of embedded contents that can be handled using plug-ins. PDF combines three technologies: PostScript is a page description language run in an interpreter to generate an image. It can handle graphics and has standard features of programming languages such as branching and looping . PDF

756-450: A PDF. Within text strings, characters are shown using character codes (integers) that map to glyphs in the current font using an encoding . There are several predefined encodings, including WinAnsi , MacRoman , and many encodings for East Asian languages and a font can have its own built-in encoding. (Although the WinAnsi and MacRoman encodings are derived from the historical properties of

864-420: A PostScript file could be accurately rendered only as the cumulative result of executing all preceding commands to draw all previous pages—any of which could affect subsequent pages—plus the commands to draw that particular page, and there was no easy way to bypass that process to skip around to different pages. Traditionally, to go from PostScript to PDF, a source PostScript file (that is, an executable program)

972-477: A Web browser plugin without waiting for the entire file to download, since all objects required for the first page to display are optimally organized at the start of the file. PDF files may be optimized using Adobe Acrobat software or QPDF . Page dimensions are not limited by the format itself. However, Adobe Acrobat imposes a limit of 15 million by 15 million inches, or 225 trillion in (145,161 km ). The basic design of how graphics are represented in PDF

1080-466: A compatible web browser, it can be used online and offline (with or without internet connectivity). Google Sheets originated from a web-based spreadsheet application XL2Web developed by 2Web Technologies , combined with DocVerse which enabled multiple-user online collaboration of Office documents. In 2016 Collabora Online Calc was launched, notable in that the web based spreadsheet could be hosted and integrated into any environment without dependency on

1188-689: A computer, users need to be using the Chromium -based web browser (e.g., Google Chrome , Microsoft Edge ). A Chrome extension , Google Docs Offline , allows users to enable offline support for Sheets and other Drive suite files on the Google Drive website. The Android and iOS apps natively support offline editing. Files in the following formats can be viewed and converted to the Sheets format: .xls (if newer than Microsoft Office 95 ), .xlsx, .xlsm, .xlt, .xltx, .xltm .ods, .csv, .tsv, .txt and .tab Overall document size

SECTION 10

#1733085298229

1296-437: A freeware proprietary productivity suite for mobile devices. In October 2012, Google Spreadsheets was renamed Google Sheets and a Google Chrome app was released that provided shortcuts to Sheets on Chrome's new tab page. Google Sheets is available as a web application supported on: Google Chrome , Microsoft Edge , Firefox , and Safari web browsers. Users can access all spreadsheets, among other files, collectively through

1404-436: A manual request to recalculate since the recalculation of large or complex spreadsheets often reduced data entry speed. Many modern spreadsheets still retain this option. Recalculation generally requires that there are no circular dependencies in a spreadsheet. A dependency graph is a graph that has a vertex for each object to be updated, and an edge connecting two objects whenever one of them needs to be updated earlier than

1512-452: A page description as an inline image .) Images are typically filtered for compression purposes. Image filters supported in PDF include the following general-purpose filters: Normally all image content in a PDF is embedded in the file. But PDF allows image data to be stored in external files by the use of external streams or Alternate Images . Standardized subsets of PDF, including PDF/A and PDF/X , prohibit these features. Text in PDF

1620-417: A paper for a project then code-named Camelot, in which he proposed the creation of a simplified version of PostScript called Interchange PostScript (IPS). Unlike traditional PostScript, which was tightly focused on rendering print jobs to output devices, IPS would be optimized for displaying pages to any screen and any platform. Adobe Systems made the PDF specification available free of charge in 1993. In

1728-474: A pre-programmed function in a formula. Spreadsheet programs also provide conditional expressions, functions to convert between text and numbers, and functions that operate on strings of text. Spreadsheets have replaced paper-based systems throughout the business world. Although they were first developed for accounting or bookkeeping tasks, they now are used extensively in any context where tabular lists are built, sorted, and shared. LANPAR, available in 1969,

1836-439: A printing device. PostScript was not intended for long-term storage and real-time interactive rendering of electronic documents to computer monitors , so there was no need to support anything other than consecutive rendering of pages. If there was an error in the final printed output, the user would correct it at the application level and send a new print job in the form of an entirely new PostScript file. Thus, any given page in

1944-469: A result, files that use a small amount of transparency might be viewed acceptably by older viewers, but files making extensive use of transparency could be viewed incorrectly by an older viewer. The transparency extensions are based on the key concepts of transparency groups , blending modes , shape , and alpha . The model is closely aligned with the features of Adobe Illustrator version 9. The blend modes were based on those used by Adobe Photoshop at

2052-534: A revision history. Where an editor is making changes is highlighted with an editor-specific color and cursor. A permissions system regulates what users can do. Updates have introduced features that use machine learning , including "Explore", which offers answers based on natural language questions in the spreadsheet. Sheets is one of the services provided by Google that also includes Google Docs , Google Slides , Google Drawings , Google Forms , Google Sites and Google Keep . Google Sheets originated from XL2Web,

2160-469: A stream may be used instead of the ASCII cross-reference table and contains the offsets and other information in binary format. The format is flexible in that it allows for integer width specification (using the /W array), so that for example, a document not exceeding 64  KiB in size may dedicate only 2 bytes for object offsets. At the end of a PDF file is a footer containing If a cross-reference stream

2268-464: A user's local computer in a variety of formats such as PDF and Office Open XML . Sheets supports tagging for archival and organizational purposes. Launched for the entire Drive suite in September 2016, "Explore" enables additional functionality through machine learning . In Google Sheets, Explore enables users to ask questions, such as "How many units were sold on Black Friday?" and Explore will return

SECTION 20

#1733085298229

2376-576: A variant used in VisiCalc and known as "A1 notation". Additionally, spreadsheets have the concept of a range , a group of cells, normally contiguous. For instance, one can refer to the first ten cells in the first column with the range "A1:A10". LANPAR innovated forward referencing/natural order calculation which didn't re-appear until Lotus 123 and Microsoft's MultiPlan Version 2. In modern spreadsheet applications, several spreadsheets, often known as worksheets or simply sheets , are gathered together to form

2484-416: A version that ran on IBM mainframes was introduced under the name AutoTab . ( National CSS offered a similar product, CSSTAB, which had a moderate timesharing user base by the early 1970s. A major application was opinion research tabulation.) AutoPlan/AutoTab was not a WYSIWYG interactive spreadsheet program, it was a simple scripting language for spreadsheets. The user defined the names and labels for

2592-427: A web-based spreadsheet application developed by 2Web Technologies , founded by Jonathan Rochelle and Farzad "Fuzzy" Khosrowshahi. XL2Web was acquired by Google in 2006 and turned into Google Labs Spreadsheets. It was launched as a test for a limited number of users, on a first-come, first-served basis on June 6, 2006. The limited test was later replaced with a beta version available to all Google Account holders, around

2700-415: Is a subset of PostScript, simplified to remove such control flow features, while graphics commands remain. PostScript was originally designed for a drastically different use case : transmission of one-way linear print jobs in which the PostScript interpreter would collect a series of commands until it encountered the showpage command, then execute all the commands to render a page as a raster image to

2808-464: Is also a shading pattern , which draws continuously varying colors. There are seven types of shading patterns of which the simplest are the axial shading (Type 2) and radial shading (Type 3). Raster images in PDF (called Image XObjects ) are represented by dictionaries with an associated stream. The dictionary describes the properties of the image, and the stream contains the image data. (Less commonly, small raster images may be embedded directly in

2916-486: Is an accepted version of this page Portable Document Format ( PDF ), standardized as ISO 32000 , is a file format developed by Adobe in 1992 to present documents , including text formatting and images, in a manner independent of application software , hardware , and operating systems . Based on the PostScript language, each PDF file encapsulates a complete description of a fixed-layout flat document, including

3024-588: Is available. The service includes a web clipboard tool that allows users to copy and paste content between Google Sheets and Google Docs, Google Slides, and Google Drawings. The web clipboard can also be used for copying and pasting content between different computers. Copied items are stored on Google's servers for up to 30 days. Google offers an extension for the Google Chrome web browser called Office editing for Docs, Sheets and Slides that enables users to view and edit Microsoft Excel documents on Google Chrome, via

3132-465: Is called an embedded font while the former is called an unembedded font . The font files that may be embedded are based on widely used standard digital font formats: Type 1 (and its compressed variant CFF), TrueType , and (beginning with PDF 1.6) OpenType . Additionally PDF supports the Type 3 variant in which the components of the font are described by PDF graphic operators. Fourteen typefaces, known as

3240-540: Is capped at 10 million cells. The Sheets app and the rest of the Google Docs Editors suite are free to use for individuals, but Sheets is also available as part of the business-centered Google Workspace (formerly G Suite) service by Google, which is a monthly subscription that enables additional business-focused functionality. Sheets can produce Google Charts and has a third-party plugin which allows for integration with Misplaced Pages. A simple find and replace tool

3348-464: Is indistinguishable from a batch compiler with added input data, producing an output report, i.e. , a 4GL or conventional, non-interactive, batch computer program. However, this concept of an electronic spreadsheet was outlined in the 1961 paper "Budgeting Models and System Simulation" by Richard Mattessich . The subsequent work by Mattessich (1964a, Chpt. 9, Accounting and Analytical Methods ) and its companion volume, Mattessich (1964b, Simulation of

Google Sheets - Misplaced Pages Continue

3456-418: Is not being used, the footer is preceded by the trailer keyword followed by a dictionary containing information that would otherwise be contained in the cross-reference stream object's dictionary: Within each page, there are one or multiple content streams that describe the text, vector and images being drawn on the page. The content stream is stack-based , similar to PostScript. There are two layouts to

3564-541: Is not required in situations where a PDF file is intended only for print. Since the feature is optional, and since the rules for tagged PDF were relatively vague in ISO 32000-1, support for tagged PDF among consuming devices, including assistive technology (AT), is uneven as of 2021. ISO 32000-2, however, includes an improved discussion of tagged PDF which is anticipated to facilitate further adoption. An ISO-standardized subset of PDF specifically targeted at accessibility, PDF/UA ,

3672-434: Is organized using ASCII characters, except for certain elements that may have binary content. The file starts with a header containing a magic number (as a readable string) and the version of the format, for example %PDF-1.7 . The format is a subset of a COS ("Carousel" Object Structure) format. A COS tree file consists primarily of objects , of which there are nine types: Comments using 8-bit characters prefixed with

3780-402: Is represented by text elements in page content streams. A text element specifies that characters should be drawn at certain positions. The characters are specified using the encoding of a selected font resource . A font object in PDF is a description of a digital typeface . It may either describe the characteristics of a typeface, or it may include an embedded font file . The latter case

3888-465: Is represented with an editor-specific color/cursor, so if another editor happens to be viewing that part of the document they can see edits as they occur. A sidebar chat functionality allows collaborators to discuss edits. The revision history allows users to see the additions made to a document, with each author distinguished by color. Only adjacent revisions can be compared and users cannot control how frequently revisions are saved. Files can be exported to

3996-439: Is used as the basis for generating PostScript-like PDF code (see, e.g., Adobe Distiller ). This is done by applying standard compiler techniques like loop unrolling , inlining and removing unused branches, resulting in code that is purely declarative and static. The end result is then packaged into a container format , together with all necessary dependencies for correct rendering (external files, graphics, or fonts to which

4104-511: Is usually referenced by its column and row (C2 would represent the cell containing the value 30 in the example table below). Usually rows, representing the dependent variables , are referenced in decimal notation starting from 1, while columns representing the independent variables use 26-adic bijective numeration using the letters A-Z as numerals. Its physical size can usually be tailored to its content by dragging its height or width at box intersections (or for entire columns or rows by dragging

4212-447: Is very similar to that of PostScript, except for the use of transparency, which was added in PDF 1.4. PDF graphics use a device-independent Cartesian coordinate system to describe the surface of a page. A PDF page description can use a matrix to scale , rotate , or skew graphical elements. A key concept in PDF is that of the graphics state , which is a collection of graphical parameters that may be changed, saved, and restored by

4320-563: The Google Drive website. In June 2014, Google rolled out a dedicated website homepage for Sheets that contain only files created with Sheets. In 2014, Google launched a dedicated mobile app for Sheets on the Android and iOS mobile operating systems. In 2015, the mobile website for Sheets was updated with a "simpler, more uniform" interface. While users can read spreadsheets through the mobile websites, users trying to edit will be redirected towards

4428-533: The Windows and Macintosh operating systems, fonts using these encodings work equally well on any platform.) PDF can specify a predefined encoding to use, the font's built-in encoding or provide a lookup table of differences to a predefined or built-in encoding (not recommended with TrueType fonts). The encoding mechanisms in PDF were designed for Type 1 fonts, and the rules for applying them to TrueType fonts are complex. For large fonts or fonts with non-standard glyphs,

Google Sheets - Misplaced Pages Continue

4536-426: The personal computer from a hobby for computer enthusiasts into a business tool. VisiCalc was the first spreadsheet that combined many of the essential features of modern spreadsheet applications, such as a WYSIWYG interactive user interface, automatic recalculation, status and formula lines, range copying with relative and absolute references, and formula building by selecting referenced cells. Unaware of LANPAR at

4644-462: The professor and manipulate it to represent it and show ratios etc. In 1964, a book entitled Business Computer Language was written by Kimball, Stoffells and Walsh. Both the book and program were copyrighted in 1966 and years later that copyright was renewed. Applied Data Resources had a FORTRAN preprocessor called Empires. In the late 1960s, Xerox used BCL to develop a more sophisticated version for their timesharing system. A key invention in

4752-400: The relational structure of a database. Spreadsheets and databases are interoperable—sheets can be imported into databases to become tables within them, and database queries can be exported into spreadsheets for further analysis. A spreadsheet program is one of the main components of an office productivity suite , which usually also contains a word processor , a presentation program , and

4860-419: The standard 14 fonts , have a special significance in PDF documents: These fonts are sometimes called the base fourteen fonts . These fonts, or suitable substitute fonts with the same metrics, should be available in most PDF readers, but they are not guaranteed to be available in the reader, and may only display correctly if the system has them installed. Fonts may be substituted if they are not embedded in

4968-611: The Apple II, this helped it grow in popularity. Lotus 1-2-3 was the leading spreadsheet for several years. Microsoft released the first version of Excel for the Apple Macintosh on September 30, 1985, and then ported it to Windows, with the first version being numbered 2.05 (to synchronize with the Macintosh version 2.2) and released in November 1987. Microsoft's Windows 3.x platforms of

5076-572: The Federal Circuit (CCPA), overturning the Patent Office in 1983 — establishing that "something does not cease to become patentable merely because the point of novelty is in an algorithm." However, in 1995 a federal district court ruled the patent unenforceable due to inequitable conduct by the inventors during the application process. The United States Court of Appeals for the Federal Circuit upheld that decision in 1996. The actual software

5184-509: The Firm through a Budget Computer Program ) applied computerized spreadsheets to accounting and budgeting systems (on mainframe computers programmed in FORTRAN IV ). These batch Spreadsheets dealt primarily with the addition or subtraction of entire columns or rows (of input variables), rather than individual cells . In 1962, this concept of the spreadsheet, called BCL for Business Computer Language,

5292-483: The Google Sheets app. The extension can be used for opening Excel files stored on the computer using Chrome, as well as for opening files encountered on the web (in the form of email attachments, web search results, etc.) without having to download them. The extension is installed on ChromeOS by default. As of June 2019, this extension is no longer required since the functionality exists natively. Google Cloud Connect

5400-429: The PDF files: non-linearized (not "optimized") and linearized ("optimized"). Non-linearized PDF files can be smaller than their linear counterparts, though they are slower to access because portions of the data required to assemble pages of the document are scattered throughout the PDF file. Linearized PDF files (also called "optimized" or "web optimized" PDF files) are constructed in a manner that enables them to be read in

5508-457: The X and Y locations. X locations, the columns, are normally represented by letters, "A," "B," "C," etc., while rows are normally represented by numbers, 1, 2, 3, etc. A single cell can be referred to by addressing its row and column, "C10". This electronic concept of cell references was first introduced in LANPAR (Language for Programming Arrays at Random) (co-invented by Rene Pardo and Remy Landau) and

SECTION 50

#1733085298229

5616-506: The answer, without requiring formula knowledge from the user. In June 2017, Google expanded the Explore feature in Google Sheets to automatically build charts and visualize data and again expanded it in December to feature machine learning capable of automatically creating pivot tables. In October 2016, Google announced the addition of "Action items" to Sheets. If a user assigns a task within a Sheet,

5724-438: The business plans that they were presenting to venture capitalists. They decided to save themselves a lot of effort and wrote a computer program that produced their tables for them. This program, originally conceived as a simple utility for their personal use, would turn out to be the first software product offered by the company that would become known as Capex Corporation . "AutoPlan" ran on GE's Time-sharing service; afterward,

5832-416: The cell itself. Alternatively, a value can be based on a formula (see below), which might perform a calculation, display the current date or time, or retrieve external data such as a stock quote or a database value. The Spreadsheet Value Rule Computer scientist Alan Kay used the term value rule to summarize a spreadsheet's operation: a cell's value relies solely on the formula the user has typed into

5940-404: The cell. The formula may rely on the value of other cells, but those cells are likewise restricted to user-entered data or formulas. There are no 'side effects' to calculating a formula: the only output is to display the calculated result inside its occupying cell. There is no natural mechanism for permanently modifying the contents of a cell unless the user manually modifies the cell's contents. In

6048-420: The cells. A given cell can hold data by simply entering it in, or a formula, which is normally created by preceding the text with an equals sign. Data might include the string of text hello world , the number 5 or the date 10-Sep-97 . A formula would begin with the equals sign, =5*3 , but this would normally be invisible because the display shows the result of the calculation, 15 in this case, not

6156-436: The cells. Formulas say how to mechanically compute new values from existing values. Values are general numbers, but can also be pure text, dates, months, etc. Extensions of these concepts include logical spreadsheets. Various tools for programming sheets, visualizing data, remotely connecting sheets, displaying cells' dependencies, etc. are commonly provided. A "cell" can be thought of as a box for holding data . A single cell

6264-418: The column- or row-headers). An array of cells is called a sheet or worksheet . It is analogous to an array of variables in a conventional computer program (although certain unchanging values, once entered, could be considered, by the same analogy, constants ). In most implementations, many worksheets may be located within a single spreadsheet. A worksheet is simply a subset of the spreadsheet divided for

6372-508: The contents. PDF 2.0 defines 256-bit AES encryption as the standard for PDF 2.0 files. The PDF Reference also defines ways that third parties can define their own encryption systems for PDF. PDF files may be digitally signed, to provide secure authentication; complete details on implementing digital signatures in PDF are provided in ISO 32000-2. PDF files may also contain embedded DRM restrictions that provide further controls that limit copying, editing, or printing. These restrictions depend on

6480-426: The context of programming languages, this yields a limited form of first-order functional programming . A standard of spreadsheets since the 1980s, this optional feature eliminates the need to manually request the spreadsheet program to recalculate values (nowadays typically the default option unless specifically 'switched off' for large spreadsheets, usually to improve performance). Some earlier spreadsheets required

6588-462: The development of electronic spreadsheets was made by Rene K. Pardo and Remy Landau, who filed in 1970 U.S. patent 4,398,249 on a spreadsheet automatic natural order calculation algorithm . While the patent was initially rejected by the patent office as being a purely mathematical invention, following 12 years of appeals, Pardo and Landau won a landmark court case at the Predecessor Court of

SECTION 60

#1733085298229

6696-411: The document refers), and compressed . Modern applications write to printer drivers that directly generate PDF rather than going through PostScript first. As a document format, PDF has several advantages over PostScript: Its disadvantages are: PDF since v1.6 supports embedding of interactive 3D documents: 3D drawings can be embedded using U3D or PRC and various other data formats. A PDF file

6804-411: The document root. This dictionary contains an array of Optional Content Groups (OCGs), each describing a set of information and each of which may be individually displayed or suppressed, plus a set of Optional Content Configuration Dictionaries, which give the status (Displayed or Suppressed) of the given OCGs. A PDF file may be encrypted , for security, in which case a password is needed to view or edit

6912-499: The early 1990s made it possible for their Excel spreadsheet application to take market share from Lotus. By the time Lotus responded with usable Windows products, Microsoft had begun to assemble their Office suite. By 1995, Excel was the market leader, edging out Lotus 1-2-3, and in 2013, IBM discontinued Lotus 1-2-3 altogether. In 2006 Google launched their beta release Google Sheets , a web based spreadsheet application that can be accessed by multiple users from any device type using

7020-527: The early years PDF was popular mainly in desktop publishing workflows, and competed with several other formats, including DjVu , Envoy , Common Ground Digital Paper, Farallon Replica and even Adobe's own PostScript format. PDF was a proprietary format controlled by Adobe until it was released as an open standard on July 1, 2008, and published by the International Organization for Standardization as ISO 32000-1:2008, at which time control of

7128-459: The entire spreadsheet) can optionally be "locked" to prevent accidental overwriting. Typically this would apply to cells containing formulas but might apply to cells containing "constants" such as a kilogram/pounds conversion factor (2.20462262 to eight decimal places). Even though individual cells are marked as locked, the spreadsheet data are not protected until the feature is activated in the file preferences. Portable Document Format This

7236-404: The first "non-procedural" computer languages) as opposed to left-to-right, top to bottom sequence for calculating the results in each cell that was used by VisiCalc , SuperCalc , and the first version of MultiPlan . Without forward referencing/natural order calculation, the user had to refresh the spreadsheet until the values in all cells remained unchanged. Once the cell values stayed constant,

7344-411: The formula itself. This may lead to confusion in some cases. The key feature of spreadsheets is the ability for a formula to refer to the contents of other cells, which may, in turn, be the result of a formula. To make such a formula, one replaces a number with a cell reference. For instance, the formula =5*C10 would produce the result of multiplying the value in cell C10 by the number 5. If C10 holds

7452-406: The full implementation of the ISO 32000-1 specification. These proprietary technologies are not standardized, and their specification is published only on Adobe's website. Many of them are not supported by popular third-party implementations of PDF. ISO published version 2.0 of PDF, ISO 32000-2 in 2017, available for purchase, replacing the free specification provided by Adobe. In December 2020,

7560-402: The graphics state, including patterns . PDF supports several types of patterns. The simplest is the tiling pattern in which a piece of artwork is specified to be drawn repeatedly. This may be a colored tiling pattern , with the colors specified in the pattern object, or an uncolored tiling pattern , which defers color specification to the time the pattern is drawn. Beginning with PDF 1.3 there

7668-494: The imaging model. A tagged PDF (see clause 14.8 in ISO 32000) includes document structure and semantics information to enable reliable text extraction and accessibility . Technically speaking, tagged PDF is a stylized use of the format that builds on the logical structure framework introduced in PDF 1.3. Tagged PDF defines a set of standard structure types and attributes that allow page content (text, graphics, and images) to be extracted and reused for other purposes. Tagged PDF

7776-418: The largest market share on the Windows and Macintosh platforms. A spreadsheet program is a standard feature of an office productivity suite . In 2006 Google launched a beta release spreadsheet web application , this is currently known as Google Sheets and one of the applications provided in Google Drive . A spreadsheet consists of a table of cells arranged into rows and columns and referred to by

7884-594: The legacy batch system into each user's spreadsheet monthly. It was designed to optimize the power of APL through object kernels, increasing program efficiency by as much as 50 fold over traditional programming approaches. An example of an early "industrial weight" spreadsheet was APLDOT, developed in 1976 at the United States Railway Association on an IBM 360/91, running at The Johns Hopkins University Applied Physics Laboratory in Laurel, MD. The application

7992-489: The mobile app to eliminate editing on the mobile web. Google Sheets serves as a collaborative tool for cooperative editing of spreadsheets in real time. Documents can be shared, opened, and edited by multiple users simultaneously and users can see character-by-character changes as other collaborators make edits. Changes are automatically saved to Google's servers and a revision history is automatically kept so past edits may be viewed and reverted to. An editor's current position

8100-524: The model to view results of underlying formulas. His idea became VisiCalc. VisiCalc for the Apple II went on to become the first killer application , a program so compelling, people would buy a particular computer just to use it. It was ported to other computers, including CP/M machines, Atari 8-bit computers , and the Commodore PET , but VisiCalc remains best known as an Apple II program. SuperCalc

8208-423: The most successful example, Lotus Improv , which saw some commercial success, notably in the financial world where its powerful data mining capabilities remain well respected to this day. Spreadsheet 2000 attempted to dramatically simplify formula construction, but was generally not successful. The main concepts are those of a grid of cells , called a sheet, with either raw data, called values, or formulas in

8316-438: The numbers within a range. Spreadsheets share many principles and traits of databases , but spreadsheets and databases are not the same things. A spreadsheet is essentially just one table, whereas a database is a collection of many tables with machine-readable semantic relationships. While it is true that a workbook that contains three sheets is indeed a file containing multiple tables that can interact with each other, it lacks

8424-440: The objects in the file, and also allows for small changes to be made without rewriting the entire file ( incremental update ). Before PDF version 1.5, the table would always be in a special ASCII format, be marked with the xref keyword, and follow the main body composed of indirect objects. Version 1.5 introduced optional cross-reference streams , which have the form of a standard stream object, possibly with filters applied. Such

8532-911: The other hand. Excel interprets "0" as meaning December 31, 1899, which is formatted to read January 0, 1900. Launched in December 2022, Simple ML is the Google's add-on for machine learning . Spreadsheet Spreadsheet users can adjust any stored value and observe the effects on calculated values. This makes the spreadsheet useful for "what-if" analysis since many cases can be rapidly investigated without manual recalculation. Modern spreadsheet software can have multiple interacting sheets and can display data either as text and numerals or in graphical form. Besides performing basic arithmetic and mathematical functions , modern spreadsheets provide built-in functions for common financial accountancy and statistical operations. Such calculations as net present value or standard deviation can be applied to tabular data with

8640-542: The other. Dependency graphs without circular dependencies form directed acyclic graphs , representations of partial orderings (in this case, across a spreadsheet) that can be relied upon to give a definite result. This feature refers to updating a cell's contents periodically with a value from an external source—such as a cell in a "remote" spreadsheet. For shared, Web-based spreadsheets, it applies to "immediately" updating cells another user has updated. All dependent cells must be updated also. Once entered, selected cells (or

8748-552: The percent sign ( % ) may be inserted. Objects may be either direct (embedded in another object) or indirect . Indirect objects are numbered with an object number and a generation number and defined between the obj and endobj keywords if residing in the document root. Beginning with PDF version 1.5, indirect objects (except other streams) may also be located in special streams known as object streams (marked /Type /ObjStm ). This technique enables non-stream objects to have standard stream filters applied to them, reduces

8856-418: The programming language from the end-user. Through IBM's VM operating system , it was among the first programs to auto-update each copy of the application as new versions were released. Users could specify simple mathematical relationships between rows and between columns. Compared to any contemporary alternatives, it could support very large spreadsheets. It loaded actual financial planning data drawn from

8964-427: The right order ("Forward Referencing/Natural Order Calculation"). Pardo and Landau developed and implemented the software in 1969. LANPAR was used by Bell Canada, AT&T, and the 18 operating telephone companies nationwide for their local and national budgeting operations. LANPAR was also used by General Motors. Its uniqueness was Pardo's co-invention incorporating forward referencing/natural order calculation (one of

9072-464: The rows and columns, then the formulas that defined each row or column. In 1975, Autotab-II was advertised as extending the original to a maximum of " 1,500 rows and columns, combined in any proportion the user requires... " GE Information Services, which operated the time-sharing service, also launched its own spreadsheet system, Financial Analysis Language (FAL), circa 1974. It was later supplemented by an additional spreadsheet language, TABOL, which

9180-415: The sake of clarity. Functionally, the spreadsheet operates as a whole and all cells operate as global variables within the spreadsheet (each variable having 'read' access only except its containing cell). A cell may contain a value or a formula , or it may simply be left empty. By convention, formulas usually begin with = sign. A value can be entered from the computer keyboard by directly typing into

9288-414: The same document at the same time. However, Google Cloud Connect has been discontinued as of April 30, 2013, as, according to Google, Google Drive achieves all of the above tasks, "with better results". While Microsoft Excel maintains the 1900 Leap year bug , Google sheets 'fixes' this bug by increasing all dates before March 1, 1900, so entering "0" and formatting it as a date returns December 30, 1899. On

9396-496: The same time as an official announcement press release was issued. In March 2010, Google acquired the online document collaboration company DocVerse. DocVerse allowed multiple-user online collaboration on Excel-compatible documents as well as other Microsoft Office formats such as Microsoft Word and Microsoft PowerPoint . Improvements based on DocVerse were announced and deployed in April 2010. In June 2012, Google acquired Quickoffice ,

9504-495: The second edition of PDF 2.0, ISO 32000-2:2020, was published, with clarifications, corrections, and critical updates to normative references (ISO 32000-2 does not include any proprietary technologies as normative references). In April 2023 the PDF Association made ISO 32000-2 available for download free of charge. A PDF file is often a combination of vector graphics , text, and bitmap graphics . The basic types of content in

9612-466: The service will intelligently assign that action to the designated user. Google states this will make it easier for other collaborators to visualize who is responsible for a task. When a user visits Google Drive or Sheets, any files containing tasks assigned to them will be highlighted with a badge. In March 2014, Google introduced add-ons; new tools from third-party developers that add more features for Google Sheets. To view and edit spreadsheets offline on

9720-423: The size of files that have large numbers of small indirect objects and is especially useful for Tagged PDF . Object streams do not support specifying an object's generation number (other than 0). An index table, also called the cross-reference table, is located near the end of the file and gives the byte offset of each indirect object from the start of the file. This design allows for efficient random access to

9828-432: The special encodings Identity-H (for horizontal writing) and Identity-V (for vertical) are used. With such fonts, it is necessary to provide a ToUnicode table if semantic information about the characters is to be preserved. A text document which is scanned to PDF without the text being recognised by optical character recognition (OCR) is an image, with no fonts or text properties. The original imaging model of PDF

9936-577: The specification passed to an ISO Committee of volunteer industry experts. In 2008, Adobe published a Public Patent License to ISO 32000-1 granting royalty-free rights for all patents owned by Adobe necessary to make, use, sell, and distribute PDF-compliant implementations. PDF 1.7, the sixth edition of the PDF specification that became ISO 32000-1, includes some proprietary technologies defined only by Adobe, such as Adobe XML Forms Architecture (XFA) and JavaScript extension for Acrobat, which are referenced by ISO 32000-1 as normative and indispensable for

10044-480: The term "spread sheet" has been used in accounting to mean a grid of columns and rows in a ledger. And prior to the rise of computerized spreadsheets, "spread" referred to a newspaper or magazine item (text or graphics) that covers two facing pages, extending across the centerfold and treating the two pages as one large page. The compound word 'spread-sheet' came to mean the format used to present book-keeping ledgers—with columns for categories of expenditures across

10152-835: The text, fonts , vector graphics , raster images and other information needed to display it. PDF has its roots in "The Camelot Project" initiated by Adobe co-founder John Warnock in 1991. PDF was standardized as ISO 32000 in 2008. The last edition as ISO 32000-2:2020 was published in December 2020. PDF files may contain a variety of content besides flat text and graphics including logical structuring elements, interactive elements such as annotations and form-fields, layers, rich media (including video content), three-dimensional objects using U3D or PRC , and various other data formats . The PDF specification also provides for encryption and digital signatures , file attachments, and metadata to enable workflows requiring these features. The development of PDF began in 1991 when John Warnock wrote

10260-416: The time, PC World magazine called VisiCalc the first electronic spreadsheet. Bricklin has spoken of watching his university professor create a table of calculation results on a blackboard . When the professor found an error, he had to tediously erase and rewrite several sequential entries in the table, triggering Bricklin to think that he could replicate the process on a computer, using the blackboard as

10368-448: The time. When the PDF 1.4 specification was published, the formulas for calculating blend modes were kept secret by Adobe. They have since been published. The concept of a transparency group in PDF specification is independent of existing notions of "group" or "layer" in applications such as Adobe Illustrator. Those groupings reflect logical relationships among objects that are meaningful when editing those objects, but they are not part of

10476-418: The top, invoices listed down the left margin, and the amount of each payment in the cell where its row and column intersect—which were, traditionally, a "spread" across facing pages of a bound ledger (book for keeping accounting records) or on oversized sheets of paper (termed 'analysis paper') ruled into rows and columns in that format and approximately twice as wide as ordinary paper. A batch "spreadsheet"

10584-508: The user was assured that there were no remaining forward references within the spreadsheet. In 1968, three former employees from the General Electric computer company headquartered in Phoenix, Arizona set out to start their own software development house . A. Leroy Ellison, Harry N. Cantrell, and Russell E. Edwards found themselves doing a large number of calculations when making tables for

10692-473: The value 3 the result will be 15 . But C10 might also hold its formula referring to other cells, and so on. The ability to chain formulas together is what gives a spreadsheet its power. Many problems can be broken down into a series of individual mathematical steps, and these can be assigned to individual formulas in cells. Some of these formulas can apply to ranges as well, like the SUM function that adds up all

10800-481: Was opaque, similar to PostScript, where each object drawn on the page completely replaced anything previously marked in the same location. In PDF 1.4 the imaging model was extended to allow transparency. When transparency is used, new objects interact with previously marked objects to produce blending effects. The addition of transparency to PDF was done by means of new extensions that were designed to be ignored in products written to PDF 1.3 and earlier specifications. As

10908-541: Was a plug-in for Microsoft Office 2003, 2007, and 2010 that could automatically store and synchronize any Excel document to Google Sheets (before the introduction of Drive). The online copy was automatically updated each time the Microsoft Excel document was saved. Microsoft Excel documents could be edited offline and synchronized later when online. Google Cloud Connect maintained previous Microsoft Excel document versions and allowed multiple users to collaborate by working on

11016-631: Was a spreadsheet application published by Sorcim in 1980, and originally bundled (along with WordStar) as part of the CP/M software package included with the Osborne 1 portable computer. It quickly became the de facto standard spreadsheet for CP/M. The introduction of Lotus 1-2-3 in November 1982 accelerated the acceptance of the IBM Personal Computer . It was written especially for IBM PC DOS and had improvements in speed and graphics compared to VisiCalc on

11124-476: Was called LANPAR — LANguage for Programming Arrays at Random. This was conceived and entirely developed in the summer of 1969, following Pardo and Landau's recent graduation from Harvard University. Co-inventor Rene Pardo recalls that he felt that one manager at Bell Canada should not have to depend on programmers to program and modify budgeting forms, and he thought of letting users type out forms in any order and having an electronic computer calculate results in

11232-463: Was developed by an independent author, Oliver Vellacott in the UK. Both FAL and TABOL were integrated with GEIS's database system, DMS. The IBM Financial Planning and Control System was developed in 1976, by Brian Ingham at IBM Canada. It was implemented by IBM in at least 30 countries. It ran on an IBM mainframe and was the first application for financial planning developed with APL that completely hid

11340-511: Was first published in 2012. With the introduction of PDF version 1.5 (2003) came the concept of Layers. Layers, more formally known as Optional Content Groups (OCGs), refer to sections of content in a PDF document that can be selectively viewed or hidden by document authors or viewers. This capability is useful in CAD drawings, layered artwork, maps, multi-language documents, etc. Basically, it consists of an Optional Content Properties Dictionary added to

11448-553: Was implemented on an IBM 1130 and in 1963 was ported to an IBM 7040 by R. Brian Walsh at Marquette University , Wisconsin . This program was written in Fortran . Primitive timesharing was available on those machines. In 1968 BCL was ported by Walsh to the IBM 360 /67 timesharing machine at Washington State University . It was used to assist in the teaching of finance to business students. Students were able to take information prepared by

11556-419: Was the first electronic spreadsheet on mainframe and time sharing computers. LANPAR was an acronym: LANguage for Programming Arrays at Random. VisiCalc (1979) was the first electronic spreadsheet on a microcomputer, and it helped turn the Apple II into a popular and widely used personal computer. Lotus 1-2-3 was the leading spreadsheet when DOS was the dominant operating system. Microsoft Excel now has

11664-546: Was used successfully for many years in developing such applications as financial and costing models for the US Congress and for Conrail . APLDOT was dubbed a "spreadsheet" because financial analysts and strategic planners used it to solve the same problems they addressed with paper spreadsheet pads. The concept of spreadsheets became widely known due to VisiCalc , developed for the Apple II in 1979 by VisiCorp staff Dan Bricklin and Bob Frankston . Significantly, it also turned

#228771