Newsgroup: it.lavoro.informatica
Titolo: Domanda per Ester

Ciao Ester,
avrei bisogno di sapere che grado di compatibilità esiste tra Excel e
Pocket Excel: devo realizzare dei documenti in formato excel da passare
da un PC ad un palmare per l'inserimento dati durante delle fiere, e
poi riportarli indietro per l'eleaborazione dei dati... quanto posso
spingermi nella programmazione dei fogli di excel?
Grazie per l'aiuto!
Buona giornata
Gianluca

 Pocket Excel: devo realizzare dei documenti in formato excel da passare
io non e' che ho proprio bisogno di saperlo, pero' ho comunque la
curiosita' di sapere perche' non le hai scritto una mail

 curiosita' di sapere perche' non le hai scritto una mail
Perchè la domanda sarà diretta a lei, ma la risposta potrebbe 
interessare tutti, non credi?

 interessare tutti, non credi?
se per tutti includi anche me, direi di no
magari interesserebbe molte piu' persone su
microsoft.public.it.office.excel

 microsoft.public.it.office.excel
Magari, si.
Ma bisogna far polemica ad ogni volo di mosca?
Tra tutti i post spazzatura che ci sono su sto news, per una volta che 
viene chiesto qualcosa di interessante, bisogna lamentarsi?
mah...

 se per tutti includi anche me, direi di no
e sticazzi, non leggere il thread.

 quanto posso spingermi nella programmazione dei fogli di excel?
Il posto migliore dove chiedere sarebbe microsoft.public.it.office.excel
o microsoft.public.it.pocketpc, ma provo comunque a risponderti. Palmari et
similia non ne ho, ti dico quel che so: PocketExcel non supporta/va VBA o
alcuno scripting. Inoltre a suo tempo ricordo che suggerivano di salvare in
formato compatibile con Office97.
E Googlando si trova questo:
1.5 MICROSOFT POCKET EXCEL
· Pocket Excel implements minimal support for local defined names to be
compatible with Microsoft Excel 95/97/2000. If you must use local names, you
should avoid creating duplicate local and global names.
· The Microsoft Excel feature that enables you to change the currency symbol
in the Format Cells dialog box is not supported in Pocket Excel. Pocket
Excel is unable to save files that use this feature.
· Adding a custom number format results in additional custom number formats
that appear as unrecognized characters (blank squares). The additional
formats are usable UNICODE format strings for formats such as Chinese dates.
These special formats are not displayed until the user explicitly puts in a
custom format.
· When printing a worksheet with cells that are formatted with the
"Automatic" color fill, the cells will print using the "Window Background"
color specified in Control Panel Display. To work around this problem,
change the fill of the cells to white instead of automatic.
CONVERSION TO/FROM POCKET EXCEL
· Pocket Excel 1.0 documents that contain 3D references cannot be converted
to Pocket Excel 2.0/3.0 format. To work around this problem, remove the 3D
references from the file, convert the document to Excel 2.0/3.0 formats, and
re-enter the 3D references.
· Cells that contain the COUNTBLANK () function may display #VALUE! in Excel
97/2000 after being edited in Pocket Excel and then converted to Excel
97/2000. To resolve this, do a Replace All that searches for "=" and
replaces it with "=".
· Cells that contain formulas of the form "=name" and "=name+name", where
"name" is a defined name may not recalculate correctly in Excel 97/2000
after conversion. To resolve this, do a Replace All that searches for "="
and replaces it with "=".
· Some defined names may get corrupted when saving Pocket Excel files as
Excel 95 on the device. If this occurs, you can work around the problem by
using ActiveSync on your desktop computer to convert the Pocket Excel files
to Excel 95 format.
· Defined names that refer to many levels of nested IF() functions may get
lost during conversion from Pocket Excel to Excel 97. To work around this
problem, reduce the number of nested IF() statements used in the defined
name.
· Microsoft Excel 97 and later supports 65536 rows. Pocket Excel supports
16384 rows. Rows beyond this are deleted upon conversion from Excel 97/2000
to Pocket Excel.
· Microsoft Excel 97 and later provides a conditional number formatting
feature. Cells formatted using this feature may not be displayed properly in
Pocket Excel.
· When converting from Pocket Excel to Microsoft Excel, many formats are
added to the Custom category in the Format Cells dialog box in Microsoft
Excel on your desktop computer. Pocket Excel displays all number formats it
supports.
· When converting a file that is formatted with color fonts, fills, or
borders from Pocket Excel to Microsoft Excel 95, some colors may not convert
appropriately. All colors convert properly when converting to Microsoft
Excel 97 or later.
· Column formatting may be lost during conversion where it intersects with
formatting applied to an entire row. For example, if you have a row with a
non-default height and all other attributes are defaults, column-formatting
information, such as borders, will be lost where the column(s) and row(s)
intersect when converting from Microsoft Excel to Pocket Excel. If you
reapply the formatting in Pocket Excel, the formatting will not subsequently
be lost in the conversion process again.
· When you convert a file from Microsoft Excel to Pocket Excel, AutoFilter
activation is not retained. However, if your AutoFilter activation resulted
in some rows being hidden, these rows are also hidden in Pocket Excel. To
display the rows, unhide them in Pocket Excel.
481. ACTIVESYNC 3.0, IS IT ANY GOOD? ANY BETTER? A COLLECTION.
(Updated on 9-6-99)
ActiveSync 3.0 is the latest and improved synchronization software for
Windows CE operating system-based Palm-size PCs and Handheld PCs. It is
easier to install and use because of a complete redesign of its
communications architecture and user interface and improvements to its
synchronization speed and overall performance. It also is compatible with
all versions of the Palm-size PC and with versions 2 and 3 of the Handheld
PC, making it the easiest and most powerful synchronization for Windows CE
from Microsoft to date.
Notice it has a name change also, going from Windows CE Services to
ActiveSync.
You can download it free at
http://www.microsoft.com/windowsce/products/download/activesync.asp
 but
beware, as there are some indications that some will have problems. I
struggled for hours to get mine to work. The readme file have dozens of
gotcha's so make sure you read them.
***
HTH e la prossima volta sarebbe meglio Googlare e rispettare qualche
basilare norma della Netiquette ;-)
Ciao ciao
-- 
*Ester Memoli*
________________________________________________
MVP worldwide: 
http://mvp.support.microsoft.com
________________________________________________

Ester Memoli [MVP] ha scritto:
[CUT]
Grazie molte, sei stata di grande aiuto...
Buona giornata
Gianluca

 viene chiesto qualcosa di interessante, bisogna lamentarsi?
<mentalita' italiana>
Tra tutte le carte che la gente butta a terra, che male fara' se anche io
butto una carta a terra?
</mentalita' italiana>
-- 
Salvatore Iovene
http://www.iovene.com