if we can copy and paste the multiple excel files into the one excel sheet without enter into the excel file, that will be helpful for us.

Previous method:
i have 7 sepereate excel ( xls and xlsx ) files. So if we want to move the sheet from old excel file to new one, we have to open the excel file first, then we have to copy that sheet, then we can move it to new one. So if you want to move the 7 seperate excel files, you have to open one by one, then you can move it by copy and paste it.

Idea:
Copy the all seperate excel files > Then right click on it > Then click on "Copy" > Then open the new excel > Then right click on the new excel sheet > Then click on "Paste" or "Cntl + V" > Then it will open as a seperate sheet in one excel file.

if we can move the all excel files by using above way, we can save some more times right. we can save lots of excel files into one excel file without taking lots of time.

This is not a big deal, but if you can make this change, we no need to open the all excel files one by one, then we can save time. So Microsoft will more friendly, if we change this kind of small changes.

Thank you in advance.

Best Regards,
Sridhar S

Excel currently detects certain number combinations over/under forward slash as dates (e.g. 2/15 as February 15th). It then automatically auto-formats these cells to date format, which is not a huge issue, and replaces the data entered with an excel date value, which IS a very big issue as specific data points entered in spreadsheets becomes corrupted, in that changing the formatting back does not restore the originally entered value. (e.g. 1/10 entered as a dilution amount is now 43110). Workarounds like entering a ' in the cell before the value are useful only if data is being entered manually - data being directly input (e.g. from equipment) is similarly effected as soon as the cell is accessed. Long-term fix: put this function as an on/off toggle available in autocorrect options. Short-term fix: add-in (could be called something like 'scientific data fix') which blocks this function.

I need to deploy a udf soon into excel desktop and online and also into google sheets. Udfs are essential to this addin. JavaScript is the natural way to go since both google and ms platforms support this language. But i can't ship a product with this key udf feature only available in developer preview. Knowing roughly when the feature will be available might save me the need to support both vba for excel desktop and JavaScript for sheets. Real addin developers need more timeline guidance from the excel team. I am a happy vba user trying to learn JavaScript as fast as possible.

I have issue with protect worksheet in excel online. I will unlock all of the cells in the worksheet, and lock one range, then protect worksheet, after that nothing is editable in the worksheet, even the cells are unlocked. But once I close this file and reopens, everything works as expected, able to edit unlock cells. I don't know this is a bug or just some features not supported in excel online version.
This issue only happens for excel online version, works fine for installed version. I m using latest office.js from official CDN link and can reproduce this issue easily using script lab.
Please let m know if you have any answer.
Excel.run(function (ctx) {
//Worksheet
var sheet = ctx.workbook.worksheets.getItem("Sheet1");

//Entire Range
var entireRange = sheet.getRange();
entireRange.format.protection.locked = false;

//Specific Range
var range = sheet.getRange("A1:B5");
range.format.protection.locked = false;
//Protect Entire sheet
sheet.protection.protect({
allowInsertRows: false,
allowDeleteRows: false
});

return ctx.sync();

}).catch(errorHandler);

We have given each Excel Table column our own Name using Name Manager. Now it is hard to find mapping between that and Table Column Name/Index. Excel UI shows it in Name Manager this way: =dimensionstable[[#Headers];[Dimension]] in 'Refers to' text box, but namedItemObject.getRange(); returns Range and from Range you get it out only in A1 format relative to worksheet, not in the form that Name Manager shows it, which would be needed.

We cannot use Table Header Names to identify column as user can change that (and we want to leave that option for user), so we use our own name for column to identify it, but it is hard to derive from that mapping to table column index.

Currently when we use Bindings.addFromPromptAsync to use it as a cell reference picker which supports ANCHORING we face two issues:

1) There is NO way how to get the range address directly (you have to find the Binding from the ID and there you can call binding.getRange() method!).

2) The returned address from the binding.getRange() (as shown above) IGNORES the anchors used in the native dialog!

My suggestion is to add a way to the Bindings.addFromPromptAsync to return the cell address really shown in the native dialog (i.e. it would support anchors like $A1, A$1, $A$1)! It could be as a part of asyncResult of the Callback function, e.g. asyncResult.value.address.