OpenOffice Calc Starter Files and Practice Downloads
Use these two synthetic downloads to check decimal parsing and exact identifier preservation. They are plain CSV data, not ready-made OpenOffice templates. No saved formulas, formatting, macros or extra sheets 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 |
Both are UTF-8. Include the first line as worksheet row 1 and start at A1 for the addresses below. The two files deliberately use different separators. 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.
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