1

Topic: OBI Publisher: a total format in a template excel

Help, please. With Publisher I work the first time.
I try to do a template in excel.
Question with a format of numbers. If to deduce easier field the format which I put on a cell is applied.
For aggregate values of type:
<? sum (//ZNACH)?>
<xsl:value-of select = "sum (//ZNACH)"/>
<xsl:value-of select = "sum (current-group ()//ZNACH)"/>
At report start I receive numbers of such format 2,4178919714834972E10 and in a cell an error "the number is saved as the text" (in a template put on this cell a number format)
Whether it is possible to register in the code a demanded format somehow? Or somehow still it to make?
And still a question, somewhere it is possible to esteem about this  language with reference to ?

2

Re: OBI Publisher: a total format in a template excel

I suppose that for the decision of your problem will enough interpose the ZERO into a cell.
Most likely, this cell at you empty. The engine  in case of blank cells considers that there there will be a text and number formatting drops.
And by the way, I always tried to do the totals of an Excel-template means most Excel.
For example, put in a cell where should be a result/podytog, the type formula:
=THE TOTALS ($A$1: $ A1)
(We assume that in cell A1 there will be an output of an element from repeating group).
Also it is not forgotten to deliver also 0 in a total cell

3

Re: OBI Publisher: a total format in a template excel

Jack Carver;
Thanks huge! There is as simply "a small chest opened"!

4

Re: OBI Publisher: a total format in a template excel

Jack Carver;
Unfortunately, with the totals it did not help
Probably, value-of select produces the text by default.
And I need a semblance of tables of a cutoff on different sheets a grouping ex-fur-tree - on different sections with the type totals <xsl:value-of select = "sum (current-group ()//ZNACH)"/>
It would not be desirable users to give a file with formulas and original values.
P.S. The model is under construction on the basis of the ready analysis. In Publisher got since cutting with sending to  BI addresses is necessary.

5

Re: OBI Publisher: a total format in a template excel

Such nonsense happens, when the total is more than 1 million It (I do not understand excel or publisher) translates it in an exponential format, and then excel considers that it is the text.

6

Re: OBI Publisher: a total format in a template excel

Just in case. Whether Mahlo to whom is required.
Wrote a macro in a template which multiplies result on 1. All works

Private Sub Workbook_Open ()
With Worksheets ("List1")
.Range ("XDO _? sumvsego?") =.Range ("XDO _? sumvsego?") * 1
For Each i In.Range ("XDO _? sum2?")
I. Value I. Value * 1
Next
End With
End Sub