Google Sheets

Help & Support 💻 Bug Reports 🐞
1

I have problem with reading Google Sheets tabe. If first char in cell is 0 (zero) and then continue with other chars, UI Bakery returns numeric 0. Field is formated as Plain Text in Sheets and also ’ before 0 won’t help.
Is this normal behavior?

TIA,
Stane

2

Hi @Karlek
Let us have a look.

3

Hi @Karlek
Could you please confirm your UI Bakery version? We had a related fix in version 3.147.0. If your version is outdated, we recommend updating your instance.
Thank you!

4

Hi kate,

thank you, update is solving the problem.

Have a nice day,

@Karlek

2 Likes
5

Hi, we again have same problems with Google Sheets after last upgrade!?

TIA,

Stane

6

Hi @Karlek

I’m sorry about that! Is the issue exactly the same? I’ll ask the devs to have a look.

7

It’s look like the same, when cell starts with 0 it pass it as num!?

Have a nice day,

8

Hi @Karlek

Please check this setting in the Google Sheets data source:

image (69)
image (69)684×304 32.2 KB

We have recently added this option, so if the setting is off, then the data source takes the default data source conversion.