ViewSheet

Last updated
ViewSheet
Original author(s) Mark Colton
Developer(s) Acornsoft
Initial release1984
Platform BBC Micro, Acorn Electron
Type Spreadsheet
License Proprietary

ViewSheet is a spreadsheet program produced in the 1980s by Acornsoft for use with the BBC Micro and Acorn Electron microcomputers. [1] It was distributed as a pre-installed ROM with some computer models, such as the Master. ViewSheet was written by Mark Colton.

Contents

Description

ViewSheet supports spreadsheets of up to 255 by 255 cells in size. Each cell can contain a number, formula or text label. Cells are referred to as slots in the official Acornsoft documentation. [2] The program is supplied with a keyboard card listing the various commands, which on the BBC Micro is placed under the clear plastic strip above the function keys.

The spreadsheet is entered by typing *SHEET. All BBC Micro screen modes are supported, and the background and foreground colours can be changed by use of Ctrl-S,n,n,0,0,0 key sequences. [1]

The program supports user-defined windows that can display cells from various different parts of the spreadsheet within the same screen. This is useful in lieu of a WIMP environment, as it saves the user the inconvenience of moving back and forth around the spreadsheet to view cells which are far apart from each other.

ViewSheet supports saving of spreadsheets to both disk and tape and printing to both serial and parallel printers. These operations are performed in command mode, which also allows changing various options such as VDU settings and screen resolution. The program also integrates with Acornsoft's View word processor, allowing mixing of spreadsheet data and word processor text within the same printout. There's also a built-in facility for generating character-based bar charts. [2]

Cells can be left or right justified and formatted according to a user specified layout. Numeric values are stored internally as five-byte floating point numbers. The ViewSheet file format is documented on page 128 of the supplied user guide, [2] which also contains an example BBC BASIC program to print out values from a saved spreadsheet.

ViewSheet takes advantage of a second 6502 processor, which triples the amount of memory available for spreadsheets, assuming the default screen mode is used (mode 3). [2]

Critical reception

ViewSheet was reviewed by Gordon Taylor in the January 1985 edition of A&B computing [3] and a book ViewSheet and Viewstore: A Dabhand Guide by Graham Bell was published by Dabs Press in 1989. [4]

David Brown, in his review for The Micro User states that ViewSheet "succeeds in providing all the basic spreadsheet functions in a well presented package". Although, he also cites several shortcomings of the program, writing "In conclusion, Viewsheet's major failing is to provide adequate facilities for textual labelling." and finishes by noting "Acornsoft is capable of producing better programs". [1]

Related Research Articles

<span class="mw-page-title-main">Acorn Electron</span> Personal computer sold in Britain

The Acorn Electron was a lower-cost alternative to the BBC Micro educational/home computer, also developed by Acorn Computers Ltd, to provide many of the features of that more expensive machine at a price more competitive with that of the ZX Spectrum. It had 32 kilobytes of RAM, and its ROM included BBC BASIC II together with the operating system. Announced in 1982 for a possible release the same year, it was eventually introduced on 25 August 1983 priced at £199.

<span class="mw-page-title-main">Microsoft Excel</span> Spreadsheet editor, part of Microsoft Office

Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android, iOS and iPadOS. It features calculation or computation capabilities, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications (VBA). Excel forms part of the Microsoft 365 suite of software.

<span class="mw-page-title-main">Spreadsheet</span> Computer application for organization, analysis, and storage of data in tabular form

A spreadsheet is a computer application for computation, organization, analysis and storage of data in tabular form. Spreadsheets were developed as computerized analogs of paper accounting worksheets. The program operates on data entered in cells of a table. Each cell may contain either numeric or text data, or the results of formulas that automatically calculate and display a value based on the contents of other cells. The term spreadsheet may also refer to one such electronic document.

<span class="mw-page-title-main">BBC BASIC</span> Version of the BASIC programming language

BBC BASIC is a version of the BASIC programming language released in 1981 as the native programming language for the BBC Micro home/personal computer, providing a standardized language for a UK computer literacy project of the BBC. It was written mainly by Sophie Wilson.

<span class="mw-page-title-main">Acorn Archimedes</span> Personal computer

Acorn Archimedes is a family of personal computers designed by Acorn Computers of Cambridge, England. The systems are based on Acorn's own ARM architecture processors and the proprietary operating systems Arthur and RISC OS. The first models were introduced in 1987, and systems in the Archimedes family were sold until the mid-1990s.

<span class="mw-page-title-main">Acorn Atom</span> Acorn Computers home computer, 1979–1982

The Acorn Atom is a home computer made by Acorn Computers Ltd from 1979 to 1982, when it was replaced by the BBC Micro. The BBC Micro began life as an upgrade to the Atom, originally known as the Proton.

<i>Elite</i> (video game) 1984 video game

Elite is a space trading video game. It was written and developed by David Braben and Ian Bell and originally published by Acornsoft for the BBC Micro and Acorn Electron computers in September 1984. Elite's open-ended game model, and revolutionary 3D graphics led to it being ported to virtually every contemporary home computer system and earned it a place as a classic and a genre maker in gaming history. The game's title derives from one of the player's goals of raising their combat rating to the exalted heights of "Elite".

