In client we add excel upload function and everything is ok, but i couldnt overcome two problems.
1- We export excel in load format and delete a cell. When we upload, it doesnt make the same cell deleted in TM1. It stays as same like we didn’t upload anything to that cell. I think it somehow skips the empty cells while uploading. By the way i have the same problems considering string cells.
2- In Turkey we use “.” as thousand separator and “,” as digit separator. UX works fine considering digit separator until now. But in excel upload when we upload 5,6 forexample, it becames 56 in UX. But this is the only problem, it works properly in all other scenarios.
Do you have any suggestions for these problems.
Thanks in advance,