Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I'm using SharePoint 2007, with custom list.

I'm using Content Editor web part in order to design my list.

{In my list the row color determined through the item ststus. e.g: If the status equal to "NOT STARTED" the row color is red, if the row status is "COMPLETED" so the row color is green, etc..}

My question is: I succeeded to implement it only on a custom list in standard view. Is it possible to implement it on data sheet view.

share|improve this question
add comment

2 Answers 2

up vote 5 down vote accepted

Customisations to the Data Sheet View are not supported, as this is generated using the Microsoft Office Access Web Datasheet Component, which renders the grid using the same base engine as the data sheet view that Microsoft Access uses.

share|improve this answer
    
from your answer I understood that I can not design custom list in data-sheet-view. so... do you have any creative idea what can I do in order to implement some "look and feel" design on data-sheet-view? thanks! :) –  liron Jul 25 '11 at 17:18
2  
The simple answer is no, as the datasheet view runs as an ActiveX control, not simple HTML, so there's no way to simply use jQuery or similar to colour the markup. –  James Love Jul 25 '11 at 17:27
    
Could you create a multiline dataform web part with conditional formatting to show the data as desired? The dataform web part would act "like" a datasheet and allow for editing. There might be some issues to work around with postbacking. –  PirateEric Jul 25 '11 at 20:26
    
Hi PirateEric! I do not have the design authorize, and I think that I could implement the dataform web part only with sharepoint design. am I wrong here? –  liron Jul 26 '11 at 7:12
1  
@JamesLove: Apparently your answer is considered definitive enough to be copied by the MS chaps: MSDN: Apply conditional formatting for datasheet view of a SP List –  Stuart Pegg Oct 5 '12 at 10:07
show 2 more comments

you can use the following css in Content editor webpart to change the look and feel different for Datasheet view of sharepoint

<style>
BODY {
    BACKGROUND: #d3d3d3
}
FORM#aspnetForm {
    BACKGROUND-COLOR: #fff

}</style>

or

form#aspnetForm{ 
background-color:#000; 
height: 100%; 
text-align: center; 
} 
body{ 
background-color:#FFF; 
text-align: center; 
} 
.ms-main{ 
margin:0 auto; 
width: 980px; 
background-color:#FFF; 
} 
#mainTable{ 
width: 100%; 
}
share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.