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