| 
	 
		View unanswered posts | View active topics
		
		It is currently Tue Nov 04, 2025 3:47 am
		
	 
	
	 
	
	 
  
	
	
		
			
				 
			 | 
		
			 Page 1 of 1
  | 
			 [ 2 posts ]  | 
			 | 
		
	 
	 
			
	
	
	
        
        
            | Author | 
            Message | 
         
        
			| 
				
				 Spencer 
				
				
					
				 
				 
			 | 
			
				
				  New line  
					
						How can I enter a new line in an Excel cell? I know in Excel there is "Alt + Enter" combination, but can I do it in code? 
					
  
			 | 
		 
		
			| Mon Aug 28, 2006 8:27 am | 
			
				
					 
					
					 
				
			 | 
    	
		 
	
	
		  | 
	 
	
			| 
				
				 exari 
				
				
					 Joined: Sat Apr 22, 2006 10:20 am Posts: 5
				 
				 
			 | 
			
				
				  Re:New line  
					
						You can enter a new line in a cell by using the character that has the 0x0A=10 code to separate the words. You also have to set the wrap property for the cell format.
 
 ExcelStyle styleWrap = new ExcelStyle();
 styleWrap.setWrap(true);
 xlsWorksheet.easy_getExcelTable().easy_getCell("A1").setStyle(styleWrap); 
					
  
			 | 
		 
		
			| Mon Aug 28, 2006 9:25 am | 
			
				
					 
					
					 
				    
			 | 
    	
		 
	
	
		 | 
	 
	
	 
	 
	
	
		
			
				  
			 | 
		
			 Page 1 of 1
  | 
			 [ 2 posts ]  | 
			 | 
		
	 
	 
 
	 
	
	
		Who is online | 
	 
	
		Users browsing this forum: No registered users and 1 guest  | 
	 
	 
 
	 | 
	You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot post attachments in this forum
  | 
 
 
 
	 |