[OpenOffice] Traducció noves funcions 2.3

[Marc Belzunces]

A sota hi ha totes les definicions. Aquí van les meves propostes preliminars:

JIS-->JIS
ASC-->ASC

Corresponen a conversions amb el japonès. No aconsegueixo esbrinar el
significat de les lletres de la funció, així que ho deixaria tal qual.

GETPIVOTDATA-->EXTREUDADESPIVOT

S'ha traduït "DataPivot Table"? És l'única cosa que queda pendent
d'aquesta traducció.

"Get" a DGET ha estat traduït com a "Extreu".


-- 
Marc Belzunces

http://www.softcatala.org/

Bloc personal: http://blocs.mesvilaweb.cat/holoce
Planeta Softcatalà: http://planeta.softcatala.org/
Skype: mbelzunces



**************************************************************************************

JIS

Explicació Ooo 2.3:

Converts half-width ASCII and katakana character to full-width

Explicació Excel 2003:

JIS
The function described in this Help topic converts half-width
(single-byte) letters within a character string to full-width
(double-byte) characters. The name of the function (and the characters
that it converts) depends upon your language settings.

For Japanese, this function changes half-width (single-byte) English
letters or katakana within a character string to full-width
(double-byte) characters.

Syntax

JIS(text)

Text    is the text or a reference to a cell that contains the text
you want to change. If text does not contain any half-width English
letters or katakana, text is not changed.

Example

=JIS("EXCEL") equals "EXCEL"

=JIS("") equals ""


PROPOSTA: ???

*****************************************************


ASC

Explicació Ooo 2.3:

Converts full-width ASCII and katakana characters to half-width.


Explicació Excel 2003:

ASC
For Double-byte character set (DBCS) languages, changes full-width
(double-byte) characters to half-width (single-byte) characters.

Syntax

ASC(text)

Text    is the text or a reference to a cell that contains the text
you want to change. If text does not contain any full-width letters,
text is not changed.

Examples

=ASC("EXCEL") equals "EXCEL"

=ASC("") equals ""

PROPOSTA: ???

***********************************************************


GETPIVOTDATA

Explicació Ooo 2.3:

Extracts value(s) from a DataPilot table.

Explicació Excel 2003:

Extreu les dades emmagatzemades en una taula dinàmica.

GETPIVOTDATA
Returns data stored in a PivotTable report. You can use GETPIVOTDATA
to retrieve summary data from a PivotTable report, provided the
summary data is visible in the report.

Note  You can quickly enter a simple GETPIVOTDATA formula by typing =
in the cell you want to return the value to and then clicking the cell
in the PivotTable report that contains the data you want to return.

Syntax

GETPIVOTDATA(data_field,pivot_table,field1,item1,field2,item2,...)

Data_field    is the name, enclosed in quotation marks, for the data
field that contains the data you want to retrieve.

Pivot_table    is a reference to any cell, range of cells, or named
range of cells in a PivotTable report. This information is used to
determine which PivotTable report contains the data you want to
retrieve.

Field1, Item1, Field2, Item2    are one to 14 pairs of field names and
item names that describe the data you want to retrieve. The pairs can
be in any order. Field names and names for items other than dates and
numbers are enclosed in quotation marks. For OLAP PivotTable reports,
items can contain the source name of the dimension as well as the
source name of the item. A field and item pair for an OLAP PivotTable
might look like this:

"[Product]","[Product].[All Products].[Foods].[Baked Goods]"

Remarks

Calculated fields or items and custom calculations are included in
GETPIVOTDATA calculations.
If pivot_table is a range that includes two or more PivotTable
reports, data will be retrieved from whichever report was created most
recently in the range.
If the field and item arguments describe a single cell, the value of
that cell is returned regardless of whether it is a string, number,
error, and so on.
If an item contains a date, the value must be expressed as a serial
number or populated by using the DATE function so that the value will
be retained if the spreadsheet is opened in a different locale. For
example, an item referring to the date March 5, 1999 could be entered
as 36224 or DATE(1999,3,5). Times can be entered as decimal values or
by using the TIME function.
If pivot_table is not a range in which a PivotTable report is found,
GETPIVOTDATA returns #REF!.
If the arguments do not describe a visible field, or if they include a
page field that is not displayed, GETPIVOTDATA returns #REF!.

Traducció espanyol: IMPORTARDATOSDINAMICOS

PROPOSTA: EXTREUDADESPIVOT