Questions tagged [formatting]

The arrangement of data for storage or display.

54 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
3
votes
0answers
175 views

SharePoint 2010 issue - can I create a bullet list that isn't double spaced?

I have some pages being created in SharePoint 2010 (we are migrating to 2016 next year, so skipping 2013 completely). I can copy and paste bullet lists into the page, or create my own, but they all ...
3
votes
1answer
1k 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 ...
3
votes
0answers
274 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 ...
2
votes
0answers
789 views

Column formatting changes vertical alignment

I followed this Microsoft guide on column formatting and made the changes I need to get it to work on 3 of my columns. Specifically I am using the bits on "Conditional formatting based on the value in ...
2
votes
0answers
47 views

Auto-populate Form Field Based on Selection

I need to be able to type in an invoice number into a form field and have the remainder of the information populate into the form. Can anyone provide me with any code or references on how to do this? ...
2
votes
1answer
876 views

SharePoint Designer 2010 - Conditional Formatting on List

I have been asked to apply conditional formatting to a list in SharePoint 2010 to change the font colour if the difference is 7 or less when you minus the date in the Date Valid column from todays ...
2
votes
2answers
2k views

Change Date Format in SharePoint 2016

I want to change the format of date from MM-DD-YYYY to DD-MM-YYYY in list, Gantt charts etc. I have tried one option so far but it doesn't work properly which is explain below: First option: I have ...
2
votes
2answers
2k 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
119 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 ...
2
votes
2answers
281 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 ...
1
vote
0answers
124 views

Column formatting for multi-choice field in SP Modern

Context: I'm working as a regular user consuming my company's modern Sharepoint deployment, so my capabilities are pretty limited other than what's available from the GUI. I'm trying to format a ...
1
vote
1answer
958 views

Using modern list view formatting to alternate row colors

I have been looking into using view formatting to alternate the colors of rows in order to recreate what came out of the box in the classic views. However it seems like I can't access the row ID as a ...
1
vote
0answers
22 views

Cell values looks different to others on SharePoint

I have an excel sheet stored on SharePoint. It has a table in it. The cells of this table get a value based on a formula I run on another PIVOT table. The formula returns the value as either P or ...
1
vote
1answer
47 views

Viewing PS1 files in browser: Possible in SPO 'classic mode'?

Not a huge fan of the new fangled site layout for newly created SharePoint Online sites, but it is growing on me. One feature I particularly like is the ability to view PowerShell files, complete with ...
1
vote
1answer
509 views

Conditional formatting on list script

