Use of Column Formula (zdemo_excel47) generates corrupted Excel about abap2xlsx HOT 10 CLOSED

Got it concerning zdemo_excel47. It's due to the login in German. It works in English.

In column E, the formula is =[@Airfare]+100

If you connect in German, the column name is different:

I will open an issue in the demos repository.

from abap2xlsx.

Now, back to your original issue, I don't think you really want to use the Excel feature of Column Formulas.

Your basic question is to use the formula =COUNTIF(P2:AS2,"K"). Pay attention to the fact that the formulas are internally stored with a comma, not a semi-colon.

I tested it, it works well.

from abap2xlsx.

Now, back to your original issue, I don't think you really want to use the Excel feature of Column Formulas.

Your basic question is to use the formula =COUNTIF(P2:AS2,"K"). Pay attention to the fact that the formulas are internally stored with a comma, not a semi-colon.

I tested it, it works well.

That is really the right solution. I didn´t tried it because I copied the Formular from the Excel Translator and it didn´t work.
Now it is working with the comma.
Thank you very much!

from abap2xlsx.

Thank you for posting. It's not the same request as the feature request 723, in your case it's an issue, 723 was a feature request.

In your case, I think the issue is due to the use of the language-specific function names (like German ZÄHLEWENN), you should only use the language-agnostic function names (which are the same as the English names).

Either you use the Microsoft Excel functions translator (which I never tested), or you enter manually the formula ZÄHLEWENN, save and look directly into the .xlsx file (it's like a ZIP file).

from abap2xlsx.

Thank you for posting. It's not the same request as the feature request 723, in your case it's an issue, 723 was a feature request.

In your case, I think the issue is due to the use of the language-specific function names (like German ZÄHLEWENN), you should only use the language-agnostic function names (which are the same as the English names).

Either you use the Microsoft Excel functions translator (which I never tested), or you enter manually the formula ZÄHLEWENN, save and look directly into the .xlsx file (it's like a ZIP file).

Hey sandraros,
the Problem is that I already tried the "language-agnostic function names". It doesn´t work either. The same as the testreport "ZDEMO_EXCEL47" which doesn´t work either, like the screenshot.

I think the Problem is, that the table can´t be recognized.

from abap2xlsx.

And sorry the referencing Issue would be Issue 905.

from abap2xlsx.

The issue 905 is about the reader but your question is about creating a formula with ZÄHLEWENN. Could you fix your question and show how I can reproduce without effort please?

from abap2xlsx.

Alright, so I try to build an Excel-File with the formula "ZÄHLEWENN" or in English "COUNTIF", but after downloading the file it shows the errror like above.

If I start the Report "ZDEMO_EXCEL47" I got the following problem for "Direct display":

If I download the file from the Report it also gives the same error. For example the file attached.
47_ColumnFormulas.xlsx

from abap2xlsx.

If I understand well, your only issue is in fact #905. If you have some ABAP expertise, would you mind developing a solution and proposing a Pull Request? For now, I would propose to close this current issue as it is a duplicate of #905.

from abap2xlsx.

Got it concerning zdemo_excel47. It's due to the login in German. It works in English.

In column E, the formula is =[@Airfare]+100

If you connect in German, the column name is different:

I will open an issue in the demos repository.

Thank you very much.

from abap2xlsx.