Türkiye Grafiği için Batman-Siirt illeri karışmakta.
Bolu ile düzce illeri karışmaktadır. Sorunun çözümü halinde daha aktif olarak kullanılabileceklerdir.

Excelde oluşturulan dağılım grafiğinde dikey ve yatay çizgiler oluşturulamamakta.
Ayrıca yine aynı grafik türünde nokta ismine etiketin isimlendirilememesi hatası mevcuttur.
Powerbi de bu sorun yok ancak excelde mevcut.

Debugging on Mac is a pain.. The built-in safari tools are buggy and laggy. The only useful feature of volron.js is displaying console.log's.
I want a normal developer experience on Mac!

The new Convert to Stocks under Data/Data Types has been extremely helpful. One metric I would like to have added to the Field list is Trailing Twelve Month (TTM) Dividend Yield. This is a common metric in investments, one that I would think your data source already has available.

Microsoft Excel address correction/verification function/Add-in using Bing

On Google sheets, users can use Google Maps services to correct/verify address data even at street level.

Can we have something similar in Excel since we have everything we need to make this work? In Excel, I came across some work around utilizing scripting but why users need to know scripting language for what can be made available right out of the box?

This would allow the ability to have the menu system outside of the content add-in. In addition would provide the ability to seamlessly bring in other charting libraries for more complicated live charting of financial data.

sometimes it is necessary to view only columns in which specific values appear (without transpose!) it will be a useful feature which will enhance use capabilities

A feature that we can tell Excel to highlight the rows or columns of data that repeat or that are duplicates and DELETE those row or columns of data. I have a company report that prints our company name and subcontractor's name on every project and I only need it shown once. Right now I am having to go in and highlight every row and delete them one-by-one. Time consuming! If there is another way, please let me know.

I am porting an add-in to Office 365. I see that gradients are not currently supported. The gradients are a key part of the functionality of our add-in (recently demoed to a number of MS execs, including Satya, Brad Smith, Rajesh Jha, and even BillG at MSR TechFest). It would be great to be able to do this soon.

Currently the web socket implementation for desktop version of Excel (Version 16.0.11601.20130 32 Bit) is not correct. The property bufferedAmount is not implemented in this version. Further messages are lost, if “send” on the WebSocket is called frequently directly from a custom function. It seems as if the SDXPlatformBundle_foundation.js has some bugs.
In office online the problem does not exist. Please make desktop version behave like online version of Excel with a complete implementation of WebSockets.

This both code will work in VBA:
dim rng as range
set rng = range("d3:d4,f3:f4") // 2 areas range
rng.copy destination:=sheet.range("...")
or: reverse region area
set rng = range("f3:f4,d3:d4") // 2 areas range
rng.copy destination:=sheet.range("...")
--------------------------------------------
There is a rearrangement of the selection so
It will affect the recording of range.value
In API-javascript this code did not work
sheet.getRange("d1").copyFrom("f3:f4,d3:d4");
because selections do not arrange themselves
-------------------------------------------------------
so if using the Findall method: var searchrange=sheet.findAll(...)
i canot using searchrange nomarly. because the search result order returns a messy result
I can only format this.
//
This is my personal opinion
Thanks!

Small question: getSelectedRange() method why not contain in worksheet method.it's easy to confuse and unreasonable
Suppose I am using a sheet variable and now i need reference to Selection then I will have to refer a new variable =context.workbook.getSelectedRange(); instead sheet.getSelectedRange();
It makes the command longer

I think should be add: .... getActiveworkSheet().getSelectedRange();
even ....getActiveSheet().getSelection(); ...

Thanks you!

var range = context.workbook.worksheets.getItem("Sheet1").getRange("A1:D4");
var sumOfTwoLookups = context.workbook.functions.sum(
context.workbook.functions.vlookup("Wrench", range, 2, false),
context.workbook.functions.vlookup("Wrench", range, 3, false)
);

Is it possible to change it similarly vba code

with context.workbook.functions
...<my code>
end with

Thanks.

In VB, i can use Union method to Union Multiple range when when they meet the conditions.but in API-js i canot select multiple areas
example: sheet.getRanges("A1:A5,B1:F1").select();

Hi All,

At the moment, workbook can't switch views,
Please advise Workbook Views control, such as Normal, Page Break Preview, Page Layout and Custom VIews,
I need your support and feedback,

Best Regards,

It is very important for me.

https://stackoverflow.com/questions/55451636/excel-javascript-api-how-to-select-cells-until-filled-range-end

I have to jump through hoops for such basic sheet traversal task..(((

https://stackoverflow.com/questions/55923941/performance-of-excel-javascript-api-excelapi1-1-when-creating-a-table-range-wi