The arrangement of data for storage or display.

learn more… | top users | synonyms

0
votes
0answers
9 views

Conditional Formatting code for percentages [duplicate]

I have a SharePoint 2013 question on conditional formatting code. I would like to have percentage font 85% - 100% in green, and 84.99% on down in red. The problem is if set to display as a % it ...
0
votes
0answers
24 views

JL Conditional Formating for SharePoint 2013

I have a column of percentages in a list. 85.0% on up is in green font, and everything 84.99% and under is in red font. The problem is if set to display as a % it stops evaluating it as a number and ...
0
votes
0answers
10 views

Formatting issues when uploading excel tables

I am uploading an excel table with 4 columns to a sharepoint list. The first three columns are text, and the last column numbers. When I go to upload, it says that the middle two columns will be ...
1
vote
0answers
36 views

Sharepoint Custom List conditional formatting date comparison

I am having an issue when creating conditional formatting using SharePoint Designer 2010. When the @Complete_x0020_Date is less than or equal to @Negotiated_x0020_Date, it will color the ...
0
votes
1answer
27 views

How do I show a calculated field along the same baseline as preceeding text?

I am new to infopath and so I may be missing something obvious... I have a combo box with sample data, and a calculated formula which binds to the value of that combo box. There is text before the ...
1
vote
1answer
120 views

Date Time format confusion in my SharePoint 2013 server

I want all my date columns in the entire server to be in 'DD/MM/YYYY' format. So I setup the Locale in the regional settings as 'United Kingdom'. I did the changes in the following locations: ...
0
votes
1answer
14 views

How do I duplicate the formatting of a Web Part?

I'm building a page with tasks for my team and I can't figure out how to copy the Task Web Part formatting to each of the other team members. At the moment I ams doing this by hand setting: Web Part ...
1
vote
1answer
47 views

Format List Calendar View Days

We'd like to format the calendar view of a list not off the data entered for each of the days, but off the actual day of the week. For example: Saturday and Sunday boxes would be red Monday boxes ...
0
votes
0answers
39 views

Validate that text field matches a format zero or more times

I have a "single line of text" column in my list that needs to contain zero or more numerical values, separated by semicolons, with no spaces, letters, or other characters. The contents of that column ...
0
votes
0answers
50 views

How to unify date formats on web parts

