Numbers in Excel table not correct

Technical Problems LayOut
,
1

Hi, I’m using the tables in Layout to show the data in Excel but Layout is changing the numbers.

  • In red you see and average which is rounding down. So 2,67 in Layout is 2,6 in stead of 2,7
  • Also with the formula A-B=C or 3,3-2,1=1,2 Layout is working fine, but when C=1 it will show the value 0 instead of 1 like the blue indicated numbers

I read in the forum a 2019 post that the rounding problem will be fixed, but it is 2023 now. I have the files attached (but cannot upload the Excel file). Can someone point me in the right direction?

excel
excel760×580 79.3 KB

layout
layout1567×990 154 KB

table_test.layout (28.2 KB)

1 Like
2

This is a known bugs, but still not be fixed, from years.

3

This topic was automatically closed 183 days after the last reply. New replies are no longer allowed.