Tag Info

New answers tagged

0

You've defined an error condition, and your test satisfies that condition With the formula: =IF([Request Type]="Review",(IF(ISBLANK([Request Date]),FALSE,TRUE)),TRUE) you are telling SharePoint that an item with a Request Type of "Review" and a blank Request Date should fail the validation and return an error message. In the list's Validation Settings ...


0

When you export the file, try changing the defult view settings to data sheet view within your library or list ( in settings). Then it has the cells and columns of excel, and you can edit via sharepoint or excel.


0

You may want to re-think your data architecture. A document library can contain custom columns for metadata, but if you have half a novel in a multi-line text field, that does not seem like a good approach. Excel can easily store more than 800 characters in a cell, but it throws errors depending on the delivery method (formula vs. manual entry, one string ...


0

I managed to do it with a power point presentation by using the PAGE VIEWER WEB PART. Displaying it as a web page and placing the link to the xlsx workbook. The excel web part is better tho.


0

I have discovered what was going wrong. Unbeknownst to me, the person creating the list by importing the Excel spreadsheet would then go in through SPD, delete the default Edit form, create a new edit form, and customize it to remove several fields they did not want showing on the form. Deleting the default Edit form also deleted the default list form web ...


-1

OpenInClient feature doesn't do anything for you if you use Chrome. The document is still downloaded when you try to open it.


0

the export to excel can be done by client side. The SPGRidView is rendered as table itself so a simple javascript can suffice exporting to excel.This is the code <input type="button" id="Button1" value="Export" onclick="TableToExcel('TableID');" /> function TableToExcel(tableid) { var id = $('[id$="' + tableid + '"]'); var output = ...


0

Once you create the Survey you will see that Option OOTB under the Actions dropdown. see this image. Their are chances that this option is not aviable or working. in order to troubleshoot that issue. see below some tips. You should have office application (Office 2010/Office 2007) should be installed on your client machine. Make sure that 'SharePoint ...


0

Yes, In order to synchronize Excel data with SharePoint, you need to convert a range of data into a table. The moment you create the table, Excel will show you an extra button to "Publish". Also if you want to synchronize Excel with SharePoint, you need to Install the Excel Addin. here i have provided the link for SharePoint 2007 addin. If you are working ...


0

Macros are not supported in Excel Online, you either need to remove the macros to allow editing in Excel Online or use the client exclusively for those files.


0

You can open the workbook imediately in Excel with the following workaround: - Opend the version history (click on the down arrow and select version history) - Copy the link to the youngest version (right click the date and select copy link address) - Paste this in the "open file" dialog from Excel (ctrl-O, ctrl-P) and enter


1

Looks like this feature is not supported but still you want their is one workaround for this but not supported .doing unsupported things generally equals "trouble", if not immediately, then later, so even if you can actually get this to work Read the reply from Peter Jamieson on Mail Merge from SharePoint 2013 ...


1

You need to use Server Side Code. The easiest option is to convert the back end DataTable to comma-seperated file. Then then use Response.Write to save it as a csv file. This file can be opened using Excel. response.ClearContent(); response.Clear(); response.ContentType = "text/plain"; response.AddHeader("Content-Disposition", "attachment; ...


2

You can go to Library Settings -> Advanced Settings -> Check "Open in the client application" Edit: This opens all the documents in client application.



Top 50 recent answers are included