Show theme settings Shopping cart Download trialFree Trial
Change Theme Settings
Change Theme Settings
Themes
 
Show All Themes
v
...v

Custom Document Management

Navigate through folders and select a document to open with the Spreadsheet.
  • Refresh
  • Download
  • Collapse
    FolderDocumentBrowsing
    • FolderCSV
    • FolderXLS
    • FolderXLSB
    • FolderXLSX

Analysis.xlsx

Schedule.xlsx
Clear selectionBrowse...
Upload

H
AA
AD
AE
FO
V
X
C
FN
FF
FS
FG
FK
1
2
3
AF
B
FC
FC
AG
FA
AT
AM
AB
AL
AC
AR
5
6
W
M
FM
AH
AN
P
K
0
9
AI
I
D
O
AJ
U
FI
E
S
FD
AK
T
N
E
PI
T
F
P
K
C
N
Q
B
A
D
O
G
I
P
A
B
M
O
SZ
C
D
PG
PH
M
A
U
I
L
T
E
O
G
Q
C
X
B
J
A
A
SA
SD
T
C
Y3
B
V
R
A
C
T
D
D
W
A
B
C
D
VG
VH
E
G
H
F
JT
B
A
D
G
E
O
T
R
C
N
U
F
H
JP
B
AF
AE
JC
A
C
B
W
E
D
L
F
S
JA
A
B
C
D
E
F
G
H
JO
B
AF
AE
AN
A
F
I
B
E
V
C
L
H
DE
A
T
G
P
B
C
W
H
R
U
  • Undopo
    Undo
  • Cut
    Clipboardpo
    Clipboard
  • v
    v
    po
    po
    po
    po
    Fontpo
    Font
  • Alignment
  • po
    Numberpo
    dialogboxlauncherNumber
  • Cells
  • Editing
  • Styles
  • Page Setuppo
    dialogboxlauncherPage Setup
  • Printpo
    dialogboxlauncherPrint
  • Document Viewspo
    Document Views
  • Showpo
    Show
  • View
  • Windowpo
    Window
  • Propertiespo
    Properties
  • Tools
  • Table Style Optionspo
    Table Style Options
  • Table Style Optionspo
    Table Style Options
  • Layout
  • PivotTable Style Optionspo
    PivotTable Style Options
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
Z
AA
AB
AC
AD
AE
AF
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
Vader Enterprises
AMOUNTS SHOWN IN U.S. DOLLARS
SALES
SALES PRICE PER UNIT
$150.00
SALES VOLUME PER PERIOD (UNITS)
1,000
TOTAL SALES
$150,000.00
VARIABLE COSTS
COMMISSION PER UNIT
$4.00
DIRECT MATERIAL PER UNIT
$87.00
SHIPPING PER UNIT
$5.00
SUPPLIES PER UNIT
$1.20
OTHER VARIABLE COSTS PER UNIT
$3.40
VARIABLE COSTS PER UNIT
$100.60
BREAKEVEN ANALYSIS
TOTAL VARIABLE COSTS
$100,600.00
UNIT CONTRIBUTION MARGIN
49.40
GROSS MARGIN
$49,400.00
FIXED COSTS PER PERIOD
ADMINISTRATIVE COSTS
$15,000.00
INSURANCE
$12,000.00
PROPERTY TAX
$1,800.00
RENT
$8,000.00
OTHER FIXED COSTS
$750.00
TOTAL FIXED COSTS PER PERIOD
$37,550.00
NET PROFIT (LOSS)
$11,850.00
RESULTS
BREAKEVEN POINT (UNITS):
760.12
SALES VOLUME ANALYSIS:
SALES VOLUME PER PERIOD (UNITS)
0
100
200
300
400
500
600
700
800
900
1,000
SALES PRICE PER UNIT
$150.00
$150.00
$150.00
$150.00
$150.00
$150.00
$150.00
$150.00
$150.00
$150.00
$150.00
FIXED COSTS PER PERIOD
$37,550.00
$37,550.00
$37,550.00
$37,550.00
$37,550.00
$37,550.00
$37,550.00
$37,550.00
$37,550.00
$37,550.00
$37,550.00
VARIABLE COSTS
$0.00
$10,060.00
$20,120.00
$30,180.00
$40,240.00
$50,300.00
$60,360.00
$70,420.00
$80,480.00
$90,540.00
$100,600.00
TOTAL COSTS
$37,550.00
$47,610.00
$57,670.00
$67,730.00
$77,790.00
$87,850.00
$97,910.00
$107,970.00
$118,030.00
$128,090.00
$138,150.00
TOTAL SALES
$0.00
$15,000.00
$30,000.00
$45,000.00
$60,000.00
$75,000.00
$90,000.00
$105,000.00
$120,000.00
$135,000.00
$150,000.00
NET PROFIT (LOSS)
($37,550.00)
($32,610.00)
($27,670.00)
($22,730.00)
($17,790.00)
($12,850.00)
($7,910.00)
($2,970.00)
$1,970.00
$6,910.00
$11,850.00
Did this demo address your needs?
If you’d like us to extend this demo further, please describe your needs below.
Thank you in advance for your cooperation.
SEND FEEDBACK

Although the DevExpress ASP.NET Spreadsheet (ASPxSpreadsheet) provides a built-in means to manage (create, open and save) files via the File ribbon tab, an external file management control can also be used with the Spreadsheet.

This demo illustrates how to use an external ASPxFileManager control to navigate a document hierarchy and select a file to open. Documents can be opened from a specific folder on the server ("DocumentBrowsing"), and can also be uploaded to this folder from an end-user's computer. The selected document is opened within the ASPxSpreadsheet by using the Open method.

Collapse/Expand
Local Copy of this Demo
To inspect the source code for this demo on your machine, you must first install our components via the DevExpress Component Installer.
You can open a local copy of this online demo directly from this webpage (if using v20.2.8, 21.1.4 or higher).
Open CS Solution
Open VB Solution
The source code files for this demo are installed (by default) in the following directories:
\Users\Public\Documents\DevExpress Demos XX.X\Components\ASP.NET\CS\ASPxSpreadsheetDemos
\Users\Public\Documents\DevExpress Demos XX.X\Components\ASP.NET\VB\ASPxSpreadsheetDemos
Calibri