SeaTable does not offer sufficient decimal places - big shortfall

Your Setup:

  • Web

Describe the Problem/Error/Question:

The interface does not allow for input of sufficient decimals. For example, I am inputting data that has 14 places to the right of the decimal. This is required for the work I do. Unfortunately this makes SeaTable unusable for my work. Good thing I decided to test before paying for a subscription. Please add more decimal places; for me personally 14 should do but I don’t know why it would have to be limited anyway. ASAP because now I have to test another platform. If SeaTable gets 14 or more decimal places let me know and then I can continue testing to see if the app will be able to handle my data. Thanks.

Hi @Roddy, and welcome to the SeaTable forum!

Please do not hesitate to fill a request on https://ideas.seatable.com/ for such particular features.

Bests,
Benjamin

I am not sure that your use case is typical use case. Hence I am not sure that we are talking about a “big shortfall”. But anyway.

SeaTable stores numbers with more decimal places than the decimal places displayed in the frontend:


In the frontend, SeaTable displays a maximum of 9 decimal places.

Are you saying that if I input 15 decimals they are still in the cell but just not displayed? I did a test by putting a number that has 15 decimals and another that had 19 and a formula seemed to work fine but indeed the display was “0”. I copied the number from one cell and pasted it in another and the formula still seemed to work. However I when I tried 2 other tests the behaviour was odd: 1) I tried pasting into a different app and got just “0”, and 2) I tried double-clicking to go into the cell to edit and I could not edit what I inputted; it showed just “0”. So it seems that ST will accept multiple decimals as a one-time input, and after that it can not be edited and the user’s input is not displayed but instead it shows “0”. Is this correct from what you understand?

Correct.

To display the data in the frontend, SeaTable rounds. You can also edit the decimal places beyond place 9, you just don’t see them the moment you take the cursor focus from the cell.

In other words, if you write/read data using the API, you don’t have a problem with 10 and more decimal places.

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