Bug 164511 - Add MAKEARRAY (MakeArray) function to Calc for interoperability with MS Excel and Google Sheets
Summary: Add MAKEARRAY (MakeArray) function to Calc for interoperability with MS Excel...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Missed-Excel-Functions
  Show dependency tree / graph
 
Reported: 2024-12-29 23:13 UTC by Óvári
Modified: 2025-01-04 06:25 UTC (History)
1 user (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 Óvári 2024-12-29 23:13:05 UTC 
Description:
Microsoft Excel
    1. https://excel-pratique.com/en/functions/makearray
    2. https://excelfind.com/excel-functions/excel-makearray-function/
    3. https://exceljet.net/functions/makearray-function
    4. https://myexcelacademy.com/functions/makearray-function/
    5. https://support.microsoft.com/en-us/office/makearray-function-b80da5ad-b338-4149-a523-5b221da09097
    6. https://www.exceldelta.com/tutorials/how-to-use-the-makearray-function-in-excel
    7. https://www.extendoffice.com/excel/functions/excel-makearray-function.html
    8. https://www.get-digital-help.com/how-to-use-the-makearray-function/
    9. https://www.statology.org/excel-makearray/
    10. https://www.thebricks.com/resources/how-to-use-the-makearray-function-in-excel-a-step-by-step-guide

Google Sheets
    1. https://infoinspired.com/google-docs/spreadsheet/how-to-makearray-function-in-google-sheets/
    2. https://sheetaki.com/use-makearray-function-in-google-sheets/
    3. https://sheets-pratique.com/en/functions/makearray
    4. https://skills.ai/blog/mastering-the-makearray-function-in-google-sheets/
    5. https://support.google.com/docs/answer/12569202?hl=en
    6. https://support.google.com/docs/answer/12657853?hl=en-GB
    7. https://support.google.com/docs/answer/6208276?hl=en
    8. https://www.benlcollins.com/spreadsheets/makearray-function/
    9. https://www.benlcollins.com/spreadsheets/makearray-function/
    10. https://www.sheetfx.net/function/makearray
    11. https://www.thebricks.com/resources/how-to-use-makearray-in-google-sheets-a-step-by-step-guide

Steps to Reproduce:
.

Actual Results:
.

Expected Results:
.


Reproducible: Always


User Profile Reset: No

Additional Info:
See Also: 138749