The arrangement of data for storage or display.

learn more… | top users | synonyms

1
vote
3answers
17 views

Conditional Formatting Based on Number Range

I'm trying to add conditional formatting to a custom list based on whether or not a field contains a number in a certain range (i.e., if the field contains a number less than 15, i'd like the ...
0
votes
0answers
12 views

conditional formatting XSLT error [closed]

I am doing conditional formatting on a list through sharepoint designer and it gives this error while changing font color on any column or row condition. please help to remove this error.
0
votes
0answers
12 views

SharePoint WCF service and automaticFormatSelectionEnabled attribute

I am creating SharePoint 2013 Custom WCF service according to this manual: ...
0
votes
1answer
24 views

Jquery to display formatted value in content editor

I'm completely new to jquery and by now I'm not able to use it. Can anyone help to write a piece of code, which will display single item (given ID) from the list 'CounterList', column 'Counter' to a ...
0
votes
1answer
23 views

How can i make a server folder path opening in file explorer using IE and SharePoint List?

I'm approaching SharePoint just now, i have this List with our actual and running projects, every project has a specific folder address on our server. I want to make that folder opening in file ...
2
votes
2answers
420 views

SharePoint Online “Page Elements” style for Format Text missing

We are currently experiencing a really weird bug where the "Page Elements" is missing under the Font Styles under Format Text. Here is a screenshot: The weird thing is, it was working fine ever ...
2
votes
1answer
33 views

Link to Edit button on page for item & conditionally format

In SharePoint Online (E3 subscription) I have 5 lists in a site and in each list the user is to enter 1 item. The end result is to enable the Create and Edit button conditionally on a page next to ...
0
votes
1answer
80 views

How to remove time stamp from date field in InfoPath form?

I have a drop down in an InfoPath form that grabs data from a SharePoint list. One of the fields in the form is a date field and when it gets populated with the date from SharePoint it includes the ...
2
votes
1answer
79 views

Format Date in Content Query

I have looked through too many threads about this and have made no progress. So far the following links have helped me the most: Content Query WebPart & Date How to format Date in Content ...
0
votes
0answers
29 views

Modify List Formatting

I don't know too much about SharePoint, but I've been tasked with changing the formatting of a list we have on our site. The list is used on multiple pages and each page has a different view. The ...
1
vote
2answers
88 views

How to stop Sharepoint from auto formatting my code?

I would like to format my code by myself so it is easier for me to read the code, rather than having SharePoint formatting my code automatically, and it is hard to read.
0
votes
0answers
22 views

Is it possible to use inline-blocks in SharePoint?

Is it possible to use inline-block in SharePoint? I am trying to use them but it keeps formatting the code, and adding a space (&#160) to my div tags which messes up the inline-blocks. Here is an ...
1
vote
2answers
739 views

How can I format phone numbers in SharePoint 2013? [duplicate]

I'm wanting to format a column in SharePoint 2013 to automatically enter the parentheses and dashes in a phone number. So no matter how the telephone is entered, it shows (###) ###-####. Thank you ...
1
vote
2answers
73 views

How to format hyperlinks in blog comments?

SO and GitHub have an easy way to format hyperlinks by hiding the URL behind some descriptive text by enclosing the text in brackets followed by an URL in parentheses. How can I do something similar ...
3
votes
1answer
260 views

get_fieldValuesAsText usage example

I need to get items using JSOM and show them on a page in a display form. So currency field will be shown like $ 123,456.78 the date will be formatted accordingly to settings and Yes\No value will be ...
0
votes
0answers
11 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
48 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
20 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
83 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
46 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
673 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
23 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
87 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 ...
1
vote
0answers
94 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 ...
9
votes
4answers
9k 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
513 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 ...
1
vote
0answers
68 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
57 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
15 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?
1
vote
0answers
111 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
720 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
976 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 ...
4
votes
2answers
14k 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
87 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
54 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
1answer
377 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
43 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
3k 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
44 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
67 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
670 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
208 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
663 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
134 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
288 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
815 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
353 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
266 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
2answers
3k 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
722 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> ...