I used the above code to apply a background color on a line with the word High in a field (choice). It does not work. I have used a code that matches exactly the word as in other fields (descriptions ...
1
vote
1answer
1k views

SharePoint Conditional Formatting Date Column

I've been trying to create a Conditional Color column for dates that are expired. The expired dates should be red and the dates that are not should be clear. I tried to use the code from http://www....
1
vote
1answer
439 views

Use Javascript to change Title Column Color based on Drop-Down Selection

I have an announcement list slider (using the Hillbilly slider set up.) I've added a heading section that pulls the Title field of the announcement list. I would like to add some Javascript that ...
1
vote
1answer
168 views

Date format without spaces

we have migrated Sharepoint from Windows Server 2008 R2 to 2012 R2. Previously was date format without spaces (f.e. 4.1.2017), now it has to be with spaces When I delete spaces, it write text like ...
1
vote
0answers
522 views

Add colored border to some elements of table

I would like to know if it is possible to add a border of a specific color in a table. The preset styles do not work as I keep some of the table boxes clear, and some colored and only want the border ...
1
vote
1answer
46 views

Bulleting/ Format Issue

I am copying and pasting bulleted lists on Sharepoint. When I press enter to go to the next line and try to continue the bulleted list, it automatically indents it and will not allow the bullet points ...
1
vote
1answer
242 views

SharePoint Designer 2013 Announcements WebPart

I'm currently using SharePoint Designer 2013 to create a custom home page for a SharePoint site. I've created an announcements WebPart however I'm having a lot of issues formatting it. I've attached a ...
1
vote
0answers
235 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 @...
1
vote
0answers
376 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 ...
1
vote
0answers
277 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. So--reluctantly-...
1
vote
1answer
167 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 ...
1
vote
0answers
84 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, ...
1
vote
0answers
652 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
0answers
72 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, ...
1
vote
0answers
109 views

Why does Search only accept YMD date format when Search Language is en-ca (usually DMY date format)?

For some reason the server thinks that the date format for English (Canada) is YMD or yyyy/MM/DD, and the server will only correctly read queries with that format. However, the default short date ...
0
votes
0answers
10 views

Conditional formatting based on set of values

Am trying to format a field in sharepoint form designed in Infopath 2013, based on set of values. There are 81 department codes to be precise, and if my value is in any one of those, I need to change ...
0
votes
1answer
11 views

InfoPath 2010 from dropdown list not showing choices when conditional formatting rule applied

Another "driving me crazy" I add a dropdown list box to my infopath form publishing to SharePoint 2013 list. I add a formatting rule to highlight field. Works fine in preview, when I publish to ...
0
votes
0answers
81 views

Wrap Text not working in SharePoint Excel

Text just appears squished instead of wrapping to the next line. Oddly when I download the file locally the wrapping works perfectly, just in SharePoint does it behave this way.
0
votes
0answers
23 views

How to get items vertically aligned across multiple columns on a modern page?

Given a modern page with three columns, I'd like the following in each column: a little bit of text and a button below it, with both the text and button centered. If each text block has two lines of ...
0
votes
0answers
27 views

Sharepoint list in Microsoft Edge wont show Backgroundcolor

So I got this weird problem.. in IE and google chrome this works perfectly and all background colours in view formatting works. But when i'm in Microsoft Edge it will only display the background color ...
0
votes
1answer
11 views

adding years to existing date to produce expiry date ( SP list)

I have a list of training course that all have different levels of validy. So course A lasts for 3 years Course B lasts for 2 years Course C lasts for 1 year At the moment I have a column with ...
0
votes
1answer
84 views

SharePoint 2013 - format webpart list column text not based on a condition

I would like to change the color and text size of a calculated column in a SharePoint 2013 not based on any condition. Searching online I have only been able to to find ways of applying conditional ...
0
votes
2answers
62 views

Custom List Header Column Sort/Filter

I'm trying to re-format the sort/filter drop down box on the column header of a custom list (font-family, font-size, background etc). This appears to be possible by using the following rule in a ...
0
votes
1answer
42 views

Hide items in list based on group membership

I have a list of items in Sharepoint. I want to allow group members to submit items to the list, but I only want owners to be able to view the items. Microsoft has an example of hiding fields in rows ...
0
votes
1answer
386 views

List View Row Formatting Using Ratings Column

I have a SharePoint Online list that contains the standard like style ratings feature. I am trying to format a row view for this list, I can get everything to work except for the ratings column (I ...
0
votes
1answer
566 views

Using JSON data bars Column formatting for text (stages)

I am looking at using column formatting to allow us to easily identify which stage a project is in. In SharePoint online using modern views. We have 4 stages and would like to have a 25%, 50% 75%, ...
0
votes
1answer
16 views

How can I change the format of a Combo-Box with fill-in answers?

I'm trying to create a field with InfoPath 2013 that is a list box that allows a user to enter in their own values. That part is simple. Where I'm running into issue is that I want to change the ...
0
votes
1answer
709 views

Column formatting changes not saving

For my document library on sharepoint online modern view, I have a column for Title. I've tried to format it so that the height changes dynamically based on how long the title is and when I save it at ...
0
votes
0answers
24 views

Conditaionl Formating of row when field is not displayed

Seems simple, but I cant figure it out. I want to highlight a row based on text being entered in a field, but the field is NOT displayed. It shows up the way I want if the field is showing up in the ...
0
votes
1answer
231 views

Sharepoint Conditional Formatting or Add Flag?

OK, so I'm trying to basically add an indicator of any kind in one field based on another field having data entered v no data entered. Ideally would like to display a red flag, or some kind of icon, ...
0
votes
0answers
772 views

Formatting column making the column text to disappear in latest Sharepoint online

Formatting column with JSON makes the column text to disappear in latest Sharepoint online. E.g. if I try to use something like that: { "elmType": "div", "txtContent": "@currentField" } saddenly I ...
0
votes
1answer
143 views

Highlight row based on indent level not using SharePoint Designer

I would like to have a conditional formatting of the rows in my SharePoint task list table. The table contains (parent) tasks and sub-tasks. As an example, I would like to shade the parent tasks grey ...
0
votes
1answer
36 views

Prevent Default Page Format From Appearing

I have several Sharepoint 2013 pages to which I've applied .css styles. But whenever the pages load, the default format flashes on the screen before my .css is applied. Does anyone have a script ...
0
votes
1answer
15 views

Changing externally shared hyperlinks format

Just wondering if anyone knows is there a way to change the format of the way documents are shared from SharePoint to external users. It works great by sending the guest hyperlink etc. but is there a ...
0
votes
1answer
322 views

SharePoint 2013 drop down menu separator/horizontal rule

I am trying to add separators (hr/) in the drop down menus of my SharePoint, however I am unable to find the place to do it within the master page. I have inspected the page in both Google Chrome and ...
0
votes
1answer
347 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 ...