OpenOffice Calc Starter Files and Practice Downloads
Use these thirteen synthetic downloads to check decimal parsing, exact identifiers, duplicate records, status-list inputs, sorting, filtered-copy checks, sales summaries, monthly pivot counts, Advanced Filter criteria, screen navigation, protected inputs and printed reports. They are plain CSV data, not ready-made OpenOffice templates. No saved formulas, formatting, macros, extra sheets, freeze settings, protection rules or print configuration are included. Keep an unchanged original and save your checked work separately.
Choose a file
| Download | Bytes | Layout including header | Separator |
|---|---|---|---|
| Decimal-comma invoices | 163 | 5 rows × 4 columns | Semicolon |
| Product identifiers | 102 | 5 rows × 2 columns | Comma |
| Duplicate-review input (CSV) | 111 | 8 rows × 3 columns | Comma |
| Status choices input (CSV) | 36 | 5 rows × 1 column | Comma |
| Tasks input (CSV) | 57 | 4 rows × 2 columns | Comma |
| Sort and AutoFilter orders (CSV) | 190 | 7 rows × 5 columns | Comma |
| Filtered-copy records (CSV) | 135 | 7 rows × 3 columns | Comma |
| Shared sales records (CSV) | 152 | 9 rows × 3 columns | Comma |
| Monthly pivot records (CSV) | 142 | 9 rows × 2 columns | Comma |
| Advanced Filter orders (CSV) | 224 | 9 rows × 5 columns | Comma |
| Wide navigation input (CSV) | 3,672 | 61 rows × 14 columns | Comma |
| Protection input values (CSV) | 37 | 3 rows × 2 columns | Comma |
| Multipage print-report input (CSV) | 4,186 | 91 rows × 6 columns | Comma |
All thirteen are UTF-8. Include the first line as worksheet row 1 and start at A1 for the addresses below. The invoice file uses semicolons; the other twelve use commas. Do not reuse a prior import setting without checking the preview.
Decimal-comma invoices: four different checks
The columns are InvoiceID, Item, Amount and Note. InvoiceID, Item and Note should remain text; Amount must be parsed as numbers using its decimal-comma convention. The source contains:
| InvoiceID | Item | Source Amount | Parsed Note |
|---|---|---|---|
| 000123 | Notebook | 12,50 | Office |
| 000124 | Pen | 3,75 | Blue; fine tip |
| 123456789012345678 | Folder | -2,25 | Adjustment |
| 000126 | Café supplies | 1000,00 | empty |
The quoted semicolon belongs inside the second note. The final Note is genuinely blank, not the word “empty”. Preserve the six-character IDs and all 18 digits of the long ID. Do not interpret identifiers as amounts.
Use the existing semicolon and decimal-comma import guide for its exact dialog procedure. It uses UTF-8, semicolon only, straight double quotes, a German (Germany) numeric parsing language, Text identifier columns and Standard amounts. Its native import and ODS save/reopen evidence is specifically Apache OpenOffice Calc 4.1.17 on Linux x86_64 with English UI, October 16, 2026, while its versioned Help reference is 4.1.16. It does not prove identical behavior in another Calc product or every locale.
Expected occupied range is A1:D5. In unused cells check =COUNT(C2:C5) → 4, =SUM(C2:C5) → 1014, and =ISTEXT(A4) → TRUE. Compare A4 directly with the original too. Check Café’s accent, the one-cell quoted note and blank D5 separately. Arithmetic is 12.50 + 3.75 − 2.25 + 1000.00 = 1014.00; a display of 1014, 1014.00 or 1014,00 can represent the same numeric value.
These results were recalculated independently for this catalogue. The negative amount is intentional numeric data, not a formula. A total alone is insufficient because SUM can ignore text amounts: check COUNT and individual cell types as well.
Product identifiers: the last digit matters
The second download has ProductID and Item columns:
| Exact ProductID | Item | Character count |
|---|---|---|
| 00123 | Cable | 5 |
| 123456789012345678 | Adapter | 18 |
| 123456789012345679 | Stand | 18 |
| 000000000000000001 | Hub | 18 |
Use comma, not semicolon, and preserve both columns as Text. Expect A1:B5. In an unused column, =LEN(A2) through =LEN(A5) should produce 5, 18, 18, 18. The Adapter and Stand identifiers differ only in their last digit, so compare full strings rather than trusting length or displayed scientific notation. The Hub ID must retain seventeen leading zeros.
This is a separate data fixture. The first download’s native test is not evidence that this second fixture was newly run. For the existing discussion, see number, date and currency formatting, particularly the distinction between numeric display and text identifiers.
Review duplicate records without deleting them
Use the duplicate-review CSV for a case-sensitive review exercise, not automatic cleanup. With its header at A1, expect A1:C8, seven records and Quantity totaling 12. Keep Account and Item as Text and Quantity numeric. The lowercase ac01 is intentionally distinct from AC01; a different quantity also makes a different record.
Follow review duplicate rows without deleting data to add the helper formulas in a separate ODS working copy. Expected matching counts, in source order, are 2, 2, 2, 1, 2, 1, 1; running occurrence counts are 1, 1, 2, 1, 2, 1, 1. That means two duplicate groups, four group members and two later copies, not four rows to delete. Retain all seven originals while reviewing.
The owning lesson records import, helper calculations and ODS reopen in Apache OpenOffice Calc 4.1.17 on Linux x86_64, English UI, October 16, 2026. This catalogue independently checks the unchanged input bytes and expected counts; it adds no native execution.
Build a status dropdown from two plain input files
The status choices CSV contains a heading and four choices, in order: New, In progress, Blocked, Done. The tasks CSV contains three tasks with blank Status cells. In one working workbook, place the first file at Lists.A1:A5 and the second at Tasks.A1:B4. Keep the original CSVs unchanged. They contain neither sheet names nor named ranges, dropdowns or validity rules.
Continue with data validity dropdowns to define StatusOptions from Lists.A2:A5, excluding the heading, and apply the rule to Tasks.B2:B20. Check both ends of the input range and the Stop rejection test described there. Save the working workbook as ODS rather than CSV so the added sheets and rules can be retained.
Evidence boundary: that lesson’s OpenOffice 4.1.17 Linux native test used manually entered values, not these CSV imports. Its successful dropdown and reopen checks do not verify CSV import or roundtrip. This catalogue checks only the files’ four choices, three task labels and three blank statuses; verify their placement before adding rules.
Sort complete records and filter Open orders
The Sort and AutoFilter orders CSV has Order, Region, Product, Amount and Status columns. Import comma-separated UTF-8 with Order/Region/Product/Status as text and Amount as numbers. With the header at A1, expect A1:E7, six records, =COUNT(D2:D7) → 6 and =SUM(D2:D7) → 670.
Follow sort and filter data to sort the complete five-column range by Region ascending, then Amount descending, keeping the header out of the records. Expected order IDs are 1003, 1001, 1004, 1006, 1005, 1002. Compare every field, not only the total: 1002 must remain West/Adapter/85/Closed.
After AutoFilter shows only Open, visible IDs are 1003, 1001, 1004, 1006. In an unused cell, =SUBTOTAL(9;D2:D7) should be 445 while SUM remains 670. Choosing All restores six records and subtotal 670. Filtering hides records; it does not delete them. This input has no saved sort, filter or formulas; create those in a separate ODS working copy. It is not the eight-order Advanced Filter dataset below.
The owning lesson records CSV import, this two-key sort, Open/All filtering and ODS save/reopen in Apache OpenOffice Calc 4.1.17 on Linux x86_64, English UI, October 16, 2026. This catalogue independently checks the unchanged bytes and expected results, not a new native run. That historical test does not cover Advanced Filter or destructive edits to filtered rows.
Check a filtered copy against complete records
The filtered-copy CSV contains Record, Status and Units, with six records plus a header in A1:C7. Import comma-separated UTF-8, keeping Record/Status as text and Units numeric. Outside A:C, =COUNT(C2:C7) should return 6 and =SUM(C2:C7) 210. Compare every row with the filtered-copy lesson.
The intended Keep extract has R101, R103 and R105, Units 10, 30 and 50, totaling 90. Follow that lesson’s Copy, not Cut or dragging, procedure into a blank unfiltered destination. Its separate manual-hide comparison expects all six records and 210: similar visible rows do not imply identical clipboard contents. Do not treat a matching sum alone as proof that the right IDs were copied.
This is raw input, without filters, an extract, formulas or extra sheets. Keep the original unchanged and use a separate ODS working copy. The lesson is documentation-qualified; this catalogue adds independent byte/arithmetic checks, not native import, clipboard or save/reopen results. Another lesson’s historical AutoFilter test does not verify this copying exercise.
Use one sales input for two distinct workflows
The shared sales CSV contains Region, Channel and Amount: eight records plus a header at A1:C9. Keep Region/Channel as text and Amount numeric. Outside the table, =COUNT(C2:C9) should be 8 and =SUM(C2:C9) 580. Expected North Online/Retail subtotals are 180/120 and South 120/160; compare records and subtotals, not only the grand total. This is not the monthly Date/RecordID dataset below.
- Worksheet pivot: use the sales-summary benchmark for Region rows, Channel columns and Sum of Amount. The owner records a separate sales pivot and ODS reopen in OpenOffice Calc 4.1.17, Linux x86_64, English UI, October 16, 2026. Sales-source editing/refresh was not tested; the monthly fixture’s refresh results do not prove sales-source growth.
- Base registration: follow the registered data-source lesson only when Base and the spreadsheet connection are already available. It keeps sales-source.ods, the connection description SalesPractice.odb, and sales-report.ods separate. The CSV includes none of these configured files or a registration. The ODB is not a backup of the records, and inserted report values are not proof of automatic synchronization. Stop if the required wizard/connection is unavailable; do not install software or substitute a driver to continue.
The Base exercise is documentation-qualified and unexecuted natively, including registration, refresh and save/reopen. The historical worksheet-pivot test does not verify it. This catalogue supplies no configured pivot, ODB, registered source, live report or new native result; preserve the unchanged CSV and check each chosen workflow separately.
Count the original eight records by year and month
The Monthly pivot records CSV has Date and RecordID columns. Import comma-separated UTF-8 with Date explicitly set to Date (YMD) and RecordID to Text. Expect A1:B9 with eight records. Check =ISNUMBER(A2) → TRUE and =COUNT(A2:A9) → 8: date-looking text is not sufficient for calendar grouping.
Use the monthly pivot lesson to put Date in Row Fields and RecordID in Data Fields, explicitly choosing Count, not Sum or Count (Numbers only). Group the result by Years and Months. Expected counts are 2025-12: 1; 2026-01: 2; 2026-02: 3; 2027-01: 2, with grand total 8. January from different years must remain separate. Count counts nonempty IDs, not distinct IDs.
This is only the original input: it has no pivot, grouping or appended R009. Follow the lesson’s separate refresh and expansion tests in an ODS working copy; refreshing a fixed A1:B9 source does not include a newly appended row 10. The original download should still contain eight records afterward.
The owning lesson records Date (YMD)/Text import, Count aggregation, Years/Months grouping, refresh tests and ODS save/reopen in Apache OpenOffice Calc 4.1.17 on Linux x86_64, English UI, October 16, 2026. This catalogue’s byte and month-count checks are independent calculations, not new OpenOffice execution. Duplicate/blank IDs, missing dates and other platforms/locales were not covered by that historical native test.
Practice an Advanced Filter with the original eight orders
The Advanced Filter orders CSV is the unchanged starting dataset from the existing criteria-range lesson. With its header at A1, expect A1:E9, eight unique IDs and Amount totaling 950. Use comma-separated UTF-8 input, keep ID/Region/Product/Status as text and import Amount as numbers. Before filtering, =COUNT(D2:D9) must be 8 and =SUM(D2:D9) must be 950; also compare each complete record.
The lesson’s first AND branch returns IDs 201, 203, 207, totaling 430. Adding its West/Closed OR branch returns 201, 203, 205, 207, totaling 570. Follow that lesson for the exact criteria cells, separate output sheet, strict/inclusive boundary checks and clearing stale results before reruns. Do not substitute the six-record basic-sort CSV: it has different records and totals.
This new file includes only raw input. You create the Criteria and Matches sheets, criteria and checks in a separate ODS working copy. It includes neither the later appended ID209 nor a saved filter or native template. Its bytes, rows and expected selections were checked independently on October 25, 2026. Import, filtering and save/reopen were not run in OpenOffice for this file; another lesson’s historical native test does not verify it.
Keep headings and identifiers visible while scrolling
The wide navigation CSV contains 60 records, with unique IDs P001 through P060, Item labels and twelve month columns from Jan to Dec. With its header at A1, expect A1:N61. Keep ID and Item as text; check the first and last records before configuring the view.
Follow freeze heading rows and identifier columns to select C2 and use Window → Freeze, keeping row 1 and columns A:B visible. Check vertical and horizontal scrolling separately and together. The CSV contains no freeze setting: create it in a separate ODS working copy. Freezing the screen does not repeat headings on printed pages.
The owning lesson records import of this 60-record fixture, scoped freeze-boundary checks and ODS save/reopen in Apache OpenOffice Calc 4.1.17 on Linux x86_64, English UI, October 16, 2026. Its reopened values matched all 61 × 14 original cells. This historical result does not verify XLSX persistence, other platforms or printed headings; this catalogue adds only independent file checks, not new native execution.
Add formulas and protection to two input rows
The protection input values CSV contains Item and Quantity input, with Notebook/2 and Pen/3. Expect A1:B3; C1:C3 are not supplied. Follow protect formulas but allow inputs to add the calculation column and configure editable input cells separately from protected formula cells. The lesson’s initial arithmetic is 2 × 4.50 = 9.00 and 3 × 1.25 = 3.75, totaling 12.75.
The CSV contains neither formulas nor protection. Save the configured working file as ODS and test an allowed input edit and a rejected formula overwrite. Sheet protection guards against accidental edits; it is not encryption or confidentiality protection.
Evidence boundary: the lesson’s OpenOffice 4.1.17 Linux native test used manually entered values, not this CSV import. Its formula-edit and ODS reopen results do not verify importing these input rows. Check both imported quantities and their stored numeric types before adding formulas; this catalogue did not run an application test.
Prepare a long report for printed headings
The print-report CSV has Date, Customer, Item, Quantity, Unit Price and Total in A1:F91, including 90 records from Customer 001 through Customer 090. Every quantity is 2, every unit price 4.50, and every supplied Total 9.00. The quantity sum is 180 and the fixed-total sum 810.00. Total cells contain sample values, not formulas: changing a quantity will not recalculate them.
Follow repeat printed headings and check PDF output for Date (YMD) import, English (USA) decimal-point amount parsing, A1:F91 as the print range and row 1 as the repeated heading. Inspect numeric types and the complete customer sequence before export. The CSV has no print range, page style or repeated-row setting; save those in an ODS working copy, then inspect the exported PDF separately.
The owning lesson records native preview/export and ODS reopen in Apache OpenOffice Calc 4.1.17 on Linux x86_64, English UI, October 16, 2026, plus inspection of its actual exported PDF. Its two-page result was specific to the tested layout: paper, fonts, widths, margins, scale and printer settings can change pagination. Check every record, repeated headings and clipping in your own output; the historical test does not establish physical printing or other platforms. No new preview, export or application run was performed for this catalogue.
Diagnose before saving
One long column usually means the wrong separator. Extra invoice columns around Amount suggest comma was accidentally enabled. A split quoted note points to quote handling. Lost zeros or changed final digits require a fresh import from the untouched source; changing the display format cannot recover unknown original characters. If an accent is damaged, check source encoding rather than changing fonts.
Save a separate ODS working copy after checking the import. For an actual reusable master, the OpenOffice template procedure covers the 4.1 desktop workflow; that template exercise is documentation-qualified and was not executed natively. A renamed CSV is not a completed template.
Documentation and test boundary
The official Apache OpenOffice 4.1 Calc Guide, published August 25, 2025, describes CSV opening and preview controls on pages 25–26. This catalogue uses the archived full-text capture retrieved October 19, 2026, rechecked against its recorded hash on October 21; a fresh PDF retrieval was not relied upon. The original version-scoped tutorial supplies the detailed import and historical native evidence. No new OpenOffice execution, screenshot or save/reopen test was performed for this catalogue. See versions and availability for current platform information.
Original-file integrity
The original UTF-8 download bytes were inspected on October 21, 2026. No replacement files were created. SHA-256 identifies the file, not successful application import:
- semicolon-decimal-comma.csv:
463cdef38bd37b8a99d79eadae330be116387d94ca184ca17da64994ccc68caa - product-identifiers.csv:
43ec957522f7094e135f28ff8d95e604f92c4fd7b41f2bd6d7212fbc74fdc2b5
The additional practice downloads above were byte-checked on October 24, 2026; their files were not modified:
- duplicate-review.csv: 111 bytes; SHA-256
7221f4760901d5b0ac055943e8b7fd53768c3944c6ad86c18443b305b0d64c46. - status-options.csv: 36 bytes; SHA-256
bb4f400a24367aef86f585a7308a02822cd9014a2bcedc0e412ab8b8592e84c5. - status-tasks.csv: 57 bytes; SHA-256
e1081bf506736171294625bd72113499dbb8b715b912686518367b6328f21d3b.
The Advanced Filter input was created from its owning lesson’s unchanged eight-record table and byte-checked on October 25, 2026:
- advanced-filter-orders.csv: 224 bytes; SHA-256
e7dcbabb815ceab61e3fb928dbc83b7f62720e55a82c7072d07a130eb4ca36df.
The existing sort and monthly-pivot inputs were independently byte-checked on October 25, 2026; neither file was modified:
- sort-orders.csv: 190 bytes; SHA-256
8445281bb0661eeabda9bfb0b8ce3f65da08ffce38a7ad195afd69724eb0883e. - pivot-monthly-records.csv: 142 bytes; SHA-256
2a29f567f9a51289977c8bba9a01cbead4f89b6aa5b692448fce111dbfc9ab1c.
The existing navigation, protection-input and print-report files were independently rechecked on October 25, 2026; their bytes were unchanged:
- freeze-navigation.csv: 3,672 bytes; SHA-256
e5927f201891934ef53b13ecdd88b59235f136278b8672d8896c9886d37912df. - protection-inputs.csv: 37 bytes; SHA-256
a35ac860730e1d5001b8e6e20ac9d39b5ae1471af6f291c904b68bcba8374287. - print-report.csv: 4,186 bytes; SHA-256
40ec187843a082f02f5ce000e06a675e2a1fd38bdb81736f7a556e9f640437b0.
The existing filtered-copy and shared-sales inputs were independently byte-checked on October 25, 2026; neither file was modified:
- filtered-copy-practice.csv: 135 bytes; SHA-256
16bfefea1be238932e60ea9357ac6ac2679bcf851d78c1d6350d3476be25f74d. - sales-by-region.csv: 152 bytes; SHA-256
a5542801e27a67f52ae11de984b5876321e2badc9db593bfa9db8e202286aa54.
Browser downloading was not verified in this review. Local file-byte, hash and link-target checks do not establish a successful download through a browser.