Excel usually treats Conditional Formatting formulas as if they are array formulas, except when loading them from an Excel 2002/2003 XML Spreadsheet file.
This is only an issue with the Excel 2002/2003 XML Spreadsheet format... the native Excel format works fine, as does the newer Excel 2007 XML format (xlsx).
After loading the spread...
I have a webapp for commercial property management that needs spreadsheet like functionality. We need the spreadsheet like functionality for doing budgets. I don't want to use Google spreadsheet because my users won't necessarily have a Google account.
So is there anything out there that I could use? I looked and could only find Social...
Hi All,
I have a 3rd Party tool that generates an xml spreadsheet (*.xls). I have another program that reads this spreasheet and processes it. The content of the generated xml spreadsheet is a table with 5 columns and my program runs select queries on them. I m facing an issue while opening a connection to the generated spreadsheet. It s...
Hi,
I am getting spreadsheet xml from a code logic (Flex Grids to spreadsheet xml).
I have 3 worksheets (A, B, C) in that spreadsheet xml.
I am opening this spreadsheet xml in Excel.
I want to view worksheet B when I am opening the spreadhseet xml in Excel.
Is there any tag/code, I need to add so that worksheet B will be visible at in...
I have a function in a controller that takes in some specifications and generates a report on them. This function user_report is called in a view:
< %= submit_to_remote 'submit-button', "Export Report to Excel", :url => { :controller => :reports, :action => :user_report, :print_state => 'print'} % >
In reports_controller I use the Spr...