Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

FormatString - Column - String DataType #519

Closed
mst42a opened this issue Jul 2, 2020 · 3 comments
Closed

FormatString - Column - String DataType #519

mst42a opened this issue Jul 2, 2020 · 3 comments
Milestone

Comments

@mst42a
Copy link

mst42a commented Jul 2, 2020

Hello,
I have faced some problems with FormatString on columns with DataType = String.
A long time ago, I have run a script in Advanced Scripting window, to set FormatString on every columns without FormatString containing some pattern in Name. (And forgot about that).
I was surprised when my data show incorrectly. I needed some time to figure out what is going on because TabularEditor didn't show up Properties FormatString for Column with Data Type = String (properties.png), but when I run script Selected.Column.FormatString.Output(); Format showed Up.

Can You change "basic" section? I mean, show FormatString properties but blocked and greyed out
Properties
FormatString

@otykier
Copy link
Collaborator

otykier commented Jul 2, 2020

What client tool are you using to browse the data model (Excel, Power BI, or ...?) To my knowledge, AS is not supposed to apply format strings to columns of DataType = String (or at least it's not documented anywhere). But if this is standard behaviour, I don't mind keeping the FormatString property visible in Tabular Editor's UI when DataType=String.

@mst42a
Copy link
Author

mst42a commented Jul 2, 2020

End user use Excel only or SSRS (report services)

@otykier otykier added this to the 2.11.6 milestone Jul 12, 2020
otykier pushed a commit that referenced this issue Jul 12, 2020
@otykier
Copy link
Collaborator

otykier commented Jul 13, 2020

Fixed in 2.11.6, so that the FormatString property is always visible regardless of the data type.

@otykier otykier closed this as completed Jul 13, 2020
SergioMurru pushed a commit to SergioMurru/TabularEditor that referenced this issue Feb 13, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants