--- title: New PHPExcel release: 1.3.0 | daily.dev description: PHPExcel 1.3.0 has been released with new features including formula calculation (e.g. evaluating =SUM(A1:A10) expressions), inserting and removing columns and... canonical: https://daily.dev/posts/new-phpexcel-release-1-3-0-kcwj3dzhr twitter:card: summary_large_image twitter:site: @dailydotdev og:type: website og:site_name: daily.dev og:title: New PHPExcel release: 1.3.0 | daily.dev og:description: PHPExcel 1.3.0 has been released with new features including formula calculation (e.g. evaluating =SUM(A1:A10) expressions), inserting and removing columns and... og:url: https://daily.dev/posts/new-phpexcel-release-1-3-0-kcwj3dzhr og:image: https://api.daily.dev/og/posts/kCWJ3Dzhr.png og:image:alt: New PHPExcel release: 1.3.0 og:image:width: 1200 og:image:height: 630 og:locale: en --- > ## Documentation Index > Fetch the complete documentation index at: https://daily.dev/llms.txt > Use this file to discover all available pages before exploring further. # New PHPExcel release: 1.3.0 **[Maarten Balliauw](https://daily.dev/sources/maartenballiauw)** · 2 min read · 0 upvotes · 0 comments ## Summary PHPExcel 1.3.0 has been released with new features including formula calculation (e.g. evaluating =SUM(A1:A10) expressions), inserting and removing columns and rows, auto-sizing columns, and freezing panes. The formula parser automatically adjusts cell references when rows or columns are inserted, and newly inserted cells inherit style information similar to Excel's behavior. Source code and demos are available on the PHPExcel site. ## Full article daily.dev links to this article rather than hosting it. Read it at the original source: ## Questions this post answers ### What new features were added in PHPExcel 1.3.0? PHPExcel 1.3.0 added formula calculation support, allowing cell values to be computed from formulas like "=SUM(A1:A10)" via getCalculatedValue(). It also introduced inserting and removing columns and rows, auto-sizing columns, and freezing panes. The formula parser automatically adjusts formula references when rows or columns are inserted or removed. _Developers tracking PHP library upgrades can follow release changes like this one on daily.dev._ ### Does PHPExcel automatically update formulas when rows are inserted? Yes, PHPExcel's formula parser automatically adjusts cell references when rows or columns are inserted or removed. For example, a formula "SUM(E4:E9)" in cell E11 updated to "SUM(E4:E11)" and shifted to cell E13 after inserting two new rows before row 7, mirroring Excel's own behavior including duplicated style information. _Anyone building spreadsheet exports in PHP can keep an eye on library behavior changes via daily.dev._ ## Similar posts on daily.dev - [Advanced Excel‑Style Data Analysis with React Spreadsheet Formulas](https://daily.dev/posts/advanced-excel-style-data-analysis-with-react-spreadsheet-formulas-gdty5mgb4) · Syncfusion · 0 upvotes · 0 comments - [LibreOffice 26.8 Beta Released For Improving This Free Software Office Suite](https://daily.dev/posts/libreoffice-26-8-beta-released-for-improving-this-free-software-office-suite-es85yjxcp) · Phoronix · 0 upvotes · 0 comments - [Formula Length](https://daily.dev/posts/formula-length-arflqz5um) · The Daily WTF · 0 upvotes · 0 comments - [PHP: PHP 8.3.33 Release Announcement](https://daily.dev/posts/php-php-8-3-33-release-announcement-8kmbd2gq3) · PHP · 6 upvotes · 0 comments --- Tags: [#php](https://daily.dev/tags/php) [View this post on daily.dev](https://daily.dev/posts/new-phpexcel-release-1-3-0-kcwj3dzhr) ```json {"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://daily.dev/#organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180},"sameAs":["https://twitter.com/dailydotdev","https://github.com/dailydotdev","https://www.linkedin.com/company/daily-dev-ltd"]},{"@type":"WebSite","@id":"https://daily.dev/#website","url":"https://daily.dev","name":"daily.dev","publisher":{"@id":"https://daily.dev/#organization"},"potentialAction":{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https://daily.dev/search?q={search_term_string}"},"query-input":"required name=search_term_string"}}]} {"@context":"https://schema.org","@type":"TechArticle","headline":"New PHPExcel release: 1.3.0","url":"https://daily.dev/posts/new-phpexcel-release-1-3-0-kcwj3dzhr","mainEntityOfPage":{"@type":"WebPage","@id":"https://daily.dev/posts/new-phpexcel-release-1-3-0-kcwj3dzhr"},"datePublished":"2026-10-04T13:06:11.238Z","dateModified":"2026-10-04T13:14:43.248Z","description":"PHPExcel 1.3.0 has been released with new features including formula calculation (e.g. evaluating =SUM(A1:A10) expressions), inserting and removing columns and...","image":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/2e34f5d4c83ca1df56a1eae41dd73695?_a=AQAEuop","thumbnailUrl":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/2e34f5d4c83ca1df56a1eae41dd73695?_a=AQAEuop","isAccessibleForFree":true,"articleSection":"Maarten Balliauw","inLanguage":"en","publisher":{"@type":"Organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180}},"author":{"@type":"Organization","name":"Maarten Balliauw","logo":"https://media.daily.dev/image/upload/s--rOTg3VYO--/f_auto,q_auto/v1791119043/logos/maartenballiauw?_a=BAMAMicg0","url":"https://daily.dev/sources/maartenballiauw"},"commentCount":0,"discussionUrl":"https://daily.dev/posts/new-phpexcel-release-1-3-0-kcwj3dzhr","interactionStatistic":[{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":0},{"@type":"InteractionCounter","interactionType":{"@type":"CommentAction"},"userInteractionCount":0}],"keywords":"php","timeRequired":"PT2M"} {"@context":"https://schema.org","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"Maarten Balliauw","item":"https://daily.dev/sources/maartenballiauw"},{"@type":"ListItem","position":3,"name":"New PHPExcel release: 1.3.0"}]} {"@context":"https://schema.org","@type":"FAQPage","@id":"https://daily.dev/posts/new-phpexcel-release-1-3-0-kcwj3dzhr#faq","mainEntity":[{"@type":"Question","name":"What new features were added in PHPExcel 1.3.0?","acceptedAnswer":{"@type":"Answer","text":"PHPExcel 1.3.0 added formula calculation support, allowing cell values to be computed from formulas like \"=SUM(A1:A10)\" via getCalculatedValue(). It also introduced inserting and removing columns and rows, auto-sizing columns, and freezing panes. The formula parser automatically adjusts formula references when rows or columns are inserted or removed. Developers tracking PHP library upgrades can follow release changes like this one on daily.dev."}},{"@type":"Question","name":"Does PHPExcel automatically update formulas when rows are inserted?","acceptedAnswer":{"@type":"Answer","text":"Yes, PHPExcel's formula parser automatically adjusts cell references when rows or columns are inserted or removed. For example, a formula \"SUM(E4:E9)\" in cell E11 updated to \"SUM(E4:E11)\" and shifted to cell E13 after inserting two new rows before row 7, mirroring Excel's own behavior including duplicated style information. Anyone building spreadsheet exports in PHP can keep an eye on library behavior changes via daily.dev."}}]} ```