Test bbcode x bordi e tabelle

Stato
Discussione chiusa ad ulteriori risposte.
30 Maggio 2015
5,319
72
48
50
Milano, Italy
office 365/2016
Miglior risposte
21
#1
Excel 2013
15/01/2015​
17/01/2012​
16/01/2015​
15/01/2014​
22/01/2016​
18/01/2015​
18/01/2014​
21/01/2014​
07/06/2015​
14/07/2015​
12/04/2016​
13/02/2015​
11/03/2015​

[sub]Row[/sub]\[sup]Col[/sup]

A

B

C

[td=bgcolor:#888888]

[/td][td=bgcolor:#00B050]criterio[/td][td=bgcolor:#00B0F0]studente[/td][td=bgcolor:#FF0000]datea[/td]

[td=bgcolor:#888888]

[/td][td=bgcolor:#FFFF00]aaa[/td][td=bgcolor:#FFFFFF]student1[/td][td=bgcolor:#FFFFFF]

[/td]

[td=bgcolor:#888888]

[/td][td=bgcolor:#FFFF00]aaa[/td][td=bgcolor:#FFFFFF]student2[/td][td=bgcolor:#FFFFFF]

[/td]

[td=bgcolor:#888888]

[/td][td=bgcolor:#FFFF00]aaa[/td][td=bgcolor:#FFFFFF]student3[/td][td=bgcolor:#FFFFFF]

[/td]

[td=bgcolor:#888888]

[/td][td=bgcolor:#B4C6E7]bbb[/td][td=bgcolor:#FFFFFF]student4[/td][td=bgcolor:#FFFFFF]

[/td]

[td=bgcolor:#888888]

[/td][td=bgcolor:#B4C6E7]bbb[/td][td=bgcolor:#FFFFFF]student5[/td][td=bgcolor:#FFFFFF]

[/td]

[td=bgcolor:#888888]

[/td][td=bgcolor:#B4C6E7]bbb[/td][td=bgcolor:#FFFFFF]student6[/td][td=bgcolor:#FFFFFF]

[/td]

[td=bgcolor:#888888]

[/td][td=bgcolor:#B4C6E7]bbb[/td][td=bgcolor:#FFFFFF]student7[/td][td=bgcolor:#FFFFFF]

[/td]

[td=bgcolor:#888888]

[/td][td=bgcolor:#B4C6E7]bbb[/td][td=bgcolor:#FFFFFF]student8[/td][td=bgcolor:#FFFFFF]

[/td]

[td=bgcolor:#888888]

[/td][td=bgcolor:#00B050]ccc[/td][td=bgcolor:#FFFFFF]student9[/td][td=bgcolor:#FFFFFF]

[/td]

[td=bgcolor:#888888]

[/td][td=bgcolor:#00B050]ccc[/td][td=bgcolor:#FFFFFF]student10[/td][td=bgcolor:#FFFFFF]

[/td]

[td=bgcolor:#888888]

[/td][td=bgcolor:#00B050]ccc[/td][td=bgcolor:#FFFFFF]student11[/td][td=bgcolor:#FFFFFF]

[/td]

[td=bgcolor:#888888]

[/td][td=bgcolor:#00B050]ccc[/td][td=bgcolor:#FFFFFF]student12[/td][td=bgcolor:#FFFFFF]

[/td]

[td=bgcolor:#888888]

[/td][td=bgcolor:#00B050]ccc[/td][td=bgcolor:#FFFFFF]student13[/td][td=bgcolor:#FFFFFF]

[/td]

Sheet: 5

 
30 Maggio 2015
5,319
72
48
50
Milano, Italy
office 365/2016
Miglior risposte
21
#2
Excel 2013
41​

[sub]Row[/sub]\[sup]Col[/sup]

A

B

C

D

E

F

[td=bgcolor:#888888]

[/td]

 

[td=bgcolor:#FF0000]JAN[/td][td=bgcolor:#FF0000]FEB[/td][td=bgcolor:#FF0000]MAR[/td][td=bgcolor:#FF0000]APR[/td][td=bgcolor:#FF0000]MAY[/td]

[td=bgcolor:#888888]

[/td][td=bgcolor:#FFFF00]Frank[/td]

11​

17​

30​

10​

9​

[td=bgcolor:#888888]

[/td][td=bgcolor:#FFFF00]Joe[/td]

28​

22​

34​

22​

43​

[td=bgcolor:#888888]

[/td][td=bgcolor:#FFFF00]Anna[/td]

5​

22​

14​

37​

21​

[td=bgcolor:#888888]

[/td][td=bgcolor:#FFFF00]Julia[/td]

12​

18​

19​

35​

20​

[td=bgcolor:#888888]

[/td][td=bgcolor:#FFFF00]Anna[/td]

24​

34​

9​

37​

12​

[td=bgcolor:#888888]

[/td][td=bgcolor:#FFFF00]Julia[/td][td=bgcolor:#A9D08E]

[/td]

36​

39​

20​

23​

[td=bgcolor:#888888]

[/td][td=bgcolor:#FFFF00]Anna[/td]

99​

8​

5​

31​

32​

[td=bgcolor:#888888]

[/td][td=bgcolor:#FFFF00]Frank[/td]

35​

24​

42​

24​

36​

Sheet: 2

 
30 Maggio 2015
5,319
72
48
50
Milano, Italy
office 365/2016
Miglior risposte
21
#3
Excel 2013

[sub]Row[/sub]\[sup]Col[/sup]

A

B

C

[td=bgcolor:#888888]

[/td][td=bgcolor:#FF0000]frase[/td][td=bgcolor:#00B050]name[/td][td=bgcolor:#00B050]Relative position of the name[/td]

[td=bgcolor:#888888]

[/td]

Anna is dark

frank

3​

[td=bgcolor:#888888]

[/td]

luis is blond

Joe

5​

[td=bgcolor:#888888]

[/td]

Frank is Toll

lisa

4​

[td=bgcolor:#888888]

[/td]

lisa is small

Anna

1​

[td=bgcolor:#888888]

[/td]

Joe is good guy

Luis

2​

[td=bgcolor:#888888]

[/td]

table 2

  

[td=bgcolor:#888888]

[/td][td=bgcolor:#FF0000]name[/td][td=bgcolor:#00B050]frase[/td][td=bgcolor:#00B050]Relative position frase[/td]

[td=bgcolor:#888888]

[/td]

frank

now maybe anna

4​

[td=bgcolor:#888888]

[/td]

Joe

luis is blond

5​

[td=bgcolor:#888888]

[/td]

Lisa

Frank is Toll

1​

[td=bgcolor:#888888]

[/td]

Anna

Lisa is small

3​

[td=bgcolor:#888888]

[/td]

Luis

Joe is good guy

2​

Sheet: Foglio1

 
30 Maggio 2015
5,319
72
48
50
Milano, Italy
office 365/2016
Miglior risposte
21
#4
jhjkjajhdsfakj

Excel 2013

[sub]Row[/sub]\[sup]Col[/sup]

A

B

C

[td=bgcolor:#888888]

[/td][td=bgcolor:#FFFF00]Rep[/td][td=bgcolor:#FF0000]Sales[/td][td=bgcolor:#0070C0]Product ID[/td]

[td=bgcolor:#888888]

[/td]

Bob

1​

101​

[td=bgcolor:#888888]

[/td]

John

0​

202​

[td=bgcolor:#888888]

[/td]

Sam

3​

101​

[td=bgcolor:#888888]

[/td]

Mary

7​

303​

[td=bgcolor:#888888]

[/td]

Bob

2​

202​

[td=bgcolor:#888888]

[/td]

Sam

1​

101​

[td=bgcolor:#888888]

[/td]

Mary

0​

101​

[td=bgcolor:#888888]

[/td]

Bob

1​

202​

[td=bgcolor:#888888]

[/td]

John

0​

303​

[td=bgcolor:#888888]

[/td]

Sam

3​

101​

[td=bgcolor:#888888]

[/td]

Mary

6​

101​

[td=bgcolor:#888888]

[/td]

Bob

2​

202​

[td=bgcolor:#888888]

[/td]

Sam

1​

303​

[td=bgcolor:#888888]

[/td]

Mary

0​

101​

Sheet: 10

 
30 Maggio 2015
5,319
72
48
50
Milano, Italy
office 365/2016
Miglior risposte
21
#5
formula estarzione


Excel 2013

[sub]Row[/sub]\[sup]Col[/sup]

A

B

C

[td=bgcolor:#888888]

[/td][td=bgcolor:#FFFF00]Rep[/td][td=bgcolor:#FF0000]Sales[/td][td=bgcolor:#0070C0]Product ID[/td]

[td=bgcolor:#888888]

[/td]

Bob

1​

101​

[td=bgcolor:#888888]

[/td]

John

0​

202​

[td=bgcolor:#888888]

[/td]

Sam

3​

101​

[td=bgcolor:#888888]

[/td]

Mary

7​

303​

[td=bgcolor:#888888]

[/td]

Bob

2​

202​

[td=bgcolor:#888888]

[/td]

Sam

1​

101​

[td=bgcolor:#888888]

[/td]

Mary

0​

101​

[td=bgcolor:#888888]

[/td]

Bob

1​

202​

[td=bgcolor:#888888]

[/td]

John

0​

303​

[td=bgcolor:#888888]

[/td]

Sam

3​

101​

[td=bgcolor:#888888]

[/td]

Mary

6​

101​

[td=bgcolor:#888888]

[/td]

Bob

2​

202​

[td=bgcolor:#888888]

[/td]

Sam

1​

303​

[td=bgcolor:#888888]

[/td]

Mary

0​

101​

Sheet: 10



grazie
 
30 Maggio 2015
5,319
72
48
50
Milano, Italy
office 365/2016
Miglior risposte
21
#6
Nuovo post

Excel 2013

[sub]Row[/sub]\[sup]Col[/sup]

A

B

C

[td=bgcolor:#888888]

[/td][td=bgcolor:#FFFF00]Rep[/td][td=bgcolor:#FF0000]Sales[/td][td=bgcolor:#0070C0]Product ID[/td]

[td=bgcolor:#888888]

[/td]

Bob

1​

101​

[td=bgcolor:#888888]

[/td]

John

0​

202​

[td=bgcolor:#888888]

[/td]

Sam

3​

101​

[td=bgcolor:#888888]

[/td]

Mary

7​

303​

[td=bgcolor:#888888]

[/td]

Bob

2​

202​

[td=bgcolor:#888888]

[/td]

Sam

1​

101​

[td=bgcolor:#888888]

[/td]

Mary

0​

101​

[td=bgcolor:#888888]

[/td]

Bob

1​

202​

[td=bgcolor:#888888]

[/td]

John

0​

303​

[td=bgcolor:#888888]

[/td]

Sam

3​

101​

[td=bgcolor:#888888]

[/td]

Mary

6​

101​

[td=bgcolor:#888888]

[/td]

Bob

2​

202​

[td=bgcolor:#888888]

[/td]

Sam

1​

303​

[td=bgcolor:#888888]

[/td]

Mary

0​

101​

Sheet: 10




Grazie
 

Ste

Utente abituale
7 Giugno 2015
207
0
0
17
Brescia
2016 PC
Miglior risposte
0
#7
Excel 2013
A​
RK​
PTS​
FLAG​
CLASSIFICA​
PG​
V​
N​
P​
GF​
GS​
DG​

[sub]Row[/sub]\[sup]Col[/sup]

N

O

P

Q

R

S

T

U

V

W

X

Y

[td=bgcolor:#888888]

[/td]

GRUPPO A

   

[td=bgcolor:#888888]

[/td][td=bgcolor:#FF0000]

[/td][td=bgcolor:#FF0000]

[/td][td=bgcolor:#FF0000]

[/td][td=bgcolor:#FF0000]

[/td][td=bgcolor:#FF0000]

[/td][td=bgcolor:#FF0000]

[/td][td=bgcolor:#FF0000]

[/td][td=bgcolor:#FF0000]

[/td][td=bgcolor:#FF0000]

[/td][td=bgcolor:#FF0000]

[/td][td=bgcolor:#FF0000]

[/td][td=bgcolor:#FF0000]

[/td]

[td=bgcolor:#888888]

[/td]

A1​

1​

4​

 

Chile

2​

1​

1​

0​

5​

3​

2​

[td=bgcolor:#888888]

[/td]

A2​

2​

4​

 

Bolivia

2​

1​

1​

0​

3​

2​

1​

[td=bgcolor:#888888]

[/td]

A3​

3​

2​

 

Mexico

2​

0​

2​

0​

3​

3​

0​

[td=bgcolor:#888888]

[/td]

A4​

4​

0​

 

Ecuador

2​

0​

0​

2​

2​

5​

-3​

Sheet: Classifiche

 

Ste

Utente abituale
7 Giugno 2015
207
0
0
17
Brescia
2016 PC
Miglior risposte
0
#10
Excel 2013
A​
RK​
PTS​
FLAG​
CLASSIFICA​
PG​
V​
N​
P​
GF​
GS​
DG​

[sub]Row[/sub]\[sup]Col[/sup]

N

O

P

Q

R

S

T

U

V

W

X

Y

[td=bgcolor:#888888]

[/td]

GRUPPO A

   

[td=bgcolor:#888888]

[/td][td=bgcolor:#FF0000]

[/td][td=bgcolor:#FF0000]

[/td][td=bgcolor:#FF0000]

[/td][td=bgcolor:#FF0000]

[/td][td=bgcolor:#FF0000]

[/td][td=bgcolor:#FF0000]

[/td][td=bgcolor:#FF0000]

[/td][td=bgcolor:#FF0000]

[/td][td=bgcolor:#FF0000]

[/td][td=bgcolor:#FF0000]

[/td][td=bgcolor:#FF0000]

[/td][td=bgcolor:#FF0000]

[/td]

[td=bgcolor:#888888]

[/td]

A1​

1​

4​

 

Chile

2​

1​

1​

0​

5​

3​

2​

[td=bgcolor:#888888]

[/td]

A2​

2​

4​

 

Bolivia

2​

1​

1​

0​

3​

2​

1​

[td=bgcolor:#888888]

[/td]

A3​

3​

2​

 

Mexico

2​

0​

2​

0​

3​

3​

0​

[td=bgcolor:#888888]

[/td]

A4​

4​

0​

 

Ecuador

2​

0​

0​

2​

2​

5​

-3​

Sheet: Classifiche

 

Andre81

Utente junior
16 Giugno 2015
68
0
6
Parma
2013
Miglior risposte
0
#13
Excel 2013
delta​

[sub]Row[/sub]\[sup]Col[/sup]

A

B

C

D

E

F

G

H

I

J

K

L

M

N

O

P

[td=bgcolor:#888888]

[/td]

 

base​

start​

down​

up​

end​

[td=bgcolor:#FFFF00]

[/td]

         

[td=bgcolor:#888888]

[/td]

START

 

2000​

 

         

[td=bgcolor:#888888]

[/td]

Gen

1911​

89​

0​

 

-89​

         

[td=bgcolor:#888888]

[/td]

Feb

1911​

0​

150​

 

150​

         

[td=bgcolor:#888888]

[/td]

Mar

2061​

0​

510​

 

510​

         

[td=bgcolor:#888888]

[/td]

Apr

2432​

139​

0​

 

-139​

         

[td=bgcolor:#888888]

[/td]

Mag

2432​

0​

200​

 

200​

         

[td=bgcolor:#888888]

[/td]

Giu

2632​

0​

350​

 

350​

         

[td=bgcolor:#888888]

[/td]

Lug

2891​

91​

0​

 

-91​

         

[td=bgcolor:#888888]

[/td]

Ago

2891​

0​

376​

 

376​

         

[td=bgcolor:#888888]

[/td]

Set

3227​

40​

0​

 

-40​

         

[td=bgcolor:#888888]

[/td]

Ott

3169​

58​

0​

 

-58​

         

[td=bgcolor:#888888]

[/td]

Nov

3074​

95​

0​

 

-95​

         

[td=bgcolor:#888888]

[/td]

Dic

3074​

0​

74​

 

74​

         

[td=bgcolor:#888888]

[/td]

END

 

3148​

         

[td=bgcolor:#888888]

[/td]

                

[td=bgcolor:#888888]

[/td]

                

[td=bgcolor:#888888]

[/td]

                

[td=bgcolor:#888888]

[/td]

                

[td=bgcolor:#888888]

[/td]

                

Sheet: waterfall

 

Ste

Utente abituale
7 Giugno 2015
207
0
0
17
Brescia
2016 PC
Miglior risposte
0
#14
Excel 2013
delta​

[sub]Row[/sub]\[sup]Col[/sup]

A

B

C

D

E

F

G

H

I

J

K

L

M

N

O

P

[td=bgcolor:#888888]

[/td]

 

base​

start​

down​

up​

end​

[td=bgcolor:#FFFF00]

[/td]

         

[td=bgcolor:#888888]

[/td]

START

 

2000​

 

         

[td=bgcolor:#888888]

[/td]

Gen

1911​

89​

0​

 

-89​

         

[td=bgcolor:#888888]

[/td]

Feb

1911​

0​

150​

 

150​

         

[td=bgcolor:#888888]

[/td]

Mar

2061​

0​

510​

 

510​

         

[td=bgcolor:#888888]

[/td]

Apr

2432​

139​

0​

 

-139​

         

[td=bgcolor:#888888]

[/td]

Mag

2432​

0​

200​

 

200​

         

[td=bgcolor:#888888]

[/td]

Giu

2632​

0​

350​

 

350​

         

[td=bgcolor:#888888]

[/td]

Lug

2891​

91​

0​

 

-91​

         

[td=bgcolor:#888888]

[/td]

Ago

2891​

0​

376​

 

376​

         

[td=bgcolor:#888888]

[/td]

Set

3227​

40​

0​

 

-40​

         

[td=bgcolor:#888888]

[/td]

Ott

3169​

58​

0​

 

-58​

         

[td=bgcolor:#888888]

[/td]

Nov

3074​

95​

0​

 

-95​

         

[td=bgcolor:#888888]

[/td]

Dic

3074​

0​

74​

 

74​

         

[td=bgcolor:#888888]

[/td]

END

 

3148​

         

[td=bgcolor:#888888]

[/td]

                

[td=bgcolor:#888888]

[/td]

                

[td=bgcolor:#888888]

[/td]

                

[td=bgcolor:#888888]

[/td]

                

[td=bgcolor:#888888]

[/td]

                

Sheet: waterfall

Giusto!
 
30 Maggio 2015
5,319
72
48
50
Milano, Italy
office 365/2016
Miglior risposte
21
#16
...volevo anche inserire il grafico ma non sono capace y)
Ciao Andrea 81
per inserire una immagine come questa non puoi usare il BBcode che va bene solo per le griglie e tabelle
ma una procedura diversa con file statici .gif .png . jpg .tiff

per primo devi trasformare il grafico in formato immagine .gif .png . jpg .tiff (clicca sul grafico, copia, incolla in paint, salva con nome)
e poi guarda questo video!
►https://www.youtube.com/watch?v=3lbyY41HUYg



fammi sapere!
 

Andre81

Utente junior
16 Giugno 2015
68
0
6
Parma
2013
Miglior risposte
0
#17
Ciao Andrea 81
per inserire una immagine come questa non puoi usare il BBcode che va bene solo per le griglie e tabelle
ma una procedura diversa con file statici .gif .png . jpg .tiff

per primo devi trasformare il grafico in formato immagine .gif .png . jpg .tiff (clicca sul grafico, copia, incolla in paint, salva con nome)
e poi guarda questo video!
►https://www.youtube.com/watch?v=3lbyY41HUYg



fammi sapere!
Grazie mille Gerardo!!
 
Stato
Discussione chiusa ad ulteriori risposte.

Sostieni ForumExcel

Aiutaci a sostenere le spese e a mantenere online la community attraverso una libera donazione!