Title: Excel Import
Last modified: May 31, 2026

---

# Excel Import

 *  Resolved [ckettl](https://wordpress.org/support/users/ckettl/)
 * (@ckettl)
 * [1 week, 1 day ago](https://wordpress.org/support/topic/excel-import-4/)
 * Hi,
 * I’m using the Excel import function and the FIXED command. The content of a cell
   is “=FIXED(1507.5,2,TRUE)” but the “true” addition will not work at all. It shows“
   1507.5”. Without “TRUE” “=FIXED(1507.5,2)” it works and shows “1,507.50” but 
   I don’t want the 1000 separator. In Excel the fixed command works fine. Where
   is my mistake?
 * Regards
 * Christain

Viewing 4 replies - 1 through 4 (of 4 total)

 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [1 week, 1 day ago](https://wordpress.org/support/topic/excel-import-4/#post-18924296)
 * Hi [@ckettl](https://wordpress.org/support/users/ckettl/),
 * Thanks for your post and sorry for the trouble!
 * Nice find! Indeed, it looks like the formula evaluation library that TablePress
   uses internally is not properly taking into account the `Decimals` parameter,
   when the `No_commas` parameter is set to `true`.
 * I have [created an issue](https://github.com/PHPOffice/PhpSpreadsheet/issues/4889)
   in the formula evaluation library’s issue tracker, to make the developers aware
   of this. They’ll likely fix this shortly and I will then of course integrate 
   this fix into TablePress!
 * Best wishes,
   Tobias
 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [6 days, 21 hours ago](https://wordpress.org/support/topic/excel-import-4/#post-18925507)
 * Hi [@ckettl](https://wordpress.org/support/users/ckettl/),
 * Good news! This will be fixed in TablePress 3.3.2, coming in about two weeks!
 * In the meantime, if you already want to fix this on your site, so that you can
   run the import with a working implementation of the `FIXED` function, you can
   simply apply the change that is highlighted in [this pull request](https://github.com/PHPOffice/PhpSpreadsheet/pull/4891/changes#diff-1d69a6427902da4800f774395d46c14538f9c3cf42234b1a3f8fe20221d07a2c)
   in the file “/wp-content/plugins/tablepress/libraries/vendor/PhpSpreadsheet/Calculation/
   TextData/Format.php” on your site, e.g. via the “Plugin Editor” in WordPress.
 * Thanks again for reporting this, I really appreciate it!
 * Best wishes,
   Tobias
 *  Thread Starter [ckettl](https://wordpress.org/support/users/ckettl/)
 * (@ckettl)
 * [4 days, 1 hour ago](https://wordpress.org/support/topic/excel-import-4/#post-18928697)
 * Hi Tobias,
 * thanks for your very quick response. It works very well.
 * Unfortunately I found another issue using Excel import. I am using formulas in
   excel. As long as the cells “only” includes numbers everthing works well. Example:
   cell $A$1 includes “=A2+A3”. As long as cells A2 and cell A3 is 1 the result 
   in A1 is 2. Now I want A2 printed in bold so A2 includs “<strong>1</strong>. 
   Then the result in $A$1 fails. Cells used in formulas must not include any other
   information but numbers.
 * Regards,
 * Christian
 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [3 days, 22 hours ago](https://wordpress.org/support/topic/excel-import-4/#post-18928873)
 * Hi [@ckettl](https://wordpress.org/support/users/ckettl/),
 * Yes, that’s correct. Unfortunately, it’s not possible to have HTML tags in cells
   which are then used for calculations as well.
 * The workaround that I recommend for is to separate the formula calculation and
   the formatting: Basically, duplicate the rows and hide the first one (via the“
   Selected rows: Hide” button). In that row, only use plain numbers for the calculations.
   Then, in the second row, only apply the formatting with a cell content like `
   <strong>{=F4}</strong>` (assuming that “4” is the first (hidden) row with the
   plain number and/or calculation results).
 * Best wishes,
   Tobias

Viewing 4 replies - 1 through 4 (of 4 total)

You must be [logged in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fexcel-import-4%2F%3Foutput_format%3Dmd&locale=en_US)
to reply to this topic.

 * ![](https://ps.w.org/tablepress/assets/icon.svg?rev=3192944)
 * [TablePress - Tables in WordPress made easy](https://wordpress.org/plugins/tablepress/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/tablepress/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/tablepress/)
 * [Active Topics](https://wordpress.org/support/plugin/tablepress/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/tablepress/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/tablepress/reviews/)

 * 4 replies
 * 2 participants
 * Last reply from: [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * Last activity: [3 days, 22 hours ago](https://wordpress.org/support/topic/excel-import-4/#post-18928873)
 * Status: resolved