NEWFreeOffice PlanMaker 2024
The best free alternative to Microsoft Excel
Create complex calculations, worksheets and charts easily with the powerful spreadsheet application FreeOffice PlanMaker, the best free alternative to Microsoft Excel.
More than 430 calculation functions and a wide variety of analysis features help you get the most out of your data. Large worksheets with up to one million rows and 16,384 columns are supported, as are pivot tables for quickly summarizing and analyzing your data.
FreeOffice PlanMaker opens and saves all Microsoft Excel XLS and XLSX files. You can also export your worksheets to PDF format.
Features
Files and printing
- Worksheets can be losslessly exchanged between any version of PlanMaker on any operating system.
- Open and save XLS and XLSX files from Microsoft Excel in an identical format to the original files, including password-protected files.
- Open OpenDocument Calc in an identical format to the original files
- Import and export assistant for text files and dBASE databases
- Create PDF files directly in FreeOffice PlanMaker
- Scale the printout so that it fits on a specified number of pages (five different scaling methods)
- Print 2, 4, 8 or 16 pages on one sheet of paper (only in Windows)
Extensive calculation capabilities
- More than 430 calculation functions
- Worksheets with 1 million rows and 16,384 columns
- Calculation with complex numbers and array functions
- Numbers can be formatted as currency units, with fixed decimal places and thousands separators, as percentages or fractions, as dates and times, etc.
- Perpetual time format (20:00 + 5:00 is 25:00 and not 1:00) which also allows negative times
- AutoSum, AutoProduct, etc.
- AutoFill: intelligent filling of cell areas with values and rows of values
- External references (calculations that access data in other files)
Editing worksheets
- Freeze rows and columns
- Syntax highlighting
- AutoComplete for cells
- Select and format multiple worksheets simultaneously
- Sheet, workbook and document protection with encryption
Analyzing data
- You can use pivot tables to summarize, sort, compare, evaluate and group data into categories.
- Goal seeker
- Create database ranges within worksheets
- Data grouping (outline view)
- Sort by up to 64 columns
- AutoFilter and special filters
- Database functions for totals, averages, variance, etc.
Creating attractive worksheets
- Cell styles as in Microsoft Excel 2021 and Excel 365
- Conditional formatting as in Microsoft Excel 2021 and Excel 365
- Borders, shading and fill patterns
- Rotate and merge cells
- Center across columns
- Headers and footers (split into left, center and right sections)
- Colored tabs for worksheets
- Set the size of the tabs in the worksheet register
Pictures and drawings
- Comprehensive drawing and picture functions: Draw and design directly in the worksheet with Excel-compatible AutoShapes
- Insert pictures in a range of file formats
- Change brightness, contrast and gamma of pictures directly in FreeOffice PlanMaker
- Fill drawings with colors, patterns, pictures and gradients
- Contour wrap
- Connector lines between objects
- Large symbol library for flowcharts and organizational charts
- TextArt feature for font effects
Presenting and visualizing data
- Powerful Excel-compatible chart module for impressive charts
- Insert more than 80 different types of charts, for example, bar charts, histograms and pie charts
- Impressive effects on charts: soft shadows, beveled edges, transparencies, lighting sources, etc.
- Charts can be rotated in 3D space.
Extras
- Fully Unicode-enabled, including Arabic
- Spell check in 85 languages
- Automatic hyphenation in 35 languages