Comments (4)
Hi @hansie-the-quorum, Can you give some more detail about your issue? Does the code you posted not work or is the issue something else?
from open-xml-sdk.
from open-xml-sdk.
Hi @hansie-the-quorum, There appears to be an issue with ShowDropDown = true
. As a workaround, remove that line and do not set the ShowDropDown
value and it will work. This is not the expected behavior and requires further investigation, but this will resolve the issue.
if (data.ApplyLookup(x, rowIndex))
{
string columnName = GetExcelColumnName(x + 1);
DataValidation dataValidation = new DataValidation
{
Type = DataValidationValues.List,
// ShowDropDown = true, // Do not set this property.
AllowBlank = true,
SequenceOfReferences = new ListValue<StringValue> { InnerText = $"{columnName}{rowIndex}" }
};
string lookupString = $"\"{string.Join(",", data.LookupValues[x].Select(kv => kv.Value))}\"";
dataValidation.Formula1 = new Formula1(lookupString);
dataValidations.Append(dataValidation);
}
from open-xml-sdk.
from open-xml-sdk.
Related Issues (20)
- SpreadsheetDocument Class documentation contains non-existent Close method HOT 3
- Changing underlying excel data sheet does not update other worksheets HOT 1
- Excel with Comments is not working with Open XML SDK
- Unable to read cells with % symbol
- Upgrading to 3+ can be troublesome for .NET6 projects HOT 3
- .NET Core 8 taking a lot longer to build and publish
- Change SpreadSheetML namespace to SpreadsheetML
- Manual approval required for workflow run 8287853350: Approval for publishing to Nuget.org HOT 2
- Investigate changing extensionlist/extension mechanism naming to more closely match Office use HOT 18
- Bug with Open XML SDK HOT 1
- SpreadsheetDocument.Dispose() throws System.ObjectDisposedException HOT 6
- [Performance] Reduce ElementFeatureCollection calls HOT 3
- Bug with Open XML SDK HOT 1
- When opening a pptx file, it prompts that there is a problem with the content and needs to be repaired. HOT 1
- Open XML SDK contains too few samples, isn't documented properly on microsoft's site and questions aren't answered on stackoverflow. HOT 28
- Create a New Workbook With LineChart,then I opened it with office Excel,but office excel will repair it ,then my LineChart will disappear HOT 1
- Unable to add shapes in word file HOT 1
- Framework Support Update/Unclear HOT 1
- Deletion of a Part breaks reading other Parts through "using" method HOT 4
- AddImagePart adds Media folder and images to Root instead of the Word sub folder within the document package
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from open-xml-sdk.