バージョン 1705 以降の Excel 2016 でコピー範囲が保持されるようになった動作のプログラムへの影響

こんにちは、Office 開発サポート チームの中村です。   今回の投稿では、Excel のコピー動作の変更に関して記載します。 これまで、Excel ではセル範囲をコピーした後、他のセルに値を入力したり、セルの挿入や削除などを行うと、コピー範囲が解除されて貼り付けられなくなっていました。 この動作について、クイック実行版の Excel 2016 バージョン 1705 (16.0.8201.xxxx) で、Excel のセル範囲をコピーした後、他の操作を行っても、コピー範囲が解除されないように変更されました。このバージョンは、Current Channel 向けに 2017 年 5 月に提供されたものとなり、他のチャネルへは順次提供されます。この新しい動作については、以下の公開情報で確認できます。   タイトル : Office 365 の新機能 アドレス : https://support.office.com/ja-JP/article/95c8d81d-08ba-42c1-914f-bca4603e1426 該当箇所 : “2017 年 5 月の更新プログラム” 内の “コピーを保持する”   例) 以下のように A1 セルをコピーします。   B1 セルに文字を入力します。   Enter キーを押下して、入力を完了すると、A1 セルのコピーが維持されたままとなっており、そのまま C1 セルに貼り付けられます。   これに伴って、画面操作では、行などの挿入を行うときに…


Microsoft Azure leads the industry in ISO certifications

We are happy to announce that Microsoft Azure recently completed a new set of independent third-party ISO and Cloud Security Alliance (CSA) audits to expand our certification portfolio. Azure leads the industry with the most comprehensive compliance coverage, enabling customers to meet a wide range of regulatory obligations. If that were not enough, having a…


[Replicação] SQL Server Comandos DDL

Essa semana me deparei com um cenário bem particular em um de nossos clientes. O cliente utiliza replicação transacional e desabilitou nas propriedades da publicação a opção “Replicate Schema Changes”, conforme imagem abaixo: Para habilitar ou desabilitar esta propriedade, podemos utilizar o SSMS, conforme imagem acima, ou utilizar a procedure sp_changepublication como no script abaixo:…


Run Your Independent Automated Tests Using vNext Build In Visual Studio Online

Here is a walk through of a cookbook which would enable the use of Visual Studio Online vNext builds for automated Selenium/CodedUI tests to run independently in an Azure VM. Why Azure VM’s ! As local servers/hardware are aging and becoming more obsolete, using cloud based solutions offer power and flexibility How to Configure !…


FAQ : SSL certificates for Web Apps and App Service Certificates

Here is a list of commonly asked questions for App Service Certificates. How do I purchase and configure a new SSL certificate in Azure for my web app? To learn how to purchase and set up an SSL certificate for your App Service web app, see Add an SSL certificate to your App Service app. I…

3

Microsoft Azure Enables NIST CSF Compliance: Detect Function

Today, as part of our ongoing support of the Cybersecurity Executive Order, I am pleased to announce the third release in a series of documents on enabling compliance with the NIST Cybersecurity Framework (CSF) through Microsoft Azure services. This release specifically outlines how to implement the Detect function requirements using the services offered by Azure….


General availability of Storage Service Encryption and “Secure transfer required”

*Today, we are excited to announce the general availability of Storage Service Encryption for Azure Files Storage, as well as the “Secure transfer required” feature now being supported in the Azure Government Storage account. Storage Service Encryption for Azure File Storage Azure File Storage is a fully managed service providing distributed and cross platform storage….


Azure Cyber Analytics Program for Power and Utilities Partners

Microsoft is deeply aware of the importance of cybersecurity for companies supporting the electric grid and is committed to helping partners and customers secure their nations’ most critical of critical infrastructure. In furtherance of this commitment, we are announcing a cyber program: “Microsoft Azure Certified Elite Partner Program for Cyber Analytics in Power and Utilities”. Microsoft…


Announcing the Cognitive Services White Glove Program for All Azure Government Customers

Earlier this year we announced the initial release and public preview of Cognitive Services in Azure Government. From talking with you, we understand that building Artificial Intelligence in your application has proved to be a daunting task, but we’re now here to help! Azure Government is expanding the Cognitive Services public preview with the launch…