Fast and powerful .NET spreadsheet component, support data format, freeze, outline, formula calculation, chart, script execution and etc. Compatible with Excel 2007 (.xlsx) format and working on .NET 3.5 (or client profile), WPF and Android platform.
May I ask how to use a custom function to retrieve the contents of merged cells? Assuming that A1:A2 contains merged cells with the value 'value', how can I use a function in cell B1 to retrieve the value in A1:A2?
May I ask how to use a custom function to retrieve the contents of merged cells? Assuming that A1:A2 contains merged cells with the value 'value', how can I use a function in cell B1 to retrieve the value in A1:A2?