Data format

[Deleted user]

Hello, I find Range.getValue() is a double type no matter what the format of the range in spreadsheet is. I set it to text, it is also double. I think it is a problem. By the way, can you refer functions of range to return type what I want. For example, Range.getIntValue will give me a integer no matter it is a text or double or other format of the range. Now I have to deal with null pointer and type converting.

[github-actions]

Thanks for your report! Please ensure you have provided enough info in order to recreate the issue, including the problematic ODS File.' first issue

[Deleted user]

Thanks for your report! Please ensure you have provided enough info in order to recreate the issue, including the problematic ODS File.' first issue

Ok, I will create a demo project later.

[miachm]

Hi! I don't fully understand your first question. About the second question. I am considering to change the return value Object to a more specific class, something like: "OdsValue", which will contains methods for type conversion. Unfortunately I can't do that without breaking the API (I would rather to keep the API space stable for now). The problem with implementing a getIntValue() is that not every value it's convertible to int: - How do you convert an empty value to int? Right now it's specified by a null pointer. - How do you convert a text like: "Hello World" to int? - How do you convert a date to int? - Etc... You would still have to deal with these cases anyway. In your use case, this case might be rare. But in that case, you could abstract out using a helper function which deal with the type casting and null pointers. Greetings, Miguel

…

On Mon, 5 Jul 2021, 00:17 yangshulin2019, ***@***.***> wrote: Hello, I find Range.getValue() is a double type no matter what the format of the cell is. I set it to text, it is also double. I think it is a problem. By the way, can you refer functions of range to return what I want type. For example, Range.getIntValue will give me a integer no matter it is a text or double or other format of the range. Now I have to deal with null pointer and type converting. — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub <#33>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ACONZCGOWI6AF4UKPBDJLXDTWDT2FANCNFSM47ZUOULQ> .

[Deleted user]

For the first problem, I create a demo to explain it. You can check https://github.com/yangshulin2019/SODS-Example. As in test.ods file, A1 is a number and B1 is a text format, but when I print the value, it gives double type 1.0 and 123456.0, the results should be 1 and 123456.
For the second one, I agree with you.
By the way, I suggest Sheet.getLastRow and Sheet.getDataRange to return valid data, not the whole sheet data. It includes many null values and it is not useful for users. You can just reference Google Appsscript, Sheet.getDataRange() return only valid data.

[miachm]

I see your point, but the answer of SODS is correct. There are not integers in an ODS file, every number is float:

Of course if you wanted to show them to the user, you could skip the decimal point in these specific cases.

About the content, getLastRow() tries to get you the last row with useful data in contrast to getMaxRows(). I guess it could fail if these rows have a specific style formatting associated (but not a value). I guess the whole system of rows/column need to be reworked.

I guess it´s a better idea to return valid data with getDataRange(). Meanwhile, the same bebaviour could be recreated with:

getRange(0,0,getLastRows(),getLastColumns());

At least in theory. I am aware it could give you unreal numbers because the style formatting.

Good stuff, let´s can we solve these problems :)

Thanks