LibreOffice is an office workspace for writing documents, calculating spreadsheets, building slide decks, drawing diagrams, working with databases, and composing mathematical formulas. Writer handles pages and long text, Calc works with cells and data, and Impress builds presentations. Draw, Base, and Math cover the other document types. LibreOffice changes the document itself; it is not only a viewer, and one installation can create or edit several kinds of office file.
Six document roles
Each LibreOffice component uses controls suited to its material. Writer has page styles, headings, tables, indexes, and mail merge. Calc organizes formulas, sheets, charts, filters, and pivot-style summaries. Impress arranges slides and presentation timing. Draw works with objects and connectors, Base links forms and queries to databases, and Math writes formulas that can sit inside another document.
The parts share spell checking, export commands, templates, and a common file picker, but they do not turn every file into the same object. A spreadsheet opened in Calc keeps its cells and formula logic. A text document opened in Writer keeps pages and paragraph styles. Choosing the correct component matters when a file extension or an imported object could be handled in more than one way.
Native and foreign
LibreOffice uses OpenDocument formats as its native storage. It also reads and writes common Microsoft Office formats, so a document can move between different office environments. Conversion is not invisible. Complex page layouts, embedded objects, fonts, charts, and advanced formatting can shift after import or export. A careful exchange therefore needs a visual check in the program that will finally print or present the file.
Macros need even more attention. Microsoft VBA and LibreOffice Basic use different object models. Some VBA can run when macro support is enabled, while other automation needs editing before it behaves correctly. Opening a workbook without an error does not prove that every button, event, or calculation behind it survived the conversion.
CSV needs choices
Calc treats a CSV file as text that needs interpretation. The import dialog asks which character set and separator divide the fields. It can also assign a type to each column. Marking an identifier column as Text preserves leading zeroes in postal codes, stock numbers, or account references. Leaving automatic detection in control can turn a date-like code into a date or a long number into another representation.
Formula-like fields create another choice: Calc can evaluate them or keep them as text. The safer choice depends on whether the file contains intended calculations or untrusted text that merely begins with a formula marker. If the import settings dialog is skipped, Calc may reuse the last settings, so a semicolon-delimited file can open incorrectly after a previous comma-delimited job.
Export loses structure
CSV output is narrower than a spreadsheet. LibreOffice saves only the active sheet, and the file does not retain cell formatting, multiple tabs, or the workbook’s formula structure. It records the exported values in a delimited text form. A user who needs every sheet must export them separately or keep an OpenDocument spreadsheet alongside the CSV copy.
PDF export preserves a visual result rather than the ordinary editing structure. Page ranges, image compression, and archival profiles can be selected before saving. A hybrid PDF is an exception: it embeds the original OpenDocument data inside the PDF, so LibreOffice can reopen that embedded document for editing. The extra data increases the file and may not survive every PDF-processing service, so the original office document still deserves its own saved copy.