I have three web parts on my SharePoint 2013 page which show an item with the latest date of modification. These web parts are based on: Announcement app (so basically list with customized layout, ...
5
votes
4answers
2k views

Color code item row based on column value in SharePoint Foundation 2013

I have a custom list which contains a field called Status. In the AllItems view, I would like to color code each line item based on the value of Status. Is this possible to do withing SharePoint ...
0
votes
2answers
72 views

How to suppress display of comma when rendering a number column?

This is for SP2010. I have a custom content type which has a column defined as a Number column type. For other business reasons, it does need to be a Number type, so switching it to "Single line of ...
0
votes
0answers
117 views

DataProviderJSON: Cannot convert object of type 'System.String' to type 'System.Collections.Generic.List`1

I'm getting this error, my JSON is well formatted. using (ContentBySearchWebPart box = GetControlByIDPath(ControlID, this.Page.Controls[0]) as ContentBySearchWebPart) { string ...
1
vote
0answers
39 views

Apply CSS to all Choice Checkboxes [closed]

I have a choice field that allows multiple selections and users to add new values. I'm trying to put a red border around all of the checkboxes (long story why I need it). Previously I've done this ...
0
votes
1answer
29 views

SP 2010 - Lookup Column not working with Conditional Formatting

I have a lookup column for Tabs: Major Sub-1 Sub-2 Sub-3 Technical Pricing I need to setup conditional formatting so the row color changes with the level of tab selected. I can do this with drop ...
0
votes
0answers
11 views

How do I hide the text formatting in my shared calendar?

Our shared calendar now shows all the text formatting. How do I hide this formatting and not delete it?
0
votes
0answers
40 views

2013 workflow decisions based on Managed Metadata terms

I have seen various postings on formatting GUID references to access Managed Metadata terms. How does one evaluate (IF or WAIT) the different terms of a term set in a workflow? Could someone provide a ...
1
vote
0answers
76 views

Can the hover/active borders of form fields be customized and/or disabled?

I'm really not crazy about field borders in forms. In InfoPath, you can get rid of the borders, but then the row heights jump in the browser once the form is published to SharePoint. ...
0
votes
1answer
154 views

Number formatting in Sharepoint list

I have several large Sharepoint lists that I imported from Excel, the first column of each of these lists is "Customer Number" these numbers uploaded in the form 1,000,000 and so on. I want to ...
0
votes
1answer
427 views

Conditional Formatting not applied to web part?

SharePoint Server 2010. In SPD, I have applied Conditional Formatting to a document library row, so the background changes color based on a column value in the row. Works great when viewing the ...
0
votes
0answers
55 views

Conditional formatting due dates (UK)

I have a SP2010 list with various columns but am looking to add some conditional formatting based on a deadline date and warning date - ie if deadline > today, row goes red, if deadline< today but ...
2
votes
1answer
6k views

How to add hide/show section toggle to InfoPath form?

MS Word 2013 has this great feature. You can define sections of a document with Headings. You make certain lines headings by highlighting the text and choosing the Heading 1 Style from the ribbon. ...
1
vote
1answer
67 views

Can I lock the cells size in a datasheet view?

I'm working on Sharepoint2010. I have a datasheet which users can edit free. However I've noticed that everyone can change the size of the cells and even add other columns. How can I prevent any user ...
2
votes
1answer
40 views

How do I get a placeholder of 0?

I want my InfoPath form to have numbers formatted like "010" instead of "10" to then sync with SharePoint. How can I get my form to show the zero placeholder instead of two digits?
0
votes
0answers
41 views

Conditional Formatting

I have been able to successfully format a list based on due date. Eg. Due date - 7 is green and due date >= current date in red. etc. I have done this using SPD2010. The challenge here is that the ...
0
votes
1answer
208 views

Conditional formatting displaying correctly in SPD but not in page

I have been attempting to create status indicators in Sharpeoint Designer 2010 using two background images (red and green circles) in a hyperlink column and conditional formatting. The idea is that ...
2
votes
1answer
36 views

SharePoint 2007 Web parts view size

Can the view of web parts be zoomed in or out? I have a named Excel Chart displayed in an Excel Web Access web part. The chart appears very large in the web part. Is there any way to adjust the ...
0
votes
1answer
2k views

Conditional Formatting using Calculated Column as Condition (SharePoint Designer 2010)

I want to use conditional formatting to change the color of a row based on a Calculated Column. I know I could do this with a CEWP but I would prefer to do it in SPD 2010 because I am new to ...
0
votes
1answer
38 views

Paste code into a discussion?

I have a discussion going on our Sharepoint site and I'm trying to paste some JSON for evaluation. I see no [pre] markup or anything similar. Am I just missing it?
1
vote
0answers
49 views

How to prevent SharePoint 2010 Ribbon from reformating HTML code

I have the telerik editor installed in SharePoint 2010 Enterprise, and every time I edit a page in advance HTML mode, I would like SharePoint to remember how I formated the HTML code. But instead, ...
2
votes
1answer
446 views

Remove HTML Tags when Copying and Pasting into SharePoint People Picker textbox

I'm trying to remove formatting and in this case, mailto anchor html tags from being copied when I paste into the people picker textbox/field in SharePoint 2010 and have no idea how to go about doing ...
0
votes
1answer
168 views

Hide Edit button in Data View web part based on Person / Group column

I am working on a customized Project Management solution using SharePoint. I have a data view web part which displays all the project data including Project Name / Project Manager. I have a Edit ...
0
votes
1answer
437 views

Conditional formatting lookup column

I am attempting to do conditional formatting in a list view in SharePoint Designer. In this list I have a list that contains a lookup column, and other columns derived from the list of that lookup ...
2
votes
0answers
101 views

InfoPath Designer 2010 - Format HTML tags

I have set up a web browser form for SP2007 in InfoPath Designer 2010. It points to a list that contains several columns of different types, to include some enhanced rich text multiline fields. The ...
1
vote
0answers
203 views

How to apply “Table Style Medium 4” template formatting to excel created using open xml?

Hi I have a few datatables (No DataSet). I have created a method which will write datatable to excel. after writing data from datatable to excel, I will again call the same method of excel generation ...
1
vote
2answers
632 views

Display “NaN” instead percentage value

I'm using SharePoint 2007 and developing a custom view using SharePoint Designer 2007. I've a column of a table that should display numbers as percentage. Minimun value is 0, maximum 100. In SP ...
1
vote
1answer
237 views

Possible to restrict format/layout/fonts of Wikis & blogs?

Is there a way that I can restrict the text formatting(font etc)/layout on the Sharepoint blog/Wiki sites? Or doesSharepoint have any options to control the HTML that is being generated when users ...
1
vote
1answer
196 views

Highlight items older than X

I have a list which 4 statuses. New, claimed, pending and completed. I need to highlight items which are in the new status for longer than 3 hours. I've read that using the =today() function isn't ...
0
votes
1answer
2k views

conditional formatting with advanced rules

I need to format rows in a list, based on the due date and status. If a task is not completed and there is still more then 7 days time it should be green. If a task is not completed and there are 3 ...
1
vote
1answer
608 views

SharePoint 2007 List as Datasource for SSRS 2005 - Query invalid and formating SharePoint Dates?

I have this XML query that pulls all entries and fields from a SharePoint list. <Query> <SoapAction>http://schemas.microsoft.com/sharepoint/soap/GetListItems</SoapAction> ...
1
vote
1answer
232 views

sharepoint list view conditional formatting

I'm trying to set a conditional formatting for my custom list data row, it works fine for background color but not for foreground color, when I inspect the element in chrome browser, I found it apply ...
2
votes
1answer
1k views

How to enable bullet styles in Sharepoint 2010?

Intro: I'm running a publishing service using Sharepoint 2010 and recently tried to copy and paste contents from Word 2010 into an article. Problem: After pasting the content, it did not retain the ...
1
vote
2answers
7k views

How do I apply conditional formatting using SharePoint Designer 2013?

I'm attempting to apply Conditional Formatting to a list view web part via SharePoint Designer 2013, and I can't seem to find the option to do so. I've a horrible feeling I'm just being daft, but ...
2
votes
1answer
114 views

SP2010 - Formatted data view web part saved to gallery - get error when dropped on parent site

I have a list on a subsite that I need to feature on the parent site homepage. I created the formatted data view and saved it as a web part in the gallery. I drop it on the homepage but get a "web ...
3
votes
1answer
2k views

How do I validate a selected “choice” field in a survey?

We've got SP2010 foundation, and the other limitation is that we do not have access to SPD or any of the programmatic ways of accomplishing this. I'm looking for information about how to set this up ...
1
vote
2answers
2k views

Copy/Paste to SP 2010 Page does not keep formatting?

I am trying to copy a formatted Word 2010 document and paste it into a SharePoint 2010 page. Most of the formatting comes over to SharePoint fine, EXCEPT for the indentation of the lines. Is there ...
0
votes
1answer
451 views

Use FormattedString with FormField in view/edit form

I am trying to format a Sharepoint:FormField in a view/edit form and used FormattedString, but it doesn´t work. I do this because I would like to display a number without comma separator. ...
0
votes
1answer
340 views

Format field containing integer in edit/view form

I have a list with a field that contains an integer, let´s say 12345. In the edit/view form, the field is displayed as 12,345. How can I format the field so that it displays 12345? This is how the ...
1
vote
0answers
62 views

Configure search to show particular cells of a list

This might be some kind of a stupid question, but I'm absolutely new to SharePoint and I've no idea what to do. I uploaded a list to my SharePoint and added a search scope for it. Now I can search, ...
0
votes
2answers
323 views

Custom Field with Custom Format

I have been tring to create a text field (SPFieldText) with a custom format XX-XXXX-XXXX and add a check (control) so that when you add a dokument with same property but different format to a document ...