Acornsoft was the software arm of Acorn Computers, and a major publisher of software for the BBC Micro and Acorn Electron. As well as games, it also produced a large number of educational titles, extra computer languages and business and utility packages – these included word processor VIEW and the spreadsheet ViewSheet supplied on ROM and cartridge for the BBC Micro/Acorn Electron and included as standard in the BBC Master and Acorn Business Computer.

<span class="mw-page-title-main">Enterprise (computer)</span> Zilog Z80-based home computer

The Enterprise is a Zilog Z80-based home computer announced in 1983, but through a series of delays, not commercially available until 1985. The specification as released was powerful and one of the higher end in its class. This was due to the use of ASICs for graphics and sound which took workload away from the CPU, an extensive implementation of ANSI BASIC and a bank switching system to allow for larger amounts of RAM than the Z80 natively supported. It also featured a distinctive and colourful case design, and promise of multiple expansion options. Ultimately it was not commercially successful, after multiple renames, delays and a changing market place. Its manufacturer calling in the receivers in 1986 with significant debt. It was developed by British company Intelligent Software and marketed by Enterprise Computers. Its two variants are the Enterprise 64, with 64 kilobytes of Random Access Memory (RAM), and the Enterprise 128, with 128 KB of RAM.

<span class="mw-page-title-main">BBC Domesday Project</span> Crowdsourced born-digital description of the UK, published in 1986

The BBC Domesday Project was a partnership between Acorn Computers, Philips, Logica, and the BBC to mark the 900th anniversary of the original Domesday Book, an 11th-century census of England. It has been cited as an example of digital obsolescence on account of the physical medium used for data storage.

<span class="mw-page-title-main">BBC Master</span> Microcomputer

The BBC Master is a home computer released by Acorn Computers in early 1986. It was designed and built for the British Broadcasting Corporation (BBC) and was the successor to the BBC Micro Model B. The Master 128 remained in production until 1993.

The Acorn Business Computer (ABC) was a series of microcomputers announced at the end of 1983 by the British company Acorn Computers. The series of eight computers was aimed at the business, research and further education markets. Demonstrated at the Personal Computer World Show in September 1984, having been under development for "about a year" and having been undergoing field trials from May 1984, the range "understandably attracted a great deal of attention" and was favourably received by some commentators. The official launch of the range was scheduled for January 1985.

In computing, caret navigation is a kind of keyboard navigation where a caret is used to navigate within a text document.

<span class="mw-page-title-main">Acorn MOS</span> Computer operating system

The Machine Operating System (MOS) or OS is a discontinued computer operating system (OS) used in Acorn Computers' BBC computer range. It included support for four-channel sound, graphics, file system abstraction, and digital and analogue input/output (I/O) including a daisy-chained expansion bus. The system was single-tasking, monolithic and non-reentrant.

<span class="mw-page-title-main">BBC Micro expansion unit</span>

A BBC Micro expansion unit, for the BBC Micro is one of a number of peripherals in a box with the same profile and styling as the main computer.

Positron is a fixed shooter written by Gary Partis for the BBC Micro and Acorn Electron and published by Micro Power in 1983. It was developed on a pre-release Electron and was one of the few games available for the machine on its launch.

<span class="mw-page-title-main">BBC Micro</span> Series of microcomputers by Acorn

The British Broadcasting Corporation Microcomputer System, or BBC Micro, is a series of microcomputers and associated peripherals designed and built by Acorn Computers in the 1980s for the BBC Computer Literacy Project. Designed with an emphasis on education, it was notable for its ruggedness, expandability, and the quality of its operating system. An accompanying 1982 television series, The Computer Programme, featuring Chris Serle learning to use the machine, was broadcast on BBC2.

The Samsung SGH-i907, marketed as the Samsung Epix in the United States by AT&T Wireless, is a Windows Mobile-based quad-band GSM smartphone manufactured by Samsung.

<span class="mw-page-title-main">Acornsoft LISP</span>

Acornsoft LISP is a dialect and commercial implementation of the Lisp programming language, released in the early 1980s for the 8-bit Acorn Atom, BBC Micro and Acorn Electron computers.

Wordwise is a word processor program published in 1981. It was the best selling word processor in the UK for the BBC Microcomputer during the 1980–1990 time period. The program was supplied on an 8K ROM, and was published by Computer Concepts. The use of ROM allowed the entire RAM of the host machine to be used for storing and manipulating the text, and providing printer-buffer functionality.

References

  1. 1 2 3 Brown, David. "VIEWSHEET". The Micro User (issue 02-03). Retrieved 2010-10-21. VIEWSHEET is a ROM based spreadsheet program marketed by Acornsoft and written in house, rather than commissioned from another software house.
  2. 1 2 3 4 "ViewSheet User Guide and Reference Card First Edition". Acornsoft. 1984. Archived from the original on 2011-07-16. Retrieved 2010-10-21. To ask the computer for ViewSheet you should type: *SHEET and press RETURN.
  3. Taylor, Gordon (January 1985). "ARTICLES ON COMPUTING BY GORDON TAYLOR". A&B Computing. Retrieved 2010-10-21. Dynamic Duo - Acornsoft's ViewSheet with the Raven-20 Shadow RAM board.
  4. Bell, Graham (1989). "ViewSheet and Viewstore: A Dabhand Guide by Graham Bell". Dabs Press. Retrieved 2010-10-21. A complete tutorial and reference guide for the Acornsoft ViewSheet spreadsheet and the ViewStore database manager