Attachment 115265 Details for Bug 85063 – Test file (csv)

Test file (csv)

Test_Table_Reference_LibreOffice_5.csv (text/csv), 3.02 KB, created by m_a_riosv on 2015-05-02 11:22:06 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: m_a_riosv

Created: 2015-05-02 11:22:06 UTC

Size: 3.02 KB

patch

obsolete

>Country,People,Percent,AvgPercGrow,AvgAbsGrow,DoubYears,AltFigure,EstDate,Source,,,
> Germany,81.276.000,=+B2/B$30,"0,32",256.000,220,81.083.600,30/09/14,Official estimate,,,
> United Kingdom,64.915.000,=+B3/B$30,"0,63",406.000,110,64.105.700,01/07/13,Official estimate,,=SUM(Population[People]),=FORMULA(K3)
> France,64.304.000,=+B4/B$30,"0,45",289.000,154,66.121.000,01/04/15,Monthly official estimate,,=SUM(Population[Percent]),=FORMULA(K4)
> Italy,60.963.000,=+B5/B$30,"0,49",298.000,141,60.788.845,30/11/14,Monthly official estimate,,=SUM(Population[AvgPercGrow]),=FORMULA(K5)
> Spain,46.335.000,=+B6/B$30,"-0,28",-129.000,,46.464.053,01/07/14,Official estimate,,=SUM(Population[AvgAbsGrow]),=FORMULA(K6)
> Poland,38.494.000,=+B7/B$30,"0,05",20.000,1.334,38.484.000,31/12/14,Official estimate,,=AVERAGE(Population[DoubYears]),=FORMULA(K7)
> Romania,19.822.000,=+B8/B$30,"-0,41",-81.000,,19.942.642,01/01/14,Official estimate,,=SUM(Population[AltFigure]),=FORMULA(K8)
> Netherlands,16.933.000,=+B9/B$30,"0,37",62.000,189,16.914.600,01/05/15,Official population clock,,=MIN(Population[EstDate]),=FORMULA(K9)
> Belgium,11.259.000,=+B10/B$30,"0,52",58.000,134,11.239.846,01/03/15,Monthly official estimate,,=COUNTA(Population[EstDate]),=FORMULA(K10)
> Greece,10.769.000,=+B11/B$30,"-0,11",-12.000,,10.816.286,24/05/11,Final 2011 census result,,,
> Czech Republic,10.535.000,=+B12/B$30,"-0,06",-6.000,,10.538.275,31/12/14,Official estimate,,,
> Portugal,10.311.000,=+B13/B$30,"-0,56",-58.000,,10.427.301,05/07/05,Official estimate,,,
> Hungary,9.835.000,=+B14/B$30,"-0,28",-28.000,,9.849.000,31/12/14,Official estimate,,,
> Sweden,9.794.000,=+B15/B$30,"1,03",100.000,68,9.760.142,28/02/15,Monthly official estimate,,,
> Austria,8.608.000,=+B16/B$30,"0,67",57.000,104,8.579.747,01/01/15,Official estimate,,,
> Bulgaria,7.185.000,=+B17/B$30,"-0,57",-41.000,,7.245.677,31/12/13,Official estimate,,,
> Denmark,5.673.000,=+B18/B$30,"0,48",27.000,145,5.659.715,01/01/15,Official estimate,,,
> Finland,5.475.000,=+B19/B$30,"0,11",6.000,632,5.473.465,31/03/15,Monthly official estimate,,,
> Slovakia,5.426.000,=+B20/B$30,"0,13",7.000,537,5.415.949,30/09/14,Official estimate,,,
> Ireland,4.630.000,=+B21/B$30,"0,35",16.000,200,4.609.600,01/04/14,Official estimate,,,
> Croatia,4.230.000,=+B22/B$30,"-0,31",-13.000,,4.267.558,01/07/12,Official estimate,,,
> Lithuania,2.906.000,=+B23/B$30,"-0,85",-25.000,,2.912.566,01/04/15,Monthly official estimate,,,
> Slovenia,2.065.000,=+B24/B$30,"0,15",3.000,477,2.062.731,01/10/14,Official estimate,,,
> Latvia,1.979.000,=+B25/B$30,"-0,9",-18.000,,1.983.300,01/04/15,Monthly official estimate,,,
> Estonia,1.315.000,=+B26/B$30,"0,46",6.000,152,1.312.252,01/01/15,Official estimate,,,
> Cyprus,876.000,=+B27/B$30,"0,46",4.000,151,865.900,31/12/12,Official estimate,,,
> Luxembourg,570.000,=+B28/B$30,"2,52",14.000,28,562.958,31/12/14,Official estimate,,,
> Malta,425.000,=+B29/B$30,"0,47",2.000,147,417.432,20/11/11,2011 census result,,,
>Total,=SUM(B2:B29),=SUM(C2:C29),=SUM(D2:D29),=SUM(E2:E29),=AVERAGE(F2:F29),=SUM(G2:G29),=MIN(H2:H29),=COUNTA(I2:I29),,,

Actions: View

Attachments on bug 85063: 107883 | 107884 | 107885 | 115265