Abstract: To improve efficiency of populating a spreadsheet with data, the system and method disclosed herein provide for a user to request automatic filling of data into the spreadsheet. In one embodiment, the user identifies a target area such as a column of the spreadsheet and existing data items entered by the user are detected in a base column and the target column. In one aspect, a data item in a cell is detected in the target column. In another aspect a column header is detected in the target column. A semantic relationship is determined between the detected data items in the base column and target column. The determined relationship is then used to determine at least one new data item to add to the target area of the spreadsheet.

Abstract: To improve efficiency of populating a spreadsheet with data, the system and method disclosed herein provide for a user to request automatic filling of data into the spreadsheet. In one embodiment, the user identifies a target area such as a column of the spreadsheet and existing data items entered by the user are detected in a base column and the target column. In one aspect, a data item in a cell is detected in the target column. In another aspect a column header is detected in the target column. A semantic relationship is determined between the detected data items in the base column and target column. The determined relationship is then used to determine at least one new data item to add to the target area of the spreadsheet.

Abstract: Aspects of the subject matter described herein relate to managing policies. In aspects, a staging store is used to store policies that are not applied to a computer system unless and until they are copied to or otherwise imported into a production store. A configuration entity is allowed read/write access to the staging store, but is not allowed write access to the production store. A policy manager is granted read access to the staging store and write access to the production store. The policy manager may approve or deny staging policies. If the policy manger approves a staging policy, the policy manager may derive a production policy from the staging policy and store the production policy in the production store. Once a policy is in the production store, the policy may be applied to one or more entities as appropriate.

Abstract: Aspects of the subject matter described herein relate to symmetric routing to a private network. In aspects, a remote client may try to connect to an entity of a private network using a non-routable network address. Upon detecting that connectivity is not established or not possible via a given network address, the client may obtain network data associated with a gateway that provides access to the private network and create a virtual interface where the gateway is the next-hop router. After creating the virtual interface, the client may communicate with entities of the private network using the virtual interface of the client. By sending traffic through the virtual interface with a source address having a prefix associated with the gateway, the client may ensure that traffic sent to and from the private network traverses the gateway.

Abstract: Aspects of the subject matter described herein relate to symmetric routing to a private network. In aspects, a remote client may try to connect to an entity of a private network using a non-routable network address. Upon detecting that connectivity is not established or not possible via a given network address, the client may obtain network data associated with a gateway that provides access to the private network and create a virtual interface where the gateway is the next-hop router. After creating the virtual interface, the client may communicate with entities of the private network using the virtual interface of the client. By sending traffic through the virtual interface with a source address having a prefix associated with the gateway, the client may ensure that traffic sent to and from the private network traverses the gateway.

Abstract: Aspects of the subject matter described herein relate to managing policies. In aspects, a staging store is used to store policies that are not applied to a computer system unless and until they are copied to or otherwise imported into a production store. A configuration entity is allowed read/write access to the staging store, but is not allowed write access to the production store. A policy manager is granted read access to the staging store and write access to the production store. The policy manager may approve or deny staging policies. If the policy manger approves a staging policy, the policy manager may derive a production policy from the staging policy and store the production policy in the production store. Once a policy is in the production store, the policy may be applied to one or more entities as appropriate.