Archive

Posts Tagged ‘web-apps’

How to workaround problems embedding MS-Office web apps into WordPress.com

  1. UPDATE: this is becoming part of a series, it seems.
  2. SkyDrive and WordPress integration used to work much better, but not anymore?
  3. SkyDrive offers embed code with unescaped &, but you need to replace by & for  WordPress.com to accept the embed.
  4. SkyDrive offers embedding a range, but WordPress fails to display it (e.g. Item=’Sheet1′!A1%3AE10 – maybe b/o the parenthesis?);  tables do still display (e.g. Item=Table1).
  5. Wait, there is more: one or both of the following prevent display also:  &ActiveCell=’Sheet1′!C3&wdHideHeaders=True
  6. A working example for the record (to be enclosed between []):
    office width="700" height="443" frameborder="0" scrolling="no" 
    src="https://skydrive.live.com/embed?cid=4FA3329905D7E1CE&resid=4FA3329905D7E1CE%2143384
    &authkey=AGmGlsvpKj5r0pU&em=2&Item=Table1&wdHideGridlines=True"

MS-SkyDrive-related blog posts

Unable to edit MS-Excel online spreadsheet because of other user locking

  1. Problem: Why is a user opening a spreadsheet in the browser (even if with edit.aspx URL) causing a warning "The spreadsheet is locked by another user" if i try to open it in MS-Excel?  I thought Excel Web App allows multiple uses to edit the spreadsheet at the same time?
  2. Solution: Opening the spreadsheet for editing in the browser still locks it for being opened in MS-Excel (and vice versa), but not for opening it for editing in another browser.

How to use the LRC Lists

2011/09/20 2 comments
  1. The LRC lists are built with MS-Excel Web app, one of the new features which came with NINERMAIL (live@edu, try logging into http://skydrive.com .
  2. Important benefits of MS-Excel Web app include
    1. sorting: click on column header / down arrow, and choose menu item: “Sort Ascending/Descending”
    2. filtering: click on column header / down arrow, and choose menu item:
      1. either “filter”, excel-web-app-filter1, to choose from a condensed overview of all unique items that occur in the column, and e.g. filter out “Blanks” by removing the checkmark in front of it: excel-web-app-filter2
      2. or the advanced “number filter” (in columns with numbers) or “textfilter”,excel-web-app-filter3 , to do more advanced searches, like for all items that contain “camera”: excel-web-app-filter4 
      3. sharing beyond viewing: Authorized users can click on an “edit link” below the list display to update the information from their web browser.