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

Supress zero output on worksheet-level #83

Closed
ivanfemia opened this issue Dec 27, 2013 · 6 comments
Closed

Supress zero output on worksheet-level #83

ivanfemia opened this issue Dec 27, 2013 · 6 comments
Milestone

Comments

@ivanfemia
Copy link
Collaborator

Is it possible to setup the worksheet to supress the output of "0" like it can be done in the options of excel?
Frank

@ivanfemia
Copy link
Collaborator Author

Frank,

could you please maintain your collaboration Workspace profile (name) and provide us a detailed example of your request?

@ivanfemia
Copy link
Collaborator Author

Updating issues (#31, #32, #71, #83, #85, #10)

@ivanfemia
Copy link
Collaborator Author

Hi Ivan
you asked for an example. May you do not know what I mean. This property Sheets("Tabelle2").DisplayZeros = True/False is used very often in big worksheet to make them more readable. Of cause I could use a work arround by replacing "Zero"-Values with '' but calculated fields (the result is zero) are still shown as "0.00" or "0".
Sorry for my "too short" quick and dirty question before and you could understand my need a little better.

@ivanfemia
Copy link
Collaborator Author

I never used this feature :)

Fixed with commit [[url:https://code.sdn.sap.com/code/abap2xlsx/subversion/changesets/173|173]]
Check demo4 and mark as fixed this issue if your test is fine

@ivanfemia
Copy link
Collaborator Author

Frank,

update your Code Exchange profile in order to have a name instead of your S-id

@ivanfemia
Copy link
Collaborator Author

No feedback from Frank consider this issue fixed

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

1 participant