Bug 164512 - Add MAP function to Calc for interoperability with MS Excel and Google Sheets
Summary: Add MAP function to Calc for interoperability with MS Excel and Google Sheets
Status: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium enhancement
Assignee: Ben Urban
URL:
Whiteboard: target:27.2.0
Keywords:
Depends on:
Blocks: Missed-Excel-Functions 172815
  Show dependency tree / graph
 
Reported: 2024-12-29 23:16 UTC by DELETE ACCOUNT
Modified: 2026-07-15 14:07 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description DELETE ACCOUNT 2024-12-29 23:16:22 UTC 
Description:
Microsoft Excel
    1. https://excel-pratique.com/en/functions/map
    2. https://excelfind.com/excel-functions/excel-map-function/
    3. https://exceljet.net/functions/map-function
    4. https://infoinspired.com/excel-formula/map-function-in-excel-simplified/
    5. https://support.microsoft.com/en-us/office/map-function-48006093-f97c-47c1-bfcc-749263bb1f01
    6. https://www.exceldelta.com/tutorials/how-to-use-the-map-function-in-excel
    7. https://www.get-digital-help.com/how-to-use-the-map-function/
    8. https://www.ncesc.com/geographic-pedia/how-does-the-map-function-work-in-excel/
    9. https://www.sumproduct.com/blog/article/a-to-z-of-excel-functions/the-map-function
    10. https://www.thebricks.com/resources/how-to-use-the-map-function-in-excel-a-step-by-step-guide

Google Sheets
    1. https://infoinspired.com/google-docs/spreadsheet/how-to-use-map-function-google-sheets/
    2. https://sheetaki.com/map-function-in-google-sheets/
    3. https://skills.ai/blog/mastering-map-function-in-google-sheets/
    4. https://spreadsheetdaddy.com/google-sheets/functions/map
    5. https://support.google.com/docs/answer/12568985?hl=en
    6. https://www.benlcollins.com/spreadsheets/map-function/
    7. https://www.lido.app/tutorials/google-sheets-map
    8. https://www.thebricks.com/resources/how-to-use-map-in-google-sheets-a-step-by-step-guide
    9. https://www.youtube.com/watch?v=KO_B4T9H-9A

Steps to Reproduce:
.

Actual Results:
.

Expected Results:
.


Reproducible: Always


User Profile Reset: No

Additional Info:
See Also: 138749
Comment 1 Ben Urban 2026-07-13 16:41:37 UTC 
This function has been added in commit 76c9c81b02fd1159d03133e5dbcb488d3a659d13.